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 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87
|
SELECT
--
-- Votre attention
-- ND sur réseau ATM hors TDSL
--
rcg.nd,
rcg.libst,
rcg.nomeqptl_src,
rcg.nomeqptl_acl,
cha.infbaielog,
cha.nochsbaie,
crt_dslam.crtnum,
por_dslam.portnum,
to_char(rcg.vpia) as vpia,
to_char(rcg.vc) as vc,
reg.nomrgl,
rcg.nobroche_cl as broche,
noe.codecentre42c,
rcg.nomeqptl_z,
to_char(crt_bas.crtnum) as crtbas,
to_char(por_bas.portnum) as portbas,
to_char(rcg.vpiz) as vpiz,
eqp.constrgest,
eqp.nomgest,
eqp.vrslog,
eqp.adrip,
to_char(vp11.bas_vp11) as bas_vp11,
eler_vlan.numinterf,
rcg.nomeqptl_npaa as npaa,
rcg.nomeqptl_npaz as npaz
FROM
oceane oc,
dsl_rcglobal rcg,
dsl_elemres eler_vlan,
dsl_elemres elea_l,
dsl_elemres elez_l,
dsl_reglette reg,
dsl_chassis cha,
dsl_carte crt_dslam,
dsl_port por_dslam,
dsl_carte crt_bas,
dsl_port por_bas,
dsl_eqptl eqp,
dsl_noeud noe,
(SELECT
distinct rcg_nd.nd,
rcg_nd.nomeqptl_acl,
rcg_vp11.vpia,
rcg_vp11.nomeqptl_z as bas_vp11
FROM
(SELECT
ideqptl_acl,
vpia,
nomeqptl_z
FROM
dsl_rcglobal
WHERE
vpia = 11)
rcg_vp11,
(SELECT
rcglo.nd,
rcglo.ideqptl_acl,
rcglo.nomeqptl_acl
FROM
oceane oce,
dsl_rcglobal rcglo
WHERE
oce.nd=rcglo.nd)
rcg_nd
WHERE
rcg_nd.ideqptl_acl = rcg_vp11.ideqptl_acl)
vp11
WHERE
oc.nd = rcg.nd
AND elea_l.typress = 'L'
AND elez_l.typress = 'L'
AND rcg.nd = vp11.nd (+)
AND rcg.rglid_cl = reg.rglid
AND rcg.chsid_acl = cha.chsid
AND rcg.crtid_acl = crt_dslam.crtid
AND rcg.portid_acl = por_dslam.portid
AND rcg.crtidz = crt_bas.crtid (+)
AND rcg.portidz = por_bas.portid (+)
AND rcg.nomeqptl_acl = eqp.nomeqptl
AND rcg.idnoeud_acl = noe.idnoeud
AND eler_vlan.idelem = rcg.idelem |
Partager