1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43
| CREATE VIEW V_Test (cell, mcc, mnc, lac, cid, bsc, msc, types, lat, lon, nodeB)
AS (SELECT
I.cell,
I.mcc,
I.mnc,
I.lac,
I.ci,
I.bsc,
B.msc,
C.site,
RSite.LATITUDEREAL_NAD83,
RSite.LONGITUDEREAL_NAD83,
'---'
FROM internal_cell I, RadioEng_ERP_SiteInfo RSector, bsc B, cna_cell_sites_view C, RadioEng_ERP_SectorInfo RSite
WHERE
I.cell = C.cell
and B.bsc = I.bsc
and B.configuration = 0
and I.configuration = 0
and RSector.sectorname = I.cell
and RSite.ERP_ID = RSector.ERP_ID
UNION ALL
SELECT
U.cellid,
V.mcc,
V.mnc,
U.un_lac,
U.un_cId,
'bsc',
U.msc,
'SiteType',
RSite.LATITUDEREAL_NAD83,
RSite.LONGITUDEREAL_NAD83,
V.nodeb
FROM rfcfg.V_RFCFG_UMTS_UTranCell U,rfcfg.V_RFCFG_UMTS_RncFunction V, rfcfg.UMTSNodeB B, RadioEng_ERP_SiteInfo RSite, RadioEng_ERP_SectorInfo RSector
WHERE
ES_ADMINISTRATIVESTATE = 1
AND U.rncId = V.UserLabel
AND V.Userlabel = B.RNC
AND RSite.ERP_ID = RSector.ERP_ID
AND U.cellid = RSector.sectorname) |
Partager