[Home] [Help]
View: JAI_CMN_HR_LOCATIONS_V
View Text
SELECT DISTINCT NVL(HL.DESCRIPTION
, 'NULL LOCATION') DESCRIPTION
, JHU.LOCATION_ID
, JHU.ORGANIZATION_ID
FROM HR_LOCATIONS HL
, JAI_CMN_INVENTORY_ORGS JHU
WHERE HL.LOCATION_ID(+) = JHU.LOCATION_ID
Columns
Name |
DESCRIPTION |
LOCATION_ID |
ORGANIZATION_ID |