MATERIALIZED VIEW: IEC.IEC_O_VAL_DNU_S6_COUNTS_MV

Source

SELECT LIST_HEADER_ID, DO_NOT_USE_REASON_S6 DO_NOT_USE_REASON, COUNT(DO_NOT_USE_REASON_S6) COUNT
               FROM IEC_O_VALIDATION_REPORT_DETS
               WHERE DO_NOT_USE_REASON_S6 IS NOT NULL
               GROUP BY LIST_HEADER_ID, DO_NOT_USE_REASON_S6