DBA Data[Home] [Help]

APPS.GML_MOLINE_DATA_FIX_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 20: oe_order_headers_all h,

16: mo.quantity_delivered,
17: NVL( (-1) * sum(itp.trans_qty), 0) trans_qty,
18: NVL( (-1) * sum(itp.trans_qty2), 0) trans_qty2
19: FROM ic_txn_request_lines mo,
20: oe_order_headers_all h,
21: oe_order_lines_all d,
22: ic_tran_pnd itp
23: WHERE itp.line_id(+) = mo.txn_source_line_id
24: AND mo.txn_source_line_id = d.line_id

Line 41: oe_order_headers_all soh,

37: sol.line_id order_line_id,
38: moh.request_number
39: FROM ic_txn_request_lines mol,
40: ic_txn_request_headers moh,
41: oe_order_headers_all soh,
42: oe_order_lines_all sol
43: WHERE moh.header_id = mol.header_id
44: AND soh.header_id = sol.header_id
45: AND sol.line_id = mol.txn_source_line_id