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

TABLE: AR.HZ_ADDRESS_USAGE_DTLS

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


The HZ_ADDRESS_USAGE_DTLS table stores the required geography components for addresses usages per country and address style. For example, the necessary valid geography components can differ depending on whether the address is used for geography or tax purposes.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HZ_ADDRESS_USAGE_DTLS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnUSAGE_DTL_ID
HZ_ADDRESS_USAGE_DTLS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnUSAGE_ID
ColumnGEOGRAPHY_TYPE
Columns
Name Datatype Length Mandatory Comments
USAGE_DTL_ID NUMBER (15) Yes Unique address usage detail identifier
USAGE_ID NUMBER (15) Yes Unique address usage identifier
GEOGRAPHY_TYPE VARCHAR2 (30) Yes Required geography type for usage
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_DTL_ID
,      USAGE_ID
,      GEOGRAPHY_TYPE
,      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_USAGE_DTLS;

Dependencies

[top of page]

AR.HZ_ADDRESS_USAGE_DTLS does not reference any database object

AR.HZ_ADDRESS_USAGE_DTLS is referenced by following:

SchemaAR
ViewHZ_ADDRESS_USAGE_DTLS#