How to link hr_all_organization_units with po_requisition_lines_all
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
0