[Home] [Help]
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
Name |
LOCATION |
EMP_ID |
ORG_ID |