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

TABLE: AR.HZ_IMP_CONTACTROLES_SG

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


The HZ_IMP_CONTACTROLES_SG table is used internally by TCA import to process information loaded into the HZ_IMP_CONTACTROLES_INT interface table. During the import process, data from the HZ_IMP_ CONTACTROLES _INT table is moved into the HZ_IMP_ CONTACTROLES _SG table to improve performance


Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HZ_IMP_CONTACTROLES_SG_N1 NORMAL NONUNIQUE Tablespace ColumnBATCH_ID
ColumnSUB_ORIG_SYSTEM
ColumnACTION_FLAG
ColumnSUB_ORIG_SYSTEM_REFERENCE
Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER (15)
Batch identifier
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
CONTACT_ID NUMBER (15)
Unique identifier for the contact
CONTACT_ROLE_ID NUMBER (15)
Unique identifier for the contact role
SUB_ORIG_SYSTEM VARCHAR2 (30)
Original system for the subject party
SUB_ORIG_SYSTEM_REFERENCE VARCHAR2 (240)
Original system reference for the subject party
Query Text

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


SELECT BATCH_ID
,      BATCH_MODE_FLAG
,      ACTION_FLAG
,      ERROR_FLAG
,      INT_ROW_ID
,      CONTACT_ID
,      CONTACT_ROLE_ID
,      SUB_ORIG_SYSTEM
,      SUB_ORIG_SYSTEM_REFERENCE
FROM AR.HZ_IMP_CONTACTROLES_SG;

Dependencies

[top of page]

AR.HZ_IMP_CONTACTROLES_SG does not reference any database object

AR.HZ_IMP_CONTACTROLES_SG is referenced by following:

SchemaAR
ViewHZ_IMP_CONTACTROLES_SG#