GML Sales Order Audit Trail
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
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 | |
|---|---|---|---|
| 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 |
