APPS.GML_MOLINE_DATA_FIX_PKG dependencies on OE_ORDER_LINES_ALL

Line 21: oe_order_lines_all d,

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
25: AND d.header_id = h.header_id

Line 42: oe_order_lines_all sol

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
46: AND NVL(mol.quantity_delivered, 0) = NVL(mol.quantity_detailed, 0)