APPS.MSC_REL_PS_PLAN_PUB dependencies on MSC_PO_REQUISITIONS_INTERFACE

Line 701: /* DELETE MSC_PO_REQUISITIONS_INTERFACE

697: EXECUTE IMMEDIATE lv_sql_stmt
698: USING IN po_group_by_name,
699: OUT arg_req_load_id;
700:
701: /* DELETE MSC_PO_REQUISITIONS_INTERFACE
702: WHERE sr_instance_id= arg_org_instance;
703: */
704: END;
705: END IF;

Line 791: select source_line_id from msc_po_requisitions_interface

787: AND transaction_id in
788: (select header_id from msc_wip_job_schedule_interface
789: where sr_instance_id = arg_org_instance
790: UNION ALL
791: select source_line_id from msc_po_requisitions_interface
792: where sr_instance_id = arg_org_instance
793: UNION ALL
794: select source_line_id from msc_po_reschedule_interface
795: where sr_instance_id = arg_org_instance

Line 814: DELETE MSC_PO_REQUISITIONS_INTERFACE

810: DELETE MSC_WIP_JOB_DTLS_INTERFACE
811: WHERE sr_instance_id= arg_org_instance
812: AND NVL(GROUP_ID,-1) = NVL(arg_wip_group_id, -1);
813:
814: DELETE MSC_PO_REQUISITIONS_INTERFACE
815: WHERE sr_instance_id= arg_org_instance
816: AND NVL(BATCH_ID, -1) = NVL(arg_po_batch_number, -1);
817:
818: DELETE MSC_PO_RESCHEDULE_INTERFACE

Line 837: DELETE MSC_PO_REQUISITIONS_INTERFACE

833: DELETE MSC_WIP_JOB_DTLS_INTERFACE
834: WHERE sr_instance_id= arg_org_instance
835: AND NVL(GROUP_ID,-1) = NVL(arg_wip_group_id, -1);
836:
837: DELETE MSC_PO_REQUISITIONS_INTERFACE
838: WHERE sr_instance_id= arg_org_instance
839: AND NVL(BATCH_ID, -1) = NVL(arg_po_batch_number, -1);
840:
841: