View: HZ_TIMEZONES_VL

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.HZ_TIMEZONES_VL

View Text

SELECT TZ.TIMEZONE_ID
, TZ_TL.NAME
, TZ_TL.DESCRIPTION
, TZ.GLOBAL_TIMEZONE_NAME
, 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.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')

Columns