1. Tables and Views for Common Features
  2. FND_TIMEZONES_VL

FND_TIMEZONES_VL

Details

  • Schema: REFDATA

  • Object owner: FND

  • Object type: VIEW

Columns

Name

TIMEZONE_CODE

NAME

ENABLED_FLAG

GMT_OFFSET

DAYLIGHT_SAVINGS_FLAG

ACTIVE_TIMEZONE_CODE

UPGRADE_TZ_ID

TIMEZONE_ABBREVIATION

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT

B.TIMEZONE_CODE,

T.NAME NAME,

B.ENABLED_FLAG,

B.GMT_OFFSET,

B.DAYLIGHT_SAVINGS_FLAG,

B.ACTIVE_TIMEZONE_CODE,

B.UPGRADE_TZ_ID,

B.TIMEZONE_ABBREVIATION TIMEZONE_ABBREVIATION,

B.CREATION_DATE,

B.CREATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_LOGIN

FROM

FND_TIMEZONES_B B,

FND_TIMEZONES_TL T

WHERE

B.TIMEZONE_CODE = T.TIMEZONE_CODE AND T.LANGUAGE = USERENV('LANG')