[Home] [Help] [Dependency Information]
Object Name: | HZ_IMP_ADAPTERS |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.HZ_IMP_ADAPTERS |
Subobject Name: | |
Status: | VALID |
The HZ_IMP_ADAPTERS table stores information about using location services adapters to validate addresses in the interface tables before importing to the TCA Registry. The table includes the countries that the user chooses to validate, the adapter chosen for each country, and the number of records that passed or failed the validation
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HZ_IMP_ADAPTERS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
BATCH_ID
COUNTRY_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | (15) | Yes | Interface batch identifier |
COUNTRY_CODE | VARCHAR2 | (2) | Yes | Country or territory supported by the adapter.Foreign Key to FND_TERRITORIES |
ADAPTER_CONTENT_SOURCE | VARCHAR2 | (30) | Content source that uniquely identifies this location service adapter. Validated against CONTENT_SOURCE_TYPE lookup | |
SEND_FLAG | VARCHAR2 | (1) | Y or N indicates whether address validation wasrequested or not | |
RECORDS_PASSED_VALIDATION | NUMBER | Number of records that passed the validation | ||
RECORDS_FAILED_VALIDATION | NUMBER | Number of records that failed the validation | ||
TOTAL_RECORDS_VALIDATED | NUMBER | Total records sent for address validation | ||
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 | |
REQUEST_ID | NUMBER | (15) | No Comments | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | No Comments | |
PROGRAM_ID | NUMBER | (15) | No Comments | |
PROGRAM_UPDATE_DATE | DATE | No Comments |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_ID
, COUNTRY_CODE
, ADAPTER_CONTENT_SOURCE
, SEND_FLAG
, RECORDS_PASSED_VALIDATION
, RECORDS_FAILED_VALIDATION
, TOTAL_RECORDS_VALIDATED
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM AR.HZ_IMP_ADAPTERS;
AR.HZ_IMP_ADAPTERS does not reference any database object
AR.HZ_IMP_ADAPTERS is referenced by following:
|
|
|