1. Tables and Views for SCM
  2. ACA_CS_RELATIONSHIP_

ACA_CS_RELATIONSHIP_

This table is used to store the relationship between two IM/AUX objects. Stores the source and destination object types and respective id for each reference added.

Details

  • Schema: FUSION

  • Object owner: ACA

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

ACA_CS_RELATIONSHIP_PK_

LAST_UPDATE_DATE, LAST_UPDATED_BY, RELATIONSHIP_ID

Columns

Name Datatype Length Precision Not-null Comments
RELATIONSHIP_ID NUMBER 18 Yes This is the primary key for relationships. As an internal ID used to uniquely identify the object, its values are governed by the global Fusion sequence generator
DEST_OBJ_PK2VALUE NUMBER 18 Refers to PK2 value of the affected object
DEST_OBJ_PK3VALUE NUMBER 18 Refers to PK3 value of the affected object
DEST_OBJ_PK4VALUE NUMBER 18 Refers to PK4 value of the affected object
DEST_OBJ_PK5VALUE NUMBER 18 Refers to PK5 value of the affected object
SRC_OBJ_PK4VALUE NUMBER 18 Refers to PK4 Value of Controlling Object
SRC_OBJ_PK5VALUE NUMBER 18 Refers to PK5 Value of Controlling Object
SRC_OBJ_PK3VALUE NUMBER 18 Refers to PK3 Value of Controlling Object
SRC_OBJ_PK2VALUE NUMBER 18 Refers to PK2 Value of Controlling Object
OBJECT_VERSION_NUMBER NUMBER 9 Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
RELATIONSHIP_TYPE VARCHAR2 30 Indicates the various types of relationships when associating multiple objects. The values of this column will be picked from FND lookup ORA_ACA_REL_TYPE.
TARGET_TYPE VARCHAR2 1 Specifies if the target object is a fusion object(0) or an AUX object(1)
DIRECTION_TYPE VARCHAR2 1 Indicates if the relationship is bidirectional(0) or unidirectional(1)
SRC_OBJ_TYPE VARCHAR2 30 Class type of the controlling object
SRC_OBJ_ID NUMBER 18 Refers to the id of the controlling object
SRC_OBJ_NUMBER VARCHAR2 500 Refers to the number of the controlling object
DEST_OBJ_TYPE VARCHAR2 30 Class type of the affected object.This is required only for IM objects.
DEST_OBJ_ID NUMBER 18 Refers to the id of the affected object. This is required only for IM objects.
DEST_OBJ_NUMBER VARCHAR2 500 Refers to the number of the affected object.
AUX_UNIQUE_ID VARCHAR2 100 The AU Coex unquie identifier string. This is required only for AUX objects.
AUX_RELATIONSHIP_ID VARCHAR2 100 This column represents the specific reference row in the linked object's relationship table.
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
AUDIT_ACTION_TYPE_ VARCHAR2 10 Action Type - have values like INSERT, UPDATE and DELETE.
AUDIT_CHANGE_BIT_MAP_ VARCHAR2 1000 Used to store a bit map of 1s and 0s for each column in the table.
AUDIT_IMPERSONATOR_ VARCHAR2 64 Who column: indicates the impersonator who last updated the row.

Indexes

Index Uniqueness Tablespace Columns
ACA_CS_RELATIONSHIPN1_ Non Unique Default RELATIONSHIP_ID, LAST_UPDATE_DATE
ACA_CS_RELATIONSHIP_PK_ Unique Default LAST_UPDATE_DATE, LAST_UPDATED_BY, RELATIONSHIP_ID
ACA_CS_RELATIONSHIP_U1_ Unique Default LAST_UPDATE_DATE, LAST_UPDATED_BY, SRC_OBJ_TYPE, SRC_OBJ_ID, DEST_OBJ_TYPE, DEST_OBJ_ID, AUX_UNIQUE_ID