[Home] [Help] [Dependency Information]
Object Name: | FND_TIMEZONES_B |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.FND_TIMEZONES_B |
Subobject Name: | |
Status: | VALID |
List of Timezone names (translated) for LOV purposes. Only timezones supported
by the Oracle database may be defined here.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_TIMEZONES_B_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
TIMEZONE_CODE
ZD_EDITION_NAME |
FND_TIMEZONES_B_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
UPGRADE_TZ_ID
ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TIMEZONE_CODE | VARCHAR2 | (50) | Yes | the unique identifier of a timezone |
ENABLED_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the zone is currently enabled for use |
GMT_OFFSET | NUMBER | Yes | The offset from gmt of this timezone under standard time | |
DAYLIGHT_SAVINGS_FLAG | VARCHAR2 | (1) | Yes | Indicates whether this zone adjusts for daylight savings |
ACTIVE_TIMEZONE_CODE | VARCHAR2 | (50) | Indicates which timezone is currently active with the same conversion rules | |
UPGRADE_TZ_ID | NUMBER | Yes | Used for upgrade purposes from foreign key to hz_timezones | |
CREATION_DATE | DATE | Yes | CREATION_DATE | |
CREATED_BY | NUMBER | Yes | CREATED_BY | |
LAST_UPDATE_DATE | DATE | Yes | LAST_UPDATE_DATE | |
LAST_UPDATED_BY | NUMBER | LAST_UPDATED_BY | ||
LAST_UPDATE_LOGIN | NUMBER | LAST_UPDATE_LOGIN | ||
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT TIMEZONE_CODE
, ENABLED_FLAG
, GMT_OFFSET
, DAYLIGHT_SAVINGS_FLAG
, ACTIVE_TIMEZONE_CODE
, UPGRADE_TZ_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ZD_EDITION_NAME
FROM APPLSYS.FND_TIMEZONES_B;
APPLSYS.FND_TIMEZONES_B does not reference any database object
APPLSYS.FND_TIMEZONES_B is referenced by following:
|
|
|