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


TABLE: AR.HZ_LOCATIONS

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


The HZ_LOCATIONS table stores information about a delivery or postal address such as building number, street address, postal code, and directions to a location. This table provides physical location information about parties (organizations and people) and customer accounts. For example, you can store information such as Building 300, 500 Oracle Parkway, 94065, and "Take the Ralston Avenue exit from highway 101, go east on Twin Dolphins Drive, turn left on Oracle Parkway, watch for the Building 300 sign on your right."
.
Records in the HZ_LOCATIONS table can store delivery and postal information about a location through columns such as the LOCATION_DIRECTIONS, POST_OFFICE, and TIME_ZONE columns. You can also use the HZ_LOCATIONS table to store latitude and longitude information. Data in the HZ_LOCATIONS table is also used to determine the appropriate tax authority and tax rates for sales tax and VAT calculations.
.
The primary key for this table is LOCATION_ID.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: HZ_LOCATIONS_PK
  1. ColumnLOCATION_ID
Indexes
Index Type Uniqueness Tablespace Column
HZ_LOCATIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLOCATION_ID
SYS_IL0000028551C00111$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000028551C00112$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
HZ_LOCATIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnADDRESS1
HZ_LOCATIONS_N11 FUNCTION-BASED NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnUPPER("ADDRESS1")
HZ_LOCATIONS_N13 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORIG_SYSTEM_REFERENCE
HZ_LOCATIONS_N14 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGEOMETRY_STATUS_CODE
HZ_LOCATIONS_N16 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnVALIDATION_STATUS_CODE
HZ_LOCATIONS_N17 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDATE_VALIDATED
HZ_LOCATIONS_N18 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTIMEZONE_ID
HZ_LOCATIONS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCREATION_DATE
HZ_LOCATIONS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnADDRESS_KEY
HZ_LOCATIONS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPOSTAL_CODE
HZ_LOCATIONS_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOUNTRY
ColumnSTATE
HZ_LOCATIONS_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCLLI_CODE
Columns
Name Datatype Length Mandatory Comments
LOCATION_ID NUMBER (15) Yes Unique identifier for this location
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).
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_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_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).
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).
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_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
WH_UPDATE_DATE DATE

No longer used
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield segment
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Not currently used
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Not currently used
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Not currently used
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
Not currently used
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Not currently used
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Not currently used
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Not currently used
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Not currently used
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
Not currently used
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Not currently used
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
Not currently used
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
Not currently used
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
Not currently used
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
Not currently used
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
Not currently used
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
Not currently used
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
Not currently used
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
Not currently used
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
Not currently used
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
Not currently used
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
Not currently used
ORIG_SYSTEM_REFERENCE VARCHAR2 (240) Yes Address identifier from foreign system
COUNTRY VARCHAR2 (60) Yes Country code from the TERRITORY_CODE column in the FND_TERRITORY table
ADDRESS1 VARCHAR2 (240) Yes First line for address
ADDRESS2 VARCHAR2 (240)
Second line for address
ADDRESS3 VARCHAR2 (240)
Third line for address
ADDRESS4 VARCHAR2 (240)
Fourth line for address
CITY VARCHAR2 (60)
City
POSTAL_CODE VARCHAR2 (60)
Postal code
STATE VARCHAR2 (60)
State
PROVINCE VARCHAR2 (60)
Province
COUNTY VARCHAR2 (60)
County
ADDRESS_KEY VARCHAR2 (500)
Derived key that factilitates fuzzy searches
ADDRESS_STYLE VARCHAR2 (30)
Used as context value for Flexible Address Format descriptive flexfield. Do not use this column, join to the FND_TERRITORIES table via COUNTRY = TERRITORY_CODE to retrieve the address style for the country.
VALIDATED_FLAG VARCHAR2 (1)
Indicates if the location was validated. Y for validated, N for unvalidated.
ADDRESS_LINES_PHONETIC VARCHAR2 (560)
Phonetic or Kana representation of the Kanji address lines (used in Japan)
APARTMENT_FLAG VARCHAR2 (1)
No longer used
PO_BOX_NUMBER VARCHAR2 (50)
No longer used
HOUSE_NUMBER VARCHAR2 (50)
No longer used
STREET_SUFFIX VARCHAR2 (50)
No longer used
APARTMENT_NUMBER VARCHAR2 (50)
No longer used
SECONDARY_SUFFIX_ELEMENT VARCHAR2 (240)
No longer used
STREET VARCHAR2 (50)
No longer used
RURAL_ROUTE_TYPE VARCHAR2 (50)
No longer used
RURAL_ROUTE_NUMBER VARCHAR2 (50)
No longer used
STREET_NUMBER VARCHAR2 (50)
No longer used
BUILDING VARCHAR2 (50)
No longer used
FLOOR VARCHAR2 (50)
No longer used
SUITE VARCHAR2 (50)
No longer used
ROOM VARCHAR2 (50)
No longer used
POSTAL_PLUS4_CODE VARCHAR2 (10)
Four digit extension to the United States Postal ZIP code.
TIME_ZONE VARCHAR2 (50)
No longer used
OVERSEAS_ADDRESS_FLAG VARCHAR2 (1)
No longer used
POST_OFFICE VARCHAR2 (50)
No longer used
POSITION VARCHAR2 (50)
The primary direction such as North or East that is used to access the location.
DELIVERY_POINT_CODE VARCHAR2 (50)
No longer used
LOCATION_DIRECTIONS VARCHAR2 (640)
Directions to the location
ADDRESS_EFFECTIVE_DATE DATE

