DBA Data[Home] [Help] [Dependency Information]

TABLE: APPLSYS.FND_TIMEZONES_B

Object Details
Object Name: FND_TIMEZONES_B
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.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.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FND_TIMEZONES_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnTIMEZONE_CODE
FND_TIMEZONES_B_U2 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnUPGRADE_TZ_ID
Columns
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

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
Query Text

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
FROM APPLSYS.FND_TIMEZONES_B;

Dependencies

[top of page]

APPLSYS.FND_TIMEZONES_B does not reference any database object

APPLSYS.FND_TIMEZONES_B is referenced by following:

SchemaAPPS
SynonymFND_TIMEZONES_B