[Home] [Help]
View: JG_ZZ_OPERATING_UNITS_V
Product: | JG - Regional Localizations |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT OPER.NAME OPERATING_UNIT_NAME
, ORG.LOCATION_ID LOCATION_ID
, LOC.LOCATION_CODE LOCATION_CODE
FROM HR_ALL_ORGANIZATION_UNITS ORG
, HR_OPERATING_UNITS OPER
, HR_LOCATIONS LOC
WHERE ORG.ORGANIZATION_ID = OPER.ORGANIZATION_ID
AND ORG.LOCATION_ID = LOC.LOCATION_ID UNION SELECT MEANING OPERATING_UNIT_NAME
, -100 LOCATION_ID
, NULL LOCATION_CODE FROM GL_LOOKUPS WHERE LOOKUP_TYPE = 'LITERAL' AND LOOKUP_CODE = 'N/A'
Columns
Name |
OPERATING_UNIT_NAME |
LOCATION_ID |
LOCATION_CODE |