APPS.INV_GMI_MIGRATION dependencies on IC_LOTS_MST

Line 174: FROM ic_lots_mst

170: BEGIN
171: SELECT lot_no ||decode(sublot_no, NULL,NULL,', '||sublot_no)
172: ||'('||to_char(p_lot_id)||')'
173: INTO l_return_val
174: FROM ic_lots_mst
175: WHERE lot_id = p_lot_id AND
176: rownum = 1;
177: EXCEPTION
178: WHEN NO_DATA_FOUND THEN

Line 1575: FROM ic_item_cnv c, ic_lots_mst_mig m

1571: l_migrated_ind PLS_INTEGER;
1572:
1573: CURSOR c_ic_item_cnv IS
1574: SELECT m.parent_lot_number, m.lot_number, m.organization_id, c.*
1575: FROM ic_item_cnv c, ic_lots_mst_mig m
1576: WHERE
1577: c.rowid BETWEEN p_start_rowid AND p_end_rowid and
1578: c.item_id = m.item_id and
1579: c.lot_id = m.lot_id and

Line 1950: UPDATE ic_lots_mst_mig

1946: adetail.last_update_date
1947: );
1948: END LOOP;
1949: END LOOP;
1950: UPDATE ic_lots_mst_mig
1951: SET
1952: conv_migrated_ind = 1,
1953: last_update_date = sysdate,
1954: last_updated_by = 0