Untitled

select * from MBD_STAGE.FUSE_SOFT_CANCEL_SUBS
where partnername = 'vodafoneindia'
and soft_cancel_active = 'Active'