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

TABLE: AR.HZ_ADDRESS_USAGES

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


The HZ_ADDRESS_USAGES table stores the address usages per country and address style. Address usages are used during the Geography Name Referencing process to identify the geography components required for an address to pass the Geography Name Referencing process for that usage.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HZ_ADDRESS_USAGES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnUSAGE_ID
HZ_ADDRESS_USAGES_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnMAP_ID
ColumnUSAGE_CODE
Columns
Name Datatype Length Mandatory Comments
USAGE_ID NUMBER (15) Yes Unique address usage identifier
MAP_ID NUMBER (15) Yes Foreign key to HZ_GEO_STRUCT_MAP.map_id
USAGE_CODE VARCHAR2 (30) Yes Code for address usage
STATUS_FLAG VARCHAR2 (1) Yes Indicates if usage is active.
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
OBJECT_VERSION_NUMBER NUMBER (15) Yes Version number for concurrency control purposes
CREATED_BY_MODULE VARCHAR2 (150)
TCA Who column
APPLICATION_ID NUMBER (15)
TCA Who column
Query Text

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


SELECT USAGE_ID
,      MAP_ID
,      USAGE_CODE
,      STATUS_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      CREATED_BY_MODULE
,      APPLICATION_ID
FROM AR.HZ_ADDRESS_USAGES;

Dependencies

[top of page]

AR.HZ_ADDRESS_USAGES does not reference any database object

AR.HZ_ADDRESS_USAGES is referenced by following:

SchemaAR
ViewHZ_ADDRESS_USAGES#