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

HI Folks

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

select prha.segment1 Requisition_Number,poh.*

from po_requisition_headers_all prha,

     po_requisition_lines_all prla,

     po_req_distributions_all prda,

     po_distributions_all pda,

     PO_HEADERS_ALL poh

where poh.po_header_id =pda.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 poh.segment1 = :PO_Number