APPS.GMA_MIGRATION_PUB dependencies on IC_ITEM_MST

Line 179: FROM ic_loct_inv inv, ic_item_mst_b i, ic_whse_mst w

175: (item_id, lot_id, whse_mapping_code, whse_code, location, status) NOT IN (
176: SELECT inv.item_id, inv.lot_id,
177: DECODE(w.subinventory_ind_flag, 'Y', w.orgn_code, w.whse_code),
178: inv.whse_code, inv.location, inv.lot_status -- lot with diff status
179: FROM ic_loct_inv inv, ic_item_mst_b i, ic_whse_mst w
180: WHERE
181: inv.item_id = i.item_id AND
182: inv.whse_code = w.whse_code AND
183: i.lot_ctl = 1 AND

Line 209: FROM ic_loct_inv inv, ic_item_mst_b i, ic_whse_mst w

205: (item_id, lot_id, whse_mapping_code, whse_code, location, status) in (
206: SELECT inv.item_id, inv.lot_id,
207: DECODE(w.subinventory_ind_flag, 'Y', w.orgn_code, w.whse_code),
208: inv.whse_code, inv.location, inv.lot_status
209: FROM ic_loct_inv inv, ic_item_mst_b i, ic_whse_mst w
210: WHERE
211: inv.item_id = i.item_id AND
212: inv.whse_code = w.whse_code AND
213: i.lot_ctl = 1 AND

Line 277: FROM ic_loct_inv inv, ic_item_mst_b i, ic_lots_mst l, ic_whse_mst w

273: WHERE item_id = inv.item_id AND lot_id = inv.lot_id AND
274: whse_code = inv.whse_code AND additional_status_lot = 0 AND
275: rownum = 1) mig_status,
276: DECODE(i.sublot_ctl, 1, DECODE(l.sublot_no, NULL, NULL, l.lot_no)) parent_lot
277: FROM ic_loct_inv inv, ic_item_mst_b i, ic_lots_mst l, ic_whse_mst w
278: WHERE
279: inv.whse_code = w.whse_code AND
280: inv.item_id = i.item_id AND
281: i.lot_ctl = 1 AND

Line 327: FROM ic_item_mst

323: FUNCTION get_item_no(p_item_id NUMBER) RETURN VARCHAR2 IS
324: l_item_no VARCHAR2(80);
325: BEGIN
326: SELECT item_no INTO l_item_no
327: FROM ic_item_mst
328: WHERE item_id = p_item_id;
329: RETURN (l_item_no);
330: END get_item_no;
331: