DBA Data[Home] [Help]

APPS.INV_ITEM_EVENTS_PVT dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 156: FROM mtl_system_items_interface

152: CURSOR c_raise_item_change_event(cp_request_id NUMBER
153: ,cp_xset_id NUMBER) IS
154: SELECT 'x' FROM dual
155: WHERE EXISTS( SELECT NULL
156: FROM mtl_system_items_interface
157: WHERE set_process_id = cp_xset_id
158: AND process_flag = 7
159: AND request_id = cp_request_id
160: AND transaction_type in ('UPDATE','CREATE'));

Line 578: FROM mtl_system_items_interface

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