APPS.GMI_PURGE_EMPTY_BAL_PKG dependencies on IC_LOCT_INV

Line 130: ' FROM ic_loct_inv a,ic_item_mst b,ic_lots_mst c ' ||

126: --Bug#3315228 Ramakrishna the l_where2 is taken out from the select statement
127: l_select_stmt := 'SELECT b.item_no,a.whse_code,a.location, ' ||
128: ' a.loct_onhand,a.rowid, a.loct_onhand2,a.qchold_res_code, ' ||
129: ' a.lot_status,decode(c.lot_no,'||''''||l_default_lot||''''||',NULL,c.lot_no) lot_no ' ||
130: ' FROM ic_loct_inv a,ic_item_mst b,ic_lots_mst c ' ||
131: ' WHERE a.item_id = '|| l_where_clause || l_where1
132: ||' and a.lot_id = c.lot_id and b.item_id = c.item_id ';
133: --END BUG#2552369
134:

Line 177: FROM ic_loct_inv

173: --BEGIN BUG#2552369 V. Ajay Kumar
174: --Commented the additional WHERE clause from the DELETE statement.
175:
176: DELETE
177: FROM ic_loct_inv
178: WHERE rowid = l_row_id;
179: --AND loct_onhand >= 0
180: --AND loct_onhand <= .000000001;
181: