Product: | OKX - Contracts Integration |
---|---|
Description: | Timezones |
Implementation/DBA Data: | APPS.OKX_TIMEZONES_V |
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