1. Tables and Views for SCM
  2. CSE_AS_SOLD_RELATIONS_V

CSE_AS_SOLD_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(nvl(logical_object_id,object_id)) root_asset_id,

nvl(logical_object_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 = nvl(logical_object_id, object_id) and potential_flag = 'N' and relationship_type_code = 'ORA_COMPONENT')