VIEW: APPS.OKX_TIMEZONES_V

Source

View Text - Preformatted

SELECT B.TIMEZONE_ID TIMEZONE_ID ,B.GLOBAL_TIMEZONE_NAME GLOBAL_TIMEZONE_NAME ,B.GMT_DEVIATION_HOURS GMT_DEVIATION_HOURS ,B.DAYLIGHT_SAVINGS_TIME_FLAG DAYLIGHT_SAVINGS_TIME_FLAG ,B.BEGIN_DST_MONTH BEGIN_DST_MONTH ,B.BEGIN_DST_DAY BEGIN_DST_DAY ,B.BEGIN_DST_WEEK_OF_MONTH BEGIN_DST_WEEK_OF_MONTH ,B.BEGIN_DST_DAY_OF_WEEK BEGIN_DST_DAY_OF_MONTH ,B.BEGIN_DST_HOUR BEGIN_DST_HOUR ,B.END_DST_MONTH END_DST_MONTH ,B.END_DST_DAY END_DST_DAY ,B.END_DST_WEEK_OF_MONTH END_DST_WEEK_OF_MONTH ,B.END_DST_DAY_OF_WEEK END_DAY_OF_WEEK ,B.END_DST_HOUR END_DST_HOUR ,NewTL.NAME NAME ,NewTL.NAME DESCRIPTION FROM hz_timezones B ,hz_timezones_TL TL ,fnd_timezones_b newB ,fnd_timezones_TL newTL WHERE TL.TIMEZONE_ID = B.TIMEZONE_ID AND TL.LANGUAGE = USERENV('LANG') AND NewTL.TIMEZONE_CODE = NewB.TIMEZONE_CODE AND TL.LANGUAGE = NewTL.LANGUAGE AND NewB.Upgrade_tz_id = b.timezone_id

View Text - HTML Formatted

SELECT B.TIMEZONE_ID TIMEZONE_ID
, B.GLOBAL_TIMEZONE_NAME GLOBAL_TIMEZONE_NAME
, B.GMT_DEVIATION_HOURS GMT_DEVIATION_HOURS
, B.DAYLIGHT_SAVINGS_TIME_FLAG DAYLIGHT_SAVINGS_TIME_FLAG
, B.BEGIN_DST_MONTH BEGIN_DST_MONTH
, B.BEGIN_DST_DAY BEGIN_DST_DAY
, B.BEGIN_DST_WEEK_OF_MONTH BEGIN_DST_WEEK_OF_MONTH
, B.BEGIN_DST_DAY_OF_WEEK BEGIN_DST_DAY_OF_MONTH
, B.BEGIN_DST_HOUR BEGIN_DST_HOUR
, B.END_DST_MONTH END_DST_MONTH
, B.END_DST_DAY END_DST_DAY
, B.END_DST_WEEK_OF_MONTH END_DST_WEEK_OF_MONTH
, B.END_DST_DAY_OF_WEEK END_DAY_OF_WEEK
, B.END_DST_HOUR END_DST_HOUR
, NEWTL.NAME NAME
, NEWTL.NAME DESCRIPTION
FROM HZ_TIMEZONES B
, HZ_TIMEZONES_TL TL
, FND_TIMEZONES_B NEWB
, FND_TIMEZONES_TL NEWTL
WHERE TL.TIMEZONE_ID = B.TIMEZONE_ID
AND TL.LANGUAGE = USERENV('LANG')
AND NEWTL.TIMEZONE_CODE = NEWB.TIMEZONE_CODE
AND TL.LANGUAGE = NEWTL.LANGUAGE
AND NEWB.UPGRADE_TZ_ID = B.TIMEZONE_ID