ACA_STRUCTURE_REF_DESIGNATOR_V

Details

• Schema: FUSION

• Object owner: ACA

• Object type: VIEW

Columns

Name
COMPONENT_SEQUENCE_ID REFERENCE_DESIGNATOR_STR

Query

SQL_Statement

SELECT component_sequence_id, RTRIM(XMLAGG(XMLELEMENT(E,component_reference_designator, ',').EXTRACT('//text()') ORDER BY component_reference_designator).GetClobVal(),',') reference_designator_str FROM (SELECT * FROM EGP_REFERENCE_DESIGNATORS b WHERE EXISTS ( (SELECT 1 FROM ACA_STRUCTURE_EXPL_STAGING a WHERE A.component_sequence_id = B.component_sequence_id) ) AND b.acd_type != 3 ) GROUP BY component_sequence_id