eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: AR.HZ_LOCATIONS

Object Details

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

Physical addresses

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: HZ_LOCATIONS_PK

LOCATION_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
HZ_LOCATIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LOCATION_ID
SYS_IL0000028551C00111$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000028551C00112$$	LOB	UNIQUE	APPS_TS_TX_DATA
HZ_LOCATIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADDRESS1
HZ_LOCATIONS_N11	FUNCTION-BASED NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UPPER("ADDRESS1")
HZ_LOCATIONS_N13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORIG_SYSTEM_REFERENCE
HZ_LOCATIONS_N14	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GEOMETRY_STATUS_CODE
HZ_LOCATIONS_N16	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VALIDATION_STATUS_CODE
HZ_LOCATIONS_N17	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DATE_VALIDATED
HZ_LOCATIONS_N18	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TIMEZONE_ID
HZ_LOCATIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CREATION_DATE
HZ_LOCATIONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADDRESS_KEY
HZ_LOCATIONS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	POSTAL_CODE
HZ_LOCATIONS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COUNTRY STATE
HZ_LOCATIONS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CLLI_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 i
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 a
GEOMETRY_SOURCE	VARCHAR2	(30)		Source of Geometry Information. This column is only used by Site Hub.
GEOMETRY_ACCURACY	NUMBER			Accuracy of Geometry Information.

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
,      GEOMETRY_SOURCE
,      GEOMETRY_ACCURACY
FROM AR.HZ_LOCATIONS;

Dependencies

[top of page]

AR.HZ_LOCATIONS references the following:

MDSYS: SDO_GEOMETRY
SYS: STANDARD - show dependent code

AR.HZ_LOCATIONS is referenced by following:

APPS: OE_ITEMS_MV
AR: HZ_LOCATIONS#