昆明医科大学第一附属医院费用统计 (2023-04-18)

SELECT NVL(SUM(DECODE(stat_cate, '01', t.tot_cost, 0)), 0) 西药费, NVL(SUM(DECODE(stat_cate, '02', t.tot_cost, 0)), 0) 中成药费, NVL(SUM(DECODE(stat_cate, '03', t.tot_cost, 0)), 0) 中草药费, NVL(SUM(DECODE(stat_cate, '04', t.tot_cost, 0)), 0) 挂号费, NVL(SUM(DECODE(stat_cate, '05', t.tot_cost, 0)), 0) 床位费, NVL(SUM(DECODE(stat_cate, '06', t.tot_cost, 0)), 0) 诊疗费, NVL(SUM(DECODE(stat_cate, '07', t.tot_cost, 0)), 0) 检查费, NVL(SUM(DECODE(stat_cate, '08', t.tot_cost, 0)), 0) 治疗费, NVL(SUM(DECODE(stat_cate, '09', t.tot_cost, 0)), 0) 护理费, NVL(SUM(DECODE(stat_cate, '10', t.tot_cost, 0)), 0) 手术费, NVL(SUM(DECODE(stat_cate, '11', t.tot_cost, 0)), 0) 化验费, NVL(SUM(DECODE(stat_cate, '12', t.tot_cost, 0)), 0) 放射费, NVL(SUM(DECODE(stat_cate, '14', t.tot_cost, 0)), 0) 其他费, DECODE(b.hospital_didt,'YLV21051','昆明医科大学第一附属医院','43120189-1-2','昆明医科大学第一附属医院呈贡医院') 院区 FROM (SELECT fee_code, tot_cost, fun_get_fee_stat_cate('ZY01', fee_code) stat_cate FROM fin_ipb_feeinfo WHERE balance_state = '1' AND fee_date >= TO_DATE('2023-04-18 00:00:00', 'yyyy-mm-dd hh24:mi:ss') AND fee_date <= TO_DATE('2023-04-18 10:00:00', 'yyyy-mm-dd hh24:mi:ss') AND balance_date > TO_DATE('2023-04-18 10:00:00', 'yyyy-mm-dd hh24:mi:ss')) t JOIN fin_ipr_inmaininfo b ON t.inpatient_no = b.inpatient_no GROUP BY DECODE(b.hospital_didt,'YLV21051','昆明医科大学第一附属医院','43120189-1-2','昆明医科大学第一附属医院呈贡医院')