DBA Data[Home] [Help]

APPS.CLN_SYNC_ITEM_PKG dependencies on MTL_ITEM_CATEGORIES_INTERFACE

Line 1256: FROM mtl_item_categories_interface mici

1252: WHERE process_flag IN (3,4)
1253: AND set_process_id = l_set_process_id
1254: UNION
1255: SELECT 'x'
1256: FROM mtl_item_categories_interface mici
1257: WHERE process_flag IN (3,4)
1258: AND set_process_id = l_set_process_id
1259: );
1260: EXCEPTION

Line 1674: ||' FROM mtl_item_categories_interface mici'

1670: ||' AND process_flag IN (3,4)'
1671: ||' UNION'
1672: ||' SELECT DISTINCT INVENTORY_ITEM_ID,'
1673: ||' item_number, process_flag'
1674: ||' FROM mtl_item_categories_interface mici'
1675: ||' WHERE process_flag IN (3,4)'
1676: ||' AND set_process_id = '||l_set_process_id
1677: ||' AND process_flag IN (3,4)';
1678: