MSS_FS_ATTRIBUTE_VALUES_V

Details

• Schema: FUSION

• Object owner: MSS

• Object type: VIEW

Columns

Name
PLAN_ID WORK_ORDER_ID ATTRIBUTE_VALUES

Query

SQL_Statement

select opAv.PLAN_ID, opAv.WORK_ORDER_ID, ( '[' || (rtrim((xmlcast(xmlagg(xmlelement(e, '"' || av.ATTRIBUTE_ID || ':' || av.ATTRIBUTE_VALUE_ID || ':' || av.COLOR || '",' ) order by av.ATTRIBUTE_ID) as clob)), ',')) || ']' ) as ATTRIBUTE_VALUES from MSS_WO_OP_ATTRIBUTE_VALUES opAv join MSS_ATTRIBUTE_VALUES av on opAV.PLAN_ID = av.PLAN_ID and opAV.ATTRIBUTE_ID = av.ATTRIBUTE_ID and opAV.ATTRIBUTE_VALUE_ID = av.ATTRIBUTE_VALUE_ID where opAv.WORK_ORDER_ID is not null group by opAv.PLAN_ID, opAv.WORK_ORDER_ID