VIEW: APPS.FND_TIMEZONES_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')