APPS.INV_ITEM_EVENTS_PVT dependencies on DUAL

Line 154: SELECT 'x' FROM dual

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

Line 164: SELECT 'x' FROM dual

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

Line 173: SELECT 'x' FROM dual

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

Line 576: SELECT 'x' FROM dual

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

Line 586: SELECT 'x' FROM dual

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