| Extract buyer's name from requisition [message #13894] |
Sun, 01 August 2004 16:44  |
Nur Lailin
Messages: 3
Registered: August 2004
|
Junior Member |
|
|
Hi all,
I am in the midst of creating a report that extracts information from both po and requisition tables. I have managed to do this but in addition I will also need to display the name of the buyer who created the requisition.
In the po_requisition_headers_all, there is a field called created_by but it contain ID numbers instead of the actual names. There's also a field called agent_id which is linked to po_agents, yet again that's only an ID. Where are these tables linked to in order to extract the full name? So far I've only come across the hr_employee view which keeps the full name of employees.
For your info, I'm using Oracle 8i.
Please help!
|
|
|
|
| Re: Extract buyer's name from requisition [message #13907 is a reply to message #13894] |
Mon, 02 August 2004 03:57  |
Art Metzer
Messages: 2480
Registered: December 2002
|
Senior Member |
|
|
Look at the applsys.fnd_user table. You'll join on user_id to get user_name. Depending on your setup, you may also be able to join from that table's employee_id to hr.per_all_people_f.person_id.
Hope this helps,
Art.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
