ACD_CONCEPTS_STRUCTURE_COUNT

Details

Name
CONCEPT_STRUCTURE_ID TOP_CONCEPT_ID CONCEPT_NAME CONCEPT_DESCRIPTION LIFECYCLE_PHASE DISTANCE RELATED_TYPE_ID RELATED_TYPE ELEMENT_COUNT COMPONENT_COUNT ITEM_COUNT

Name

CONCEPT_STRUCTURE_ID

TOP_CONCEPT_ID

CONCEPT_NAME

CONCEPT_DESCRIPTION

LIFECYCLE_PHASE

DISTANCE

RELATED_TYPE_ID

RELATED_TYPE

ELEMENT_COUNT

COMPONENT_COUNT

ITEM_COUNT

SQL_Statement
SELECT connect_by_root acs.concept_structure_id concept_structure_id, connect_by_root acs.top_concept_id top_concept_id, connect_by_root acv.name concept_name, connect_by_root acv.description concept_description, connect_by_root acv.lifecycle_phase lifecycle_phase, level distance, CASE WHEN acs.to_type='ITEM' THEN acs.to_item_id ELSE TO_CHAR(acs.to_id) END AS related_type_id, acs.to_type related_type, 1 AS element_count, CASE WHEN acs.to_type='COMPONENT' THEN 1 ELSE 0 END AS component_count, CASE WHEN acs.to_type='ITEM' THEN 1 ELSE 0 END AS item_count FROM ACD_CONCEPT_STRUCTURE acs, ACD_CONCEPT_VL acv WHERE acs.top_concept_id = acv.concept_id START WITH acs.from_str_id IS NULL CONNECT BY prior acs.concept_structure_id = acs.from_str_id

SQL_Statement

SELECT connect_by_root acs.concept_structure_id concept_structure_id,

connect_by_root acs.top_concept_id top_concept_id,

connect_by_root acv.name concept_name,

connect_by_root acv.description concept_description,

connect_by_root acv.lifecycle_phase lifecycle_phase,

level distance,

CASE

WHEN acs.to_type='ITEM'

THEN acs.to_item_id

ELSE TO_CHAR(acs.to_id)

END AS related_type_id,

acs.to_type related_type,

1 AS element_count,

CASE

WHEN acs.to_type='COMPONENT'

THEN 1

ELSE 0

END AS component_count,

CASE

WHEN acs.to_type='ITEM'

THEN 1

ELSE 0

END AS item_count

FROM ACD_CONCEPT_STRUCTURE acs,

ACD_CONCEPT_VL acv

WHERE acs.top_concept_id = acv.concept_id

START WITH acs.from_str_id IS NULL

CONNECT BY prior acs.concept_structure_id = acs.from_str_id