Requisition Details Query - ASCP

ELECT
  prqh.segment1 requisition_no
, prqh.creation_date
, papf.full_name Buyer
, msib.segment1 item
, prla.item_description
, prla.unit_meas_lookup_code uom
, prla.unit_price
, prla.quantity
, prla.source_type_code
, prla.quantity_delivered
, prla.need_by_date
, prla.note_to_receiver
, prla.justification
, prqh.org_id
, prla.destination_organization_id
, prqh.approved_date
, ood.organization_code
FROM
  po_requisition_headers_all prqh
, po_requisition_lines_all prla
, per_all_people_f papf
, mtl_system_items_b msib
, org_organization_definitions ood
WHERE
  prqh.requisition_header_id   =prla.requisition_header_id
AND ood.organization_id        = prla.destination_organization_id
AND prqh.interface_SOURCE_CODE = 'MSC'
AND prqh.preparer_id           =papf.person_id
AND msib.inventory_item_id     = prla.item_id
AND sysdate BETWEEN papf.effective_start_date AND papf.effective_end_date
AND prla.destination_organization_id=msib.organization_id
AND prqh.creation_date between :P_FROM_DATE and :P_TO_DATE
and prla.destination_organization_id = :P_ORG_ID
ORDER BY
  1;