[Home] [Help]
View: FND_TIMEZONES_VL
Product: | FND - Application Object Library |
Description: | FND_TIMEZONES_VL |
Implementation/DBA Data: |
APPS.FND_TIMEZONES_VL
|
View Text
SELECT TZ.TIMEZONE_CODE
, TZ_TL.NAME NAME
, TZ.ENABLED_FLAG
, TZ.GMT_OFFSET
, TZ.DAYLIGHT_SAVINGS_FLAG
, TZ.ACTIVE_TIMEZONE_CODE
, TZ.UPGRADE_TZ_ID
, TZ.CREATION_DATE
, TZ.CREATED_BY
, TZ.LAST_UPDATE_DATE
, TZ.LAST_UPDATED_BY
, TZ.LAST_UPDATE_LOGIN
FROM FND_TIMEZONES_B TZ
, FND_TIMEZONES_TL TZ_TL
WHERE TZ.TIMEZONE_CODE = TZ_TL.TIMEZONE_CODE
AND TZ_TL.LANGUAGE = USERENV('LANG')
Columns
Name |
TIMEZONE_CODE |
NAME |
ENABLED_FLAG |
GMT_OFFSET |
DAYLIGHT_SAVINGS_FLAG |
ACTIVE_TIMEZONE_CODE |
UPGRADE_TZ_ID |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |