APPS.CLN_SYNC_ITEM_PKG dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 1246: FROM mtl_system_items_interface msit

1242: WHERE REQUEST_ID = l_request_id
1243: AND TRANSACTION_ID > 0
1244: AND rownum < 2*/
1245: SELECT 'x'
1246: FROM mtl_system_items_interface msit
1247: WHERE process_flag IN (3,4)
1248: AND set_process_id = l_set_process_id
1249: UNION
1250: SELECT 'x'

Line 1660: ||' FROM mtl_system_items_interface msit'

1656: END IF;
1657:
1658: sql_statement := ' SELECT DISTINCT INVENTORY_ITEM_ID,'
1659: ||' item_number, process_flag'
1660: ||' FROM mtl_system_items_interface msit'
1661: ||' WHERE process_flag IN (3,4)'
1662: ||' AND set_process_id = '||l_set_process_id
1663: ||' AND process_flag IN (3,4)'
1664: ||' UNION'