APPS.INV_ITEM_EVENTS_PVT dependencies on DUAL

Line 155: SELECT 'x' FROM dual

151: update to the tables by checking the records with process_flag=7 */
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

Line 166: SELECT 'x' FROM dual

162: AND transaction_type in ('UPDATE','CREATE'));
163:
164: CURSOR c_raise_revision_event(cp_request_id NUMBER
165: ,cp_xset_id NUMBER) IS
166: SELECT 'x' FROM dual
167: WHERE EXISTS(SELECT NULL
168: FROM mtl_item_revisions_interface
169: WHERE set_process_id = cp_xset_id
170: AND process_flag = 7

Line 175: SELECT 'x' FROM dual

171: AND request_id = cp_request_id);
172:
173: CURSOR c_raise_item_categories_event(cp_request_id NUMBER
174: ,cp_xset_id NUMBER) IS
175: SELECT 'x' FROM dual
176: WHERE EXISTS(SELECT NULL
177: FROM mtl_item_categories_interface
178: WHERE set_process_id = cp_xset_id
179: AND process_flag = 7

Line 580: SELECT 'x' FROM dual

576: update to the tables by checking the records with process_flag=7 */
577:
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

Line 590: SELECT 'x' FROM dual

586: AND transaction_type in ('UPDATE','CREATE'));
587:
588: CURSOR c_raise_item_categories_event(cp_request_id NUMBER
589: ,cp_xset_id NUMBER) IS
590: SELECT 'x' FROM dual
591: WHERE EXISTS(SELECT NULL
592: FROM mtl_item_categories_interface
593: WHERE set_process_id = cp_xset_id
594: AND process_flag = 7