ACD_CONCEPT_STR_CONCEPTS_V

Details

• Schema: FUSION

• Object owner: ACD

• Object type: VIEW

Columns

Name
CONCEPT_STRUCTURE_ID CONCEPT_ID

Query

SQL_Statement

SELECT CONCEPT_STRUCTURE_ID, FROM_ID CONCEPT_ID FROM acd_concept_structure WHERE from_type = 'CONCEPT' UNION SELECT CONCEPT_STRUCTURE_ID, TO_ID CONCEPT_ID FROM acd_concept_structure WHERE to_type = 'CONCEPT' UNION SELECT CONCEPT_STRUCTURE_ID, FROM_ID CONCEPT_ID FROM acd_concept_structure WHERE from_type = 'SUB_CONCEPT' UNION SELECT CONCEPT_STRUCTURE_ID, TO_ID CONCEPT_ID FROM acd_concept_structure WHERE to_type = 'SUB_CONCEPT'