2 Replies Latest reply on May 8, 2013 4:10 PM by manu.mur

    Help for Query to find Requisition Requester from PO

    manu.mur
      Hi All,

      I am on R12.1

      I am using the below query to find the Requisition Requester from the PO Distributuion ID. I believe req_distribution_id on the po_distributions_all is the foreign key link to the distribution_id on po_req_distributions_all, and this is the link between PO and Requisition.

      select papf.last_name||','||papf.first_name from
      po_req_distributions_all prd,
      po_requisition_lines_all prl,
      per_all_people_f papf
      where prd.distribution_id = +< req_distribution_id on the po_distributions_all goes here>+ AND prd.requisition_line_id = prl.requisition_line_id
      AND prl.to_person_id = papf.person_id
      AND SYSDATE between papf.effective_start_Date and effective_end_date

      But for some POs, the req_distribution_id is NULL on the po_distributions_all table. But these POs were created from Requisitions and i can get to the requisition by searching with PO # from frontend (Requisition Summary screen)

      How can fetch the requisition requester for these POs?