APPS.EGO_IMPORT_BATCH_PURGE_PKG dependencies on MTL_ITEM_CATEGORIES_INTERFACE

Line 121: ( -- Looking for failure rows in MTL_ITEM_CATEGORIES_INTERFACE

117: AND EIPI.REQUEST_ID = I.REQUEST_ID
118: AND ROWNUM = 1
119: )
120: ,
121: ( -- Looking for failure rows in MTL_ITEM_CATEGORIES_INTERFACE
122: SELECT 'PARTIAL'
123: FROM MTL_ITEM_CATEGORIES_INTERFACE MICI
124: WHERE
125: ( MICI.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID

Line 123: FROM MTL_ITEM_CATEGORIES_INTERFACE MICI

119: )
120: ,
121: ( -- Looking for failure rows in MTL_ITEM_CATEGORIES_INTERFACE
122: SELECT 'PARTIAL'
123: FROM MTL_ITEM_CATEGORIES_INTERFACE MICI
124: WHERE
125: ( MICI.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
126: OR ( MICI.ITEM_NUMBER = I.ITEM_NUMBER
127: AND (

Line 249: FROM MTL_ITEM_CATEGORIES_INTERFACE

245:
246: UNION
247:
248: SELECT DISTINCT set_process_id , organization_id, ORGANIZATION_CODE, REQUEST_ID, INVENTORY_ITEM_ID, item_number, BUNDLE_ID, PROCESS_FLAG
249: FROM MTL_ITEM_CATEGORIES_INTERFACE
250: WHERE PROCESS_FLAG IN (3,6,7)
251:
252: UNION
253:

Line 377: DELETE FROM MTL_ITEM_CATEGORIES_INTERFACE

373:
374:
375: FORALL item IN l_item_table.first .. l_item_table.last
376:
377: DELETE FROM MTL_ITEM_CATEGORIES_INTERFACE
378: WHERE SET_PROCESS_ID = TREAT( l_item_table(item) AS Ego_item_list_inf).SET_PROCESS_ID
379: AND ( organization_id = TREAT( l_item_table(item) AS Ego_item_list_inf).organization_id
380: OR ( organization_code = TREAT( l_item_table(item) AS Ego_item_list_inf).organization_code
381: AND ( organization_code IS NULL OR TREAT( l_item_table(item) AS Ego_item_list_inf).organization_code IS NULL )

Line 1055: DELETE FROM MTL_ITEM_CATEGORIES_INTERFACE WHERE SET_PROCESS_ID = p_batch_id AND PROCESS_FLAG IN (3,6,7);

1051:
1052:
1053: stm_num :=5;
1054:
1055: DELETE FROM MTL_ITEM_CATEGORIES_INTERFACE WHERE SET_PROCESS_ID = p_batch_id AND PROCESS_FLAG IN (3,6,7);
1056:
1057: fnd_file.put_line(fnd_file.Log,'No.of Item Categories Entities deleted are '||SQL%ROWCOUNT);
1058:
1059: