ZCH_CLNS_CP_RESULTS_V

Details

• Schema: FUSION

• Object owner: ZCH

• Object type: VIEW

Columns

Name
DATA_MGMT_BATCH_ID OBJ_NAME ACCEPTED ERROR REJECTED NEW SUBMITTED VALID INVALID SYSTEM_ERROR PARTIALLY_VALID TOTAL_PROCESSED

Query

SQL_Statement

SELECT ZCPR.DATA_MGMT_BATCH_ID, ZCPR.OBJ_NAME, SUM(DECODE(ZCPR.USAGE_STATUS_CODE, 'ACCEPTED', 1, 0)) Accepted, SUM(DECODE(ZCPR.USAGE_STATUS_CODE, 'ERROR', 1, 0)) Error, SUM(DECODE(ZCPR.USAGE_STATUS_CODE, 'REJECTED', 1, 0)) Rejected, SUM(DECODE(ZCPR.USAGE_STATUS_CODE, 'NEW', 1, 0)) New, SUM(DECODE(ZCPR.USAGE_STATUS_CODE, 'SUBMITTED', 1, 0)) Submitted, SUM(DECODE(ZCPR.VERIFICATION_STATUS, 'ORA_VALID', 1, 0)) valid, SUM(DECODE(ZCPR.VERIFICATION_STATUS, 'ORA_INVALID', 1, 0)) Invalid, SUM(DECODE(ZCPR.VERIFICATION_STATUS, 'ORA_SYSTEM_ERROR', 1, 0)) System_error, SUM(DECODE(ZCPR.VERIFICATION_STATUS, 'ORA_PARTIALLY_VALID', 1, 0)) Partially_Valid, COUNT(1) Total_Processed FROM FUSION.ZCH_CLNS_CP_RESULTS ZCPR GROUP BY ZCPR.DATA_MGMT_BATCH_ID, ZCPR.OBJ_NAME