Procurement - EBS (MOSC)

MOSC Banner

How to link hr_all_organization_units with po_requisition_lines_all

edited Feb 20, 2013 7:41AM in Procurement - EBS (MOSC) 4 commentsAnswered
Good Morning Everyone:      I need to write a report linking a requisition with locations.  The Location details are obtained when we create a Requisition and is captured in po_requisition_lines_all (deliver_to_location_id). I know this maps to Hr_Locations table. How can I get this linked to hr_all_organization_units table (we have the locations in this table and the location_id is missing)? However, oracle is populating the data when you  create a requisition.
Any help is appreciated. 
Thanks
Srini
  

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center