DBA Data[Home] [Help]
Skip to content

MATERIALIZED VIEW: IEC.IEC_O_VAL_DNU_S4_COUNTS_MV

Source


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