eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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