ZCH_CLNS_RSLT_BATCHES_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

Query

SQL_Statement

select t.data_mgmt_batch_id, t.total, t.no_of_cleansed, t.no_of_verified, t.no_of_skipped, t.no_of_failed from ( select bt.last_update_date, rs.data_mgmt_batch_id, rs.total, rs.no_of_cleansed, rs.no_of_verified, rs.no_of_skipped, rs.no_of_failed from (select cs.data_mgmt_batch_id, sum(cs.total) total, sum(cs.no_of_cleansed) no_of_cleansed, sum(cs.no_of_verified) no_of_verified, sum(cs.no_of_skipped) no_of_skipped, sum(cs.no_of_failed) no_of_failed from (select s.process_id data_mgmt_batch_id, stats.* from zch_data_mgmt_process_stats s, json_table(s.stats_content columns ( nested path '$[*]' COLUMNS ( TOTAL number path '$.total', NO_OF_CLEANSED number path '$.cleansed', NO_OF_VERIFIED number path '$.verified', NO_OF_SKIPPED number path '$.skipped', NO_OF_FAILED number path '$.failed' ) ) ) stats where obj_name = 'LOCATION') cs group by cs.data_mgmt_batch_id) rs, FUSION.ZCH_DATA_MGMT_BATCHES_B bt where bt.data_mgmt_batch_id = rs.data_mgmt_batch_id and bt.batch_type = 'CLEANSING' order by bt.creation_date desc) t where rownum < 11