PO Quotation Details (Oracle Fusion SQL)

Supply Chain & Manufacturing (SCM) Purchase Order (PO-Fusion-SQL's)
1

This PO Quotation Details query displays quotation and purchase order details for each supplier and operating unit, helping users track procurement status and supplier commitments.

#sqlquery

SELECT
    --SQL4Fusion (An Orbit Analytics Project)
    --Retrieve quotation and purchase order details with supplier info.
	HAOU.NAME  OPERATING_UNIT,
	PSV.SEGMENT1 SUPPLIER_NUMBER,
	PSV.VENDOR_NAME  SUPPLIER_NAME,
	PSSAM.VENDOR_SITE_CODE  SUPPLIER_SITE,
	PRHA.REQUISITION_NUMBER  QUOTATION_NUMBER,
    PRLA.SOURCE_DOCUMENT_TYPE  QUOTATION_TYPE,
    PHA.SEGMENT1 PO_NUMBER,
	PHA.TYPE_LOOKUP_CODE,
    PHA.APPROVED_DATE,
    PLA.LINE_NUM  LINE_NUMBER,
    PLA.ITEM_DESCRIPTION,
    PLA.QUANTITY,
    PLA.UNIT_PRICE,
	PHA.CURRENCY_CODE CURRENCY,
    NVL(PLA.AMOUNT,0)  LINE_AMOUNT,
	PLLA.NEED_BY_DATE,
    PLLA.PROMISED_DATE
FROM
    POR_REQUISITION_HEADERS_ALL PRHA,
    POR_REQUISITION_LINES_ALL PRLA,
    POR_REQ_DISTRIBUTIONS_ALL PRDA,
    PO_HEADERS_ALL PHA,
    PO_LINES_ALL PLA,
    PO_LINE_LOCATIONS_ALL PLLA,
	PO_DISTRIBUTIONS_ALL PDA,
    POZ_SUPPLIERS_V PSV,
    POZ_SUPPLIER_SITES_ALL_M PSSAM,
    HR_ALL_ORGANIZATION_UNITS HAOU
WHERE
    PRHA.REQUISITION_HEADER_ID = PRLA.REQUISITION_HEADER_ID
    AND PRLA.REQUISITION_LINE_ID = PRDA.REQUISITION_LINE_ID
    AND PRDA.DISTRIBUTION_ID = PDA.REQ_DISTRIBUTION_ID
    AND PDA.PO_HEADER_ID = PHA.PO_HEADER_ID
    AND PHA.PO_HEADER_ID = PLA.PO_HEADER_ID
    AND PLA.PO_LINE_ID = PLLA.PO_LINE_ID
    AND PHA.VENDOR_ID = PSV.VENDOR_ID
    AND PHA.VENDOR_SITE_ID = PSSAM.VENDOR_SITE_ID
    AND PHA.PRC_BU_ID = HAOU.ORGANIZATION_ID
	--AND PHA.TYPE_LOOKUP_CODE = 'QUOTATION'
ORDER BY 
PHA.SEGMENT1