機械翻訳について

ACA_STRUCTURE_REF_DESIGNATOR_V

詳細

• スキーマ: FUSION

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

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

列

名前
COMPONENT_SEQUENCE_ID REFERENCE_DESIGNATOR_STR

問合せ

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