APPS.MSC_REL_PS_PLAN_PUB dependencies on MSC_PO_REQUISITIONS_INTERFACE

Line 682: /* DELETE MSC_PO_REQUISITIONS_INTERFACE

678: EXECUTE IMMEDIATE lv_sql_stmt
679: USING IN po_group_by_name,
680: OUT arg_req_load_id;
681:
682: /* DELETE MSC_PO_REQUISITIONS_INTERFACE
683: WHERE sr_instance_id= arg_org_instance;
684: */
685: END;
686: END IF;

Line 772: select source_line_id from msc_po_requisitions_interface

768: AND transaction_id in
769: (select header_id from msc_wip_job_schedule_interface
770: where sr_instance_id = arg_org_instance
771: UNION ALL
772: select source_line_id from msc_po_requisitions_interface
773: where sr_instance_id = arg_org_instance
774: UNION ALL
775: select source_line_id from msc_po_reschedule_interface
776: where sr_instance_id = arg_org_instance

Line 788: DELETE MSC_PO_REQUISITIONS_INTERFACE

784: DELETE MSC_WIP_JOB_DTLS_INTERFACE
785: WHERE sr_instance_id= arg_org_instance
786: AND NVL(GROUP_ID,-1) = NVL(arg_wip_group_id, -1);
787:
788: DELETE MSC_PO_REQUISITIONS_INTERFACE
789: WHERE sr_instance_id= arg_org_instance
790: AND NVL(BATCH_ID, -1) = NVL(arg_po_batch_number, -1);
791:
792: DELETE MSC_PO_RESCHEDULE_INTERFACE

Line 811: DELETE MSC_PO_REQUISITIONS_INTERFACE

807: DELETE MSC_WIP_JOB_DTLS_INTERFACE
808: WHERE sr_instance_id= arg_org_instance
809: AND NVL(GROUP_ID,-1) = NVL(arg_wip_group_id, -1);
810:
811: DELETE MSC_PO_REQUISITIONS_INTERFACE
812: WHERE sr_instance_id= arg_org_instance
813: AND NVL(BATCH_ID, -1) = NVL(arg_po_batch_number, -1);
814:
815: