DBA Data[Home] [Help]

VIEW: APPS.PO_REQUESTOR_LOCATIONS_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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