APPS.GML_RELEASE_SHIPMENT_PKG dependencies on IC_LOCT_INV

Line 33: FROM ic_loct_inv

29: Lot_id as lot_id,
30: Location as location,
31: loct_onhand as qty,
32: 0 as valid_flag
33: FROM ic_loct_inv
34: WHERE (item_id, whse_code, lot_id, location) in
35: ( SELECT distinct item_id,
36: whse_code,
37: lot_id,

Line 103: -- Loop to see if a record exists in IC_LOCT_INV

99: l_tran_pnd(i).valid_flag:= 0;
100: l_counter := l_counter + 1;
101: ELSE
102:
103: -- Loop to see if a record exists in IC_LOCT_INV
104: FOR j IN 1..l_num_onhand LOOP
105: IF ( (l_tran_pnd(i).item_id = l_loct_inv(j).item_id)
106: AND (l_tran_pnd(i).whse_code = l_loct_inv(j).whse_code)
107: AND (l_tran_pnd(i).lot_id = l_loct_inv(j).lot_id)