【資料名稱】：paging

【資料作者】：paging

【資料日期】：2011

【資料語言】：英文

【資料格式】：DOC

【資料目錄和簡介】：

SELECTa.period_start_time time,
o.NAME,
c.CELL_ID CELL,
C.LA_ID_LAC LAC,
a.PAGING_MSG_SENT PAGING,
a.DELETE_PAGING_COMMAND,
--a.AVE_NON_DRX_AGCH_LOAD_AIR_SUM,
--a.AVE_NON_DRX_AGCH_LOAD_AIR_DEN,
a.PS_PAGING_MSG_SENT,
a.CS_PAGING_MSG_SENT




FROM C_BTS C , OBJECTS o, p_NBSC_RES_ACCESS a


WHEREa.INT_ID = o.INT_ID
and a.BTS_INT_ID=C.INT_ID
and c.conf_name='<ACTUAL>'
and o.name like 'XG_BSC%'
and a.PAGING_MSG_SENT <>'0'
-- and c.CELL_ID='18571'
--and ( C.LA_ID_LAC ='31195' orC.LA_ID_LAC ='31156')
--andC.LA_ID_LAC ='31156'
and to_char(period_start_time, 'yyyymmdd') >= '&start'
and to_char(period_start_time, 'yyyymmdd') <= '&stop'
and to_char(period_start_time, 'hh24') >= '10'
and to_char(period_start_time, 'hh24') <= '10'
--and (TO_CHAR(period_start_time, 'YYYY-MM-DD') between'2008-11-05' and '2008-11-07')
order byc.CELL_ID