CSE_AS_BUILT_RELATIONS_V
Details
-
Schema: FUSION
-
Object owner: CSE
-
Object type: VIEW
Columns
Name |
---|
ROOT_ASSET_ID PARENT_ASSET_ID CHILD_ASSET_ID CHILD_LEVEL CHILD_LPAD_CHARS LEAF_NODE RELATIONSHIP_TYPE_CODE ACTIVE_START_DATE ACTIVE_END_DATE |
Query
SQL_Statement |
---|
select connect_by_root(object_id) root_asset_id, object_id parent_asset_id, subject_id child_asset_id, level child_level, lpad('*', (level)*1, '*') child_lpad_chars, connect_by_isleaf leaf_node, relationship_type_code relationship_type_code, active_start_date active_start_date, active_end_date active_end_date from cse_asset_relationships where relationship_type_code = 'ORA_COMPONENT' and active_end_date is null and potential_flag = 'N' connect by nocycle(prior subject_id = object_id and potential_flag = 'N' and relationship_type_code = 'ORA_COMPONENT') |