GML Sales Order Audit Trail

➜ Back to Library
Description
Categories: BI Publisher, Manufacturing
Application: Process Manufacturing Logistics
Source: Sales Order Audit Trail Report (XML)
Short Name: ORAUDTR_XML
DB package: GML_ORAUDTR_XMLP_PKG 
select distinct
      od. order_id order_id2,
      OH.ORGN_CODE,
      op_cust_mst.cust_no, 
      op_cust_mst.cust_name, 
      ad.shipper_code, 
      ad.sched_shipdate,
      ad.qc_grade_wanted, 
      oh.order_no, 
      ad.from_whse,
      od.line_no, 
       ad.line_id,	
      ad.to_whse, 
      ic_item_mst.item_no,
      ad.holdreas_code, 
      ad.order_qty1, 
      op_ordr_sts.order_status_code,
      ad.order_um1, 
	ad.net_price,
	od.billing_currency,
	ad.created_by,
	ad.creation_date,
                   ad.last_update_date,
	AD.ATTRIBUTE1,                                              
	AD.ATTRIBUTE2,                                             
	AD.ATTRIBUTE3,                                            
	AD.ATTRIBUTE4,                                           
	AD.ATTRIBUTE5,                                          
	AD.ATTRIBUTE6,                                         
	AD.ATTRIBUTE7,                                       
	AD.ATTRIBUTE8,                                        
	AD.ATTRIBUTE9,                                      
	AD.ATTRIBUTE10,                                      
	AD.ATTRIBUTE11,                                     
	AD.ATTRIBUTE12,                                    
	AD.ATTRIBUTE13,                                   
	AD.ATTRIBUTE14,                                  
	AD.ATTRIBUTE15,                                 
	AD.ATTRIBUTE16,                                
	AD.ATTRIBUTE17,                               
	AD.ATTRIBUTE18,                              
	AD.ATTRIBUTE19,                             
	AD.ATTRIBUTE20,                            
	AD.ATTRIBUTE21,                           
	AD.ATTRIBUTE22,                          
	AD.ATTRIBUTE23,                         
	AD.ATTRIBUTE24,                        
	AD.ATTRIBUTE25,                       
	AD.ATTRIBUTE26 ,                      
	AD.ATTRIBUTE27,                     
	AD.ATTRIBUTE28 ,                    
	AD.ATTRIBUTE29 ,                   
	AD.ATTRIBUTE30, 
	GML_ORAUDTR_XMLP_PKG.cf_user_name2formula(ad.created_by) CF_User_Name2,
	GML_ORAUDTR_XMLP_PKG.F_CF_1(ad.net_price,od.billing_currency) Format1
from
	op_ordr_hdr oh,
	op_ordr_dtl od,
	op_audt_mst ah,
	op_audt_dtl ad,
                  op_cust_mst op_cust_mst,
       	ic_item_mst ic_item_mst,
	op_ordr_sts op_ordr_sts 
WHERE 
	ah.changeorder_id = ad.changeorder_id
	and od.line_id = ad.line_id
	and od.order_id = oh.order_id 
	AND   od.item_id = ic_item_mst.item_id 
	AND   od.shipcust_id = op_cust_mst.cust_id 
	AND   od.delete_mark = 0 
 	and ad.line_status = op_ordr_sts.order_status
	and op_ordr_sts.lang_code = USERENV('LANG')
	and ah.order_id = oh.order_id 
 and od.order_id=:order_id 
 and od.order_id=:order_id 
 and ad.line_id=:line_id2
ORDER BY od.order_id,ad.line_id,ad.creation_date
Parameter Name SQL text Validation
user 
 
 Number
orgn 
 
Sort Order 4 
 
 LOV Oracle
Sort Order 3 
 
 LOV Oracle
Sort Order 2 
 
 LOV Oracle
Sort Order 1 
 
 LOV Oracle
To Operator Code 
 
 LOV Oracle
From Operator Code 
 
 LOV Oracle
To Item Number 
 
 LOV Oracle
From Item Number 
 
 LOV Oracle
To Change Date 
 
 Date
From Change Date 
 
 Date
To Order Number 
 
 LOV Oracle
From Order Number 
 
 LOV Oracle
To Ship Customer 
 
 LOV Oracle
From Ship Customer 
 
 LOV Oracle
Download
Related Blitz Reports
GML Bill Of Lading GML Unallocated Orders GML Ship Picklist GML Sales Order Acknowledgement GML PO/Stock Return History GML Items Received GML OPM Apps Receipt Number CST Supply Chain Consolidated Bills of Material Cost CST Supply Chain Indented Bills of Material Cost
Blitz Report In Action