Report Datamart Blocking Task
das isch dr Datamart für dr Blocking Task vo de Metatype BP, Cont und Macc
[report 2.0]
report rbsc$task_blocking.blc_list
/*
-------------------------------------------------------------------------------------------------------------
Bank:
Business Area:
Description: Report datamart for accessing blocking objects of meta type BP, CONT and MACC
-------------------------------------------------------------------------------------------------------------
ID Date Name, Company Issue Affected BUs, Description
-------------------------------------------------------------------------------------------------------------
001
-------------------------------------------------------------------------------------------------------------
*/
datamart
connect rbsc$blocking as dt
where [(dt.obj_type_id != 9 or dt.obj_sub_type_id = 1)]
group by
bu [dt.bu_id]
order by [dt.bu_id]
bp [case when dt.obj_type_id = 4 then dt.obj_id
when dt.obj_type_id = 1 then obj_cont(dt.obj_id).bp_id
when dt.obj_type_id = 9 then obj_macc(dt.obj_id).bp_id
else null
end]
order by [bp.id]
block [dt.obj_id]
order by [case when dt.obj_type_id = 4 then 1
when dt.obj_type_id = 1 then 2
when dt.obj_type_id = 9 then 3
else 9
end]
consolidate
on bu
name text assign [dt.bu.displ_text]
on bp
name text assign [obj_bp(bp.id).displ_text]
on block
obj_id number assign [dt.obj_id]
obj_type_id number assign [dt.obj_type_id]
obj_type text assign [dt.obj_type.name]
obj_type_intl_id text assign [dt.obj_type.intl_id]
block text assign [dt.block.name]
block_text text assign [dt.block_text]
remark text assign [dt.remark]
close_date date assign [dt.obj.close_date]
end datamart
end report
