APPS.GML_RELEASE_SHIPMENT_PKG dependencies on IC_TRAN_PND

Line 15: FROM ic_tran_pnd

11: Lot_id as lot_id,
12: Location as location,
13: SUM(-Trans_qty) as qty,
14: 0 as valid_flag
15: FROM ic_tran_pnd
16: WHERE doc_type = 'OPSO'
17: AND delete_mark <> 1
18: AND completed_ind <> 1
19: AND trans_qty <> 0

Line 39: FROM ic_tran_pnd

35: ( SELECT distinct item_id,
36: whse_code,
37: lot_id,
38: location
39: FROM ic_tran_pnd
40: WHERE doc_type = 'OPSO'
41: AND delete_mark <> 1
42: AND completed_ind <> 1
43: AND trans_qty <> 0

Line 118: -- This loop checks if there is sufficient quantity in ic_tran_pnd

114: l_tran_pnd(i).valid_flag:= 1;
115: l_counter := l_counter + 1;
116: END IF;
117:
118: -- This loop checks if there is sufficient quantity in ic_tran_pnd
119: FOR j IN 1..l_num_onhand LOOP
120: IF ( (l_tran_pnd(i).item_id = l_loct_inv(j).item_id)
121: AND (l_tran_pnd(i).whse_code = l_loct_inv(j).whse_code)
122: AND (l_tran_pnd(i).lot_id = l_loct_inv(j).lot_id)