APPS.INVPAGI2 dependencies on MTL_SYSTEM_ITEMS_S

Line 324: SELECT MTL_SYSTEM_ITEMS_S.CURRVAL

320: for cr in ee loop
321: --User can now populate inventory item id in the interface table.
322: l_Itemid_error := FALSE;
323: BEGIN
324: SELECT MTL_SYSTEM_ITEMS_S.CURRVAL
325: INTO l_item_id FROM DUAL;
326: IF cr.inventory_item_id > l_item_id THEN
327: l_Itemid_error := TRUE;
328: END IF;

Line 993: set inventory_item_id = MTL_SYSTEM_ITEMS_S.nextval

989: INVPUTLI.info('INVPAGI2: No match in MSI; Creating Inventory Item Id from sequence');
990: END IF;
991:
992: update MTL_SYSTEM_ITEMS_INTERFACE
993: set inventory_item_id = MTL_SYSTEM_ITEMS_S.nextval
994: where rowid = cr.rowid
995: returning inventory_item_id INTO cr.inventory_item_id;
996:
997: dbms_sql.close_cursor(DSQL_c);