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