機械翻訳について

CSE_AS_BUILT_RELATIONS_V

詳細

• スキーマ: FUSION

• オブジェクト所有者: CSE

• オブジェクト・タイプ: VIEW

列

名前
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

問合せ

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')