APPS.GML_MOLINE_DATA_FIX_PKG dependencies on IC_TXN_REQUEST_LINES

Line 19: FROM ic_txn_request_lines mo,

15: mo.quantity_detailed,
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

Line 39: FROM ic_txn_request_lines mol,

35: SELECT mol.line_id mo_line_id,
36: soh.order_number ,
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

Line 76: UPDATE ic_txn_request_lines

72: --DBMS_OUTPUT.put_line(' updating mo line quantity_delivered as ' || mo_line.trans_qty );
73:
74: --BEGIN BUG#2736088 V. Ajay Kumar
75: --Removed the reference to "apps".
76: UPDATE ic_txn_request_lines
77: SET quantity_delivered = mo_line.trans_qty,
78: secondary_quantity_delivered = mo_line.trans_qty2,
79: quantity_detailed = mo_line.trans_qty,
80: secondary_quantity_detailed = mo_line.trans_qty2

Line 102: UPDATE ic_txn_request_lines

98: --DBMS_OUTPUT.put_line(' This Move Order has to be updated to status=CLOSED');
99:
100: --BEGIN BUG#2736088 V. Ajay Kumar
101: --Removed the reference to "apps".
102: UPDATE ic_txn_request_lines
103: SET line_status = 5
104: WHERE line_id = mo_line_stat.mo_line_id;
105: --END BUG#2736088
106: