pcdinh_pdf_archive_normalization_report

SELECT 
    MAX(CASE 
      WHEN checked_status = 0 THEN doc_count
      ELSE 0
    END) file_not_existed,
    MAX(CASE 
      WHEN checked_status = 1 THEN doc_count
      ELSE 0
    END) file_existed,
    MAX(CASE 
      WHEN checked_status = 5 THEN doc_count 
      ELSE 0
    END) wvb_number_not_found,
    MAX(CASE 
      WHEN checked_status = 7 THEN doc_count
      ELSE 0
    END) AS unable_rename,
    MAX(CASE 
      WHEN checked_status = 8 THEN doc_count
      ELSE 0
    END) invalid_file_extension,
    MAX(CASE checked_status
      WHEN -1 THEN doc_count
      ELSE 0
    END) not_checked    
FROM (
    SELECT 
      checked_status,
      COUNT(checked_status) doc_count
    FROM (SELECT 
            NVL(checked_status, -1) checked_status -- script does not check newly added records
          FROM wvb_document)    
    GROUP BY checked_status
)