APPS.INV_ITEM_EVENTS_PVT dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 156: WHERE EXISTS( SELECT /*+ first_rows index(MTL_SYSTEM_ITEMS_INTERFACE,MTL_SYSTEM_ITEMS_INTERFACE_N3) */ -- Bug 10404086

152:
153: CURSOR c_raise_item_change_event(cp_request_id NUMBER
154: ,cp_xset_id NUMBER) IS
155: SELECT 'x' FROM dual
156: WHERE EXISTS( SELECT /*+ first_rows index(MTL_SYSTEM_ITEMS_INTERFACE,MTL_SYSTEM_ITEMS_INTERFACE_N3) */ -- Bug 10404086
157: NULL
158: FROM mtl_system_items_interface
159: WHERE set_process_id = cp_xset_id
160: AND process_flag = 7

Line 158: FROM mtl_system_items_interface

154: ,cp_xset_id NUMBER) IS
155: SELECT 'x' FROM dual
156: WHERE EXISTS( SELECT /*+ first_rows index(MTL_SYSTEM_ITEMS_INTERFACE,MTL_SYSTEM_ITEMS_INTERFACE_N3) */ -- Bug 10404086
157: NULL
158: FROM mtl_system_items_interface
159: WHERE set_process_id = cp_xset_id
160: AND process_flag = 7
161: AND request_id = cp_request_id
162: AND transaction_type in ('UPDATE','CREATE'));

Line 582: FROM mtl_system_items_interface

578: CURSOR c_raise_item_change_event(cp_request_id NUMBER
579: ,cp_xset_id NUMBER) IS
580: SELECT 'x' FROM dual
581: WHERE EXISTS( SELECT NULL
582: FROM mtl_system_items_interface
583: WHERE set_process_id = cp_xset_id
584: AND process_flag = 7
585: AND request_id = cp_request_id
586: AND transaction_type in ('UPDATE','CREATE'));