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

TABLE: AR.HZ_IMP_OSR_CHANGE

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


The HZ_IMP_OSR_CHANGE table is used internally by TCA import to process information loaded into the HZ_IMP_PARTIES_INT and HZ_IMP_ADDRESSES_INT interface table. During the import process, a row would be populated for each interface entry that has a change in source system reference


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HZ_IMP_OSR_CHANGE_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnBATCH_ID
ColumnENTITY_NAME
ColumnNEW_ORIG_SYSTEM_REFERENCE
ColumnENTITY_ID
Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER (15) Yes Batch identifier
ENTITY_ID NUMBER (15) Yes Unique identifier for the party or address
NEW_ORIG_SYSTEM_REFERENCE VARCHAR2 (240)
New original system identifier for the party or address
OLD_ORIG_SYSTEM_REFERENCE VARCHAR2 (240)
Old original system identifier for the party or address
NEW_OSR_EXISTS_FLAG VARCHAR2 (1)
Indicates if new source system reference exists. Y for yes, N or NULL for no
ENTITY_NAME VARCHAR2 (30) Yes Indicates whether the entry is a party or address
PARTY_ID NUMBER (15)
Unique identifier for the party associated with address
Query Text

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


SELECT BATCH_ID
,      ENTITY_ID
,      NEW_ORIG_SYSTEM_REFERENCE
,      OLD_ORIG_SYSTEM_REFERENCE
,      NEW_OSR_EXISTS_FLAG
,      ENTITY_NAME
,      PARTY_ID
FROM AR.HZ_IMP_OSR_CHANGE;

Dependencies

[top of page]

AR.HZ_IMP_OSR_CHANGE does not reference any database object

AR.HZ_IMP_OSR_CHANGE is referenced by following:

SchemaAR
ViewHZ_IMP_OSR_CHANGE#