Query for the Open Purchase Orders (PO's) distribution details in Oracle Fusion

SELECT DISTINCT
POHA.PO_HEADER_ID,
POHA.SEGMENT1,
POLA.LINE_NUM,
PODA.QUANTITY_ORDERED,
PODA.QUANTITY_DELIVERED,
PODA.AMOUNT_BILLED,
PODA.QUANTITY_ORDERED - PODA.QUANTITY_DELIVERED as NEW_PO_TO_BE_CREATED,
PODA.PJC_PROJECT_ID,
PODA.PJC_TASK_ID,
PODA.PJC_EXPENDITURE_ITEM_DATE,
PODA.PJC_ORGANIZATION_ID,
PODA.PJC_BILLABLE_FLAG

FROM
PO_HEADERS_ALL POHA,
PO_LINES_ALL POLA,
PO_LINE_LOCATIONS_ALL POLLA,
PO_DISTRIBUTIONS_ALL PODA

WHERE
 POHA.PO_HEADER_ID=POLA.PO_HEADER_ID
AND POLA.PO_LINE_ID=POLLA.PO_LINE_ID
AND POLLA.LINE_LOCATION_ID=PODA.LINE_LOCATION_ID
--AND POHA.SEGMENT1 like 'P2'
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