APPS.EGO_IMPORT_UTIL_PVT dependencies on MTL_SYSTEM_ITEMS_INTERFACE_S

Line 36: SOURCE_SYSTEM_REFERENCE MTL_SYSTEM_ITEMS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE,

32: TRANSACTION_ID NUMBER,
33: INVENTORY_ITEM_ID NUMBER,
34: ORGANIZATION_ID NUMBER,
35: ITEM_NUMBER MTL_SYSTEM_ITEMS_INTERFACE.ITEM_NUMBER%TYPE,
36: SOURCE_SYSTEM_REFERENCE MTL_SYSTEM_ITEMS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE,
37: SOURCE_SYSTEM_ID NUMBER,
38: DATA_LEVEL_ID NUMBER,
39: SUPPLIER_ID NUMBER,
40: SUPPLIER_SITE_ID NUMBER,

Line 5431: SELECT style_item_flag,mtl_system_items_interface_s.NEXTVAL,

5427: AND application_id = 431);
5428:
5429: CURSOR c_item_details
5430: IS
5431: SELECT style_item_flag,mtl_system_items_interface_s.NEXTVAL,
5432: item_catalog_group_id
5433: FROM mtl_system_items_interface
5434: WHERE item_number = p_item_number
5435: AND organization_id = p_organization_id

Line 5559: ,MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

5555: )
5556: VALUES
5557: (
5558: 2
5559: ,MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
5560: ,p_batch_id
5561: ,'SYNC'
5562: ,p_item_number
5563: ,p_organization_id