APPS.CLN_SYNC_ITEM_PKG dependencies on MTL_ITEM_REVISIONS

Line 528: FROM mtl_item_revisions

524: END IF;
525:
526: SELECT count(*)
527: INTO l_count
528: FROM mtl_item_revisions
529: WHERE inventory_item_id = l_inventory_item_id
530: AND organization_id = p_organization_id
531: AND revision = p_item_revision;
532:

Line 1251: FROM mtl_item_revisions_interface mri

1247: WHERE process_flag IN (3,4)
1248: AND set_process_id = l_set_process_id
1249: UNION
1250: SELECT 'x'
1251: FROM mtl_item_revisions_interface mri
1252: WHERE process_flag IN (3,4)
1253: AND set_process_id = l_set_process_id
1254: UNION
1255: SELECT 'x'

Line 1667: ||' FROM mtl_item_revisions_interface mri'

1663: ||' AND process_flag IN (3,4)'
1664: ||' UNION'
1665: ||' SELECT DISTINCT INVENTORY_ITEM_ID,'
1666: ||' item_number, process_flag'
1667: ||' FROM mtl_item_revisions_interface mri'
1668: ||' WHERE process_flag IN (3,4)'
1669: ||' AND set_process_id = '||l_set_process_id
1670: ||' AND process_flag IN (3,4)'
1671: ||' UNION'