APPS.EGO_IMPORT_BATCH_PURGE_PKG dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 46: ( -- Looking for failure rows in MTL_SYSTEM_ITEMS_INTERFACE

42: item_number,
43: BUNDLE_ID,
44: COALESCE -- search for failures
45: (
46: ( -- Looking for failure rows in MTL_SYSTEM_ITEMS_INTERFACE
47: SELECT 'PARTIAL'
48: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII
49: WHERE
50: ( MSII.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID

Line 48: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII

44: COALESCE -- search for failures
45: (
46: ( -- Looking for failure rows in MTL_SYSTEM_ITEMS_INTERFACE
47: SELECT 'PARTIAL'
48: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII
49: WHERE
50: ( MSII.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
51: OR ( MSII.ITEM_NUMBER = I.ITEM_NUMBER
52: AND (

Line 231: FROM MTL_SYSTEM_ITEMS_INTERFACE

227: 0 isincomp,
228: 0 isinsubcomp
229:
230: FROM ( SELECT DISTINCT set_process_id, organization_id, ORGANIZATION_CODE, REQUEST_ID, INVENTORY_ITEM_ID, item_number, BUNDLE_ID ,PROCESS_FLAG
231: FROM MTL_SYSTEM_ITEMS_INTERFACE
232: WHERE PROCESS_FLAG IN (3,6,7)
233:
234: UNION
235:

Line 293: DELETE FROM MTL_SYSTEM_ITEMS_INTERFACE

289:
290:
291: FORALL item IN 1.. l_item_table.Count
292:
293: DELETE FROM MTL_SYSTEM_ITEMS_INTERFACE
294: WHERE set_process_id = TREAT( l_item_table(item) AS Ego_item_list_inf).set_process_id
295: AND ( organization_id = TREAT( l_item_table(item) AS Ego_item_list_inf).organization_id
296: OR ( organization_code = TREAT( l_item_table(item) AS Ego_item_list_inf).organization_code
297: AND ( organization_code IS NULL OR TREAT( l_item_table(item) AS Ego_item_list_inf).organization_code IS NULL )

Line 1035: DELETE FROM MTL_SYSTEM_ITEMS_INTERFACE WHERE set_process_id = p_batch_id AND PROCESS_FLAG IN (3,6,7);

1031: SELECT BATCH_TYPE INTO l_batch_type FROM EGO_IMPORT_BATCHES_B WHERE BATCH_ID=p_batch_id;
1032:
1033: stm_num :=2;
1034:
1035: DELETE FROM MTL_SYSTEM_ITEMS_INTERFACE WHERE set_process_id = p_batch_id AND PROCESS_FLAG IN (3,6,7);
1036:
1037: fnd_file.put_line(fnd_file.Log,'No.of Item Entities deleted are '||SQL%ROWCOUNT);
1038:
1039: stm_num :=3;