VIEW: APPS.CSM_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.DST_INCREMENT from jtm_hz_timezones_b tz, csm_hz_timezones_acc acc WHERE acc.TIMEZONE_ID = tz.TIMEZONE_ID AND EXISTS(SELECT 1 FROM ASG_USER WHERE USER_ID=ASG_BASE.GET_USER_ID AND ( NVL(MULTI_PLATFORM,'N')='N' OR tz.TIMEZONE_ID = FND_PROFILE.VALUE('SERVER_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.DST_INCREMENT
FROM JTM_HZ_TIMEZONES_B TZ
, CSM_HZ_TIMEZONES_ACC ACC
WHERE ACC.TIMEZONE_ID = TZ.TIMEZONE_ID
AND EXISTS(SELECT 1
FROM ASG_USER
WHERE USER_ID=ASG_BASE.GET_USER_ID
AND ( NVL(MULTI_PLATFORM
, 'N')='N' OR TZ.TIMEZONE_ID = FND_PROFILE.VALUE('SERVER_TIMEZONE_ID')))