Welcome Notes

Welcome Viewers

30 December 2015

Query for PO Draft

Query for PO Draft 
 IF @transaction_type In ( 'A' ,'U') AND @object_type = '112'  
 BEGIN  
 if exists(select * from ODRF t1 inner join DRF1 t2 on t1.DocEntry =t2.DocEntry where  
  t1.DoCENTRY =@list_of_cols_val_tab_del and t1.ObjType = 22 AND isnull(T2.Project,'') = '')  
 BEGIN  
 SELECT @Error = 5, @error_message = 'Project Code is missing !'  
 END  
 END