View: PO_REQUESTOR_LOCATIONS_V

Product:	PO - Purchasing
Description:	Employee's location, given employee ID and optionally organization
Implementation/DBA Data:	APPS.PO_REQUESTOR_LOCATIONS_V

View Text

SELECT HRL.LOCATION_CODE
, HRE.EMPLOYEE_ID
, HRL.INVENTORY_ORGANIZATION_ID
FROM HR_EMPLOYEES_CURRENT_V HRE
, HR_LOCATIONS HRL
WHERE HRE.LOCATION_ID = HRL.LOCATION_ID

Columns