1. Tables and Views for SCM
  2. CSE_ASSET_RELATIONSHIPS_GT

CSE_ASSET_RELATIONSHIPS_GT

This is an inprocess data staging table used in the processing of as built and as sold relationships from manufacturing and order management to installed base.

Details

  • Schema: FUSION

  • Object owner: CSE

  • Object type: TABLE

  • Tablespace: Default

Columns

Name Datatype Length Precision Comments
GTT_RELATIONSHIP_ID NUMBER 18 The primary key of this global temporary table. Generated internally and rows deleted at the end of the session.
PARENT_GTT_RELATIONSHIP_ID NUMBER 18 The reference to another row in the global temporary table that plays the part of a parent.
RELATIONSHIP_ACTION VARCHAR2 30 The action to create or update the relationship is captured here.
RELATIONSHIP_TYPE_CODE VARCHAR2 30 The type of relationship between the parent asset(object_id) and the child asset(subject_id).
OBJ_GTT_ASSET_ID NUMBER 18 Parent asset that is in process in the assets global temporary table.
SUBJ_GTT_ASSET_ID NUMBER 18 Child asset that is in process in the assets global temporary table.
OBJ_GTT_TXN_ID NUMBER 18 The transaction context of the parent asset.
SUBJ_GTT_TXN_ID NUMBER 18 The transaction context of the child asset.
GTT_GROUP_ID NUMBER 18 The transaction grouping that this record is part of.
RELATIONSHIP_ID NUMBER 18 The primary key of the production table cse_asset_relationships.
HIERARCHY_ID NUMBER 18 The foreign key reference to the logical hierarchy.
OBJECT_TYPE VARCHAR2 3 The type of the object reference here. It could be 'A' for Asset or 'G' for Genealogy Object. When the object type is 'A', the object_id column stores the asset_id. When the object type is 'G', the object_id column stores the genealogy_object_id.
OBJECT_ID NUMBER 18 Parent Asset Reference. Foreign key to the asset entity.
SUBJECT_TYPE VARCHAR2 3 The type of the subject reference here. It could be 'A' for Asset or 'G' for Genealogy Object. When the subject type is 'A', the subject_id column stores the asset_id. When the subject type is 'G', the subject_id column stores the genealogy_object_id.
SUBJECT_ID NUMBER 18 Child Asset Reference. Foreign key to the asset entity
LOGICAL_OBJECT_ID NUMBER 18 A superlative relationship (As Sold Structure) is built using the SubjectID -> LogicalObjectID self hierarchy to present the sales view of the customer assets. This column is used purely for that purpose.
LOGICAL_GTT_ASSET_ID NUMBER 18 A superlative relationship (As Sold Structure) is built using the SubjectID -> LogicalObjectID self hierarchy to present the sales view of the customer assets. This column is used purely for that purpose. This is the global temp table reference.
SPLIT_FROM_GTT_REL_ID NUMBER 18 If relationships are split, then the reference to the relationship that this row split from.
POSITION_NUMBER NUMBER The position number of the component or the node in the asset logical hierarchy.
POTENTIAL_FLAG VARCHAR2 1 There are use cases in the Manufacturing flow where a component of relationship is assumed based on the delayed birthing point of the assembly serial number. In such cases the component takes on a Many-to-Many relationship with multiple parent serial numbers. These relationships are marked as potential relationships with this flag.
SPLIT_FLAG VARCHAR2 1 This flag indicates a relationship between genealogy objects, mainly the lots that are split from another. The relationship will be created with the relationship type as "component of", with the split flag set.
MERGE_FLAG VARCHAR2 1 This flag indicates a relationship between genealogy objects, mainly the lots that are merged to another. The relationship will be created with the relationship type as "component of", with the merge flag set.
TRANSLATE_FLAG VARCHAR2 1 This flag indicates a relationship between genealogy objects, mainly the lots that are translated to another. The relationship will be created with the relationship type as "component of", with the translate flag set.
ACTIVE_START_DATE TIMESTAMP The active start date of the relationship.
ACTIVE_END_DATE TIMESTAMP The active end date of the relationship.
OBJECT_ITEM_ID NUMBER 18 The item reference in the parent asset.
OBJECT_SERIAL_NUMBER VARCHAR2 80 The serial number reference of the parent asset.
OBJECT_LOT_NUMBER VARCHAR2 80 The lot number reference of the parent asset.
OBJECT_ASSET_QTY NUMBER The quantity of the parent asset.
SUBJECT_ITEM_ID NUMBER 18 The item reference in the child asset.
SUBJECT_SERIAL_NUMBER VARCHAR2 80 The serial number reference in the child asset.
SUBJECT_LOT_NUMBER VARCHAR2 80 The lot number reference in the child asset.
SUBJECT_ASSET_QTY NUMBER The child asset quantity.
MATCH_FOUND VARCHAR2 1 This flag indicates whether a match is found already or not.
TRANSACTED_RELATIONSHIP_ID NUMBER 18 The foreign key to the intersection entity cse_transacted_relationships. This entity holds the many to many association between transactions and relationships.
EVENT_RAISED_FLAG VARCHAR2 1 Flag indicating whether an asset event was raised or not.

Indexes

Index Uniqueness Columns
CSE_ASSET_RELATIONSHIPS_GT_N1 Non Unique GTT_GROUP_ID, RELATIONSHIP_ID, SUBJECT_ID, OBJECT_ID