DBA Data[Home] [Help]

APPS.MSC_A2A_XML_WF dependencies on MSC_PO_REQUISITIONS_INTERFACE

Line 152: DELETE MSC_PO_REQUISITIONS_INTERFACE

148: DELETE MSC_PO_RESCHEDULE_INTERFACE
149: WHERE purchase_order_id = p_unique_id;
150:
151: ELSIF p_map_code = 'MSC_REQUISITNO_OAG71_OUT' THEN
152: DELETE MSC_PO_REQUISITIONS_INTERFACE
153: WHERE source_line_id = p_unique_id;
154:
155: ELSIF p_map_code = 'MSC_PRODORDERO_OAG71_OUT' THEN
156: DELETE MSC_WIP_JOB_SCHEDULE_INTERFACE

Line 261: 'select distinct source_line_id from msc_po_requisitions_interface '

257:
258: -- Create Reqs
259:
260: OPEN c_cur FOR
261: 'select distinct source_line_id from msc_po_requisitions_interface '
262: ||' where sr_instance_id = :instance_id' USING p_instance_id;
263:
264: LOOP
265: