This content has been marked as final. Show 4 replies
Kindly some one help me to sort out this issue.
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 =
where object_id = a.po_header_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.
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.
Hi,1 person found this helpful
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".