[Home] [Help] [Dependency Information]
Object Name: | HZ_ORIG_SYS_REFERENCES |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.HZ_ORIG_SYS_REFERENCES |
Subobject Name: | |
Status: | VALID |
The HZ_ORIG_SYSTEM_REFERENCES table stores the mapping between source system references and the owner tables. The source system reference is an identifier for the record that the data came from the source system and the owner table is the TCA table, which stores that data. A record with an Active status means the cross-reference mapping between TCA and source system is vaild. An Inactive status means the cross-referencing mapping is no longer valid.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HZ_ORIG_SYS_REFERENCES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ORIG_SYSTEM_REF_ID |
HZ_ORIG_SYS_REFERENCES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ORIG_SYSTEM
ORIG_SYSTEM_REFERENCE OWNER_TABLE_NAME OWNER_TABLE_ID |
HZ_ORIG_SYS_REFERENCES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
OWNER_TABLE_NAME
OWNER_TABLE_ID |
HZ_ORIG_SYS_REFERENCES_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ORIG_SYSTEM
OWNER_TABLE_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORIG_SYSTEM_REF_ID | NUMBER | (15) | Yes | Sequentially generated identifier |
ORIG_SYSTEM | VARCHAR2 | (30) | Yes | Source system name |
ORIG_SYSTEM_REFERENCE | VARCHAR2 | (255) | Yes | Source system id for the source system logical entit |
OWNER_TABLE_NAME | VARCHAR2 | (30) | Yes | TCA tables that have source system reference column |
OWNER_TABLE_ID | NUMBER | (15) | Yes | Unique identifier for a record in the owner table |
STATUS | VARCHAR2 | (1) | Yes | A for Active. Mapping is validI for Inactive. Mapping is invalidThe default is A for Active. |
REASON_CODE | VARCHAR2 | (30) | Reason for setting the record to Inactive | |
OLD_ORIG_SYSTEM_REFERENCE | VARCHAR2 | (255) | Old source system reference that is being replaced | |
START_DATE_ACTIVE | DATE | Yes | Start date | |
END_DATE_ACTIVE | DATE | End date | ||
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Version number for concurrency control purpose | |
CREATED_BY_MODULE | VARCHAR2 | (150) | TCA Who column | |
APPLICATION_ID | NUMBER | (15) | TCA Who column | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
PARTY_ID | NUMBER | (15) | Denormalized party identifier from HZ_PARTIES table | |
REQUEST_ID | NUMBER | (15) | Request ID of concurrent program | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Identifies the application running the program | |
PROGRAM_ID | NUMBER | (15) | Identifies the concurrent program that was run | |
PROGRAM_UPDATE_DATE | DATE | Date that the program updated the record |
Cut, paste (and edit) the following text to query this object:
SELECT ORIG_SYSTEM_REF_ID
, ORIG_SYSTEM
, ORIG_SYSTEM_REFERENCE
, OWNER_TABLE_NAME
, OWNER_TABLE_ID
, STATUS
, REASON_CODE
, OLD_ORIG_SYSTEM_REFERENCE
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, CREATED_BY_MODULE
, APPLICATION_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, PARTY_ID
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM AR.HZ_ORIG_SYS_REFERENCES;
AR.HZ_ORIG_SYS_REFERENCES does not reference any database object
AR.HZ_ORIG_SYS_REFERENCES is referenced by following:
|
|
|