VIEW: APPS.JTM_HZ_TIMEZONES_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID, tz.TIMEZONE_ID , tz.name , tz.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, tz.DST_INCREMENT from jtm_hz_timezones_b tz, jtm_hz_timezones_acc acc WHERE acc.TIMEZONE_ID = tz.TIMEZONE_ID

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, TZ.TIMEZONE_ID
, TZ.NAME
, TZ.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
, TZ.DST_INCREMENT
FROM JTM_HZ_TIMEZONES_B TZ
, JTM_HZ_TIMEZONES_ACC ACC
WHERE ACC.TIMEZONE_ID = TZ.TIMEZONE_ID