DBA Data[Home] [Help]

APPS.MSC_ATP_PUB dependencies on PO_REQUISITION_HEADERS_ALL

Line 592: from po_requisition_headers_all prha

588: msc.msc_oe_data_temp_s.NEXTVAL,
589: l_atp_rec.identifier(i),
590: decode(l_atp_rec.oe_flag(i),'Y',(Select decode(MSC_ATP_PVT.G_INV_CTP, 5, l_atp_rec.OE_FLAG(i),
591: decode( prha.interface_source_code, 'MRP', 'Y', 'MSC', 'Y','CTO', 'Y', 'CTO-LOWER LEVEL', 'Y', 'N')) --4889943
592: from po_requisition_headers_all prha
593: where prha.requisition_header_id = l_atp_rec.attribute_01(i))), --5008194/FP 5054154
594:
595: decode(l_atp_rec.oe_flag(i),'Y', (Select po.destination_organization_id
596: from po_requisition_lines_all po,