Query to Get PO Header , PO Lines , PO Schedules and po distribution details

SQL Query to Get PO Header , PO Lines , PO Schedules and po distribution details 

SELECT DISTINCT

    poh.po_header_id,

    poh.segment1 AS po_number,

    pol.po_line_id,

    pol.line_num,

    pol.item_id,

    pol.quantity line_quantity,

    pod.po_distribution_id,

    pod.distribution_num,

    pod.quantity_ordered,

    pll.quantity schedule_qty,

    pll.need_by_date,

    pll.promised_date,

    pll.requested_ship_date

FROM

    po_headers_all        poh,

    po_lines_all          pol,

    po_distributions_all  pod,

    po_line_locations_all pll

WHERE

        pol.po_header_id = poh.po_header_id

    AND pod.po_line_id = pol.po_line_id

    AND pll.po_line_id = pol.po_line_id

    AND pod.line_location_id = pll.line_location_id and poh.segment1 =:PURCHASE_ORDER_NUMBER ORDER BY poh.segment1