[Home] [Help] [Dependency Information]
Object Name: | HZ_IMP_ADDRESSES_SG |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.HZ_IMP_ADDRESSES_SG |
Subobject Name: | |
Status: | VALID |
The HZ_IMP_ADDRESSES_SG table is used internally by TCA import to process information loaded into the HZ_IMP_ADDRESSES_INT interface table. During the import process, data from the HZ_IMP_ADDRESSES_INT table is moved into the HZ_IMP_ADDRESSES_SG table to improve performance
Tablespace: | |
---|---|
PCT Free: | |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HZ_IMP_ADDRESSES_SG_U1 | NORMAL | UNIQUE |
BATCH_MODE_FLAG
BATCH_ID PARTY_ID PRIMARY_FLAG INT_ROW_ID | |
HZ_IMP_ADDRESSES_SG_N1 | NORMAL | NONUNIQUE |
BATCH_ID
PARTY_ORIG_SYSTEM ACTION_FLAG PARTY_ORIG_SYSTEM_REFERENCE | |
HZ_IMP_ADDRESSES_SG_N2 | NORMAL | NONUNIQUE |
BATCH_ID
SITE_ORIG_SYSTEM ACTION_FLAG SITE_ORIG_SYSTEM_REFERENCE PARTY_SITE_ID PARTY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | (15) | Unique identifier for the batch | |
BATCH_MODE_FLAG | VARCHAR2 | (1) | Indicates whether the import is run in batch mode or online mode | |
ACTION_FLAG | VARCHAR2 | (1) | Indicates the insert or update action decided by the matching process | |
ERROR_FLAG | VARCHAR2 | (1) | Indicates that an error has occurred during the matching phase. | |
INT_ROW_ID | ROWID | (10) | Record Row identifier from associated interface table | |
PARTY_ORIG_SYSTEM | VARCHAR2 | (30) | Original System identifier for the associated party | |
PARTY_ORIG_SYSTEM_REFERENCE | VARCHAR2 | (240) | Original system reference for the associated party | |
PARTY_ID | NUMBER | (15) | Unique identifier for the associated party | |
PARTY_ACTION_FLAG | VARCHAR2 | (1) | Indicates the Insert or Update action decided by the matching process for the associated party | |
NEW_OSR_EXISTS_FLAG | VARCHAR2 | (1) | Y or N, indicates that a new source system reference exists or not | |
PRIMARY_FLAG | VARCHAR2 | (1) | Y or N, indicates that the record is marked as primary or not | |
PARTY_SITE_ID | NUMBER | (15) | Unique Identifier for the associated site | |
SITE_ORIG_SYSTEM | VARCHAR2 | (30) | Original system identifier for the associated site | |
SITE_ORIG_SYSTEM_REFERENCE | VARCHAR2 | (240) | Original system reference for the associated site | |
OLD_SITE_ORIG_SYSTEM_REF | VARCHAR2 | (240) | Old Original system Reference for the associated site |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_ID
, BATCH_MODE_FLAG
, ACTION_FLAG
, ERROR_FLAG
, INT_ROW_ID
, PARTY_ORIG_SYSTEM
, PARTY_ORIG_SYSTEM_REFERENCE
, PARTY_ID
, PARTY_ACTION_FLAG
, NEW_OSR_EXISTS_FLAG
, PRIMARY_FLAG
, PARTY_SITE_ID
, SITE_ORIG_SYSTEM
, SITE_ORIG_SYSTEM_REFERENCE
, OLD_SITE_ORIG_SYSTEM_REF
FROM AR.HZ_IMP_ADDRESSES_SG;
AR.HZ_IMP_ADDRESSES_SG does not reference any database object
AR.HZ_IMP_ADDRESSES_SG is referenced by following:
|
|
|