Query to find out the Requisition and PO number from Order Number in B2B Order?

SELECT   DISTINCT OOHA.ORDER_NUMBER,

                  OOHL.LINE_NUMBER,

                  PRHA.SEGMENT1 REQUISITION_NUMBER,

                  PRLA.LINE_NUM REQUISITION_LINE_NUMBER,

                  PHA.SEGMENT1 PO_NUMBER,

                  PLA.LINE_NUM PO_LINE_NUMBER

  FROM   OE_ORDER_HEADERS_ALL OOHA,

         OE_ORDER_LINES_ALL OOHL,

         PO_REQUISITION_HEADERS_ALL PRHA,

         PO_REQUISITION_LINES_ALL PRLA,

         PO_REQ_DISTRIBUTIONS_ALL PRDA,

         PO_DISTRIBUTIONS_ALL PDA,

         PO_HEADERS_ALL PHA,

         PO_LINES_ALL PLA

 WHERE   OOHA.HEADER_ID = OOHL.HEADER_ID

         AND PRHA.INTERFACE_SOURCE_LINE_ID = OOHL.LINE_ID

         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 PHA.PO_HEADER_ID = PLA.PO_HEADER_ID

         AND ooha.order_number = '10128192'