This content has been marked as final. Show 3 replies
Use po number to go to po_headers_all.segment1
po_headers_all > po_distributions_all using po_header_id
po_distributions_all > pa_projects using project_id
Hope this helps
Omkar Technologies Inc.
Independent Techno-functional Consultant
For Requestor you can use
po_distributions_all --> deliver_to_person_id --> Join that to per_all_people_f --> Person_id.
This will get you requestor details. If you want to get Buyer details then check Po_headers_all Agent_id with per_all_people_f person_id.
Hi Sandeep. Thanks for the help. What table and column has the PO number that the end user would see inthe app. Also what table and column would I find the User entered text that describes what they bought. Thanks for your help.