Join between PO and PA modules -- Oracle Apps R12

 SELECT PHA.SEGMENT1, PT.Task_name , PT.TASK_ID, PLA.UNIT_PRICE
FROM   PA_PROJECTS_ALL PA,
    PA_TASKS PT,
    PO_DISTRIBUTIONS_ALL PDA,
    PO_LINE_LOCATIONS_ALL PLLA,
    PO_LINES_ALL PLA,
    PO_HEADERS_ALL PHA,
    PO_REQ_DISTRIBUTIONS_ALL PRDA,
    PO_REQUISITION_LINES_ALL PRLA,
    PO_REQUISITION_HEADERS_ALL PRHA
WHERE  PA.PROJECT_ID = PT.PROJECT_ID
AND    PT.TASK_ID = PDA.TASK_ID
AND    PDA.LINE_LOCATION_ID = PLLA.LINE_LOCATION_ID
AND    PLLA.PO_LINE_ID = PLA.PO_LINE_ID
AND    PLA.PO_HEADER_ID = PHA.PO_HEADER_ID
AND    PDA.REQ_DISTRIBUTION_ID = PRDA.DISTRIBUTION_ID(+)
AND    PRDA.REQUISITION_LINE_ID = PRLA.REQUISITION_LINE_ID(+)
AND    PRLA.REQUISITION_HEADER_ID = PRHA.REQUISITION_HEADER_ID(+)
AND   (PHA.CANCEL_FLAG IS NULL OR PHA.CANCEL_FLAG = 'N')
AND   (PLA.CANCEL_FLAG IS NULL OR PLA.CANCEL_FLAG = 'N')
AND   (PLLA.CANCEL_FLAG IS NULL OR PLLA.CANCEL_FLAG = 'N')
AND PA.PROJECT_ID = 3109;