ZCH_CLNS_BATCH_RSLT_V

Details

• Schema: FUSION

• Object owner: ZCH

• Object type: VIEW

Columns

Name
DATA_MGMT_BATCH_ID PROCESS_STATUS_CODE STATUS COUNT_STAR

Query

SQL_Statement
SELECT ZCR.DATA_MGMT_BATCH_ID, PROCESS_STATUS_CODE, COUNT(PROCESS_STATUS_CODE) Status , COUNT(*) COUNT_STAR FROM FUSION.ZCH_CLNS_LOC_RESULTS ZCR GROUP BY ZCR.DATA_MGMT_BATCH_ID, PROCESS_STATUS_CODE