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


TABLE: AR.HZ_IMP_ADDRESSES_INT

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


The TCA import interface table, HZ_IMP_ADDRESSES_INT, stores information for population into the HZ_LOCATIONS and the HZ_PARTY_SITES tables in TCA
* Scope: public
* Product: HZ
* Lifecycle: active
* Display Name: Address
* Category: BUSINESS_ENTITY HZ_ADDRESS

Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HZ_IMP_ADDRESSES_INT_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnBATCH_ID
ColumnSITE_ORIG_SYSTEM
ColumnSITE_ORIG_SYSTEM_REFERENCE
ColumnPARTY_ID
HZ_IMP_ADDRESSES_INT_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnBATCH_ID
ColumnPARTY_ORIG_SYSTEM
ColumnINTERFACE_STATUS
ColumnPARTY_ORIG_SYSTEM_REFERENCE
Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER (15) Yes Unique Identifier for a Batch
PARTY_ORIG_SYSTEM VARCHAR2 (30) Yes Original System ID for the Party
PARTY_ORIG_SYSTEM_REFERENCE VARCHAR2 (240) Yes Original System Reference for the Party
SITE_ORIG_SYSTEM VARCHAR2 (30)
Original System ID for the Site
SITE_ORIG_SYSTEM_REFERENCE VARCHAR2 (240)
Original System Reference for the Site
INSERT_UPDATE_FLAG VARCHAR2 (1)
Indicates if a record should be explicitly inserted or updated
CORRECT_MOVE_INDICATOR VARCHAR2 (1)
Indicates if an address should be treated as a "move" or "correction"
ADDRESS1 VARCHAR2 (240)
Fist Line of Address
ADDRESS2 VARCHAR2 (240)
Second Line of Address
ADDRESS3 VARCHAR2 (240)
Third Line of Address
ADDRESS4 VARCHAR2 (240)
Fourth Line of Address
ADDRESS_LINES_PHONETIC VARCHAR2 (560)
Phonetic or Kana representation of the Kanji address lines (used in Japan)
CITY VARCHAR2 (60)
City
CLLI_CODE VARCHAR2 (60)
Common Language Location Identifier (CLLI) code
COUNTRY VARCHAR2 (2)
Country code from the TERRITORY_CODE column in the FND_TERRITORY table
COUNTY VARCHAR2 (60)
County
DELIVERY_POINT_CODE VARCHAR2 (50)
No longer used
DESCRIPTION VARCHAR2 (2000)
An extensive description of the location
LANGUAGE VARCHAR2 (4)
Operating language of the location. Foreign key to the FND_LANGUAGES table
LOCATION_DIRECTIONS VARCHAR2 (640)
Directions to the location
POSTAL_CODE VARCHAR2 (60)
Postal Code
POSTAL_PLUS4_CODE VARCHAR2 (10)
Four digit extension to the United States Postal ZIP code.
PROVINCE VARCHAR2 (60)
Province
SALES_TAX_GEOCODE VARCHAR2 (30)
US State and Local Tax Jurisdiction code. Use this field to provide either a Vertex GeoCode or Taxware Geocode value for the Point of Order Origin
SALES_TAX_INSIDE_CITY_LIMITS VARCHAR2 (30)
Indicates if a location is inside the boundary of a city, based on the associated GeoCode. Used to calculate state and local taxes in the United States. Y for locations within the city limits, N for locations outside the city limits. Defaults to N if Null.
SHORT_DESCRIPTION VARCHAR2 (240)
Short description of the location
STATE VARCHAR2 (60)
State
TIMEZONE_CODE VARCHAR2 (50)
Time zone identifier. Foreign key to HZ_TIMEZONES
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure definition
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
ADDRESS1_STD VARCHAR2 (240)
Standardized First Line of Address
ADDRESS2_STD VARCHAR2 (240)
Standardized Second Line of Address
ADDRESS3_STD VARCHAR2 (240)
Standardized Third Line of Address
ADDRESS4_STD VARCHAR2 (240)
Standardized Fourth Line of Address
CITY_STD VARCHAR2 (60)
Standard City
PROV_STATE_ADMIN_CODE_STD VARCHAR2 (60)
Standard Province, State or Administrative Boundary
COUNTY_STD VARCHAR2 (60)
Standardized County
COUNTRY_STD VARCHAR2 (2)
Standardized Country
POSTAL_CODE_STD VARCHAR2 (60)
Standard Postal Code
ACCEPT_STANDARDIZED_FLAG VARCHAR2 (1)
Indicates if a Standardized Address is Acceptable according to the address validation setup
ADAPTER_CONTENT_SOURCE VARCHAR2 (30)
The Source Used to Validate the Address
ADDR_VALID_STATUS_CODE VARCHAR2 (30)
The Address Validation Code returned by the Source
DATE_VALIDATED DATE

