DBA Data[Home] [Help]

APPS.CLN_SYNC_ITEM_PKG dependencies on MTL_ITEM_REVISIONS_INTERFACE

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'