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 6215: SELECT style_item_flag,mtl_system_items_interface_s.NEXTVAL,

6211: AND application_id = 431);
6212:
6213: CURSOR c_item_details
6214: IS
6215: SELECT style_item_flag,mtl_system_items_interface_s.NEXTVAL,
6216: item_catalog_group_id
6217: FROM mtl_system_items_interface
6218: WHERE item_number = p_item_number
6219: AND organization_id = p_organization_id

Line 6343: ,MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

6339: )
6340: VALUES
6341: (
6342: 2
6343: ,MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
6344: ,p_batch_id
6345: ,'SYNC'
6346: ,p_item_number
6347: ,p_organization_id