Date Address was Validated
PARTY_SITE_NAME VARCHAR2 (240)
Name of the Party Site
PARTY_SITE_NUMBER VARCHAR2 (30)
Number of the Party Site
INTERFACE_STATUS VARCHAR2 (30)
Status for the data in the interface table
ERROR_ID NUMBER (15)
Foreign Key to the Error Table
DQM_ACTION_FLAG VARCHAR2 (1)
Indicates record category and action to take on records being imported, based on DQM de-duplication between those records and records already in TCA. D for duplicate, P for potential duplicate, and null for new or existing record
DUP_WITHIN_INT_FLAG VARCHAR2 (1)
Not currently used
VALIDATION_SUBSET_ID NUMBER (15)
Unique identifier for the subsets of data processed by address validation
CREATION_DATE DATE

Standard Who Column
CREATED_BY NUMBER (15)
Standard Who Column
LAST_UPDATE_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER (15)
Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
REQUEST_ID NUMBER (15)
Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID NUMBER (15)
Application identifier of last concurrent program to update this record
PROGRAM_ID NUMBER (15)
Program identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE DATE

Last date this record was updated by a concurrent program
CREATED_BY_MODULE VARCHAR2 (30)
Standard Who column
PRIMARY_FLAG VARCHAR2 (1)
Indicates that the record is marked as primary
PARTY_ID NUMBER (15)
Party that owns the address
Query Text

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


SELECT BATCH_ID
,      PARTY_ORIG_SYSTEM
,      PARTY_ORIG_SYSTEM_REFERENCE
,      SITE_ORIG_SYSTEM
,      SITE_ORIG_SYSTEM_REFERENCE
,      INSERT_UPDATE_FLAG
,      CORRECT_MOVE_INDICATOR
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      ADDRESS_LINES_PHONETIC
,      CITY
,      CLLI_CODE
,      COUNTRY
,      COUNTY
,      DELIVERY_POINT_CODE
,      DESCRIPTION
,      LANGUAGE
,      LOCATION_DIRECTIONS
,      POSTAL_CODE
,      POSTAL_PLUS4_CODE
,      PROVINCE
,      SALES_TAX_GEOCODE
,      SALES_TAX_INSIDE_CITY_LIMITS
,      SHORT_DESCRIPTION
,      STATE
,      TIMEZONE_CODE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ADDRESS1_STD
,      ADDRESS2_STD
,      ADDRESS3_STD
,      ADDRESS4_STD
,      CITY_STD
,      PROV_STATE_ADMIN_CODE_STD
,      COUNTY_STD
,      COUNTRY_STD
,      POSTAL_CODE_STD
,      ACCEPT_STANDARDIZED_FLAG
,      ADAPTER_CONTENT_SOURCE
,      ADDR_VALID_STATUS_CODE
,      DATE_VALIDATED
,      PARTY_SITE_NAME
,      PARTY_SITE_NUMBER
,      INTERFACE_STATUS
,      ERROR_ID
,      DQM_ACTION_FLAG
,      DUP_WITHIN_INT_FLAG
,      VALIDATION_SUBSET_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CREATED_BY_MODULE
,      PRIMARY_FLAG
,      PARTY_ID
FROM AR.HZ_IMP_ADDRESSES_INT;

Dependencies

[top of page]

AR.HZ_IMP_ADDRESSES_INT does not reference any database object

AR.HZ_IMP_ADDRESSES_INT is referenced by following:

SchemaAPPS
SynonymHZ_IMP_ADDRESSES_INT