Oracle Apps - How do get PO details based on Requisition Number

Hi Folks,

Below is the query to get PO details based on Requisition Number

SELECT poh.segment1, prha.segment1 RequisitionNumber,poh.*

FROM   apps.po_headers_all poh

,      apps.po_lines_all pol

,      apps.po_distributions_all pod

,      apps.po_req_distributions_all prda

,      apps.po_requisition_lines_all prla

,      apps.po_requisition_headers_all prha

WHERE  poh.po_header_id = pol.po_header_id

AND    pol.po_line_id = pod.po_line_id

AND    pod.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    prha.segment1= :Requisition_Number

order by prha.LAST_UPDATE_DATE desc