GML Sales Order Audit Trail

➜ Back to Library
Description
Categories: BI Publisher
Columns: Order Id2, Orgn Code, Cust No, Cust Name, Shipper Code, Sched Shipdate, Qc Grade Wanted, Order No, From Whse, Line No ...
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
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
orgn 
 
user 
 
 Number
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 Temporary Supply Chain Cost Rollup - Print CST Supply Chain Consolidated Bills of Material Cost
Blitz Report In Action
Blitz Report™

Blitz Report™ provides multiple benefits: