DBA Data[Home] [Help]

APPS.INV_GMI_MIGRATION dependencies on IC_LOTS_MST_MIG

Line 1667: FROM ic_item_cnv c, ic_lots_mst_mig m

1663: l_migrated_ind PLS_INTEGER;
1664:
1665: CURSOR c_ic_item_cnv IS
1666: SELECT m.parent_lot_number, m.lot_number, m.organization_id, c.*
1667: FROM ic_item_cnv c, ic_lots_mst_mig m
1668: WHERE
1669: c.rowid BETWEEN p_start_rowid AND p_end_rowid and
1670: c.item_id = m.item_id and
1671: c.lot_id = m.lot_id and

Line 2042: UPDATE ic_lots_mst_mig

2038: adetail.last_update_date
2039: );
2040: END LOOP;
2041: END LOOP;
2042: UPDATE ic_lots_mst_mig
2043: SET
2044: conv_migrated_ind = 1,
2045: last_update_date = sysdate,
2046: last_updated_by = 0