Date when the location is valid.
ADDRESS_EXPIRATION_DATE DATE

Date when the location is no longer valid
ADDRESS_ERROR_CODE VARCHAR2 (50)
No longer used
CLLI_CODE VARCHAR2 (60)
Common Language Location Identifier (CLLI) code
DODAAC VARCHAR2 (6)
No longer used
TRAILING_DIRECTORY_CODE VARCHAR2 (60)
No longer used
LANGUAGE VARCHAR2 (4)
Operating language of the location. Foreign key to the FND_LANGUAGES table
LIFE_CYCLE_STATUS VARCHAR2 (30)
No longer used
SHORT_DESCRIPTION VARCHAR2 (240)
Short description of the location
DESCRIPTION VARCHAR2 (2000)
An extensive description of the location
CONTENT_SOURCE_TYPE VARCHAR2 (30) Yes Source of data content.
LOC_HIERARCHY_ID NUMBER (15)
Location hierarchy identifier. Foreign key to the JTF_LOC_HIERARCHIES_B table
SALES_TAX_GEOCODE VARCHAR2 (30)
US Sales Tax Jurisdiction code. Use this field to provide a Jurisdiction Code (also called as Geocode) defined by wither Vertex or Taxware. This value is passed as a ship-to locaiton jurisdiction code to the tax partner API.
SALES_TAX_INSIDE_CITY_LIMITS VARCHAR2 (30)
Indicates if the location is inside the boundary of a city. Used to calculate state and local taxes in the United States. Value '1' is for locations inside the city limits and '0' is for locations outside the city limits. Defaults to null if '1'.
FA_LOCATION_ID NUMBER (15)
Foreign key to the FA_LOCATIONS table
GEOMETRY SDO_GEOMETRY (1)
OBJECT_VERSION_NUMBER NUMBER

This column is used for locking purposes
CREATED_BY_MODULE VARCHAR2 (150)
TCA Who column
APPLICATION_ID NUMBER

TCA Who column
TIMEZONE_ID NUMBER

Time zone identifier. Foreign key to HZ_TIMEZONES
GEOMETRY_STATUS_CODE VARCHAR2 (30)
Spatial data integration status for given location.
ACTUAL_CONTENT_SOURCE VARCHAR2 (30) Yes Additional Content Source Type column for backward compatibility.
VALIDATION_STATUS_CODE VARCHAR2 (30)
Standardized status code describing the results of the validation
DATE_VALIDATED DATE

Date the address was last validated.
DO_NOT_VALIDATE_FLAG VARCHAR2 (1)
A new attribute that indicates that a particular location is not eligible for address validatino regardless of the current Validation Status Code. The default is "No" meaning that by default, all address are eligible for validation. This attribute is not unset on update.
Query Text

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


SELECT LOCATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      WH_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      ORIG_SYSTEM_REFERENCE
,      COUNTRY
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      POSTAL_CODE
,      STATE
,      PROVINCE
,      COUNTY
,      ADDRESS_KEY
,      ADDRESS_STYLE
,      VALIDATED_FLAG
,      ADDRESS_LINES_PHONETIC
,      APARTMENT_FLAG
,      PO_BOX_NUMBER
,      HOUSE_NUMBER
,      STREET_SUFFIX
,      APARTMENT_NUMBER
,      SECONDARY_SUFFIX_ELEMENT
,      STREET
,      RURAL_ROUTE_TYPE
,      RURAL_ROUTE_NUMBER
,      STREET_NUMBER
,      BUILDING
,      FLOOR
,      SUITE
,      ROOM
,      POSTAL_PLUS4_CODE
,      TIME_ZONE
,      OVERSEAS_ADDRESS_FLAG
,      POST_OFFICE
,      POSITION
,      DELIVERY_POINT_CODE
,      LOCATION_DIRECTIONS
,      ADDRESS_EFFECTIVE_DATE
,      ADDRESS_EXPIRATION_DATE
,      ADDRESS_ERROR_CODE
,      CLLI_CODE
,      DODAAC
,      TRAILING_DIRECTORY_CODE
,      LANGUAGE
,      LIFE_CYCLE_STATUS
,      SHORT_DESCRIPTION
,      DESCRIPTION
,      CONTENT_SOURCE_TYPE
,      LOC_HIERARCHY_ID
,      SALES_TAX_GEOCODE
,      SALES_TAX_INSIDE_CITY_LIMITS
,      FA_LOCATION_ID
,      GEOMETRY
,      OBJECT_VERSION_NUMBER
,      CREATED_BY_MODULE
,      APPLICATION_ID
,      TIMEZONE_ID
,      GEOMETRY_STATUS_CODE
,      ACTUAL_CONTENT_SOURCE
,      VALIDATION_STATUS_CODE
,      DATE_VALIDATED
,      DO_NOT_VALIDATE_FLAG
FROM AR.HZ_LOCATIONS;

Dependencies

[top of page]

AR.HZ_LOCATIONS references the following:

SchemaMDSYS
TYPESDO_GEOMETRY
SchemaSYS
PL/SQL PackageSTANDARD - show dependent code
AR.HZ_LOCATIONS is referenced by following:

SchemaAPPS
SynonymHZ_LOCATIONS
Materialized ViewLNS_LOAN_DTLS_ALL_MV
Materialized ViewOE_ITEMS_MV