Query to get Requisition to PO Details in Oracle Fusion

SELECT DISTINCT PRHA.REQUISITION_NUMBER,

                PHA.SEGMENT1 PO_NUMBER,

                PAH.OBJECT_TYPE_CODE,

                PAH.OBJECT_SUB_TYPE_CODE,

                PAH.SEQUENCE_NUM,

                PPTF.FULL_NAME REQUESTER,

                PAH.ACTION_CODE,

                PAH.ACTION_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_DISTRIBUTIONS_ALL PDA,

       PO_ACTION_HISTORY PAH,

       PER_PERSON_NAMES_F PPTF

 WHERE 1 = 1

       AND PRHA.requisition_number IN

              ('REQ-12345')

       AND 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 PDA.PO_LINE_ID = PLA.PO_LINE_ID

       AND PRHA.REQUISITION_HEADER_ID = PAH.OBJECT_ID

       AND PPTF.PERSON_ID = PAH.PERFORMER_ID

       AND PPTF.name_type='GLOBAL'

       AND TRUNC(SYSDATE) BETWEEN PPTF.effective_start_date AND PPTF.effective_end_date