新建文本文档.txt

电信计费帐务系统话费查询营业厅触摸屏界面

查询长途：
select phone_nbr,call_start_time,
      end_phone_nbr,chg_duration,
basic_chg,tax,basic_chg+tax
  from hrb_vw_ld_call_dtl@cxjd
where phone_nbr ='2345986'
  and billing_period='200006'
  and bill_item='LDC'
order by call_start_time



select phone_nbr,call_start_time,
      end_phone_nbr,chg_duration,
basic_chg,tax,basic_chg+tax
  from hrb_tb_ld_call_dtl_06@cxjd
where phone_nbr ='2345986'
  and billing_period='200006'
  and bill_item='LDC'
order by call_start_time









查询信息费：
select phone_nbr,call_start_time,
      end_phone_nbr,chg_duration,
basic_chg,tax,basic_chg+tax
  from hrb_vw_ld_call_dtl@cxjd
where phone_nbr ='2345986'
  and billing_period='200006'
  and bill_item='INFO'
order by call_start_time



查询话费汇总：

select * from hrb_tb_jf_chgit_query@cxjd
where  phone_nbr ='2345986'
and billing_period ='200006'