QUERY TO FIND OUT PR AND PO LINKED Oracle Purchasing - SQL

QUERY TO FIND OUT PR AND PO LINKED Oracle Purchasing - SQL

Below is the query for find our PR and PO

select req.segment1,req.DESCRIPTION req_,req.APPROVED_DATE,po.segment1,po.CREATION_DATE,po.APPROVED_FLAG
from po_headers_all po,
po_distributions_all dst,
po_req_distributions_all rd,
po_requisition_lines_all rl,
po_requisition_headers_all req
where po.po_header_id = dst.po_header_id
and dst.req_distribution_id = rd.distribution_id
and rd.requisition_line_id = rl.requisition_line_id
and rl.requisition_header_id = req.requisition_header_id