1. Tables and Views for SCM
  2. CSE_ASSET_RELATIONS_GT_DEBUG

CSE_ASSET_RELATIONS_GT_DEBUG

This is as debug table to capture the inprocess data 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

Primary Key

Name Columns

CSE_ASSET_RELATIONS_GTD_PK

GTT_RELATIONSHIP_ID, DEBUG_STAGE

Columns

Name Datatype Length Precision Not-null Comments
GTT_RELATIONSHIP_ID NUMBER 18 Yes The primary key of this global temporary table. Generated internally and rows deleted at the end of the session.
DEBUG_STAGE VARCHAR2 30 Yes The developer handle to capture the stage in which the debug data is captured. A free format user handle.
API_NAME VARCHAR2 120 The api from where the debugging is initiated.
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 to be used in the processing.
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.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes 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.

Indexes

Index Uniqueness Tablespace Columns
CSE_ASSET_RELATIONS_GTD_U01 Unique Default GTT_RELATIONSHIP_ID, DEBUG_STAGE