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

SELECT DISTINCT
POHA.PO_HEADER_ID,
POHA.SEGMENT1,
POLA.LINE_NUM,
POLT.LINE_TYPE,
ESIT.DESCRIPTION,
POLA.QUANTITY,
POLA.UNIT_PRICE

FROM
PO_HEADERS_ALL POHA,
PO_LINES_ALL POLA,
PO_LINE_TYPES_TL POLT,
EGP_SYSTEM_ITEMS_TL ESIT,
PO_LINE_LOCATIONS_ALL POLLA

WHERE
 POHA.PO_HEADER_ID=POLA.PO_HEADER_ID
AND POLA.LINE_TYPE_ID=POLT.LINE_TYPE_ID
AND ESIT.INVENTORY_ITEM_ID=POLA.ITEM_ID
--AND POHA.SEGMENT1 like 'XXXXXXXX'
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