PR's Raised against Particular Job

SELECT   ROWNUM "SL NO",
                prha.segment1 "PR NO",
                prha.creation_date "PR CREATION DATE",
               (prla.quantity*prla.unit_price) "PR VALUE",
               msib.inventory_item_id "MATERIAL CODE",
               msib.description "MATERIAL DESCRIPTION",
               prla.quantity "QTY",
               prla.unit_meas_lookup_code "UOM",
               prha.authorization_status "PR APPROVAL STATUS",
               pha.segment1 "PO NO",
               pha.creation_date "PO DATE",
               (pla.quantity*pla.unit_price) "PO VALUE"
FROM     po_requisition_headers_all prha,
              po_requisition_lines_all prla,
              mtl_system_items_b msib,
              po_headers_all pha,
              po_req_distributions_all prda,
              po_distributions_all pda,
              po_lines_all pla,
              hr_operating_units hou
WHERE prha.requisition_header_id=prla.requisition_header_id
AND       prha.org_id=msib.organization_id
AND       msib.inventory_item_id=prla.item_id
AND       prla.requisition_line_id=prda.requisition_line_id
AND       prda.distribution_id=pda.req_distribution_id
AND       pda.po_line_id=pla.po_line_id
AND       pla.po_header_id=pha.po_header_id
AND       hou.name=:Operating_Unit
AND       TRUNC(prha.creation_date)  BETWEEN NVL(:From_Creation_Date,to_date                                                   (prha.creation_date,'DD-MON-RR')) AND NVL(:To_Creation_Date,to_date
              (prha.creation_date,'DD-MON-RR'))
AND       msib.inventory_item_id BETWEEN NVL(:From_Material_Code,msib.inventory_item_id)
              AND NVL(:To_Material_Code,msib.inventory_item_id)