GML Sales Order Audit Trail

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
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
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