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

TABLE: AR.HZ_IMP_CREDITRTNGS_SG

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


The HZ_IMP_CREDITRTNGS_SG table is used internally by TCA import to process information loaded into the HZ_IMP_CREDITRTNGS_INT interface table. . During the import process, data from the HZ_IMP_CREDITRTNGS_INT table is moved into the HZ_IMP_CREDITRTNGS_SG table to improve performance


Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HZ_IMP_CREDITRTNGS_SG_N1 NORMAL NONUNIQUE Tablespace ColumnBATCH_ID
ColumnPARTY_ORIG_SYSTEM
ColumnACTION_FLAG
ColumnPARTY_ORIG_SYSTEM_REFERENCE
Columns
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 party
PARTY_ORIG_SYSTEM_REFERENCE VARCHAR2 (240)
Original system reference for the party
PARTY_ID NUMBER (15)
Unique identifier for the party
CREDIT_RATING_ID NUMBER (15)
Unique identifier for the credit rating
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
,      PARTY_ORIG_SYSTEM
,      PARTY_ORIG_SYSTEM_REFERENCE
,      PARTY_ID
,      CREDIT_RATING_ID
FROM AR.HZ_IMP_CREDITRTNGS_SG;

Dependencies

[top of page]

AR.HZ_IMP_CREDITRTNGS_SG does not reference any database object

AR.HZ_IMP_CREDITRTNGS_SG is referenced by following:

SchemaAR
ViewHZ_IMP_CREDITRTNGS_SG#