GML Sales Order Audit Trail

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Sales Order Audit Trail Report of OPM OP
Application: Process Manufacturing Logistics
Source: Sales Order Audit Trail Report (XML)
Short Name: ORAUDTR_XML
DB package: GML_ORAUDTR_XMLP_PKG
Run GML Sales Order Audit Trail and other Oracle EBS reports with Blitz Report™ on our demo environment
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
From Ship Customer 
 
 LOV Oracle
To Ship Customer 
 
 LOV Oracle
From Order Number 
 
 LOV Oracle
To Order Number 
 
 LOV Oracle
From Change Date 
 
 Date
To Change Date 
 
 Date
From Item Number 
 
 LOV Oracle
To Item Number 
 
 LOV Oracle
From Operator Code 
 
 LOV Oracle
To Operator Code 
 
 LOV Oracle
Sort Order 1 
 
 LOV Oracle
Sort Order 2 
 
 LOV Oracle
Sort Order 3 
 
 LOV Oracle
Sort Order 4 
 
 LOV Oracle
Download
Related Blitz Reports
GML Bill Of Lading GML Ship Picklist GML Unallocated Orders GML Sales Order Acknowledgement ECC Process Manufacturing, Outside Processing Batch GML Items Received GML PO/Stock Return History GML OPM Apps Receipt Number CST Supply Chain Cost Rollup - Print
Blitz Report™

Blitz Report™ provides multiple benefits: