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

TABLE: AR.HZ_TIMEZONE_MAPPING

Object Details
Object Name: HZ_TIMEZONE_MAPPING
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.HZ_TIMEZONE_MAPPING
Subobject Name:
Status: VALID


The HZ_TIMEZONE_MAPPING table stores information about mapping a city, postal code, telephone area code, province, state, and country to a time zone. For example, Redwood City in California, USA could be mapped to the Pacific Standard time zone.
.
The primary key for this table is MAPPING_ID.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HZ_TIMEZONE_MAPPING_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnMAPPING_ID
ColumnZD_EDITION_NAME
HZ_TIMEZONE_MAPPING_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOUNTRY
HZ_TIMEZONE_MAPPING_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTIMEZONE_ID
Columns
Name Datatype Length Mandatory Comments
MAPPING_ID NUMBER (15) Yes Address to timezone mapping identifier
AREA_CODE VARCHAR2 (10)
Telephone area code
POSTAL_CODE VARCHAR2 (60)
Postal code
CITY VARCHAR2 (60)
Name of the city
STATE VARCHAR2 (60)
Name of the state
COUNTRY VARCHAR2 (60) Yes Name of the country
PROVINCE VARCHAR2 (60)
Name of the province
TIMEZONE_ID NUMBER (15) Yes Timezone identifier. Foreign key to the HZ_TIMEZONES table.
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT MAPPING_ID
,      AREA_CODE
,      POSTAL_CODE
,      CITY
,      STATE
,      COUNTRY
,      PROVINCE
,      TIMEZONE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ZD_EDITION_NAME
FROM AR.HZ_TIMEZONE_MAPPING;

Dependencies

[top of page]

AR.HZ_TIMEZONE_MAPPING does not reference any database object

AR.HZ_TIMEZONE_MAPPING is referenced by following:

SchemaAR
ViewHZ_TIMEZONE_MAPPING#