Query to get the PO header details in Oracle Fusion

SELECT DISTINCT
POHA.PO_HEADER_ID,
POHA.SEGMENT1,
HAOT.NAME as PRC_BU_ID,
HAOT.NAME as REQ_BU_ID,
HAOT.NAME as BILLTO_BU_ID,
XEP.NAME as SOLDTO_LE_ID,
HRLA1.LOCATION_NAME as BILL_TO_LOCATION_ID,
HRLA.LOCATION_NAME as SHIP_TO_LOCATION_ID,
--HRLA.LOCATION_NAME,
HP.PARTY_NAME as VENDOR_NAME,
--HPS.PARTY_SITE_NAME,
--PSS.VENDOR_SITE_CODE,
APT.NAME,
PPNF.LAST_NAME||', '||PPNF.FIRST_NAME "Buyer Name",
POHA.DOCUMENT_STATUS,
PSS.VENDOR_SITE_CODE

FROM
PO_HEADERS_ALL POHA,
HR_ORGANIZATION_UNITS_F_TL HAOT,
XLE_ENTITY_PROFILES XEP,
HR_LOCATIONS_ALL HRLA,
HR_LOCATIONS_ALL HRLA1,
POZ_SUPPLIERS PS,
HZ_PARTIES HP,
HZ_PARTY_SITES HPS,
AP_TERMS_TL APT,
PER_PERSON_NAMES_F PPNF,
POZ_SUPPLIER_SITES_ALL_M PSS

WHERE
    HAOT.ORGANIZATION_ID = POHA.BILLTO_BU_ID
AND HAOT.ORGANIZATION_ID = POHA.PRC_BU_ID
AND HAOT.ORGANIZATION_ID = POHA.REQ_BU_ID
AND XEP.LEGAL_ENTITY_ID = POHA.SOLDTO_LE_ID
AND HRLA.LOCATION_ID=POHA.SHIP_TO_LOCATION_ID
AND HRLA1.LOCATION_ID=POHA.BILL_TO_LOCATION_ID
AND PS.VENDOR_ID=POHA.VENDOR_ID
AND PS.PARTY_ID=HP.PARTY_ID
AND HP.PARTY_ID=HPS.PARTY_ID
AND APT.TERM_ID=POHA.TERMS_ID
AND PPNF.PERSON_ID=POHA.AGENT_ID
AND PSS.VENDOR_SITE_ID=POHA.VENDOR_SITE_ID
--AND POHA.SEGMENT1 like 'XXXXXX'
AND POHA.DOCUMENT_STATUS <>'CLOSED'
AND POHA.DOCUMENT_STATUS <>'CANCELED'
AND POHA.DOCUMENT_STATUS <>'CLOSED FOR RECEIVING'
AND POHA.DOCUMENT_STATUS <>'INCOMPLETE'
AND POHA.DOCUMENT_STATUS <>'CLOSED FOR INVOICING'

ORDER BY POHA.SEGMENT1