[Home] [Help] [Dependency Information]
Object Name: | HZ_GEOGRAPHY_IDENTIFIERS |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.HZ_GEOGRAPHY_IDENTIFIERS |
Subobject Name: | |
Status: | VALID |
HZ_GEOGRPHY_IDENTIFIERS stores multiple identifiers used to describe the same geography. The values stored in this field may come from different geography data providers or entered by the user. Identifiers include Names (for example Alternate Names or Vanity Names) and Codes (for example ISO codes for countries or UN/LOCODES for locations). For Example: A section of Redwood City has a vanity name of Redwood Shores.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HZ_GEOGRAPHY_IDENTIFIERS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
GEOGRAPHY_ID
IDENTIFIER_TYPE IDENTIFIER_SUBTYPE IDENTIFIER_VALUE LANGUAGE_CODE |
HZ_GEOGRAPHY_IDENTIFIERS_N1 | FUNCTION-BASED NORMAL | NONUNIQUE | APPS_TS_TX_IDX | UPPER("IDENTIFIER_VALUE") |
HZ_GEOGRAPHY_IDENTIFIERS_N2 | FUNCTION-BASED NORMAL | NONUNIQUE | APPS_TS_TX_IDX | UPPER("IDENTIFIER_VALUE") |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GEOGRAPHY_ID | NUMBER | (15) | Yes | Unique identifier for this geography |
GEO_DATA_PROVIDER | VARCHAR2 | (30) | Yes | Name of the data source provider |
IDENTIFIER_SUBTYPE | VARCHAR2 | (30) | Yes | Specifies the type of a code or a name |
IDENTIFIER_VALUE | VARCHAR2 | (360) | Yes | Stores the value of the identifier type |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Version number of the record | |
IDENTIFIER_TYPE | VARCHAR2 | (30) | Yes | Specifies whether the value in identifier_value is a code or a name |
PRIMARY_FLAG | VARCHAR2 | (1) | Yes | Indicates whether this name or code is the default for this geography |
LANGUAGE_CODE | VARCHAR2 | (4) | Yes | Stores the language in which identifier_value is stored |
GEOGRAPHY_USE | VARCHAR2 | (30) | Yes | Use of geography data |
GEOGRAPHY_TYPE | VARCHAR2 | (30) | Yes | Type of geography data |
CREATED_BY_MODULE | VARCHAR2 | (150) | Yes | Source application module that created this record. |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
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_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
APPLICATION_ID | NUMBER | (15) | Unique identifier for the application that created this record. Foreign key to FND_APPLICATION table. | |
PROGRAM_ID | NUMBER | (15) | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | |
PROGRAM_LOGIN_ID | NUMBER | (15) | Program login identifier of last concurrent program to update this record. | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | |
REQUEST_ID | NUMBER | (15) | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
Cut, paste (and edit) the following text to query this object:
SELECT GEOGRAPHY_ID
, GEO_DATA_PROVIDER
, IDENTIFIER_SUBTYPE
, IDENTIFIER_VALUE
, OBJECT_VERSION_NUMBER
, IDENTIFIER_TYPE
, PRIMARY_FLAG
, LANGUAGE_CODE
, GEOGRAPHY_USE
, GEOGRAPHY_TYPE
, CREATED_BY_MODULE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, APPLICATION_ID
, PROGRAM_ID
, PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID
, REQUEST_ID
FROM AR.HZ_GEOGRAPHY_IDENTIFIERS;
AR.HZ_GEOGRAPHY_IDENTIFIERS does not reference any database object
AR.HZ_GEOGRAPHY_IDENTIFIERS is referenced by following:
|
|
|