APPS.GMI_MOVE_ORDER_LINES_PVT dependencies on IC_TRAN_PND

Line 72: From ic_tran_pnd

68: And mtl.segment1= ic.item_no;
69:
70: CURSOR get_detailed_qtys IS
71: Select sum(abs(trans_qty)), sum(abs(trans_qty2))
72: From ic_tran_pnd
73: Where line_id = l_mo_line_rec.txn_source_line_id
74: -- And item_id = l_opm_item_id (commenting this line so that index on line_id gets used)
75: And lot_id <> 0
76: And doc_type = 'OMSO'

Line 82: From ic_tran_pnd

78: And completed_ind = 0;
79:
80: CURSOR get_default_detailed_qtys IS
81: Select sum(abs(trans_qty)), sum(abs(trans_qty2))
82: From ic_tran_pnd
83: Where line_id = l_mo_line_rec.txn_source_line_id
84: -- And item_id = l_opm_item_id (commenting this line so that index on line_id gets used)
85: And lot_id = 0
86: And doc_type = 'OMSO'

Line 101: FROM ic_tran_pnd

97:
98: /* Uday Phadtare Bug 2973135 */
99: CURSOR get_default_trans(p_line_id NUMBER, p_item_id NUMBER) IS
100: SELECT count(*)
101: FROM ic_tran_pnd
102: WHERE line_id = p_line_id
103: AND doc_type = 'OMSO'
104: -- AND item_id = p_item_id (commenting this line so that index on line_id gets used)
105: AND staged_ind = 0

Line 281: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND(l_default_tran_rec, l_default_tran_rec) THEN

277: END IF;
278:
279: l_default_tran_rec.trans_id := l_trans_id;
280:
281: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND(l_default_tran_rec, l_default_tran_rec) THEN
282: GMI_RESERVATION_UTIL.PrintLn('balancing default lot for line_id '|| l_mo_line_rec.txn_source_line_id);
283: GMI_RESERVATION_UTIL.balance_default_lot
284: ( p_ic_default_rec => l_default_tran_rec
285: , p_opm_item_id => l_default_tran_rec.item_id