1. Tables and Views for Sales and Fusion Service
  2. ZCH_CLNS_RSLT_STATUS_V

ZCH_CLNS_RSLT_STATUS_V

Details

  • Schema: FUSION

  • Object owner: ZCH

  • Object type: VIEW

Columns

Name

DATA_MGMT_BATCH_ID

TOTAL

NO_OF_CLEANSED

NO_OF_VERIFIED

NO_OF_SKIPPED

NO_OF_FAILED

COUNT_STAR

CT_TOTAL

CT_OF_CLEANSED

CT_OF_VERIFIED

CT_OF_SKIPPED

CT_OF_FAILED

Query

SQL_Statement

SELECT

ZCR.DATA_MGMT_BATCH_ID,

SUM(DECODE(ZCR.PROCESS_STATUS_CODE, NULL, 0, 1)) Total,

SUM(DECODE(ZCR.PROCESS_STATUS_CODE, 'CLEANSED', 1, 0)) no_of_Cleansed,

SUM(DECODE(ZCR.PROCESS_STATUS_CODE, 'VERIFIED', 1, 0)) no_of_Verified,

SUM(DECODE(ZCR.PROCESS_STATUS_CODE, 'SKIPPED', 1, 0)) no_of_Skipped,

SUM(DECODE(ZCR.PROCESS_STATUS_CODE, 'FAILED', 1, 0)) no_of_Failed,

COUNT(*) COUNT_STAR,

COUNT(DECODE(ZCR.PROCESS_STATUS_CODE, NULL, 0, 1)) ct_Total,

COUNT(DECODE(ZCR.PROCESS_STATUS_CODE, 'CLEANSED', 1, 0)) ct_of_Cleansed,

COUNT(DECODE(ZCR.PROCESS_STATUS_CODE, 'VERIFIED', 1, 0)) ct_of_Verified,

COUNT(DECODE(ZCR.PROCESS_STATUS_CODE, 'SKIPPED', 1, 0)) ct_of_Skipped,

COUNT(DECODE(ZCR.PROCESS_STATUS_CODE, 'FAILED', 1, 0)) ct_of_Failed

FROM

FUSION.ZCH_CLNS_LOC_RESULTS ZCR

GROUP BY

ZCR.DATA_MGMT_BATCH_ID