CSE_GENEALOGY_OBJ_REFS_V

Details

• Schema: FUSION

• Object owner: CSE

• Object type: VIEW

Columns

Name

TRACKED_OBJECT_REF_ID GEN_OBJECT_ID TRANSACTION_ID ASSET_ID TRACKED_OBJECT_CODE DATA_SOURCE_TYPE DATA_SOURCE PK_ATTRIBUTE1 PK_VALUE1 UK_ATTRIBUTE1 UK_VALUE1 PK_ATTRIBUTE2 PK_VALUE2 UK_ATTRIBUTE2 UK_VALUE2 PK_ATTRIBUTE3 PK_VALUE3 UK_ATTRIBUTE3 UK_VALUE3 PK_ATTRIBUTE4 PK_VALUE4 UK_ATTRIBUTE4 UK_VALUE4 PK_ATTRIBUTE5 PK_VALUE5 UK_ATTRIBUTE5 UK_VALUE5 DISPLAY_ATTRIBUTE1 DISPLAY_ATTRIBUTE2 DISPLAY_ATTRIBUTE3 DISPLAY_ATTRIBUTE4

Query

SQL_Statement

select cto.tracked_object_ref_id tracked_object_ref_id, cto.gen_object_id gen_object_id, cto.transaction_id transaction_id, cto.asset_id asset_id, cto.tracked_object_code tracked_object_code, con.data_source_type data_source_type, con.data_source data_source, con.pk_attribute1 pk_attribute1, cto.pk_value1 pk_value1, con.uk_attribute1 uk_attribute1, cto.uk_value1 uk_value1, con.pk_attribute2 pk_attribute2, cto.pk_value2 pk_value2, con.uk_attribute2 uk_attribute2, cto.uk_value2 uk_value2, con.pk_attribute3 pk_attribute3, cto.pk_value3 pk_value3, con.uk_attribute3 uk_attribute3, cto.uk_value3 uk_value3, con.pk_attribute4 pk_attribute4, cto.pk_value4 pk_value4, con.uk_attribute4 uk_attribute4, cto.uk_value4 uk_value4, con.pk_attribute5 pk_attribute5, cto.pk_value5 pk_value5, con.uk_attribute5 uk_attribute5, cto.uk_value5 uk_value5, con.display_attribute1 display_attribute1, con.display_attribute2 display_attribute2, con.display_attribute3 display_attribute3, con.display_attribute4 display_attribute4 from cse_tracked_object_refs cto, cse_genealogy_obj_nodes_v con where con.object_code = cto.tracked_object_code