4 Replies Latest reply on Dec 23, 2009 11:15 AM by S.PDASH

    Urgent : PO Approver ID or Approver Name

    user627525
      Hi Friends,

      I have to develop the RDF. It contains po number,amount, PO Approver_name, PO Approver_job.

      I could not able to find the PO Approver_name, Approver_job. kindly some one help me from which Table i can able to find these columns.

      Thanks in advance.

      Edited by: user627525 on Dec 21, 2009 4:34 AM
        • 1. Re: Urgent : PO Approver ID or Approver Name
          user627525
          Kindly some one help me to sort out this issue.

          Thanks.
          • 2. Re: Urgent : PO Approver ID or Approver Name
            S.PDASH
            Hi,
            Basically I am a functional person and I gathered my courage to build up a query to address your tech question.. Hope below query will solve your issue, I am optimistic :)

            select a.segment1 PO_NUM, sum(b.unit_price b.quantity) PO_Price, c.employee_name Approver_name, d.d_job_id JOB*
            from po_headers_all a, po_lines_all b, PO_ACTION_HISTORY_v c, PER_ASSIGNMENTS_V7 d
            where a.org_id = <org_id>   --- e.g Operating_unit: 3593
            and a.segment1 = <PO_Number> --- e.g. '600001145'
            and a.approved_flag = 'Y'
            and a.po_header_id = b.po_header_id
            and a.po_header_id = c.object_id
            and c.action_code = 'APPROVE'
            AND c.sequence_num =
            *(SELECT max(sequence_num)*
            FROM  PO_ACTION_HISTORY_v
            where object_id = a.po_header_id)
            AND c.employee_id=d.person_id
            group by a.segment1, c.employee_id, c.employee_name, d.d_job_id

            Please execute the above query and let us know your feedback.

            Regards,
            S.P DASH
            • 3. Re: Urgent : PO Approver ID or Approver Name
              user627525
              Thanks very much S.P DASH for your reply. i have used your query and developed the report. it is giving data.
              Thanks once again.
              • 4. Re: Urgent : PO Approver ID or Approver Name
                S.PDASH
                Hi,
                Thanks for confirming.. Infact I took almost 1 hour to build this query :).. Would you mind to close the thread along with your remarks as "correct" or "helpful".

                Regards,
                S.P DASH
                1 person found this helpful