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 NameSQL textValidation
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 GML Unallocated Orders Report (OPM - OM) GMD Production Test Results
Blitz Report In Action