DBA Data[Home] [Help]

APPS.MSC_ATP_PUB dependencies on PO_REQUISITION_HEADERS_ALL

Line 598: from po_requisition_headers_all prha

594: msc.msc_oe_data_temp_s.NEXTVAL,
595: l_atp_rec.identifier(i),
596: decode(l_atp_rec.oe_flag(i),'Y',(Select decode(MSC_ATP_PVT.G_INV_CTP, 5, l_atp_rec.OE_FLAG(i),
597: decode( prha.interface_source_code, 'MRP', 'Y', 'MSC', 'Y','CTO', 'Y', 'CTO-LOWER LEVEL', 'Y', 'N')) --4889943
598: from po_requisition_headers_all prha
599: where prha.requisition_header_id = l_atp_rec.attribute_01(i))), --5008194/FP 5054154
600:
601: decode(l_atp_rec.oe_flag(i),'Y', (Select po.destination_organization_id
602: from po_requisition_lines_all po,