QP_MATRIX_RULES_VL
Details
-
Schema: FUSION
-
Object owner: QP
-
Object type: VIEW
Columns
Name |
---|
DYNAMIC_MATRIX_ID DYNAMIC_MATRIX_RULE_ID DYNAMIC_MATRIX_CLASS_ID ATTRIBUTE_1 ATTRIBUTE_VALUE_1 ATTRIBUTE_2 ATTRIBUTE_VALUE_2 ATTRIBUTE_3 ATTRIBUTE_VALUE_3 ATTRIBUTE_4 ATTRIBUTE_VALUE_4 ATTRIBUTE_5 ATTRIBUTE_VALUE_5 ATTRIBUTE_6 ATTRIBUTE_VALUE_6 ATTRIBUTE_7 ATTRIBUTE_VALUE_7 ATTRIBUTE_8 ATTRIBUTE_VALUE_8 ATTRIBUTE_9 ATTRIBUTE_VALUE_9 ATTRIBUTE_10 ATTRIBUTE_VALUE_10 ATTRIBUTE_11 ATTRIBUTE_VALUE_11 ATTRIBUTE_12 ATTRIBUTE_VALUE_12 ATTRIBUTE_13 ATTRIBUTE_VALUE_13 ATTRIBUTE_14 ATTRIBUTE_VALUE_14 ATTRIBUTE_15 ATTRIBUTE_VALUE_15 ATTRIBUTE_16 ATTRIBUTE_VALUE_16 ATTRIBUTE_17 ATTRIBUTE_VALUE_17 ATTRIBUTE_18 ATTRIBUTE_VALUE_18 ATTRIBUTE_19 ATTRIBUTE_VALUE_19 ATTRIBUTE_20 ATTRIBUTE_VALUE_20 ATTRIBUTE_21 ATTRIBUTE_VALUE_21 ATTRIBUTE_22 ATTRIBUTE_VALUE_22 ATTRIBUTE_23 ATTRIBUTE_VALUE_23 ATTRIBUTE_24 ATTRIBUTE_VALUE_24 ATTRIBUTE_25 ATTRIBUTE_VALUE_25 |
Query
SQL_Statement |
---|
SELECT DYNAMIC_MATRIX_ID, DYNAMIC_MATRIX_RULE_ID, MAX(DYNAMIC_MATRIX_CLASS_ID) DYNAMIC_MATRIX_CLASS_ID, MAX( CASE WHEN DIMENSION_NO='Dimension1' THEN ATTRIBUTE_NAME END) ATTRIBUTE_1, MAX( CASE WHEN DIMENSION_NO='Dimension1' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_1, MAX( CASE WHEN DIMENSION_NO='Dimension2' THEN ATTRIBUTE_NAME END) ATTRIBUTE_2, MAX( CASE WHEN DIMENSION_NO='Dimension2' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_2, MAX( CASE WHEN DIMENSION_NO='Dimension3' THEN ATTRIBUTE_NAME END) ATTRIBUTE_3, MAX( CASE WHEN DIMENSION_NO='Dimension3' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_3, MAX( CASE WHEN DIMENSION_NO='Dimension4' THEN ATTRIBUTE_NAME END) ATTRIBUTE_4, MAX( CASE WHEN DIMENSION_NO='Dimension4' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_4, MAX( CASE WHEN DIMENSION_NO='Dimension5' THEN ATTRIBUTE_NAME END) ATTRIBUTE_5, MAX( CASE WHEN DIMENSION_NO='Dimension5' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_5, MAX( CASE WHEN DIMENSION_NO='Dimension6' THEN ATTRIBUTE_NAME END) ATTRIBUTE_6, MAX( CASE WHEN DIMENSION_NO='Dimension6' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_6, MAX( CASE WHEN DIMENSION_NO='Dimension7' THEN ATTRIBUTE_NAME END) ATTRIBUTE_7, MAX( CASE WHEN DIMENSION_NO='Dimension7' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_7, MAX( CASE WHEN DIMENSION_NO='Dimension8' THEN ATTRIBUTE_NAME END) ATTRIBUTE_8, MAX( CASE WHEN DIMENSION_NO='Dimension8' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_8, MAX( CASE WHEN DIMENSION_NO='Dimension9' THEN ATTRIBUTE_NAME END) ATTRIBUTE_9, MAX( CASE WHEN DIMENSION_NO='Dimension9' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_9, MAX( CASE WHEN DIMENSION_NO='Dimension10' THEN ATTRIBUTE_NAME END) ATTRIBUTE_10, MAX( CASE WHEN DIMENSION_NO='Dimension10' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_10, MAX( CASE WHEN DIMENSION_NO='Dimension11' THEN ATTRIBUTE_NAME END) ATTRIBUTE_11, MAX( CASE WHEN DIMENSION_NO='Dimension11' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_11, MAX( CASE WHEN DIMENSION_NO='Dimension12' THEN ATTRIBUTE_NAME END) ATTRIBUTE_12, MAX( CASE WHEN DIMENSION_NO='Dimension12' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_12, MAX( CASE WHEN DIMENSION_NO='Dimension13' THEN ATTRIBUTE_NAME END) ATTRIBUTE_13, MAX( CASE WHEN DIMENSION_NO='Dimension13' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_13, MAX( CASE WHEN DIMENSION_NO='Dimension14' THEN ATTRIBUTE_NAME END) ATTRIBUTE_14, MAX( CASE WHEN DIMENSION_NO='Dimension14' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_14, MAX( CASE WHEN DIMENSION_NO='Dimension15' THEN ATTRIBUTE_NAME END) ATTRIBUTE_15, MAX( CASE WHEN DIMENSION_NO='Dimension15' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_15, MAX( CASE WHEN DIMENSION_NO='Dimension16' THEN ATTRIBUTE_NAME END) ATTRIBUTE_16, MAX( CASE WHEN DIMENSION_NO='Dimension16' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_16, MAX( CASE WHEN DIMENSION_NO='Dimension17' THEN ATTRIBUTE_NAME END) ATTRIBUTE_17, MAX( CASE WHEN DIMENSION_NO='Dimension17' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_17, MAX( CASE WHEN DIMENSION_NO='Dimension18' THEN ATTRIBUTE_NAME END) ATTRIBUTE_18, MAX( CASE WHEN DIMENSION_NO='Dimension18' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_18, MAX( CASE WHEN DIMENSION_NO='Dimension19' THEN ATTRIBUTE_NAME END) ATTRIBUTE_19, MAX( CASE WHEN DIMENSION_NO='Dimension19' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_19, MAX( CASE WHEN DIMENSION_NO='Dimension20' THEN ATTRIBUTE_NAME END) ATTRIBUTE_20, MAX( CASE WHEN DIMENSION_NO='Dimension20' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_20, MAX( CASE WHEN DIMENSION_NO='Dimension21' THEN ATTRIBUTE_NAME END) ATTRIBUTE_21, MAX( CASE WHEN DIMENSION_NO='Dimension21' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_21, MAX( CASE WHEN DIMENSION_NO='Dimension22' THEN ATTRIBUTE_NAME END) ATTRIBUTE_22, MAX( CASE WHEN DIMENSION_NO='Dimension22' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_22, MAX( CASE WHEN DIMENSION_NO='Dimension23' THEN ATTRIBUTE_NAME END) ATTRIBUTE_23, MAX( CASE WHEN DIMENSION_NO='Dimension23' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_23, MAX( CASE WHEN DIMENSION_NO='Dimension24' THEN ATTRIBUTE_NAME END) ATTRIBUTE_24, MAX( CASE WHEN DIMENSION_NO='Dimension24' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_24, MAX( CASE WHEN DIMENSION_NO='Dimension25' THEN ATTRIBUTE_NAME END) ATTRIBUTE_25, MAX( CASE WHEN DIMENSION_NO='Dimension25' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_25 FROM (SELECT DYNAMIC_MATRIX_DIMENSION_NAME AS ATTRIBUTE_NAME, ATTRIBUTE_TYPE, COLUMN_VALUE , b.DYNAMIC_MATRIX_RULE_ID, a.DYNAMIC_MATRIX_ID, a.DYNAMIC_MATRIX_CLASS_ID, 'Dimension' || (row_number() over (partition BY b.DYNAMIC_MATRIX_RULE_ID, a.DYNAMIC_MATRIX_ID order by DISPLAY_SEQUENCE_NUM)) AS DIMENSION_NO FROM (SELECT DimensionsTL.DYNAMIC_MATRIX_DIMENSION_NAME, 'VALUE_' ||MatrixDimensionsB.DATA_TYPE_CODE ||InheritedDimensions.MAP_TO_RULE_COL_NUM AS ATTRIBUTE_TYPE, DIMENSION_TYPE, MatrixDimensionsB.DISPLAY_SEQUENCE_NUM AS DISPLAY_SEQUENCE_NUM, InheritedDimensions.DYNAMIC_MATRIX_ID, MatrixDimensionsB.DYNAMIC_MATRIX_CLASS_ID FROM QP_MATRIX_DIMENSIONS_B MatrixDimensionsB, QP_MATRIX_INHERITED_DIMENSIONS InheritedDimensions, QP_MATRIX_DIMENSIONS_TL DimensionsTL WHERE MatrixDimensionsB.DYNAMIC_MATRIX_DIMENSION_ID = InheritedDimensions.DYNAMIC_MATRIX_DIMENSION_ID AND MatrixDimensionsB.DYNAMIC_MATRIX_DIMENSION_ID = DimensionsTL.DYNAMIC_MATRIX_DIMENSION_ID AND DimensionsTL.LANGUAGE = USERENV('LANG') ) a, (SELECT COLUMN_NAME, COLUMN_VALUE, DYNAMIC_MATRIX_RULE_ID, DYNAMIC_MATRIX_ID FROM (SELECT NVL(TO_CHAR(VALUE_NUMBER1),' ') VALUE_NUMBER1, NVL(TO_CHAR(VALUE_NUMBER2),' ') VALUE_NUMBER2, NVL(TO_CHAR(VALUE_NUMBER3),' ') VALUE_NUMBER3, NVL(TO_CHAR(VALUE_NUMBER4),' ') VALUE_NUMBER4, NVL(TO_CHAR(VALUE_NUMBER5),' ') VALUE_NUMBER5, NVL(TO_CHAR(VALUE_NUMBER6),' ') VALUE_NUMBER6, NVL(TO_CHAR(VALUE_NUMBER7),' ') VALUE_NUMBER7, NVL(TO_CHAR(VALUE_NUMBER8),' ') VALUE_NUMBER8, NVL(TO_CHAR(VALUE_NUMBER9),' ') VALUE_NUMBER9, NVL(TO_CHAR(VALUE_NUMBER10),' ') VALUE_NUMBER10, NVL(TO_CHAR(VALUE_NUMBER11),' ') VALUE_NUMBER11, NVL(TO_CHAR(VALUE_NUMBER12),' ') VALUE_NUMBER12, NVL(TO_CHAR(VALUE_NUMBER13),' ') VALUE_NUMBER13, NVL(TO_CHAR(VALUE_NUMBER14),' ') VALUE_NUMBER14, NVL(TO_CHAR(VALUE_NUMBER15),' ') VALUE_NUMBER15, NVL(TO_CHAR(VALUE_NUMBER16),' ') VALUE_NUMBER16, NVL(TO_CHAR(VALUE_NUMBER17),' ') VALUE_NUMBER17, NVL(TO_CHAR(VALUE_NUMBER18),' ') VALUE_NUMBER18, NVL(TO_CHAR(VALUE_NUMBER19),' ') VALUE_NUMBER19, NVL(TO_CHAR(VALUE_NUMBER20),' ') VALUE_NUMBER20, NVL(TO_CHAR(VALUE_NUMBER21),' ') VALUE_NUMBER21, NVL(TO_CHAR(VALUE_NUMBER22),' ') VALUE_NUMBER22, NVL(TO_CHAR(VALUE_NUMBER23),' ') VALUE_NUMBER23, NVL(TO_CHAR(VALUE_NUMBER24),' ') VALUE_NUMBER24, NVL(TO_CHAR(VALUE_NUMBER25),' ') VALUE_NUMBER25, NVL(VALUE_STRING1,' ') VALUE_STRING1, NVL(VALUE_STRING2,' ') VALUE_STRING2, NVL(VALUE_STRING3,' ') VALUE_STRING3, NVL(VALUE_STRING4,' ') VALUE_STRING4, NVL(VALUE_STRING5,' ') VALUE_STRING5, NVL(VALUE_STRING6,' ') VALUE_STRING6, NVL(VALUE_STRING7,' ') VALUE_STRING7, NVL(VALUE_STRING8,' ') VALUE_STRING8, NVL(VALUE_STRING9,' ') VALUE_STRING9, NVL(VALUE_STRING10,' ') VALUE_STRING10, NVL(VALUE_STRING11,' ') VALUE_STRING11, NVL(VALUE_STRING12,' ') VALUE_STRING12, NVL(VALUE_STRING13,' ') VALUE_STRING13, NVL(VALUE_STRING14,' ') VALUE_STRING14, NVL(VALUE_STRING15,' ') VALUE_STRING15, NVL(VALUE_STRING16,' ') VALUE_STRING16, NVL(VALUE_STRING17,' ') VALUE_STRING17, NVL(VALUE_STRING18,' ') VALUE_STRING18, NVL(VALUE_STRING19,' ') VALUE_STRING19, NVL(VALUE_STRING20,' ') VALUE_STRING20, NVL(VALUE_STRING21,' ') VALUE_STRING21, NVL(VALUE_STRING22,' ') VALUE_STRING22, NVL(VALUE_STRING23,' ') VALUE_STRING23, NVL(VALUE_STRING24,' ') VALUE_STRING24, NVL(VALUE_STRING25,' ') VALUE_STRING25, NVL(TO_CHAR(VALUE_DATE1,'YYYY-MM-DD'),' ') VALUE_DATE1, NVL(TO_CHAR(VALUE_DATE2,'YYYY-MM-DD'),' ') VALUE_DATE2, NVL(TO_CHAR(VALUE_DATE3,'YYYY-MM-DD'),' ') VALUE_DATE3, NVL(TO_CHAR(VALUE_DATE4,'YYYY-MM-DD'),' ') VALUE_DATE4, NVL(TO_CHAR(VALUE_DATE5,'YYYY-MM-DD'),' ') VALUE_DATE5, NVL(TO_CHAR(VALUE_DATE6,'YYYY-MM-DD'),' ') VALUE_DATE6, NVL(TO_CHAR(VALUE_DATE7,'YYYY-MM-DD'),' ') VALUE_DATE7, NVL(TO_CHAR(VALUE_DATE8,'YYYY-MM-DD'),' ') VALUE_DATE8, NVL(TO_CHAR(VALUE_DATE9,'YYYY-MM-DD'),' ') VALUE_DATE9, NVL(TO_CHAR(VALUE_DATE10,'YYYY-MM-DD'),' ') VALUE_DATE10, NVL(TO_CHAR(VALUE_DATE11,'YYYY-MM-DD'),' ') VALUE_DATE11, NVL(TO_CHAR(VALUE_DATE12,'YYYY-MM-DD'),' ') VALUE_DATE12, NVL(TO_CHAR(VALUE_DATE13,'YYYY-MM-DD'),' ') VALUE_DATE13, NVL(TO_CHAR(VALUE_DATE14,'YYYY-MM-DD'),' ') VALUE_DATE14, NVL(TO_CHAR(VALUE_DATE15,'YYYY-MM-DD'),' ') VALUE_DATE15, NVL(TO_CHAR(VALUE_DATE16,'YYYY-MM-DD'),' ') VALUE_DATE16, NVL(TO_CHAR(VALUE_DATE17,'YYYY-MM-DD'),' ') VALUE_DATE17, NVL(TO_CHAR(VALUE_DATE18,'YYYY-MM-DD'),' ') VALUE_DATE18, NVL(TO_CHAR(VALUE_DATE19,'YYYY-MM-DD'),' ') VALUE_DATE19, NVL(TO_CHAR(VALUE_DATE20,'YYYY-MM-DD'),' ') VALUE_DATE20, NVL(TO_CHAR(VALUE_DATE21,'YYYY-MM-DD'),' ') VALUE_DATE21, NVL(TO_CHAR(VALUE_DATE22,'YYYY-MM-DD'),' ') VALUE_DATE22, NVL(TO_CHAR(VALUE_DATE23,'YYYY-MM-DD'),' ') VALUE_DATE23, NVL(TO_CHAR(VALUE_DATE24,'YYYY-MM-DD'),' ') VALUE_DATE24, NVL(TO_CHAR(VALUE_DATE25,'YYYY-MM-DD'),' ') VALUE_DATE25, NVL(TO_CHAR(VALUE_TIMESTAMP1,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP1, NVL(TO_CHAR(VALUE_TIMESTAMP2,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP2, NVL(TO_CHAR(VALUE_TIMESTAMP3,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP3, NVL(TO_CHAR(VALUE_TIMESTAMP4,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP4, NVL(TO_CHAR(VALUE_TIMESTAMP5,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP5, NVL(TO_CHAR(VALUE_TIMESTAMP6,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP6, NVL(TO_CHAR(VALUE_TIMESTAMP7,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP7, NVL(TO_CHAR(VALUE_TIMESTAMP8,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP8, NVL(TO_CHAR(VALUE_TIMESTAMP9,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP9, NVL(TO_CHAR(VALUE_TIMESTAMP10,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP10, NVL(TO_CHAR(VALUE_TIMESTAMP11,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP11, NVL(TO_CHAR(VALUE_TIMESTAMP12,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP12, NVL(TO_CHAR(VALUE_TIMESTAMP13,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP13, NVL(TO_CHAR(VALUE_TIMESTAMP14,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP14, NVL(TO_CHAR(VALUE_TIMESTAMP15,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP15, NVL(TO_CHAR(VALUE_TIMESTAMP16,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP16, NVL(TO_CHAR(VALUE_TIMESTAMP17,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP17, NVL(TO_CHAR(VALUE_TIMESTAMP18,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP18, NVL(TO_CHAR(VALUE_TIMESTAMP19,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP19, NVL(TO_CHAR(VALUE_TIMESTAMP20,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP20, NVL(TO_CHAR(VALUE_TIMESTAMP21,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP21, NVL(TO_CHAR(VALUE_TIMESTAMP22,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP22, NVL(TO_CHAR(VALUE_TIMESTAMP23,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP23, NVL(TO_CHAR(VALUE_TIMESTAMP24,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP24, NVL(TO_CHAR(VALUE_TIMESTAMP25,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP25, DYNAMIC_MATRIX_ID, DYNAMIC_MATRIX_RULE_ID FROM QP_MATRIX_RULES ) UNPIVOT( COLUMN_VALUE FOR (COLUMN_NAME) IN(VALUE_NUMBER1,VALUE_NUMBER2,VALUE_NUMBER3,VALUE_NUMBER4,VALUE_NUMBER5, VALUE_NUMBER6,VALUE_NUMBER7,VALUE_NUMBER8,VALUE_NUMBER9,VALUE_NUMBER10,VALUE_NUMBER11,VALUE_NUMBER12,VALUE_NUMBER13,VALUE_NUMBER14,VALUE_NUMBER15, VALUE_NUMBER16,VALUE_NUMBER17,VALUE_NUMBER18,VALUE_NUMBER19,VALUE_NUMBER20,VALUE_NUMBER21,VALUE_NUMBER22,VALUE_NUMBER23,VALUE_NUMBER24,VALUE_NUMBER25,VALUE_STRING1,VALUE_STRING2,VALUE_STRING3,VALUE_STRING4,VALUE_STRING5,VALUE_STRING6,VALUE_STRING7,VALUE_STRING8,VALUE_STRING9,VALUE_STRING10,VALUE_STRING11,VALUE_STRING12,VALUE_STRING13,VALUE_STRING14,VALUE_STRING15,VALUE_STRING16,VALUE_STRING17,VALUE_STRING18,VALUE_STRING19,VALUE_STRING20,VALUE_STRING21,VALUE_STRING22,VALUE_STRING23,VALUE_STRING24,VALUE_STRING25,VALUE_DATE1,VALUE_DATE2,VALUE_DATE3,VALUE_DATE4,VALUE_DATE5,VALUE_DATE6,VALUE_DATE7,VALUE_DATE8,VALUE_DATE9,VALUE_DATE10,VALUE_DATE11,VALUE_DATE12,VALUE_DATE13,VALUE_DATE14,VALUE_DATE15,VALUE_DATE16,VALUE_DATE17,VALUE_DATE18,VALUE_DATE19,VALUE_DATE20,VALUE_DATE21,VALUE_DATE22,VALUE_DATE23,VALUE_DATE24,VALUE_DATE25,VALUE_TIMESTAMP1,VALUE_TIMESTAMP2,VALUE_TIMESTAMP3,VALUE_TIMESTAMP4,VALUE_TIMESTAMP5,VALUE_TIMESTAMP6,VALUE_TIMESTAMP7,VALUE_TIMESTAMP8,VALUE_TIMESTAMP9,VALUE_TIMESTAMP10,VALUE_TIMESTAMP11,VALUE_TIMESTAMP12,VALUE_TIMESTAMP13,VALUE_TIMESTAMP14,VALUE_TIMESTAMP15,VALUE_TIMESTAMP16,VALUE_TIMESTAMP17,VALUE_TIMESTAMP18,VALUE_TIMESTAMP19,VALUE_TIMESTAMP20,VALUE_TIMESTAMP21,VALUE_TIMESTAMP22,VALUE_TIMESTAMP23,VALUE_TIMESTAMP24,VALUE_TIMESTAMP25) ) ) b WHERE a.ATTRIBUTE_TYPE = b.COLUMN_NAME AND a.DYNAMIC_MATRIX_ID = b.DYNAMIC_MATRIX_ID ) GROUP BY DYNAMIC_MATRIX_ID, DYNAMIC_MATRIX_RULE_ID |