Untitled

-- Penyisihan ph S/B reverse repo
update mrms.lg_masterParamSetComponents set formulaCode = null where relationId = 17;

update mrms.lg_paramSetComponents set formulaCode = null where relationId = 17;

-- kewajiban lain-lain
update mrms.lg_masterParamSetComponents set formulaCode = null where formulaCode = 'KWJBN_LAIN';

update mrms.lg_paramSetComponents set formulaCode = null where formulaCode = 'KWJBN_LAIN';

-- set komponen - Mudharabah Muqayadah sebagai deleted component
update mrms.lg_masterParamSetComponents set isDeleted = 1 where relationId = 63;

update mrms.lg_paramSetComponents set isDeleted = 1 where relationId = 85;

-- activate parent component
update mrms.lg_masterParamSetComponents set isActive = 1 where name in ('Aktiva tetap & inventaris nett', 'Aktiva Sewa Guna Usaha', 'Agunan Yang Diambil Alih', 'Lainnya');

--select * from mrms.lg_paramSetComponents where name like 'Aktiva tetap & inventaris nett';

update mrms.lg_paramSetComponents set isActive = 1 where name like 'Aktiva tetap & inventaris nett';

--select * from mrms.lg_paramSetComponents where name like 'Aktiva Sewa Guna Usaha';

update mrms.lg_paramSetComponents set isActive = 1 where name like 'Aktiva Sewa Guna Usaha';

--select * from mrms.lg_paramSetComponents where name like 'Agunan Yang Diambil Alih';

update mrms.lg_paramSetComponents set isActive = 1 where name like 'Agunan Yang Diambil Alih';

--select * from mrms.lg_paramSetComponents where name like 'Lainnya';

update mrms.lg_paramSetComponents set isActive = 1 where name like 'Lainnya';