VIEW: APPS.HZ_TIMEZONES_VL

Source

View Text - Preformatted

SELECT tz.TIMEZONE_ID ,tz_tl.name ,tz_tl.description ,tz.STANDARD_TIME_SHORT_CODE ,tz.DAYLIGHT_SAVINGS_SHORT_CODE ,tz.GMT_DEVIATION_HOURS ,tz.DAYLIGHT_SAVINGS_TIME_FLAG ,tz.BEGIN_DST_MONTH ,tz.BEGIN_DST_DAY ,tz.BEGIN_DST_WEEK_OF_MONTH ,tz.BEGIN_DST_DAY_OF_WEEK ,tz.BEGIN_DST_HOUR ,tz.END_DST_MONTH ,tz.END_DST_DAY ,tz.END_DST_WEEK_OF_MONTH ,tz.END_DST_DAY_OF_WEEK ,tz.END_DST_HOUR ,tz.PRIMARY_ZONE_FLAG ,tz.GLOBAL_TIMEZONE_NAME ,tz.CREATION_DATE ,tz.CREATED_BY ,tz.LAST_UPDATE_DATE ,tz.LAST_UPDATED_BY ,tz.LAST_UPDATE_LOGIN from hz_timezones tz, hz_timezones_tl tz_tl WHERE tz.TIMEZONE_ID = tz_tl.TIMEZONE_ID and tz_tl.language = USERENV('LANG')

View Text - HTML Formatted

SELECT TZ.TIMEZONE_ID
, TZ_TL.NAME
, TZ_TL.DESCRIPTION
, TZ.STANDARD_TIME_SHORT_CODE
, TZ.DAYLIGHT_SAVINGS_SHORT_CODE
, TZ.GMT_DEVIATION_HOURS
, TZ.DAYLIGHT_SAVINGS_TIME_FLAG
, TZ.BEGIN_DST_MONTH
, TZ.BEGIN_DST_DAY
, TZ.BEGIN_DST_WEEK_OF_MONTH
, TZ.BEGIN_DST_DAY_OF_WEEK
, TZ.BEGIN_DST_HOUR
, TZ.END_DST_MONTH
, TZ.END_DST_DAY
, TZ.END_DST_WEEK_OF_MONTH
, TZ.END_DST_DAY_OF_WEEK
, TZ.END_DST_HOUR
, TZ.PRIMARY_ZONE_FLAG
, TZ.GLOBAL_TIMEZONE_NAME
, TZ.CREATION_DATE
, TZ.CREATED_BY
, TZ.LAST_UPDATE_DATE
, TZ.LAST_UPDATED_BY
, TZ.LAST_UPDATE_LOGIN
FROM HZ_TIMEZONES TZ
, HZ_TIMEZONES_TL TZ_TL
WHERE TZ.TIMEZONE_ID = TZ_TL.TIMEZONE_ID
AND TZ_TL.LANGUAGE = USERENV('LANG')