,'Directory Assistance',attr_1))total
( when id = 1 and attr_31 like 'RoamStandard%' when id = 5 and attr_30 like 'Dir%' and attr_31 like 'Roam'Directory Assistan
('20190301','YYYYMMDD')
then CH_MONEY_PAID_DED-nvl(CH_MONEY_SUBS_DED,0)-REV_VOICE_INT-REV_VOICE_ROAM_OUTGOING-REV_VOICE_ROAM_Incomingelse (CH_MONEY_OOB-REV_VOICE_INT-REV_VOICE_ROAM_OUTGOING-REV_VOICE_ROAM_Incoming) end)/100 AS VOICE_OO