Cisco Transport Manager Server Database Schema, 5.0
Chapter 2: Database Schema Views
Download this chapter
Download the complete book
Table Of Contents
2.1 Active_Alarm_View_With_Ack
2.26 HFR_Interface_DRC_PM_View
2.29 HFR_MPLS_Interface_PM_View
2.32 HFR_MPLS_TE_Tunnel_PM_View
2.42 MCard_L2Topology_Map_View
2.52 ONS15216_Active_User_View
2.67 ONS15454_Active_User_View
2.68 ONS15454_BLSR_Config_View
2.69 ONS15454_BLSR_Squelch_View
2.70 ONS15454_Class_QoS_PM_View
2.71 ONS15454_CMS_Storage_View
2.82 ONS15454_MatchStmt_QoS_PM_View
2.84 ONS15454_OSPF_Area_Range_View
2.86 ONS15454_OTN_Path_PM_FE_View
2.87 ONS15454_OTN_Path_PM_View
2.88 ONS15454_OTN_Sec_PM_FE_View
2.90 ONS15454_Phy_Layer_PM_VIEW
2.91 ONS15454_Policy_QoS_PM_View
2.95 ONS15454_SNMP_Trap_Dest_View
2.96 ONS15454_SONET_Line_PM_FE_View
2.97 ONS15454_SONET_Line_PM_View
2.98 ONS15454_SONET_Path_PM_FE_View
2.99 ONS15454_SONET_Path_PM_View
2.100 ONS15454_SONET_Section_PM_View
2.101 ONS15454_SONET_VT_PM_FE_View
2.102 ONS15454_SONET_VT_PM_View
2.103 ONS15454_Spanning_Trees_View
2.104 ONS15454_Static_Route_View
2.107 ONS15454_Virtual_Link_View
2.108 ONS15454SDH_E1_PM_FE_View
2.112 ONS15454SDH_HO_PM_FE_View
2.114 ONS15454SDH_LO_VC3_PM_FE_View
2.115 ONS15454SDH_LO_VC3_PM_View
2.116 ONS15454SDH_LO_VC12_PM_FE_View
2.117 ONS15454SDH_LO_VC12_PM_View
2.118 ONS15454SDH_MS_PM_FE_View
2.121 ONS15501_Opt_Power_PM_View
2.122 ONS155xx_CDL_Flow_Config_View
2.124 ONS155xx_Circuit_CC_View
2.125 ONS155xx_Circuit_Dest_View
2.126 ONS155xx_Circuit_Final_View
2.127 ONS155xx_Circuit_Path_View
2.128 ONS155xx_Circuit_Segment_View
2.129 ONS155xx_Circuit_Span_View
2.130 ONS155xx_Circuit_SRCDEST_View
2.131 ONS155xx_Circuit_Stack_View
2.133 ONS155xx_Ckt_CC_Dest_MT_View
2.134 ONS155xx_Ckt_CC_Detailed_View
2.135 ONS155xx_Ckt_CC_Link_View
2.136 ONS155xx_Ckt_CC_Path_View
2.137 ONS155xx_Ckt_CC_Src_Dest_View
2.138 ONS155xx_Ckt_CC_Src_MT_View
2.139 ONS155xx_Ckt_Endpoint_View
2.140 ONS155xx_Ckt_Link_Final_View
2.142 ONS155xx_Ckt_NE_Final_View
2.143 ONS155xx_Ckt_Opt_Pwr_View
2.144 ONS155xx_Ckt_Path_Final_View
2.145 ONS155xx_Ckt_Path_Join_View
2.146 ONS155xx_Ckt_Path_Stack_View
2.147 ONS155xx_Ckt_Seg_Detailed_View
2.148 ONS155xx_Ckt_Segment_Path_View
2.149 ONS155xx_Ckt_Span_Dest_MT_View
2.150 ONS155xx_Ckt_Span_Det_View
2.151 ONS155xx_Ckt_Span_Join_View
2.152 ONS155xx_Ckt_Span_MT_View
2.153 ONS155xx_Ckt_Span_Src_MT_View
2.155 ONS155xx_Ckt_Src_CDL_View
2.156 ONS155xx_Ckt_SRCDEST_MT_View
2.157 ONS155xx_Ckt_Stack_Final_View
2.159 ONS155xx_Discovery_Info_View
2.160 ONS155xx_Ether_Hist_PM_View
2.162 ONS155xx_Flash_Part_View
2.164 ONS155xx_Module_Type_View
2.165 ONS155xx_Opt_Power_PM_View
2.166 ONS155xx_Path_Ckt_Final_View
2.167 ONS155xx_Path_Dest_Pwr_View
2.168 ONS155xx_Path_Link_Final_View
2.170 ONS155xx_Path_Pwr_Monitor_View
2.171 ONS155xx_Path_Pwr_No_Ava_View
2.172 ONS155xx_Path_Pwr_No_Mon_View
2.173 ONS155xx_Path_Stack_Final_View
2.175 ONS155xx_SONET_Section_PM_View
2.179 ONS15600_SONET_Line_FE_PM_View
2.180 ONS15600_SONET_Line_PM_View
2.181 ONS15600_SONET_Path_FE_PM_View
2.182 ONS15600_SONET_Path_PM_View
2.183 ONS15600_SONET_Sec_PM_View
2.184 ONS15600SDH_HO_PM_FE_View
2.186 ONS15600SDH_MS_PM_FE_View
2.189 ONS158xx_ADA_24h_PM_View
2.191 ONS158xx_AIU_24h_PM_View
2.193 ONS158xx_All_Ampl_24h_PM_View
2.194 ONS158xx_All_Ampl_ELH_PM_View
2.195 ONS158xx_All_Ampl_PM_View
2.196 ONS158xx_All_Mux_24h_PM_View
2.197 ONS158xx_All_Mux_PM_View
2.198 ONS158xx_All_Tran_24h_PM_View
2.199 ONS158xx_All_Tran_PM_View
2.200 ONS158xx_All_WD_24h_PM_View
2.202 ONS158xx_Ampl_ELH_24h_PM_View
2.203 ONS158xx_Amplifier_24h_PM_View
2.204 ONS158xx_Amplifier_PM_View
2.206 ONS158xx_B1_FEC_24h_PM_View
2.209 ONS158xx_BBA_24h_PM_View
2.211 ONS158xx_BCS_24h_PM_View
2.215 ONS158xx_CMP_24h_PM_View
2.217 ONS158xx_Demux_24h_PM_View
2.219 ONS158xx_Eth_24h_PM_View
2.221 ONS158xx_FEC_24h_PM_View
2.224 ONS158xx_IOC_Card_24h_PM_View
2.225 ONS158xx_IOC_Card_PM_View
2.226 ONS158xx_IRBA_24h_PM_View
2.228 ONS158xx_LAC_Active_Users_View
2.229 ONS158xx_LAC_Log_Status_View
2.231 ONS158xx_LAC_Profile_View
2.233 ONS158xx_LEM_24h_PM_View
2.234 ONS158xx_LEM_B1_24h_PM_View
2.236 ONS158xx_LEM_FEC_24h_PM_View
2.237 ONS158xx_LEM_FEC_PM_View
2.239 ONS158xx_LSM_24h_PM_View
2.243 ONS158xx_Mux_24h_PM_View
2.245 ONS158xx_OA_ELH_24h_PM_View
2.247 ONS158xx_OAD_24h_PM_View
2.249 ONS158xx_OADM_24h_PM_View
2.251 ONS158xx_OBA_C_24h_PM_View
2.253 ONS158xx_OCP_24h_PM_View
2.255 ONS158xx_OECP_24h_PM_View
2.257 ONS158xx_OEP_C_24h_PM_View
2.259 ONS158xx_OP_ELH_24h_PM_View
2.261 ONS158xx_OPA_C_24h_PM_View
2.263 ONS158xx_ORP_ELH_24h_PM_View
2.264 ONS158xx_ORP_ELH_PM_View
2.265 ONS158xx_OSCM_24h_PM_View
2.267 ONS158xx_OSU_24h_PM_View
2.270 ONS158xx_PRE_L_IR_24h_PM_View
2.271 ONS158xx_PRE_L_IR_PM_View
2.272 ONS158xx_PREL_24h_PM_View
2.274 ONS158xx_RBA_24h_PM_View
2.278 ONS158xx_RXT_24h_PM_View
2.279 ONS158xx_RXT_B1_24h_PM_View
2.281 ONS158xx_RXT_FEC_24h_PM_View
2.282 ONS158xx_RXT_FEC_PM_View
2.284 ONS158xx_SCF_24h_PM_View
2.286 ONS158xx_SCU_24h_PM_View
2.288 ONS158xx_Simple_24h_PM_View
2.290 ONS158xx_TPA_24h_PM_View
2.292 ONS158xx_Trans_B1_24h_PM_View
2.293 ONS158xx_Trans_B1_PM_View
2.294 ONS158xx_Trans_FEC_24h_PM_View
2.295 ONS158xx_Transp_24h_PM_View
2.296 ONS158xx_Transp_FEC_PM_View
2.297 ONS158xx_Transponder_PM_View
2.300 ONS158xx_WCM_24h_PM_View
2.301 ONS158xx_WCM_B1_24h_PM_View
2.303 ONS158xx_WCM_FEC_24h_PM_View
2.304 ONS158xx_WCM_FEC_PM_View
2.308 ONS158xx_WD_Rx_24h_PM_View
2.310 OSS_Alarm_Fltr_AidDeny_View
2.311 OSS_Alarm_Fltr_TidDeny_View
2.317 QoSTemplate_General_View
2.326 SONET_Line_FarEnd_PM_View
2.327 SONET_Line_NearEnd_PM_View
2.330 SONET_Section_NearEnd_PM_View
2.331 SONET_STSPath_FarEnd_PM_View
2.332 SONET_STSPath_NearEnd_PM_View
2.340 Unmanaged_NE_Inventory_View
2.344 VLAN_Drop_Ports_QoS_View
Database Schema Views
This chapter describes the database views that CTM creates and uses. The following CTM views are listed in alphabetical order.
2.1 Active_Alarm_View_With_Ack
CREATE OR REPLACE VIEW active_alarm_view_with_ack ASSELECTaa.ActiveAlarmSeverity AS severityIcon,ack.AckIndex AS AckIcon,aa.ActiveAlarmComment AS noteIcon,aa.ActiveAlarmServEff,aa.ActiveAlarmIndex AS ID,ni.NESysID AS NetworkElement,aa.PhysicalLoc,getModuleName(aa.NEDBAccessID, aa.ModuleType, en.EventType) AS ModuleType,getInterfaceId(aa.nedbaccessid,aa.ModuleOrIfIndex,aa.ObjectType,en.EnumString) AS InterfaceID,en.EnumString AS Type,aa.ActiveAlarmSeverity AS Severity,aa.ActiveAlarmTimeStamp AS RaisedTimeStamp,aa.ClearAlarmTimeStamp AS ClearTimeStamp,aa.ActiveAlarmAdditionalInfo AS Description,ack.AckUserName AS AckUser,decode(to_char(ack.AckTimeStamp,'DD-MON-YYYY'),'01-JAN-0001',aa.ClearAlarmTimeStamp , '','', ack.acktimestamp) AS AckTimeStamp,aa.ActiveAlarmComment AS NoteDescription, aa.NEDBAccessID,aa.nealarmtimestamp, ack.IsAutoAck, aa.AlarmStatus,aa.NeAlarmClearTimestamp, aa.AlarmSeqNum,GetPortName(aa.nedbaccessid, aa.physicalloc, aa.ModuleorIfindex, aa.moduletype) as PortName,aa.ModuleOrIfIndex as IntegerInterfaceid,aa.ExternalCondition,aa.ActiveAlarmType,en.eventtype,aa.rowid AS myrow,aa.ModelType,aa.ObjectType,aa.StrObjInstanceFROMne_info_table ni,active_alarm_table aa,alarm_event_type_enum_table en,ack_table ackWHEREaa.NEDBAccessID = ni.NEDBAccessID ANDaa.ActiveAlarmType = en.EnumIndex ANDaa.AckIndex = ack.AckIndex AND((aa.alarmstatus=1 and aa.ackindex=0) oraa.alarmstatus=0 )union allSELECTaa.ActiveAlarmSeverity AS severityIcon,ack.AckIndex AS AckIcon,aa.ActiveAlarmComment AS noteIcon,aa.ActiveAlarmServEff,aa.ActiveAlarmIndex AS ID,/'CTM' AS NetworkElement,aa.PhysicalLoc,getModuleName(aa.NEDBAccessID, aa.ModuleType, en.EventType) AS ModuleType,getInterfaceId(aa.nedbaccessid,aa.ModuleOrIfIndex,aa.ObjectType,en.EnumString) AS InterfaceID,en.EnumString AS Type,aa.ActiveAlarmSeverity AS Severity,aa.ActiveAlarmTimeStamp AS RaisedTimeStamp,aa.ClearAlarmTimeStamp AS ClearTimeStamp,aa.ActiveAlarmAdditionalInfo AS Description,ack.AckUserName AS AckUser,decode(to_char(ack.AckTimeStamp,'DD-MON-YYYY'),'01-JAN-0001',aa.ClearAlarmTimeStamp , '','',ack.acktimestamp) AS AckTimeStamp,aa.ActiveAlarmComment AS NoteDescription,aa.NEDBAccessID, to_date('') AS NEAlarmTimestamp,ack.IsAutoAck, aa.AlarmStatus,aa.NEAlarmClearTimestamp,aa.AlarmSeqNum,'' as PortName,aa.ModuleOrIfIndex as IntegerInterfaceId,aa.ExternalCondition,aa.ActiveAlarmType,en.eventtype,aa.rowid AS myrow,aa.ModelType,aa.ObjectType,aa.StrObjInstanceFROMactive_alarm_table aa,alarm_event_type_enum_table en,ack_table ackWhere aa.ActiveAlarmType = en.EnumIndex ANDaa.AckIndex = ack.AckIndex AND((aa.alarmstatus=1 and aa.ackindex=0) oraa.alarmstatus=0 ) andaa.nedbaccessid=0;2.2 Admin_Job_View
CREATE OR REPLACE VIEW Admin_Job_View asSELECTajt.jobid,ajt.taskid,ajt.jobtype,ajt.jobowner,ni.nesysid,ajt.jobstatus,ajt.creationtime,ajt.scheduledtime,ajt.starttime,ajt.endtime,ajt.usercomments,ajt.additionalinfo,ajt.nedbaccessid,ni.nemodeltype,ajt.rowid as myrow,ajt.operation_info,ajt.display_infoFROMAdmin_Job_Table ajt,ne_info_Table niWHEREajt.nedbaccessid = ni.nedbaccessid;2.3 Alarm_Count_View
CREATE OR REPLACE VIEW alarm_count_view asSELECTmn.nedbaccessid,mn.minoralarmcount,mj.majoralarmcount,cr.criticalalarmcount,wr.warningalarmcount,cl.clearedalarmcount,ack.ackalarmcountFROM(SELECT nedbaccessid, totalalarmcount as majoralarmcountfrom alarm_count_tablewhere alarmcounttype=6) mj,(SELECT nedbaccessid, totalalarmcount as minoralarmcountfrom alarm_count_tablewhere alarmcounttype=5) mn,(SELECT nedbaccessid, totalalarmcount as criticalalarmcountfrom alarm_count_tablewhere alarmcounttype=7) cr,(SELECT nedbaccessid, totalalarmcount as warningalarmcountfrom alarm_count_tablewhere alarmcounttype=4) wr,(SELECT nedbaccessid, totalalarmcount as clearedalarmcountfrom alarm_count_tablewhere alarmcounttype=-1) cl,(SELECT nedbaccessid, totalalarmcount as ackalarmcountfrom alarm_count_tablewhere alarmcounttype=-2) ackWHEREmj.nedbaccessid=mn.nedbaccessidand mj.nedbaccessid=cr.nedbaccessidand mj.nedbaccessid=wr.nedbaccessidand mj.nedbaccessid=cl.nedbaccessidand mj.nedbaccessid=ack.nedbaccessid;2.4 Alarm_Log_View
CREATE OR REPLACE VIEW alarm_log_view ASSELECTae.AlarmEventSeverity AS severityIcon,0 as AckIcon, '' as NoteIcon,ae.ServiceEffecting,ae.EventIndex as ID,nvl(ni.NESysID,'CTM') AS NetworkElement,ae.PhysicalLoc as Physicalloc,GetModuleName(ae.nedbaccessid, ae.moduletype, en.EventType) AS ModuleType,GetInterfaceId(ae.nedbaccessid, ae.ModuleOrIfIndex, ae.ObjectType, en.EnumString) AS InterfaceID,en.EnumString AS Type,ec.EnumString AS Cause,ae.AlarmEventSeverity AS severity,ae.AlarmEventTimeStamp AS RaisedTimeStamp,to_date('') as ClearTimestamp,ae.OtherInfo AS Description,'' as Ackuser,to_date('') as AckTimestamp,'' as NoteDescription,ae.Nedbaccessid as Nedbaccessid,decode(ae.nedbaccessid,0,to_date(''),ae.NEEventtimestamp) as NeAlarmTimestamp,-1 as Alarmstatus,2 as IsAutoAck,to_char('Event') as EventOrAlarm,to_date('') as NEAlarmClearTimestamp,'' as CTMDuration,GetPortName(ae.nedbaccessid, ae.physicalloc, ae.ModuleOrIfindex, ae.Moduletype) as PortName,ae.ModuleOrIfIndex as IntegerInterfaceId,en.eventtype,ae.rowid AS myrow,ae.ModelType,ae.ObjectType,ae.StrObjInstanceFROMne_info_table ni,alarm_event_table ae,alarm_event_type_enum_table en,alarm_event_cause_table ecWHEREae.NEDBAccessID = ni.NEDBAccessID(+) ANDae.AlarmEventType = en.EnumIndex ANDae.AlarmEventCause = ec.EnumIndexUNIONSELECTaa.ActiveAlarmSeverity as SeverityIcon,aa.AckIndex as AckIcon,aa.ActiveAlarmComment as NoteIcon,aa.ActiveAlarmServeff as ServiceEffecting,aa.ActiveAlarmIndex as ID,nvl(ni.NESysID,'CTM') as NetworkElement,aa.Physicalloc as Physicalloc,GetModulename(aa.nedbaccessid, aa.moduletype, en.EventType) as ModuleType,GetInterfaceId(aa.nedbaccessid, aa.ModuleOrIfIndex, aa.ObjectType, en.EnumString) as InterfaceId,en.EnumString as Type, '' as Cause,aa.ActiveAlarmSeverity as Severity,aa.ActiveAlarmTimeStamp as RaisedTimestamp,aa.ClearAlarmTimeStamp as ClearTimestamp,aa.ActiveAlarmAdditionalInfo as Description,ack.AckUserName as AckUser,decode(to_char(ack.AckTimeStamp,'DD-MON-YYYY'),'01-JAN-0001',aa.ClearAlarmTimeStamp,'','',ack.acktimestamp) AS AckTimeStamp,aa.ActiveAlarmComment as NoteDescription,aa.NEDBAccessID as Nedbaccessid,decode(aa.nedbaccessid,0,to_date(''),aa.NeAlarmTimestamp) as NeAlarmtimestamp,aa.AlarmStatus as AlarmStatus,ack.IsAutoAck as IsAutoAck,to_char('Alarm') as EventOrAlarm,aa.NEAlarmClearTimestamp as NEAlarmClearTimestamp,ctmduration(aa.ClearAlarmTimeStamp-aa.ActiveAlarmTimeStamp) as CTMDuration,GetPortName(aa.nedbaccessid, aa.physicalloc, aa.ModuleOrIfindex, aa.moduletype) as PortName,aa.ModuleOrIfIndex as IntegerInterfaceId,en.eventtype,aa.rowid as Myrow,aa.ModelType,aa.ObjectType,aa.StrObjInstanceFROMne_info_table ni,active_alarm_table aa,alarm_event_type_enum_table en,ack_table ackWHEREaa.NEDBAccessID = ni.NEDBAccessID(+) ANDaa.ActiveAlarmType = en.EnumIndex ANDaa.AckIndex = ack.AckIndex ANDaa.alarmstatus = 1 ANDaa.ackindex <> 0;2.5 Audit_Log_View
CREATE OR REPLACE VIEW audit_log_view ASSELECT nvl(n.NESYSID,'CTM') as NESYSID, nvl(t.username, 'Internal') as usernamet.timespatmp,t.module,t.classname,0 as linenumber,(t.actionname || t.logmessage) as LogMessage,nvl(t.nedbaccessid,0) as nedbaccessid,t.service,t.rowid as MyrowFROMtransaction_log_table t,ne_info_table nWHEREt.nedbaccessid=n.nedbaccessid(+);2.6 BLSR_Table_View
CREATE OR REPLACE BLSR_Table_View AS SELECTblsr.BLSRID as BLSRID,blsr.RINGID as RINGID,blsr.RINGTYPE as RINGTYPE,blsr.LINERATE as LINERATE,blsr.STATUS as STATUS,blsr.RINGREVERSION as RINGREVERSION,blsr.SPANREVERSION as SPANREVERSION,blsr.NODES as NODES,node.NODEID as NODEID,blsr.rowid as myrowFROM BLSR_TABLE blsr,BLSR_NODE nodeWHEREblsr.BLSRID = node.BLSRID;2.7 CAT65XX_Inventory_View
CREATE OR REPLACE VIEW CAT65XX_inventory_view ASSELECTne.NESysId as NEID, /* *@INDEX A 0 */eit.PhysicalLoc as PhysicalLoc, /* *@INDEX A 1 */eit.Col16 as ModuleName,eit.Col4 as Description,eit.Col3 as PhysicalName,eit.Col5 as HardwareRev,eit.Col6 as FirmwareRev,eit.Col7 as SoftwareRev,eit.Col8 as SerialNumber,eit.Col9 as MfgName,eit.Col10 as ModelName,eit.Col11 as Alias,eit.Col12 as AssetID,eit.Col13 as PartNumber,eit.Col14 as CleiCode,eit.Col1 as FRU,ne.NEDBAccessId as NEDBACCESSID,eit.rowid as myrow,eit.COL15 as Type,eit.IFINDEX as IfIndexFROMne_info_table ne,eqpt_info_table eitWHEREne.NEDBAccessId = eit.NEDBAccessId ANDeit.modeltype = 28;2.8 Children_View
CREATE OR REPLACE VIEW children_view ASSELECTeit.NEDBAccessId,eit.PhysicalLoc,eit.IfIndex,eit.ModuleType,mm.ParentIndex,eit.rowid as myrow,eit.ModelType,eit.ObjectIndex,eit.StrObjInstanceFROMeqpt_info_table eit,objecttypetable mmWHEREeit.ObjectIndex = mm.ObjectIndex AND eit.ModelType = mm.ModelType;2.9 Circuit_Node_GUI_Old_View
CREATE OR REPLACE VIEW circuit_node_gui_old_view asSELECTc.CktName as Name,c.CktType as Type,c.CktSize as CktSize,c.CktDirection as Direction,c.CktState as State,(select nesysid from ne_info_table where nenodeid=c.cktsrcnodeid and c.cktsrcnodeid !=0 ) as SrcNodeid,c.cktsrcnodeid,nvl(getModulename1(c.cktsrcnodeid, c.CktSrcModuleType),'SYSTEM') as SrcModuleType,c.CktSrcPhysicalLoc as SrcPhysicalLoc,c.CktSrcModelType as SrcModelType,c.CktSrcIfIndex as SrcInterfaceId,c.CktSrcObjectType as SrcObjectType,nvl(getModulename1(c.cktsecsrcnodeid, c.CktSecSrcModuleType),'SYSTEM') as SecSrcModuleType,c.CktSecSrcPhysicalLoc as SecSrcPhysicalLoc,c.CktSecSrcModelType as CktSecSrcModelType,c.CktSecSrcIfIndex as SecSrcInterfaceId,c.CktSecSrcObjectType as SecSrcObjectType,c.cktDestNodename as destnodename,c.cktdestModuleName,c.CktDestPhysicalLoc as DestPhysicalLoc,c.CktDestModelType as DestModelType,c.CktDestIfIndex as DestInterfaceId,c.CktDestObjectType as DestObjectType,c.CktIsMonitor as Ismonitor,c.CktSrcDropProt as SrcDropProt,c.CktNodeId as NodeId,c.CktUniqueId as UniqueId,c.CktDescription as Description,c.CustomerId as CustomerId,c.ServiceId as ServiceId,dest.cktdestnodeid as DestNodeId,spantbl.CktSpanSrcNodeId,spantbl.CktSpanDestNodeId,spantbl.cktlinkid,c.CktEnhancedState,c.CktProtectionType,dest.CktDestPathProt as DestPathProtection,c.cktComment as CircuitNote,(select nesysid from ne_info_table where nenodeid=c.cktsecsrcnodeid and c.cktsecsrcnodeid !=0 ) as SecSrcNodeid,c.cktsecsrcnodeid,c.cktSrcPortName as CktSrcPortName,c.cktSecSrcPortName as CktSecSrcPortName,c.cktDestPortName as CktDestPortName,(select count(*) from circuit_vlan_tbl where cktnodeid=c.cktnodeid and cktuniqueid=c.cktuniqueid) as NoOfVlans,vcg.VCGDirection as VCGDirection,vcg.ParentCktNodeId as ParentCktNodeId,vcg.ParentCktUniqueId as ParentCktUniqueId,c.CktOchncChannel,c.CktOchncDir,c.rowid as myrowFROMcircuit_tbl c,circuit_vcg_tbl vcg,circuit_dest_tbl dest,circuit_span_tbl spantblWHEREc.CktNodeId = dest.CktNodeId(+) andc.CktUniqueId = dest.CktUniqueId(+) andc.CktNodeId = spantbl.CktNodeId(+) andc.CktUniqueId = spantbl.CktUniqueId(+) andc.CktNodeId = vcg.CktNodeId(+) andc.CktUniqueId = vcg.CktUniqueId(+) andc.cktState != 12 ;2.10 Circuit_Node_GUI_View
CREATE OR REPLACE VIEW circuit_node_gui_view ASSELECTc.CktName as Name,c.CktType as Type,c.CktSize as CktSize,c.CktDirection as Direction,c.CktState as State,(select nesysid from ne_info_table where nenodeid=c.cktsrcnodeid and c.cktsrcnodeid !=0 ) as SrcNodeid,c.cktsrcnodeid,nvl(getSlotModuleName(c.cktsrcnodeid, c.CktSrcModuleType),'SYSTEM') as SrcModuleType,c.CktSrcPhysicalLoc as SrcPhysicalLoc,c.CktSrcIfIndex as SrcInterfaceId,nvl(getSlotModuleName(c.cktsecsrcnodeid, c.CktSecSrcModuleType),'SYSTEM') as SecSrcModuleType,c.CktSecSrcPhysicalLoc as SecSrcPhysicalLoc,c.CktSecSrcIfIndex as SecSrcInterfaceId,collapseddestnodename(c.CKTNODEID,c.CKTUNIQUEID) as destnodename,collapsedmodulename(c.CKTNODEID,c.CKTUNIQUEID)as cktdestModuleName,collapsedphy(c.CKTNODEID,c.CKTUNIQUEID) as DestPhysicalLoc,collapsedifindex(c.CKTNODEID,c.CKTUNIQUEID) as DestInterfaceId,c.CktIsMonitor as Ismonitor,c.CktSrcDropProt as SrcDropProt,c.CktNodeId as NodeId,c.CktUniqueId as UniqueId,c.CktDescription as Description,c.CustomerId as CustomerId,c.ServiceId as ServiceId,dest.cktdestnodeid as DestNodeId,spantbl.CktSpanSrcNodeId,spantbl.CktSpanDestNodeId,spantbl.cktlinkid,c.CktEnhancedState,c.CktProtectionType,dest.CktDestPathProt as DestPathProtection,c.cktComment as CircuitNote,(select nesysid from ne_info_table where nenodeid=c.cktsecsrcnodeid and c.cktsecsrcnodeid !=0 ) as SecSrcNodeid,c.cktsecsrcnodeid,eqptinfoport(getNEDBACCESSID(c.CKTSRCNODEID),c.CKTSRCPHYSICALLOC,0,c.CKTSRCMODULET YPE ) as CktSrcPortName,eqptinfoport(getNEDBACCESSID(c.CKTSECSRCNODEID),c.CKTSECSRCPHYSICALLOC,0,c.CKTSECS RCMODULETYPE ) as CktSecSrcPortName,collapsedeqptportname(c.CKTNODEID,c.CKTUNIQUEID) as CktDestPortName,(select count(*) from circuit_vlan_tbl where cktnodeid=c.cktnodeid and cktuniqueid=c.cktuniqueid) as NoOfVlans,nvl(vcg.VCGDirection,-1) as VCGDirection,nvl(vcg.ParentCktNodeId,-1) as ParentCktNodeId,nvl(vcg.ParentCktUniqueId,-1) as ParentCktUniqueId,c.CktOchncChannel,c.CktOchncDir,c.CktSrcModelType as SrcModelType,c.CktSrcObjectType as SrcObjectType,c.CktSecSrcModelType as CktSecSrcModelType,c.CktSecSrcObjectType as SecSrcObjectType,collapsedmodeltype(c.CKTNODEID,c.CKTUNIQUEID) as DestModelType,collapsedobjectindex(c.CKTNODEID,c.CKTUNIQUEID) as DestObjectType,c.isDuplicateName,nvl(getPortModuleName(c.cktsrcnodeid, c.CktSrcModuleType),'SYSTEM') as SrcPortModuleType,nvl(getPortModuleName(c.cktsecsrcnodeid, c.CktSecSrcModuleType),'SYSTEM') as SecSrcPortModuleType,collapsedportmodulename(c.CKTNODEID,c.CKTUNIQUEID)as cktdestPortModuleName,c.rowid as myrow,dest.cktdestphysicalloc as CktDestPhysicalLoc,nvl(getPortModuleName(dest.cktdestnodeid, dest.CktDestModuleType),'SYSTEM') as DestPortModuleType,spantbl.CktSpanSrcPhysicalLoc,spantbl.CktSpanDestPhysicalLocFROMcircuit_tbl c,circuit_vcg_tbl vcg,circuit_dest_tbl dest,circuit_span_tbl spantblWHEREc.CktNodeId = dest.CktNodeId(+) andc.CktUniqueId = dest.CktUniqueId(+) andc.CktNodeId = spantbl.CktNodeId(+) andc.CktUniqueId = spantbl.CktUniqueId(+) andc.CktNodeId = vcg.CktNodeId(+) andc.cktState != 12 ;2.11 Circuit_Node_View
CREATE OR REPLACE VIEW circuit_node_view ASSELECTc.CktName as Name,c.CktType as Type,c.CktSize as CktSize,c.CktDirection as Direction,c.CktState as State,(select nesysid from ne_info_table where nenodeid=c.cktsrcnodeid and c.cktsrcnodeid !=0) as SrcNodeid,nvl(getModulename1(c.cktsrcnodeid, c.CktSrcModuleType),'SYSTEM') as SrcModuleType,c.CktSrcPhysicalLoc as SrcPhysicalLoc,c.CktSrcModelType as SrcModelType,c.CktSrcIfIndex as SrcInterfaceId,c.CktSrcObjectType as SrcObjectType,nvl(getModulename1(c.cktsecsrcnodeid, c.CktSecSrcModuleType),'SYSTEM') as SecSrcModuleType,c.CktSecSrcPhysicalLoc as SecSrcPhysicalLoc,c.CktSecSrcModelType as SecSrcModelType,c.CktSecSrcIfIndex as SecSrcInterfaceId,c.CktSecSrcObjectType as SecSrcObjectType,(select nesysid from ne_info_table where nenodeid=dest.cktdestnodeid and dest.cktdestnodeid != 0) as destnodeid,nvl(getModulename1(dest.cktdestnodeid, dest.CktDestModuleType),'SYSTEM') as DestModuleType,dest.CktDestPhysicalLoc as DestPhysicalLoc,dest.CktDestIfIndex as DestInterfaceId,dest.CktDestObjectType as DestObjectType,c.CktIsMonitor as Ismonitor,c.CktSrcDropProt as SrcDropProt,dest.CktDestDropProt as DestDropProt,dest.CktDestPathProt as DestPathProt,0 as Vlanid,c.CktName as vlanname,c.CktNodeId as NodeId,c.CktUniqueId as UniqueId,c.CktDescription as Description,c.CustomerId as CustomerId,c.ServiceId as ServiceId,spantbl.CktSpanSrcNodeId,spantbl.CktSpanDestNodeId,spantbl.cktlinkid,c.CktEnhancedState,c.CktProtectionType,c.rowid as myrowFROMcircuit_tbl c,circuit_dest_tbl dest,circuit_span_tbl spantblWHEREc.CktNodeId = dest.CktNodeId(+) andc.CktUniqueId = dest.CktUniqueId(+) andc.CktNodeId = spantbl.CktNodeId(+) andc.CktUniqueId = spantbl.CktUniqueId(+) andc.cktState != 12 ;2.12 Circuit_Span_Old_View
CREATE OR REPLACE VIEW Circuit_Span_Old_View asSELECTcircuit.CktName as Name,circuit.CktType as Type,circuit.CktSize as CktSize,neInfo1.NESysID as SrcNodeId,nvl(getModulename1(spancircuit.cktspansrcnodeid, spancircuit.CktspanSrcModuleType),'SYSTEM') as SrcModuleType,spancircuit.CktSpanSrcPhysicalLoc as SrcPhysicalLoc,spancircuit.CktSpanSrcIfIndex as SrcInterfaceId,neInfo2.NESysID as DestNodeId,nvl(getModulename1(spancircuit.cktspandestnodeid, spancircuit.CktspandestModuleType),'SYSTEM') as DestModuleType,spancircuit.CktSpanDestPhysicalLoc as DestPhysicalLoc,spancircuit.CktSpanDestIfIndex as InterfaceId,spancircuit.CktSpanSrcState as SrcState,spancircuit.CktSpanDestState as DestState,spancircuit.IsCktForwarding as Forwarding,spancircuit.IsCktSpanInUPSR as InUpsr,spancircuit.IsCktSpanActive as active,spancircuit.CktSpanProtOp as ProtOp,spancircuit.CktNodeId as NodeId,spancircuit.CktUniqueId as UniqueId,neinfo1.NEDBAccessid,neinfo2.NEDBAccessid as DestNEDBAccessid,spancircuit.CktLinkId as linkid,spancircuit.CktSpanSrcNodeId as SrcNENodeId,spancircuit.CktSpanDestNodeId as DestNENodeID,spancircuit.CktspanSrcModuleType as SrcNEModuleType,spancircuit.CktspandestModuleType as DestNEModuleType,spancircuit.CktSpanSrcPortName as SrcPortName,spancircuit.CktSpanDestPortName as DestPortName,spancircuit.CktSpanSrcModelType as SrcModelType,spancircuit.CktSpanSrcObjectType as SrcObjectType,spancircuit.CktSpanDestModelType as DestModelType,spancircuit.CktSpanDestObjectType as DestObjectType,spancircuit.rowid as myrowFROM
CIRCUIT_TBL circuit,NE_INFO_TABLE neInfo1,NE_INFO_TABLE neInfo2,circuit_span_tbl spancircuitWHERE
spancircuit.CktNodeId = circuit.CktNodeId andspancircuit.CktUniqueId = circuit.CktUniqueId andspancircuit.CktSpanSrcNodeID = neInfo1.NENodeID andspancircuit.CktSpanDestNodeId = neInfo2.NENodeID;2.13 Circuit_Span_View
CREATE OR REPLACE VIEW Circuit_Span_View asSELECTcircuit.CktName as Name,circuit.CktType as Type,circuit.CktSize as CktSize,neInfo1.NESysID as SrcNodeId,nvl(getSlotModuleName(spancircuit.cktspansrcnodeid, spancircuit.CktspanSrcModuleType),'SYSTEM') as SrcModuleType,spancircuit.CktSpanSrcPhysicalLoc as SrcPhysicalLoc,spancircuit.CktSpanSrcIfIndex as SrcInterfaceId,neInfo2.NESysID as DestNodeId,nvl(getSlotModuleName(spancircuit.cktspandestnodeid, spancircuit.CktspandestModuleType),'SYSTEM') as DestModuleType,spancircuit.CktSpanDestPhysicalLoc as DestPhysicalLoc,spancircuit.CktSpanDestIfIndex as InterfaceId,spancircuit.CktSpanSrcState as SrcState,spancircuit.CktSpanDestState as DestState,spancircuit.IsCktForwarding as Forwarding,spancircuit.IsCktSpanInUPSR as InUpsr,spancircuit.IsCktSpanActive as active,spancircuit.CktSpanProtOp as ProtOp,spancircuit.CktNodeId as NodeId,spancircuit.CktUniqueId as UniqueId,neinfo1.NEDBAccessid,neinfo2.NEDBAccessid as DestNEDBAccessid,spancircuit.CktLinkId as linkid,spancircuit.CktSpanSrcNodeId as SrcNENodeId,spancircuit.CktSpanDestNodeId as DestNENodeID,spancircuit.CktspanSrcModuleType as SrcNEModuleType,spancircuit.CktspandestModuleType as DestNEModuleType,eqptinfoport(getNEDBACCESSID(spancircuit.CKTSPANSRCNODEID),spancircuit.CKTSPANSRCP HYSICALLOC,0,spancircuit.CKTSPANSRCMODULETYPE) as SrcPortName,eqptinfoport(getNEDBACCESSID(spancircuit.CKTSPANDESTNODEID),spancircuit.CKTSPANDES TPHYSICALLOC,0,spancircuit.CKTSPANDESTMODULETYPE) as DestPortName,spancircuit.CktSpanSrcModelType as SrcModelType,spancircuit.CktSpanSrcObjectType as SrcObjectType,spancircuit.CktSpanDestModelType as DestModelType,spancircuit.CktSpanDestObjectType as DestObjectType,nvl(getPortModuleName(spancircuit.cktspansrcnodeid, spancircuit.CktspanSrcModuleType),'SYSTEM') as SrcPortModuleType,nvl(getPortModuleName(spancircuit.cktspandestnodeid, spancircuit.CktspandestModuleType),'SYSTEM') as DestPortModuleType,spancircuit.rowid as myrowFROMCIRCUIT_TBL circuit,NE_INFO_TABLE neInfo1,NE_INFO_TABLE neInfo2,circuit_span_tbl spancircuitWHEREspancircuit.CktNodeId = circuit.CktNodeId andspancircuit.CktUniqueId = circuit.CktUniqueId andspancircuit.CktSpanSrcNodeID = neInfo1.NENodeID andspancircuit.CktSpanDestNodeId = neInfo2.NENodeID;2.14 Circuit_View
CREATE OR REPLACE VIEW Circuit_View ASSELECTc.CktName as Name,c.CktType as Type,c.CktSize as CktSize,c.CktDirection as Direction,c.CktState as State,(select nesysid from ne_info_table where nenodeid=c.cktsrcnodeid and c.cktsrcnodeid !=0) as SrcNodeid,nvl(getModulename1(c.cktsrcnodeid, c.CktSrcModuleType),'SYSTEM') as SrcModuleType,c.CktSrcPhysicalLoc as SrcPhysicalLoc,c.CktSrcIfIndex as SrcInterfaceId,nvl(getModulename1(c.cktsecsrcnodeid, c.CktSecSrcModuleType),'SYSTEM') as SecSrcModuleType,c.CktSecSrcPhysicalLoc as SecSrcPhysicalLoc,c.CktSecSrcIfIndex as SecSrcInterfaceId,(select nesysid from ne_info_table where nenodeid=dest.cktdestnodeid and dest.cktdestnodeid !=0 ) as destnodeid,nvl(getModulename1(dest.cktdestnodeid, dest.CktDestModuleType),'SYSTEM') as DestModuleType,dest.CktDestPhysicalLoc as DestPhysicalLoc,dest.CktDestIfIndex as DestInterfaceId,c.CktIsMonitor as Ismonitor,c.CktSrcDropProt as SrcDropProt,dest.CktDestDropProt as DestDropProt,dest.CktDestPathProt as DestPathProt,vlan.Cktvlanid as Vlanid,vlan.cktvlanname as Vlanname,c.CktNodeId as NodeId,c.CktUniqueId as UniqueId,c.CktDescription as Description,c.CustomerId as CustomerId,c.ServiceId as ServiceId,dest.CKTDESTNODEID as DESTNENODEID,c.CKTSRCNODEID as SRCNENODEID,c.CKTSECSRCNODEID as SECSRCNENODEID,c.CktEnhancedState,c.CktProtectionType,c.CktOchncChannel,c.CktOchncDir,c.CktSrcModelType as SrcModelType,c.CktSrcObjectType as SrcObjectType,c.CktSecSrcModelType as CktSecSrcModelType,c.CktSecSrcObjectType as SecSrcObjectType,dest.CktDestModelType as CktDestModelType,dest.CktDestObjectType as CktDestObjectType,c.rowid as myrowFROMcircuit_tbl c,circuit_dest_tbl dest,circuit_vlan_view vlanWHEREc.CktNodeId = dest.CktNodeId(+) andc.CktUniqueId = dest.CktUniqueId(+) andc.CktNodeId = vlan.CktNodeid andc.CktUniquei = vlan.CktUniqueid;2.15 Circuit_VLAN_View
CREATE OR REPLACE VIEW circuit_vlan_view asSELECTb.CktVlanId,b.CktVlanName,b.CktNodeId,b.CktUniqueIda.rowid as myrowFROMcircuit_vlan_tbl b ,circuit_tbl aWHEREa.CktNodeId = b.CktNodeId AND a.CktUniqueId = b.CktUniqueIdUNIONSELECT0,'',a.CktNodeId,a.CktUniqueId,a.rowid as myrowFROMcircuit_tbl aWHERE a.rowid NOT IN(SELECT a.rowid FROM circuit_tbl a, circuit_vlan_tbl bWHERE a.CktNodeId = b.CktNodeId AND a.CktUniqueId = b.CktUniqueId) ;2.16 Ckt_Span_Dest_MT_View
CREATE OR REPLACE VIEW ckt_span_dest_mt_view ASSELECT DISTINCTcst.cktspandestnodeid as cktspandestnodeid,nvl(spandest.modulename,'System') as Modulename,cst.cktspandestphysicalloc,spandest.moduletype as ModuleTypeFROM(SELECT distinctmtt.modulename as modulename,mtt.moduletype as moduletype,cstbl.cktspandestphysicalloc as cktspandestphysicalloc,cstbl.cktspandestnodeid as cktspandestnodeidfrom module_type_table mtt,ons15454_ne_inventory_table cni,circuit_span_tbl cstbl,ne_info_table newhere mtt.moduletype= cni.equipmenttypeand cni.physicalloc=round(cstbl.cktspandestphysicalloc/power(2,16))*(power(2,16))and ne.nenodeid = cstbl.cktspandestnodeidand cni.nedbaccessid=ne.nedbaccessidand ne.nemodeltype=mtt.modeltypeand (mtt.modeltype=3 or mtt.modeltype=5 or mtt.modeltype=14 or mtt.modeltype=18)) spandest,circuit_span_tbl cstWHEREcst.cktspandestnodeid = spandest.cktspandestnodeid(+)AND cst.cktspandestphysicalloc = spandest.cktspandestphysicalloc(+);2.17 Ckt_Span_Src_MT_View
CREATE OR REPLACE VIEW ckt_span_src_mt_view ASSELECT DISTINCTcst.cktspansrcnodeid as cktspansrcnodeid,nvl(spansrc.modulename,'System') as Modulename,cst.cktspansrcphysicalloc,spansrc.moduletype as ModuleTypeFROM(SELECT distinctmtt.modulename as modulename,mtt.moduletype as moduletype,cstbl.cktspansrcnodeid as cktspansrcnodeid,cstbl.cktspansrcphysicalloc as cktspansrcphysicallocfrom module_type_table mtt,ons15454_ne_inventory_table cni,circuit_span_tbl cstbl,ne_info_table newhere mtt.moduletype= cni.equipmenttypeand cni.physicalloc=round(cstbl.cktspansrcphysicalloc/power(2,16))*(power(2,16))and ne.nenodeid=cstbl.cktspansrcnodeidand cni.nedbaccessid=ne.nedbaccessidand ne.nemodeltype=mtt.modeltypeand (mtt.modeltype=3 or mtt.modeltype=5 or mtt.modeltype=14 or mtt.modeltype=18)) spansrc,circuit_span_tbl cstWHERE cst.cktspansrcnodeid=spansrc.cktspansrcnodeid(+)AND cst.cktspansrcphysicalloc=spansrc.cktspansrcphysicalloc(+) ;2.18 Client_User_View
CREATE OR REPLACE VIEW client_user_view as
SELECTusername as UsernameFROM user_tableUNIONSELECT distinctusername as UsernameFROM deleted_user_table;2.19 CTC_User_Profiles_View
CREATE OR REPLACE VIEW CTC_User_Profiles_VIEW ASSELECTa.userid as UserId,b.privilege as Privilege,a.userdesc as UserDescription,a.userpassword as PasswordFROMctc_userprofile_table a,ons15454_privilege_table bWHEREa.privilegeid = b.privilegeid;2.20 Data_Card_View
CREATE OR REPLACE VIEW DATA_CARD_VIEW ASSELECTB.NEID,B.SLOT,B.PORTNUM,B.SUBIF,B.BG,A.CIR,A.CIR_BURST,A.PIR,A.PIR_BURST,A.CCOSTRANSMITFROMINTF_SUB_INTF_VIEW B,QOS_VIEW AWHEREA.NEID(+) = B.NEID and A.SLOT(+) = B.SLOT and A.PORTNUM(+) = B.PORTNUM andA.BG(+) = B.BG;2.21 Domain_NE_Inventory_View
CREATE OR REPLACE VIEW domain_ne_inventory_view asSELECTne.NESysID,ne.NEModelType,ne.NEIPAddr,ne.isNEConnected,ne.NEState,ne.NEPMEnabled,ne.NERobustPmEnabled,ne.NEVersion,ne.GNEID,ne.NESubNetworkID,np.NPId,ne.NESnmpCommString,ne.NEConfigMode,ne.NECLLICode,ne.NEDescription,ne.NEDbaccessid,ne.NEDiscoveryState,mod.MODELTYPENAME,sub.SUBNETNAME,np.NPNAME,gne.GNESYSID,ne.rowid as myrowFROMne_info_table ne,network_partition_table np,subnetwork_table sub,model_type_table mod,gne_table gneWHEREne.NeSubNetworkid=sub.subnetidand sub.npid= np.npidand ne.NEMODELTYPE=mod.MODELTYPEand ne.GNEID=gne.GNEID(+);2.22 DSP_Circuit_View
CREATE OR REPLACE VIEW DSP_Circuit_View ASSELECTc.CKTSRCNODEID as SRCNENODEID,c.CktSrcPhysicalLoc as SrcPhysicalLoc,c.CKTSRCMODULETYPE as SRCMODULETYPE,dest.CKTDESTNODEID as DESTNENODEID,dest.CktDestPhysicalLoc as DestPhysicalLoc,dest.CKTDESTMODULETYPE as DESTMODULETYPEFROMcircuit_tbl c,circuit_dest_tbl destWHEREc.CKTNODEID = dest.CKTNODEID(+) andc.CKTUNIQUEID = dest.CKTUNIQUEID(+) and( c.CKTSRCMODULETYPE = 6684672 or c.CKTSRCMODULETYPE = 6750208 or c.CKTSRCMODULETYPE = 10747904 or dest.CKTDESTMODULETYPE = 6684672 or dest.CKTDESTMODULETYPE = 6750208 or dest.CKTDESTMODULETYPE = 10747904) andc.cktState != 12 ;2.23 DSP_Eqpt_View
CREATE OR REPLACE VIEW DSP_Eqpt_View ASSELECTe.NEDBACCESSID as NEDBACCESSID,n.NENODEID as NENODEID,e.PHYSICALLOC as PHYSICALLOC,e.EQUIPMENTTYPE as MODULETYPEFROMONS15454_NE_INVENTORY_TABLE e,NE_INFO_TABLE nWHEREe.NEDBACCESSID = n.NEDBACCESSID(+) and( e.EQUIPMENTTYPE = 102 or e.EQUIPMENTTYPE = 103 or e.EQUIPMENTTYPE = 164 ) and( n.NEMODELINDEX = 47 or n.NEMODELINDEX = 49 or n.NEMODELINDEX = 55 or n.NEMODELINDEX = 57 or n.NEMODELINDEX = 61 or n.NEMODELINDEX = 62 or n.NEMODELINDEX = 65 );2.24 GSRIOX_Inventory_View
CREATE OR REPLACE VIEW GSRIOX_inventory_view ASSELECTne.NESysId as NEID,eit.PhysicalLoc as PhysicalLoc,mtt.ModuleName as ModuleName,eit.Col4 as Description,eit.Col3 as PhysicalName,eit.Col5 as HardwareRev,eit.Col6 as FirmwareRev,eit.Col7 as SoftwareRev,eit.Col8 as SerialNumber,eit.Col9 as MfgName,eit.Col10 as ModelName,eit.Col11 as Alias,eit.Col12 as AssetID,eit.Col13 as PartNumber,eit.Col14 as CleiCode,eit.Col1 as FRU,ne.NEDBAccessId as NEDBACCESSID,eit.rowid as myrow,eit.COL16 as Type,eit.IFINDEX as IfIndex,eit.OBJECTINDEX as ObjectIndexFROMne_info_table ne,eqpt_info_table eit,module_type_table mtt,objecttypetable ottWHEREne.NEDBAccessId = eit.NEDBAccessId ANDne.NEModelType = mtt.ModelType ANDeit.ModuleType = mtt.ModuleType ANDott.objectIndex = eit.objectIndex AND(eit.objectIndex > 17999 AND eit.objectIndex < 18200) ANDne.NEModelType = 27;2.25 HFR_BGP_Peer_PM_View
CREATE OR REPLACE VIEW HFR_BGP_PEER_PM_VIEW ASSELECTni.NESysID,ni.NEDbaccessid,en.ModuleName,en.ModuleType,bgp.PhysicalLoc,bgp.NEIfIndex,bgp.BGPPeerTimeStamp,bgp.NEIfPMStatus,bgp.inMaintenance,bgp.IPADDRESS,bgp.INPUTUPDATEMSGS,bgp.OUTPUTUPDATEMSGS,bgp.INPUTMSGS,bgp.OUTPUTMSGS,bgp.CONNESTABLISHED,bgp.CONNDROPPED,bgp.ERRORSRECEIVED,bgp.ERRORSSENT,bgp.fifteenMinThresholdMask as FifteenMinThreshold,bgp.IS24H,bgp.ModelType,bgp.ObjectType,bgp.StrObjInstance,bgp.rowid as myrowFROMHFR_BGP_PEER_PM_Table bgp,ne_info_table ni,module_type_table enWHEREbgp.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDbgp.NEDBAccessID = ni.NEDBAccessID;2.26 HFR_Interface_DRC_PM_View
CREATE OR REPLACE VIEW HFR_INTERFACE_DRC_PM_VIEW ASSELECTni.NESysID,ni.NEDbaccessid,en.ModuleName,en.ModuleType,interface.PhysicalLoc,interface.NEIfIndex,interface.InterfaceDRCTimeStamp,interface.NEIfPMStatus,interface.inMaintenance,interface.IFNAME,interface.INPUTDATARATE,interface.INPUTPACKETRATE,interface.OUTPUTDATARATE,interface.OUTPUTPACKETRATE,interface.INPUTPEAKRATE,interface.INPUTPEAKPKTS,interface.OUTPUTPEAKRATE,interface.OUTPUTPEAKPKTS,interface.BANDWIDTH,interface.fifteenMinThresholdMask as FifteenMinThreshold,interface.IS24H,interface.ModelType,interface.ObjectType,interface.StrObjInstance,interface.rowid as myrowFROMHFR_INTERFACE_DRC_PM_Table interface,ne_info_table ni,module_type_table enWHEREinterface.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDinterface.NEDBAccessID = ni.NEDBAccessID;2.27 HFR_Interface_GC_PM_View
CREATE OR REPLACE VIEW HFR_INTERFACE_GC_PM_VIEW ASSELECTni.NESysID,ni.NEDbaccessid,en.ModuleName,en.ModuleType,interface.PhysicalLoc,interface.NEIfIndex,interface.InterfaceGCTimeStamp,interface.NEIfPMStatus,interface.inMaintenance,interface.IFNAME,interface.INPACKETS,interface.INOCTETS,interface.OUTPACKETS,interface.OUTOCTETS,interface.INUCASTPACKETS,interface.INMULTICASTPACKETS,interface.INBROADCASTPACKETS,interface.OUTUCASTPACKETS,interface.OUTMULTICASTPACKETS,interface.OUTBROADCASTPACKETS,interface.OUTPUTTOTALDROPS,interface.INPUTTOTALDROPS,interface.INPUTQUEUEDDROPS,interface.INPUTUNKNOWNPROTO,interface.OUTPUTTOTALERRORS,interface.OUTPUTUNDERRUN,interface.INPUTTOTALERRORS,interface.INPUTCRC,interface.INPUTOVERRUN,interface.INPUTFRAME,interface.fifteenMinThresholdMask as FifteenMinThreshold,interface.IS24H,interface.ModelType,interface.ObjectType,interface.StrObjInstance,interface.rowid as myrowFROMHFR_INTERFACE_GC_PM_Table interface,ne_info_table ni,module_type_table enWHEREinterface.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDinterface.NEDBAccessID = ni.NEDBAccessID;2.28 HFR_Inventory_View
CREATE OR REPLACE VIEW HFR_inventory_view ASSELECTne.NESysId as NEID,eit.PhysicalLoc as PhysicalLoc,mtt.ModuleName as ModuleName,eit.Col4 as Description,eit.Col3 as PhysicalName,eit.Col5 as HardwareRev,eit.Col6 as FirmwareRev,eit.Col7 as SoftwareRev,eit.Col8 as SerialNumber,eit.Col9 as MfgName,eit.Col10 as ModelName,eit.Col11 as Alias,eit.Col12 as AssetID,eit.Col13 as PartNumber,eit.Col14 as CleiCode,eit.Col1 as FRU,ne.NEDBAccessId as NEDBACCESSID,eit.rowid as myrow,eit.COL16 as Type,eit.IFINDEX as IfIndex,eit.OBJECTINDEX as ObjectIndexFROMne_info_table ne,eqpt_info_table eit,module_type_table mtt,objecttypetable ottWHEREne.NEDBAccessId = eit.NEDBAccessId ANDne.NEModelType = mtt.ModelType ANDeit.ModuleType = mtt.ModuleType ANDott.objectIndex = eit.objectIndex AND(eit.objectIndex > 17999 AND eit.objectIndex < 18200) ANDne.NEModelType = 26;2.29 HFR_MPLS_Interface_PM_View
CREATE OR REPLACE VIEW HFR_MPLS_INTERFACE_PM_VIEW ASSELECTni.NESysID,ni.NEDbaccessid,en.ModuleName,en.ModuleType,node.PhysicalLoc,node.NEIfIndex,node.MPLSInterfaceTimeStamp,node.NEIfPMStatus,node.inMaintenance,node.IFNAME,node.FAILEDLABELLOOKUP,node.FRAGMENTEDPKTS,node.fifteenMinThresholdMask as FifteenMinThreshold,node.IS24H,node.ModelType,node.ObjectType,node.StrObjInstance,node.rowid as myrowFROMHFR_MPLS_INTERFACE_PM_Table node,ne_info_table ni,module_type_table enWHEREnode.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDnode.NEDBAccessID = ni.NEDBAccessID;2.30 HFR_MPLS_LDP_PM_View
CREATE OR REPLACE VIEW HFR_MPLS_LDP_PM_VIEW ASSELECTni.NESysID,ni.NEDbaccessid,en.ModuleName,en.ModuleType,node.PhysicalLoc,node.NEIfIndex,node.MPLSLDPTimeStamp,node.NEIfPMStatus,node.inMaintenance,node.IPADDRESS,node.TOTALMSGSSENT,node.TOTALMSGSRCVD,node.INITMSGSSENT,node.INITMSGSRCVD,node.ADDRESSMSGSSENT,node.ADDRESSMSGSRCVD,node.ADDRESSWITHDRAWMSGSSENT,node.ADDRESSWITHDRAWMSGSRCVD,node.LABELMAPPINGMSGSSENT,node.LABELMAPPINGMSGSRCVD,node.LABELWITHDRAWMSGSSENT,node.LABELWITHDRAWMSGSRCVD,node.LABELRELEASEMSGSSENT,node.LABELRELEASEMSGSRCVD,node.NOTIFICATIONMSGSSENT,node.NOTIFICATIONMSGSRCVD,node.KEEPALIVEMSGSSENT,node.KEEPALIVEMSGSRCVD,node.fifteenMinThresholdMask as FifteenMinThreshold,node.IS24H,node.ModelType,node.ObjectType,node.StrObjInstance,node.rowid as myrowFROMHFR_MPLS_LDP_PM_Table node,ne_info_table ni,module_type_table enWHEREnode.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDnode.NEDBAccessID = ni.NEDBAccessID;2.31 HFR_MPLS_TE_Link_PM_View
CREATE OR REPLACE VIEW HFR_MPLS_TE_LINK_PM_VIEW ASSELECTni.NESysID,ni.NEDbaccessid,en.ModuleName,en.ModuleType,node.PhysicalLoc,node.NEIfIndex,node.MPLSTELinkTimeStamp,node.NEIfPMStatus,node.inMaintenance,node.IFNAME,node.LINKUTILIZATION,node.fifteenMinThresholdMask as FifteenMinThreshold,node.IS24H,node.ModelType,node.ObjectType,node.StrObjInstance,node.rowid as myrowFROMHFR_MPLS_TE_LINK_PM_Table node,ne_info_table ni,module_type_table enWHEREnode.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDnode.NEDBAccessID = ni.NEDBAccessID;2.32 HFR_MPLS_TE_Tunnel_PM_View
CREATE OR REPLACE VIEW HFR_MPLS_TE_TUNNEL_PM_VIEW ASSELECTni.NESysID,ni.NEDbaccessid,en.ModuleName,en.ModuleType,node.PhysicalLoc,node.NEIfIndex,node.MPLSTETunnelTimeStamp,node.NEIfPMStatus,node.inMaintenance,node.IFNAME,node.INPUTDATARATE,node.INPUTPACKETRATE,node.OUTPUTDATARATE,node.OUTPUTPACKETRATE,node.INPUTPEAKRATE,node.INPUTPEAKPKTS,node.OUTPUTPEAKRATE,node.OUTPUTPEAKPKTS,node.BANDWIDTH,node.fifteenMinThresholdMask as FifteenMinThreshold,node.IS24H,node.ModelType,node.ObjectType,node.StrObjInstance,node.rowid as myrowFROMHFR_MPLS_TE_TUNNEL_PM_Table node,ne_info_table ni,module_type_table enWHEREnode.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDnode.NEDBAccessID = ni.NEDBAccessID;2.33 HFR_Node_CPU_PM_View
CREATE OR REPLACE VIEW HFR_NODE_CPU_PM_VIEW ASSELECTni.NESysID,ni.NEDbaccessid,en.ModuleName,en.ModuleType,node.PhysicalLoc,node.NEIfIndex,node.NodeCPUTimeStamp,node.NEIfPMStatus,node.inMaintenance,node.NODEID,node.AVERAGECPUUSED,node.NUMPROCESSES,node.fifteenMinThresholdMask as FifteenMinThreshold,node.IS24H,node.ModelType,node.ObjectType,node.StrObjInstance,node.rowid as myrowFROMHFR_NODE_CPU_PM_Table node,ne_info_table ni,module_type_table enWHEREnode.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDnode.NEDBAccessID = ni.NEDBAccessID;2.34 HFR_Node_Memory_PM_View
CREATE OR REPLACE VIEW HFR_NODE_MEMORY_PM_VIEW ASSELECTni.NESysID,ni.NEDbaccessid,en.ModuleName,en.ModuleType,node.PhysicalLoc,node.NEIfIndex,node.NodeMemoryTimeStamp,node.NEIfPMStatus,node.inMaintenance,node.NODEID,node.PEAKMEMORY,node.APPMEMORY,node.fifteenMinThresholdMask as FifteenMinThreshold,node.IS24H,node.ModelType,node.ObjectType,node.StrObjInstance,node.rowid as myrowFROMHFR_NODE_MEMORY_PM_Table node,ne_info_table ni,module_type_table enWHEREnode.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDnode.NEDBAccessID = ni.NEDBAccessID;2.35 HFR_Node_Process_PM_View
CREATE OR REPLACE VIEW HFR_NODE_PROCESS_PM_VIEW ASSELECTni.NESysID,ni.NEDbaccessid,en.ModuleName,en.ModuleType,node.PhysicalLoc,node.NEIfIndex,node.NodeProcessTimeStamp,node.NEIfPMStatus,node.inMaintenance,node.NODEID,node.PROCESSID,node.AVERAGECPUUSED,node.TOTALMEMORY,node.NUMTHREADS,node.fifteenMinThresholdMask as FifteenMinThreshold,node.IS24H,node.ModelType,node.ObjectType,node.StrObjInstance,node.rowid as myrowFROMHFR_NODE_PROCESS_PM_Table node,ne_info_table ni,module_type_table enWHEREnode.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDnode.NEDBAccessID = ni.NEDBAccessID;2.36 INTF_Sub_INTF_View
CREATE OR REPLACE VIEW INTF_SUB_INTF_VIEW ASSELECT DISTINCTert.NEDBACCESSID as NEID,getSlot(ert.RELATEDPHYSICALLOC) as SLOT,getPort(ert.RELATEDPHYSICALLOC) as PORTNUM,getBGFromBGObj(ert.SELFIFINDEX) as BG,getSubIf(ert.RELATEDIFINDEX) as SUBIFFROMEqpt_Info_Table eqpt,Eqpt_RelationShip_Table ertWHEREeqpt.NEDBACCESSID = ert.NEDBACCESSID AND eqpt.PHYSICALLOC = ert.RELATEDPHYSICALLOCAND eqpt.IFINDEX = ert.RELATEDIFINDEX AND ert.SELFOBJECTINDEX = 165AND (eqpt.OBJECTINDEX = 172 OR eqpt.OBJECTINDEX = 173 OR eqpt.OBJECTINDEX = 175 OR eqpt.OBJECTINDEX = 176);2.37 Inventory_Table_View
CREATE OR REPLACE VIEW Inventory_Table_View asSELECTni.NESysID,inv.ModuleName,inv.ModulePartNum,inv.ModuleCLEICode,inv.ModuleHWVersion,inv.ModuleSWVersion,inv.ModuleSerialNumber,inv.ModuleDateOfManuf,inv.ModuleDateOfEntry,inv.ModuleHoursInUse,ni.NEDBAccessId,inv.rowid as myrowFROMNE_INFO_TABLE ni,NE_INVENTORY_TABLE invWHEREni.NEDBAccessID = inv.NEDBAccessID ;2.38 IOS_Active_Cards
CREATE OR REPLACE view IOS_ACTIVE_CARDS ASSELECT distincta.NEDBACCESSID as NEDBACCESSID,a.PHYSICALLOC as PHYSICALLOC,a.EQUIPMENTTYPE as MODULETYPE,a.NAME as MODULENAME,b.NESYSID as NEID,b.NEMODELTYPE as NEMODELTYPE,a.rowid as MYROWfrom ONS15454_NE_INVENTORY_TABLE a, NE_INFO_TABLE bwhere EQUIPMENTTYPE in ( 102,103,164 ) andEQUIPMENTSTATE = 5 anda.NEDBACCESSID = b.NEDBACCESSID;2.39 IOS_Users_View
CREATE OR REPLACE VIEW IOS_USERS_VIEW ASSELECTc.NEDBACCESSID as NEDBACCESSID,c.MODULETYPE as MODULETYPE,c.PHYSICALLOC as PHYSICALLOC,c.IFINDEX as IFINDEX,c.COL2 as USERNAME,c.COL5 as PASSWORD,c.COL3 as PRIVILEGE,a.MODULENAME as MODULENAME,b.NESYSID as NEID,c.MODELTYPE as NEMODELTYPE,c.rowid as MYROWFROMEQPT_INFO_TABLE c,NE_INFO_TABLE b,MODULE_TYPE_TABLE aWHEREc.OBJECTINDEX = 221 andc.NEDBACCESSID = b.NEDBACCESSID andc.MODELTYPE = a.MODELTYPE andc.MODULETYPE = a.MODULETYPE;2.40 Link_Utilization_View
CREATE OR REPLACE VIEW LINK_UTILIZATION_VIEW ASSELECT a.FIELD1_NUM as CKTMODULETYPE,a.FIELD2_NUM as CKTPHYSICALLOC,a.FIELD3_NUM as CKTIFINDEX,b.CKTNAME as CKTNAME,b.CKTPROTECTIONTYPE as CKTPROTECTIONTYPE,a.CUSTOMER_ID_STR as CKTCUSTOMERID,a.SERVICE_ID_STR as CKTSERVICEID,b.CKTSIZE as CKTSIZE,a.field3_num as STRIPPED_IFINDEX,a.NEDBACCESSID as NEDBACCESSID,b.CKTTYPE as CKTTYPE,b.CKTUSELAP as CKTUSELAP,b.CKTSRCIFINDEX as STRIPPED_CKTSRC_IFINDEX,collapsedifindex(b.CKTNODEID,b.CKTUNIQUEID) as CKTDEST_IFINDEX,b.CKTUNIQUEID as CKTUNIQUEID,b.CKTNODEID as CKTNODEID,a.FIELD4_NUM as CKTOBJECTTYPE,collapsedobjectindex(b.CKTNODEID,b.CKTUNIQUEID) as cktDestObjectType,b.CKTSRCMODELTYPE as modelType,b.Rowid as myrowFROMMANAGED_ET_TAB a, CIRCUIT_TBL bWHEREa.MNG_ENTITY_ID2_NUM = b.CKTUNIQUEID ANDa.MNG_ENTITY_ID_NUM = b.CKTNODEID AND( b.CKTTYPE != 5 AND b.CKTTYPE != 6 AND b.CKTTYPE != 21 AND b.CKTTYPE != 22 );2.41 Link_View
CREATE OR REPLACE VIEW Link_View asSELECTlink.LinkID as LinkId,link.LinkSrcNode as LinkSrcNode,link.LinkSrcModuleType as LinkSrcModuleType,link.LinkSrcPhysicalLoc as LinkSrcPhysicalLoc,link.LinkSrcIfIndex as LinkSrcIfIndex,eqptinfoport(link.LinkSrcNode,link.LinkSrcPhysicalLoc,link.LinkSrcIfIndex,link.Lin kSrcModuleType) as LinkSrcPortName,link.LinkDstNode as LinkDstNode,link.LinkDstModuleType as LinkDstModuleType,link.LinkDstPhysicalLoc as LinkDstPhysicalLoc,link.LinkDstIfIndex as LinkDstIfIndex,eqptinfoport(link.LinkDstNode,link.LinkDstPhysicalLoc,link.LinkDstIfIndex,link.Lin kDstModuleType) as LinkDstPortName,link.LinkSize as LinkSize,link.LinkDirection as LinkDirection,link.LinkProvType as LinkProvType,link.LinkConnectionType as LinkConnectionType,link.LinkType as LinkType,link.LinkProtType as LinkProtType,link.LinkProtRole as LinkProtRole,link.LinkState as LinkState,link.useForRouting as useForRouting,link.LinkName as LinkName,link.LinkDescription as LinkDescription,link.NumCriticalAlarms as NumCriticalAlarms,link.NumMajorAlarms as NumMajorAlarms,link.NumMinorAlarms as NumMinorAlarms,link.NumWarningAlarms as NumWarningAlarms,link.LinkSrcPhyLocUnmanaged as LinkSrcPhyLocUnmanaged,link.LinkDestPhyLocUnmanaged as LinkDestPhyLocUnmanaged,link.LinkUnmanaged as LinkUnmanaged,neinfo1.nesysid as SrcNesysid,neinfo2.nesysid as DstNesysid,link.rowid as myrow,(select neSubnetworkId from ne_info_table where nedbaccessid = link.LinkSrcNode AND neSubnetworkId = (select neSubnetworkId from ne_info_table where nedbaccessid = link.LinkDstNode)) as SubnetworkId,link.LinkLayer as LinkLayer,link.LinkValid as LinkValid,link.CableGroupId as GroupId,0 as LinkDstNode2,0 as LinkDstModuleType2,d.phyloc as LinkDstPhysicalLoc2,d.phyloc as LinkDstIfIndex2,'' as LinkDstPortName2,0 as ycable,link.LinkCost as LinkCost,link.LinkSrcModelType as LinkSrcModelType,link.LinkSrcObjectType as LinkSrcObjectType,link.LinkDstModelType as LinkDstModelType,link.LinkDstObjectType as LinkDstObjectType,0 as LinkDstModelType2,0 as LinkDstObjectType2,link.LinkSrlgList as LinkSrlgListFROMLink_table link,ne_info_table neinfo1,ne_info_table neinfo2,dummy_table dWHERElink.LinkSrcNode = neinfo1.nedbaccessid ANDlink.LinkDstNode = neinfo2.nedbaccessid ANDlink.LinkType != 11 andd.phyloc = 0UNIONSELECT distinctlink.LinkID as LinkId,link.LinkSrcNode as LinkSrcNode,link.LinkSrcModuleType as LinkSrcModuleType,link.LinkSrcPhysicalLoc as LinkSrcPhysicalLoc,link.LinkSrcIfIndex as LinkSrcIfIndex,eqptinfoport(link.LinkSrcNode,link.LinkSrcPhysicalLoc,link.LinkSrcIfIndex,link.Lin kSrcModuleType) as LinkSrcPortName,link.LinkDstNode as LinkDstNode,link.LinkDstModuleType as LinkDstModuleType,link.LinkDstPhysicalLoc as LinkDstPhysicalLoc,link.LinkDstIfIndex as LinkDstIfIndex,eqptinfoport(link.LinkDstNode,link.LinkDstPhysicalLoc,link.LinkDstIfIndex,link.Lin kDstModuleType) as LinkDstPortName,link.LinkSize as LinkSize,link.LinkDirection as LinkDirection,link.LinkProvType as LinkProvType,link.LinkConnectionType as LinkConnectionType,link.LinkType as LinkType,link.LinkProtType as LinkProtType,link.LinkProtRole as LinkProtRole,link.LinkState as LinkState,link.useForRouting as useForRouting,link.LinkName as LinkName,link.LinkDescription as LinkDescription,link.NumCriticalAlarms+link1.NumCriticalAlarms as NumCriticalAlarms,link.NumMajorAlarms+link1.NumMajorAlarms as NumMajorAlarms,link.NumMinorAlarms+link1.NumMinorAlarms as NumMinorAlarms,link.NumWarningAlarms+link1.NumWarningAlarms as NumWarningAlarms,link.LinkSrcPhyLocUnmanaged as LinkSrcPhyLocUnmanaged,link.LinkDestPhyLocUnmanaged as LinkDestPhyLocUnmanaged,link.LinkUnmanaged as LinkUnmanaged,neinfo1.nesysid as SrcNesysid,neinfo2.nesysid as DstNesysid,link.rowid as myrow,(select neSubnetworkId from ne_info_table where nedbaccessid = link.LinkSrcNode AND neSubnetworkId = (select neSubnetworkId from ne_info_table where nedbaccessid = link.LinkDstNode)) as SubnetworkId,link.LinkLayer as LinkLayer,link.LinkValid as LinkValid,link.CableGroupId as GroupId,link1.LinkDstNode as LinkDstNode2,link1.LinkDstModuleType as LinkDstModuleType2,link1.LinkDstPhysicalLoc as LinkDstPhysicalLoc2,link1.LinkDstIfIndex as LinkDstIfIndex2,eqptinfoport(link.LinkDstNode,link1.LinkDstPhysicalLoc,link1.LinkDstIfIndex,link1. LinkDstModuleType) as LinkDstPortName2,1 as ycable,link.LinkCost as LinkCost,link.LinkSrcModelType as LinkSrcModelType,link.LinkSrcObjectType as LinkSrcObjectType,link.LinkDstModelType as LinkDstModelType,link.LinkDstObjectType as LinkDstObjectType,link1.LinkDstModelType as LinkDstModelType2,link1.LinkDstObjectType as LinkDstObjectType2,link.LinkSrlgList as LinkSrlgListFROMLink_table link,Link_table link1,ne_info_table neinfo1,ne_info_table neinfo2WHERElink.LinkSrcNode = neinfo1.nedbaccessid ANDlink.LinkDstNode = neinfo2.nedbaccessid ANDlink.cableGroupId=link1.cableGroupId andlink.legIndex < link1.legIndex andlink.LinkType = 11;2.42 MCard_L2Topology_Map_View
CREATE OR REPLACE VIEW MCard_L2Topology_Map_View ASSELECTl2tct.Toponodeid as Toponodeid,l2tct.Topouniqueid as Topouniqueid,nit.NeDbAccessId as NeDbId,cst.CktSrcPhysicalLoc as PhysicalLoc,cst.CktSrcModuleType as ModuleTypeFROM Circuit_Tbl cst,L2topology_Circuits_Table l2tct,Ne_Info_Table nitWHERE cst.CktNodeId = l2tct.NodeId ANDcst.CktUniqueId = l2tct.UniqueId ANDcst.CktSrcNodeId = nit.NeNodeId ANDcst.CktSrcModuleType IN (6684672,6750208,10747904)UNIONSELECTl2tct.Toponodeid as Toponodeid,l2tct.Topouniqueid as Topouniqueid,nit.NeDbAccessId as NeDbId,cdt.cktDestPhysicalLoc as PhysicalLoc,cdt.cktDestModuleType as ModuleTypeFROM Circuit_Dest_Tbl cdt,L2topology_Circuits_Table l2tct,Ne_Info_Table nitWHERE cdt.CktNodeId = l2tct.NodeId ANDcdt.CktUniqueId = l2tct.UniqueId ANDcdt.CktDestNodeId = nit.NeNodeId ANDcdt.cktDestModuleType IN (6684672,6750208,10747904);2.43 MLL_Inv_View
CREATE OR REPLACE VIEW MLL_INV_VIEW ASSELECT distinctinfo.NEDBACCESSID as NEDBACCESSID,m.LAYERRATE as LAYERRATEFROMMODULE_TYPE_MLL_INFO m,ne_info_table info,ONS15454_ne_inventory_table invWHEREinfo.NEDBAccessID = inv.NEDBAccessID ANDinfo.NEModelType = m.ModelType ANDinv.EquipmentType = m.ModuleTypeUNIONSELECT distinctne.NEDBACCESSID as NEDBACCESSID,m.LAYERRATE as LAYERRATEFROMMODULE_TYPE_MLL_INFO m,ne_info_table ne,eqpt_info_table eitWHEREne.NEDBACCESSID = eit.NEDBACCESSID ANDne.NEModelType = m.ModelType ANDeit.ModuleType = m.ModuleType ANDne.NEModelType in (4,6,10) ANDm.ModuleType > 2003UNIONSELECT distinctt1.NEDBACCESSID as NEDBACCESSID,m.LAYERRATE as LAYERRATEFROMMODULE_TYPE_MLL_INFO m,NE_INFO_TABLE t1,ONS15216_NE_INVENTORY_TABLE t2WHEREt1.NEDBACCESSID = t2.NEDBACCESSID ANDt1.NEModelType = m.MODELTYPEUNIONSELECT distinctn.NEDBACCESSID as NEDBACCESSID,0 as LAYERRATEFROMNE_INFO_TABLE nWHEREn.NEMODELTYPE = 24UNIONSELECT distinctn.NEDBACCESSID as NEDBACCESSID,m.LAYERRATE as LAYERRATEFROMMODULE_TYPE_MLL_INFO m,NE_INFO_TABLE n,EQPT_INFO_TABLE eqptWHEREn.NEDBACCESSID = eqpt.NEDBACCESSID andm.MODELTYPE = n.NEMODELTYPE andm.MODULETYPE = eqpt.MODULETYPE and((n.NEMODELTYPE = 9) or (n.NEMODELTYPE<14 and n.NEMODELTYPE>10))UNIONSELECT distinctneInfo.NEDBACCESSID as NEDBACCESSID,mll.LAYERRATE as LAYERRATEFROMMODULE_TYPE_MLL_INFO mll,NE_INFO_TABLE neInfo,ONS1530x_NE_INVENTORY_TABLE neInvWHEREneInfo.NEDBACCESSID = neInv.NEDBACCESSID andneInfo.NEModelType = mll.ModelType andneInv.Type = mll.ModuleType andneInfo.NEModelType in (21,22);rem ( union rows for other models )2.44 NE_Alarm_View
CREATE OR REPLACE VIEW NE_Alarm_View asSELECTaat.NEDBAccessID,aat.ActiveAlarmSeverity,aat.ModuleOrIfIndex,aat.AlarmSeqNum,aat.ModuleType,aat.PhysicalLoc,aat.alarmStatus,aat.rowid as myrowaat.ModelType,aat.ObjectType,aat.StrObjInstanceFROMACTIVE_ALARM_TABLE aat,NE_INFO_TABLE nitWHEREaat.NEDBAccessID = nit.NEDBAccessID ;2.45 NE_Audit_Trail_View
CREATE OR REPLACE VIEW NE_Audit_Trail_view asSELECTa.nesysid as NEId,c.neuserid as UserId,c.nedbaccessid,c.sequencenumber as SequenceNumber,c.timestamp as TimeStamp,c.operationdescription as OperationDescription,c.operationstatus as OperationStatus,c.rowid as myrowFROMne_info_table a,ne_audit_trail_table cWHEREa.nedbaccessid = c.nedbaccessid;2.46 NE_Circuit_NodeID_View
CREATE OR REPLACE VIEW NE_Circuit_NodeID_View asSELECTa.nedbaccessid, b.cktnameFROMne_info_table a, circuit_tbl bWHEREa.NENodeID = b.CktNodeId; and b.cktstate !=12;2.47 NE_Circuit_VLAN_View
CREATE OR REPLACE VIEW NE_Circuit_Vlan_View asSELECTa.NEDBACCESSID, c.CKTVLANIDFROMNE_INFO_TABLEa, CIRCUIT_TBL b, CIRCUIT_VLAN_TBL cWHEREb.CKTUNIQUEID = c.CKTUNIQUEID ANDb.CKTNODEID = c.CKTNODEID ANDb.CKTNODEID = a.NENODEID;2.48 NE_Info_NP_View
CREATE OR REPLACE VIEW NE_Info_NP_VIEW AsSELECT ne.NEDBAccessID,ne.NESysID,ne.NEIPAddr,ne.NENSAPAddr,ne.NEState,ne.isNEConnected,decode(ne.GNEID,-1,'Not Applicable',gne.GNESysID ) as GneName,ne.NEDescription,ne.NEConfigMode,ne.NESnmpCommString,ne.NECLLICode,ne.NEStateChangeTime,ne.NEModelType,ne.NEModelIndex,ne.NEModelStatus,decode(ne.nesubnetworkID,-1,'Not Applicable',sub.SubnetName) as SubnetworkName,ne.NETimeOffset,ne.NELEDStatus,ne.NESystemTitle,ne.NEUserLabel,ne.NEVendorName,ne.NEVersion,ne.NENumActiveCriticalErrors,ne.NENumActiveMajorErrors,ne.NENumActiveMinorErrors,ne.NEPmEnabled,ne.NENodeID,ne.NEInventoryLastChanged,ne.NESubnetMask,ne.NEDefaultGateway,ne.NENumUnActiveCriticalErrors,ne.NENumUnActiveMajorErrors,ne.NENumUnActiveMinorErrors,ne.NENumCleared,ne.DisplayModelName,ne.GWTL1USERNAME,ne.GWTL1PASSWD,ne.ServiceID,ne.DeleteState,np.NPId,np.NPNameFROMne_info_table ne,subnetwork_table sub,gne_table gne,network_partition_table npWHEREne.GNEID=gne.gneid ANDne.NESubNetworkID=sub.subnetID ANDsub.NPId=np.NPId;2.49 NE_Inventory_View
CREATE OR REPLACE VIEW NE_Inventory_View asSELECTnit.NESysID,ninvt.ModuleIndex,ninvt.ModuleName,ninvt.ModulePartNum,ninvt.ModuleCLEICode,ninvt.ModuleHWVersion,ninvt.ModuleSWVersion,ninvt.ModuleSerialNumber,ninvt.ModuleDateOfManuf,ninvt.ModuleDateOfEntry,ninvt.ModuleHoursInUse,nit.NEDBAccessId,ninvt.rowid as myrowFROMNE_INVENTORY_TABLE ninvt,NE_INFO_TABLE nitWHEREninvt.NEDBAccessID = nit.NEDBAccessID ;2.50 NE_Swimage_View
CREATE OR REPLACE VIEW NE_SWIMAGE_VIEW asSELECTne.NESysId,mtt.modelTypeName AS ModelName,ne.NEState,sw.activeimagename,sw.standbyimagename,sw.defaultimagename,ne.nedbaccessid,sw.inprogress,mtt.modeltype,sw.rowid as myrowFROMNE_SWIMAGE_TABLE sw,NE_INFO_TABLE ne,Model_Type_Table mttWHEREsw.nedbaccessid = ne.nedbaccessid ANDmtt.ModelType = ne.NEModelType;2.51 ONS15200_Inventory_View
CREATE OR REPLACE VIEW ONS15200_inventory_view ASSELECTne.NESysId,eit.PhysicalLoc as PhysicalLoc,mtt.ModuleName as ModuleName,to_number(eit.Col1) as SERVICESTATE,nvl(eit.Col8, 'N/A') as ITUCHNO,to_number(eit.Col9) as DATARATE,to_number(eit.Col11) as APPLICATIONCODE,eit.Col12 as SERIALNO,eit.Col13 as NEID,eit.Col14 as PARTNO,nvl(eit.Col15, 'N/A') as NCBSWVERSION,nvl(eit.Col16, 'N/A') as NCBBOARDREVNO,eit.Col17 as CLEICODE,nvl(eit.Col26, 'N/A') as CONTAINERNAME,to_number(eit.Col44) as POWERSPLIT,nvl(eit.Col91, 'N/A') as NAME,nvl(eit.Col92, 'N/A') as PRIMARYNCBID,nvl(eit.Col93, 'N/A') as SECONDARYNCBID,ne.NEDBAccessId,eit.IFINDEX,mtt.ModuleType,to_number(eit.Col250) as CONFLICTINGCLIP,eit.rowid as myrowFROMne_info_table ne,eqpt_info_table eit,module_type_table mttWHEREne.NEDBAccessId = eit.NEDBAccessId ANDne.NEModelType = mtt.ModelType ANDeit.ModuleType = mtt.ModuleType ANDmtt.ModuleType > 7002 ANDmtt.ModuleType > 7300;2.52 ONS15216_Active_User_View
CREATE OR REPLACE view ONS15216_Active_User_view ASSELECTa.nesysid as NEId,b.userid as UserId,b.nedbaccessid,b.rowid as myrowFROMons15216_active_user_table b,ne_info_table aWHEREb.nedbaccessid = a.nedbaccessid;2.53 ONS15216_Inventory_View
CREATE OR REPLACE VIEW ONS15216_INVENTORY_VIEW asSELECT DISTINCTt1.NEDBACCESSID,t1.NEMODELINDEX,t1.NESYSID,t1.NEDESCRIPTION,t1.NECONFIGMODE,t1.NEVERSION,t2.WAVELENGTH,t2.PARTNUMBER,t2.CLEICODE,t2.SERIALNUMBER,t1.NECLLICODE,t1.GNEID,t1.NESUBNETWORKID,t2.MODULENUMBER,t2.rowid as NYROWFROMNE_INFO_TABLE t1,ONS15216_NE_INVENTORY_TABLE t2WHEREt1.NEDBACCESSID = t2.NEDBACCESSID;2.54 ONS15216_User_View
CREATE OR REPLACE view ONS15216_User_view ASSELECTa.nesysid as NEId,b.userid as UserId,b.nedbaccessid,c.privilege as Privilege,b.lastlogintime as LastLoginTime,b.Timeout as Timeout,b.rowid as myrowFROMons15216_user_table b,ne_info_table a,ons15216_privilege_table cWHEREb.nedbaccessid = a.nedbaccessid ANDb.privilegeid = c.privilegeid;2.55 ONS1530x_DCC_PM_View
CREATE OR REPLACE VIEW ONS1530x_DCC_PM_View ASSELECTpl.NESysId,mt.ModuleName,pi.PhysicalLoc,pi.NeIfIndex,pi.TimeStamp,pi.IFINUCASTPKTS,pi.IFINDISCARDS,pi.IFINERRORS,pi.IFINOCTETS,pi.IFOUTOCTETS,pi.IFINNUCASTPKTS,pi.IFINUNKNOWNPROTOS,pi.IFOUTUCASTPKTS,pi.IFOUTNUCASTPKTS,pi.IFOUTDISCARDS,pi.IFOUTERRORS,pi.IFINMULTICASTPKTS,pi.IFINBROADCASTPKTS,pi.IFOUTMULTICASTPKTS,pi.IFOUTBROADCASTPKTS,pl.NEDBAccessId,mt.ModuleType,pi.is24H,pl.NEModelType,pi.OBJECTTYPE,pi.STROBJINSTANCE,pi.rowid as myrowFROMne_info_table pl,module_type_table mt,ONS1530x_IP_PM_TABLE piWHEREpl.NEDbAccessID = pi.NEDbAccessId ANDpl.NEModelType = mt.ModelType ANDmt.ModuleType = pi.ModuleType ANDpi.iftype = 2;2.56 ONS1530x_HO_FE_PM_View
CREATE OR REPLACE VIEW ONS1530x_HO_FE_PM_ViewSELECTpl.NESysId,mt.ModuleName,pi.PhysicalLoc,pi.NeIfIndex,pi.TimeStamp,pi.FEBBE,pi.FEES,pi.FESES,pi.FEUAS,pl.NEDBAccessId,mt.ModuleType,pi.is24H,pl.NEModelType,pi.OBJECTTYPE,pi.STROBJINSTANCE,pi.rowid as myrowFROMne_info_table pl,module_type_table mt,ONS1530x_HO_PM_TABLE piWHEREpl.NEDbAccessID = pi.NEDbAccessId ANDpl.NEModelType = mt.ModelType ANDmt.ModuleType = pi.ModuleType ;2.57 ONS1530x_HO_PM_View
CREATE OR REPLACE VIEW ONS1530x_HO_PM_View ASSELECTpl.NESysId,mt.ModuleName,pi.PhysicalLoc,pi.NeIfIndex,pi.TimeStamp,pi.NEBBE,pi.NEES,pi.NESES,pi.NEUAS,pl.NEDBAccessId,mt.ModuleType,pi.is24H,pl.NEModelType,pi.OBJECTTYPE,pi.STROBJINSTANCE,pi.rowid as myrowFROMne_info_table pl,module_type_table mt,ONS1530x_HO_PM_TABLE piWHEREpl.NEDbAccessID = pi.NEDbAccessId ANDpl.NEModelType = mt.ModelType ANDmt.ModuleType = pi.ModuleType ;2.58 ONS1530x_Inventory_View
CREATE OR REPLACE VIEW ONS1530x_inventory_view ASSELECTinfo.NESysId,nvl(mtt2.ModuleName,'EMPTY SLOT') as ModuleName,inv.PhysicalLoc as PhysicalLoc,inv.InstallState as InstallState,mtt1.ModuleName as ExpectedModule,nvl(inv.ServiceState,'N/A') as ServiceState,nvl(inv.SoftwareVersion,'N/A') as SoftwareVersion,nvl(inv.SerialNumber,'N/A') as SerialNumber,nvl(inv.HardwareVersion,'N/A') as HardwareVersion,info.NEDBAccessId,info.rowid as myrow,inv.Type as ModuleTypeFROMne_info_table info,ONS1530x_ne_inventory_table inv,module_type_table mtt1,module_type_table mtt2WHEREinfo.NEDBAccessID = inv.NEDBAccessID ANDinfo.NEModelType = mtt1.ModelType ANDinfo.NEModelType = mtt2.ModelType ANDmtt1.moduleType = inv.ExpectedModule ANDmtt2.moduleType = inv.ModuleName;commit;2.59 ONS1530x_LAN_PM_View
CREATE OR REPLACE VIEW ONS1530x_LAN_PM_View ASSELECTpl.NESysId,mt.ModuleName,pi.PhysicalLoc,pi.NeIfIndex,pi.TimeStamp,pi.IFINUCASTPKTS,pi.IFINDISCARDS,pi.IFINERRORS,pi.IFINOCTETS,pi.IFOUTOCTETS,pi.IFINNUCASTPKTS,pi.IFINUNKNOWNPROTOS,pi.IFOUTUCASTPKTS,pi.IFOUTNUCASTPKTS,pi.IFOUTDISCARDS,pi.IFOUTERRORS,pi.IFINMULTICASTPKTS,pi.IFINBROADCASTPKTS,pi.IFOUTMULTICASTPKTS,pi.IFOUTBROADCASTPKTS,pl.NEDBAccessId,mt.ModuleType,pi.is24H,pl.NEModelType,pi.OBJECTTYPE,pi.STROBJINSTANCE,pi.rowid as myrowFROMne_info_table pl,module_type_table mt,ONS1530x_IP_PM_TABLE piWHEREpl.NEDbAccessID = pi.NEDbAccessId ANDpl.NEModelType = mt.ModelType ANDmt.ModuleType = pi.ModuleType ANDpi.iftype = 0;2.60 ONS1530x_LO_FE_PM_View
CREATE OR REPLACE VIEW ONS1530x_LO_FE_PM_View ASSELECTpl.NESysId,mt.ModuleName,pi.PhysicalLoc,pi.NeIfIndex,pi.TimeStamp,pi.FEBBE,pi.FEES,pi.FESES,pi.FEUAS,pl.NEDBAccessId,mt.ModuleType,pi.is24H,pl.NEModelType,pi.OBJECTTYPE,pi.STROBJINSTANCE,pi.rowid as myrowFROMne_info_table pl,module_type_table mt,ONS1530x_LO_PM_TABLE piWHEREpl.NEDbAccessID = pi.NEDbAccessId ANDpl.NEModelType = mt.ModelType ANDmt.ModuleType = pi.ModuleType ;2.61 ONS1530x_LO_PM_View
CREATE OR REPLACE VIEW ONS1530x_LO_PM_View ASSELECTpl.NESysId,mt.ModuleName,pi.PhysicalLoc,pi.NeIfIndex,pi.TimeStamp,pi.NEBBE,pi.NEES,pi.NESES,pi.NEUAS,pl.NEDBAccessId,mt.ModuleType,pi.is24H,pl.NEModelType,pi.OBJECTTYPE,pi.STROBJINSTANCE,pi.rowid as myrowFROMne_info_table pl,module_type_table mt,ONS1530x_LO_PM_TABLE piWHEREpl.NEDbAccessID = pi.NEDbAccessId ANDpl.NEModelType = mt.ModelType ANDmt.ModuleType = pi.ModuleType ;2.62 ONS1530x_MS_FE_PM_View
CREATE OR REPLACE VIEW ONS1530x_MS_FE_PM_ViewSELECTpl.NESysId,mt.ModuleName,pi.PhysicalLoc,pi.NeIfIndex,pi.TimeStamp,pi.FEBBE,pi.FEES,pi.FESES,pi.FEUAS,pl.NEDBAccessId,mt.ModuleType,pi.is24H,pl.NEModelType,pi.OBJECTTYPE,pi.STROBJINSTANCE,pi.rowid as myrowFROMne_info_table pl,module_type_table mt,ONS1530x_MS_PM_TABLE piWHEREpl.NEDbAccessID = pi.NEDbAccessId ANDpl.NEModelType = mt.ModelType ANDmt.ModuleType = pi.ModuleType ;2.63 ONS1530x_MS_PM_View
CREATE OR REPLACE VIEW ONS1530x_MS_PM_ViewSELECTpl.NESysId,mt.ModuleName,pi.PhysicalLoc,pi.NeIfIndex,pi.TimeStamp,pi.NEBBE,pi.NEES,pi.NESES,pi.NEUAS,pl.NEDBAccessId,mt.ModuleType,pi.is24H,pl.NEModelType,pi.OBJECTTYPE,pi.STROBJINSTANCE,pi.rowid as myrowFROMne_info_table pl,module_type_table mt,ONS1530x_MS_PM_TABLE piWHEREpl.NEDbAccessID = pi.NEDbAccessId ANDpl.NEModelType = mt.ModelType ANDmt.ModuleType = pi.ModuleType ;2.64 ONS1530x_RS_PM_View
CREATE OR REPLACE VIEW ONS1530x_RS_PM_ViewSELECTpl.NESysId,mt.ModuleName,pi.PhysicalLoc,pi.NeIfIndex,pi.TimeStamp,pi.NEBBE,pi.NEES,pi.NESES,pi.NEUAS,pl.NEDBAccessId,mt.ModuleType,pi.is24H,pl.NEModelType,pi.OBJECTTYPE,pi.STROBJINSTANCE,pi.rowid as myrowFROMne_info_table pl,module_type_table mt,ONS1530x_RS_PM_TABLE piWHEREpl.NEDbAccessID = pi.NEDbAccessId ANDpl.NEModelType = mt.ModelType ANDmt.ModuleType = pi.ModuleType ;2.65 ONS1530x_WAN_PM_View
CREATE OR REPLACE VIEW ONS1530x_WAN_PM_ViewSELECTpl.NESysId,mt.ModuleName,pi.PhysicalLoc,pi.NeIfIndex,pi.TimeStamp,pi.IFINUCASTPKTS,pi.IFINDISCARDS,pi.IFINERRORS,pi.IFINOCTETS,pi.IFOUTOCTETS,pi.IFINNUCASTPKTS,pi.IFINUNKNOWNPROTOS,pi.IFOUTUCASTPKTS,pi.IFOUTNUCASTPKTS,pi.IFOUTDISCARDS,pi.IFOUTERRORS,pi.IFINMULTICASTPKTS,pi.IFINBROADCASTPKTS,pi.IFOUTMULTICASTPKTS,pi.IFOUTBROADCASTPKTS,pl.NEDBAccessId,mt.ModuleType,pi.is24H,pl.NEModelType,pi.OBJECTTYPE,pi.STROBJINSTANCE,pi.rowid as myrowFROMne_info_table pl,module_type_table mt,ONS1530x_IP_PM_TABLE piWHEREpl.NEDbAccessID = pi.NEDbAccessId ANDpl.NEModelType = mt.ModelType ANDmt.ModuleType = pi.ModuleType ANDpi.iftype = 1;commit;2.66 ONS15454_8B10B_PM_View
CREATE OR REPLACE VIEW ONS15454_8B10B_PM_VIEW ASSELECTni.NESysID,ni.NEDbaccessid,en.ModuleName,en.ModuleType,fc.Physicalloc,fc.NEIfIndex,fc.TimeStamp,fc.NEIfPmStatus,fc.ThresholdList,fc.InMaintenance,fc.validPackets,fc.invalidPackets,fc.codeGroupViolations,fc.idleOrderedSets,fc.nonIdleOrderedSets,fc.dataCodeGroups,fc.rxTotalPackets,fc.ifInErrors,fc.statsEncodingDispErrors,fc.dataOrderedSets,fc.dataPayLoad,fc.IS24H,fc.ModelType,fc.ObjectType,fc.StrObjInstance,fc.InvalidityList,fc.rowid as myrowFROMons15454_8B10B_pm_table fc,ne_info_table ni,module_type_table enWHEREfc.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDfc.NEDBAccessID = ni.NEDBAccessID;2.67 ONS15454_Active_User_View
CREATE OR REPLACE VIEW ONS15454_Active_User_view asSELECTa.nesysid as NEId,b.userid as UserId,b.nedbaccessid,b.clientIp as ClientIp,b.rowid as myrowFROmons15454_active_user_table b,ne_info_table aWHEREb.nedbaccessid = a.nedbaccessid;2.68 ONS15454_BLSR_Config_View
CREATE OR REPLACE VIEW ONS15454_BLSR_CONFIG_VIEW asSELECTne.NESysid,mtt.modulename as ModuleName,eit.Physicalloc as Physicalloc,eit.IfIndex as IfIndex,eit.col4 as Type,eit.col5 as Rate,eit.col6 as RingID,eit.col7 as NodeID,eit.col8 as RingReversion,eit.col9 as SpanReversion,eit.col10 as WestLine,eit.col11 as EastLine,eit.NEDbaccessid as NEDbaccessid,eit.ModuleType as ModuleType,ne.rowid as myrowFROMne_info_table ne,eqpt_info_table eit,module_type_table mttWHEREne.NEDbaccessid = eit.NEDbaccessid ANDne.NEModelType = mtt.ModelType ANDeit.ModuleType = mtt.ModuleType ANDmtt.Modeltype = 3 ANDmtt.ModuleType = 0 ANDeit.ObjectIndex = 4007;2.69 ONS15454_BLSR_Squelch_View
CREATE OR REPLACE VIEW ONS15454_BLSR_SQUELCH_VIEW asSELECTne.NESysid,mtt.modulename as ModuleName,eit.Physicalloc as Physicalloc,eit.IfIndex as IfIndex,eit.col4 as STSNumber,eit.col5 as WestSource,eit.col6 as WestDest,eit.col7 as EastSource,eit.col8 as EastDest,eit.NEDbaccessid as NEDbaccessid,eit.ModuleType as ModuleType,ne.rowid as myrowFROMne_info_table ne,eqpt_info_table eit,module_type_table mttWHEREne.NEDbaccessid = eit.NEDbaccessid ANDne.NEModelType = mtt.ModelType ANDeit.ModuleType = mtt.ModuleType ANDmtt.Modeltype = 3 ANDmtt.ModuleType = 0 ANDeit.ObjectIndex = 4009;2.70 ONS15454_Class_QoS_PM_View
CREATE OR REPLACE VIEW ONS15454_class_qos_pm_view ASSELECTni.NESysID,ni.NEDbaccessid,en.ModuleName,en.ModuleType,cmQos.Physicalloc,cmQos.NEIfIndex,cmQos.TimeStamp,cmQos.NEIfPmStatus,cmQos.InMaintenance,cmQos.CBQosCMPrePolicyPkt64,cmQos.CBQosCMPrePolicyByte64,cmQos.CBQosCMPostPolicyByte64,cmQos.CBQosCMDropPkt64,cmQos.CBQosCMDropByte64,cmQos.CBQosCMNoBufDropPkt64,cmQos.IS24H,cmQos.ModelType,cmQos.ObjectType,cmQos.StrObjInstance,cmQos.InvalidityList,cmQos.rowid as myrowFROMONS15454_classmap_pm_table cmQos,ne_info_table ni,module_type_table enWHEREcmQos.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDcmQos.NEDBAccessID = ni.NEDBAccessID;2.71 ONS15454_CMS_Storage_View
CREATE OR REPLACE VIEW ONS15454_CMS_Storage_View asSELECTstorage.JarID,storage.FileName as Name,storage.JarTime as TimeStamp,storage.UserName as UserName,storage.rowid as myrowFROMONS15454_CMS_Storage_Table storage;2.72 ONS15454_COS_PM_View
CREATE OR REPLACE VIEW ONS15454_COS_pm_view ASSELECTni.NESysID,ni.NEDbaccessid,en.ModuleName,en.ModuleType,portCOS.Physicalloc,portCOS.NEIfIndex,portCOS.TimeStamp,portCOS.NEIfPmStatus,portCOS.InMaintenance,portCOS.InterfaceName,portCOS.InterfaceDirection,portCOS.ClassOfServiceLevel,portCOS.PostPolicyPackets,portCOS.PostPolicyBytes,portCOS.DropPackets,portCOS.DropBytes,portCOS.IS24H,portCOS.ModelType,portCOS.ObjectType,portCOS.StrObjInstance,portCOS.InvalidityList,portCOS.rowid as myrowFROMONS15454_COS_pm_table portCOS,ne_info_table ni,module_type_table enWHEREportCOS.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDportCOS.NEDBAccessID = ni.NEDBAccessID;2.73 ONS15454_DS1_PM_FE_View
CREATE OR REPLACE VIEW ONS15454_DS1_PM_FE_VIEW ASSELECTni.NESysID as NESysId,en.ModuleName as ModuleName,csonet.PhysicalLoc,csonet.NEIfIndex as NEIfIndex,csonet.TimeStamp as TimeStamp,csonet.NEIfPmStatus as NEIfPmStatus,csonet.InMaintenance as InMaintenance,csonet.FeDS1FDLPathCV as FDLCodeViolations,csonet.FeDS1FDLPathES as FDLErrSecs,csonet.FeDS1FDLPathESA as FDLErrSecsTypeA,csonet.FeDS1FDLPathESB as FDLErrSecsTypeB,csonet.FeDS1FDLPathSES as FDLSevErrSecs,csonet.FeDS1FDLPathSEFS as FDLSevErrFrameSecs,csonet.FeDS1FDLPathCSS as FDLControlledSlipSecs,csonet.FeDS1FDLPathUAS as FDLUnavailableSecs,csonet.FeDS1FDLPathFC as FDLFailureCount,csonet.FeDS1FDLLineES as FDLLineErrSecs,csonet.NEDBAccessID as NEDBAccessID,csonet.thresholdList as ThresholdList,en.ModuleType,csonet.IS24H,csonet.ModelType,csonet.ObjectType,csonet.StrObjInstance,csonet.InvalidityList,csonet.rowid as myrowFROMONS15454_ds1_pm_table csonet,ne_info_table ni,module_type_table enWHEREcsonet.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDcsonet.NEDBAccessID = ni.NEDBAccessID;2.74 ONS15454_DS1_PM_View
CREATE OR REPLACE VIEW ONS15454_ds1_pm_view ASSELECTni.NESysID as NESysId,en.ModuleName as ModuleName,csonet.PhysicalLoc,csonet.NEIfIndex as NEIfIndex,csonet.TimeStamp as TimeStamp,csonet.NEIfPmStatus as NEIfPmStatus,csonet.InMaintenance as InMaintenance,csonet.DS1LineCodeViolations as LineCodeViolations,csonet.DS1LineErrSecs as LineErrSecs,csonet.DS1LineSevErrSecs as LineSevErrSecs,csonet.DS1RxPathAIS as RxAis,csonet.DS1RxPathErrSecs as RxErrSecs,csonet.DS1RxPathSAS as RxSas,csonet.DS1RxPAthSevErrSecs as RxSevErrSecs,csonet.DS1RxPathUnavailableSecs as RxUnavailSecs,csonet.DS1RxpathCodeViolations as RxCodeViolations,csonet.DS1TxPathAis as TxAis,csonet.DS1TxPathErrSecs as TxErrSecs,csonet.DS1TxPathSAS as TxSas,csonet.DS1TxPathSevErrSecs as TxSevErrSecs,csonet.DS1TxPathUnavailableSecs as TxUnavailSecs,csonet.DS1TxPathCodeViolations as TxCodeViolations,csonet.DS1LineLOSS,csonet.NEDBAccessID as NEDBAccessID,csonet.thresholdList as ThresholdList,en.ModuleType,csonet.IS24H,csonet.ModelType,csonet.ObjectType,csonet.StrObjInstance,csonet.InvalidityList,csonet.rowid as myrowFROMONS15454_ds1_pm_table csonet,ne_info_table ni,module_type_table enWHEREcsonet.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDcsonet.NEDBAccessID = ni.NEDBAccessID;2.75 ONS15454_DS3_PM_FE_View
CREATE OR REPLACE VIEW ONS15454_ds3_pm_fe_view ASSELECTni.NESysID as NESysId,en.ModuleName as ModuleName,csonet.PhysicalLoc,csonet.NEIfIndex as NEIfIndex,csonet.TimeStamp as TimeStamp,csonet.NEIfPmStatus as NEIfPmStatus,csonet.InMaintenance as InMaintenance,csonet.FeDS3CpBitCodeViolations as CPBitCodeViolations,csonet.FeDS3CpBitErrSecs as CPBitErrSecs,csonet.FeDS3CpBitSAS as CPBitSAS,csonet.FeDS3CpBitSevErrSecs as CPBitSevErrSecs,csonet.FeDS3CpBitUnavailableSecs as CPBitUnavailableSecs,csonet.NEDBAccessID as NEDBAccessID,csonet.thresholdList as ThresholdList,en.ModuleType,csonet.IS24H,csonet.ModelType,csonet.ObjectType,csonet.StrObjInstance,csonet.InvalidityList,csonet.rowid as myrowFROMONS15454_ds3_pm_table csonet,ne_info_table ni,module_type_table enWHEREcsonet.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDcsonet.NEDBAccessID = ni.NEDBAccessID;2.76 ONS15454_DS3_PM_View
CREATE OR REPLACE VIEW ONS15454_ds3_pm_view ASSELECTni.NESysID as NESysId,en.ModuleName as ModuleName,csonet.PhysicalLoc,csonet.NEIfIndex as NEIfIndex,csonet.TimeStamp as TimeStamp,csonet.NEIfPmStatus as NEIfPmStatus,csonet.InMaintenance as InMaintenance,csonet.DS3LineCodeViolations as LineCodeViolations,csonet.DS3LineErrSecs as LineErrSecs,csonet.DS3LineSevErrSecs as LineSevErrSecs,csonet.DS3LineLoss as LineLoss,csonet.DS3PBitAis as PbitAis,csonet.DS3PBitCodeViolations as PbitCodeViolations,csonet.DS3PBitErrSecs as PbitErrSecs,csonet.DS3PbitSas as PbitSas,csonet.DS3PbitSevErrSecs as PbitSevErrSecs,csonet.DS3PBitUnavailableSecs as PbitUnavailableSecs,csonet.DS3cpBitCodeViolations as CpbitCodeViolations,csonet.DS3cpBitErrSecs as CpbitErrSecs,csonet.DS3cpbitSas as CpbitSas,csonet.DS3cpBitSevErrSecs as CpbitSevErrSecs,csonet.DS3CpBitUnavailableSecs as CpbitUnavailableSecs,csonet.NEDBAccessID as NEDBAccessID,csonet.thresholdList as ThresholdList,en.ModuleType,csonet.IS24H,csonet.ModelType,csonet.ObjectType,csonet.StrObjInstance,csonet.InvalidityList,csonet.rowid as myrowFROMONS15454_ds3_pm_table csonet,ne_info_table ni,module_type_table enWHEREcsonet.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDcsonet.NEDBAccessID = ni.NEDBAccessID;2.77 ONS15454_DWDM_Ring_View
CREATE OR REPLACE VIEW ONS15454_DWDM_RING_VIEW asSELECTne.NESysid,eit.col6 as RingName,eit.col3 as WestDirection,eit.col5 as EastDirection,ne.NEDbaccessid,ne.rowid as myrowFROMne_info_table ne,eqpt_info_table eitWHEREne.NEDbaccessid = eit.NEDbaccessid ANDeit.ObjectIndex = 235;2.78 ONS15454_Enet_PM_View
CREATE OR REPLACE VIEW ONS15454_enet_pm_view ASSELECTni.NESysID,ni.NEDbaccessid,en.ModuleName,en.ModuleType,enet.Physicalloc,enet.NEIfIndex,enet.TimeStamp,enet.NEIfPmStatus,enet.InMaintenance,enet.ThresholdList,enet.IfInOctets,enet.RxPackets,enet.IfInUcastPkts,enet.IfInMulticastPkts,enet.IfInBroadcastPkts,enet.IfInErrors,enet.IfOutOctets,decode(en.Moduletype,102,to_char(enet.TxPackets), 103,to_char(enet.TxPackets),118,to_char(enet.TxPackets), 119,to_char(enet.TxPackets), 181,to_char(enet.TxPackets), 182,to_char(enet.TxPackets),183,to_char(enet.TxPackets), 184,to_char(enet.TxPackets), get_enet_value2(enet.IfOutUcastPkts,enet.IfOutMulticastPkts,enet.IfOutBroadc astPkts) ) as TxPackets,enet.IfOutUcastPkts,enet.IfOutMulticastPkts,enet.IfOutBroadcastPkts,enet.Dot3StatsAlignmentErrors,enet.Dot3StatsFCSErrors,enet.Dot3StatsSingleCollisionFrames,enet.Dot3StatsMultiCollisionFrames,enet.Dot3StatsDeferredTransmissions,enet.Dot3StatsLateCollisions,enet.Dot3StatsExcessiveCollisions,enet.EtherStatsUndersizePkts,enet.EtherStatsFragments,enet.EtherStatsOversizePkts,enet.EtherStatsJabbers,decode(en.Moduletype,102, to_char(enet.RxTotalErrors), 103, to_char(enet.RxTotalErrors), 118, to_char(enet.RxTotalErrors), 119, to_char(enet.RxTotalErrors), 62, to_char(enet.RxTotalErrors), get_enet_value2(enet.Dot3StatsFCSErrors,enet.Dot3StatsAlignmentErrors,enet.EtherSta tsUnderSizePKTS, enet.ETHERSTATSOVERSIZEPKTS,enet.ETHERSTATSFRAGMENTS,enet.ETHERSTATSJABBERS)) as Rx_TOTAL_ERRORS,decode(en.Moduletype, 102, enet.RxRunts, 103, enet.RxRunts, 118, enet.RxRunts, 119, enet.RxRunts, 62, enet.RxRunts, enet.ETHERSTATSFRAGMENTS) as Rx_RUNTS,enet.RxGIANTS as rx_giants,decode(en.Moduletype, 102, enet.TxCollisions, 103, enet.TxCollisions, 118, enet.TxCollisions, 119, enet.TxCollisions,get_enet_value(enet.Dot3StatsSingleCollisionFrames,enet.Dot3StatsMultiCollisionFram es) ) as Tx_Collisions,enet.RxPauseFrames,enet.TxPauseFrames,enet.RxPktsDropInternalCongestion,enet.TxPktsDropInternalCongestion,enet.IS24H,enet.EtherUtilizationStats,enet.RxGMACDropCounts,enet.RxThresholdOversizes,enet.PortDropCounts,enet.TxGiants,enet.HDLCPktDrops,enet.RxControlFrames,enet.RXUnknownOpCodeFrames,enet.IfInErrorBytePkts,enet.IfInFramingErrorPkts,enet.IfInJunkInterPkts,enet.IfInDiscards,enet.IfOutDiscards,enet.Dot3StatsFrameTooLong,enet.Dot3StatsCarrierSenseErrors,enet.Dot3StatsSQETestErrors,enet.EtherStatsPkts64Octets,enet.EtherStatsPkts65to127Octets,enet.EtherStatsPkts128to255Octets,enet.EtherStatsPkts256to511Octets,enet.EtherStatsPkts512to1023Octets,enet.EtherStatsPkts1024to1518Octets,enet.EtherStatsBroadcastPkts,enet.EtherStatsMulticastPkts,enet.EtherStatsOctets,enet.EtherStatsCollisions,enet.EtherStatsCollisionFrames,enet.EtherStatsCRCAlignErrors,enet.MediaIndStatsRxFramesTruncated,enet.MediaIndStatsRxFramesTooLong,enet.MediaIndStatsRxFramesBadCRC,enet.MediaIndStatsTxFramesBadCRC,enet.MediaIndStatsRxShortPkts,enet.MediaIndStatsOversizeDropped,enet.IfOutErrors,enet.EtherStatsPkts,enet.Dot3StatsInternalMacTxErrors,enet.Dot3StatsInternalMacRxErrors,enet.Dot3StatsSymbolErrors,enet.RxEtherUtilizationStats,enet.TxEtherUtilizationStats,enet.StatsLineLastClearedTime,enet.MEDIAINDSTATSTXFRAMESTOOLONG,enet.ModelType,enet.ObjectType,enet.StrObjInstance,enet.InvalidityList,enet.rowid as myrowFROMons15454_enet_pm_table enet,ne_info_table ni,module_type_table enWHEREenet.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDenet.NEDBAccessID = ni.NEDBAccessID;2.79 ONS15454_FC_PM_View
CREATE OR REPLACE VIEW ONS15454_FC_PM_VIEW ASSELECTni.NESysID,ni.NEDbaccessid,en.ModuleName,en.ModuleType,fc.Physicalloc,fc.NEIfIndex,fc.TimeStamp,fc.NEIfPmStatus,fc.ThresholdList,fc.InMaintenance,fc.fibreStatsInvalidOrderedSets,fc.fibreStatsEncodingDispErrors,fc.fibreStatsRxTotalErrors,fc.fibreStatsRxFramesTruncated,fc.fibreStatsRxFramesTooLong,fc.fibreStatsRxFramesBadCRC,fc.fibreStatsRxFrames,fc.fibreStatsRxOctets,fc.fibreStatsRxDiscards,fc.fibreStatsTxFramesBadCRC,fc.fibreStatsTxFrames,fc.fibreStatsTxOctets,fc.fibreStatsTxDiscards,fc.fibreStatsLinkResets,fc.gfpStatsRxSBitErrors,fc.gfpStatsRxMBitErrors,fc.gfpStatsRxTypeInvalid,fc.gfpStatsRxSblkCRCErrors,fc.RxFCUtilizationStats,fc.TxFCUtilizationStats,fc.StatsLineLastClearedTime,fc.gfpStatsCSFRaised,fc.gfpStatsRoundTripLatency,fc.IfInErrors,fc.FibreStatsLinkRecoveries,fc.FCIngressRxDistanceExtBuffers,fc.FCEgressTxDistanceExtBuffers,fc.FibreStatsRxCredits,fc.FibreStatsTxCredits,fc.FibreStatsZeroTxCredits,fc.TxPackets,fc.RxPackets,fc.IS24H,fc.ModelType,fc.ObjectType,fc.StrObjInstance,fc.InvalidityList,fc.rowid as myrowFROMons15454_fc_pm_table fc,ne_info_table ni,module_type_table enWHEREfc.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDfc.NEDBAccessID = ni.NEDBAccessID;2.80 ONS15454_IfX_PM_View
CREATE OR REPLACE VIEW ONS15454_ifX_pm_view ASSELECTni.NESysID,ni.NEDbaccessid,en.ModuleName,en.ModuleType,ifX.Physicalloc,ifX.NEIfIndex,ifX.TimeStamp,ifX.NEIfPmStatus,ifX.InMaintenance,ifX.IfName,ifX.IfHCInOctets,ifX.IfHCOutOctets,ifX.IfHCInUcastPkts,ifX.IfHCOutUcastPkts,ifX.IfHCInMulticastPkts,ifX.IfHCOutMulticastPkts,ifX.IfHCInBroadcastPkts,ifX.IfHCOutBroadcastPkts,ifX.ifInDiscards,ifX.ifOutDiscards,ifX.IS24H,ifX.ModelType,ifX.ObjectType,ifX.StrObjInstance,ifX.InvalidityList,ifX.rowid as myrowFROMons15454_ifX_pm_table ifX,ne_info_table ni,module_type_table enWHEREifX.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDifX.NEDBAccessID = ni.NEDBAccessID;2.81 ONS15454_Inventory_View
CREATE OR REPLACE VIEW ONS15454_inventory_view ASSELECTinfo.NESysID as NESysId,inv.Name as Name,inv.HWPartNumber as HdrPartNum,inv.CleiCode as CleiCode,inv.HardwareRevision as HardRevision,inv.SerialNumber as SerialNum,inv.PhysicalLoc as PhysicalLoc,module.ModuleName as EquipType,inv.AdminState as AdminState,inv.ServiceState as ServiceState,inv.Name as ActualEquipType,inv.EquipmentState as EquipState,inv.FirmwareVersion as FirmwareVersion,inv.ApplicationFileName as ApplicationFileName,inv.EntityID as EntityId,inv.ExtraInfo as ExtraInfo,info.NEDBAccessId,module.ModuleType,inv.InventoryCode,inv.ProductId,inv.VersionId,inv.rowid as myrowFROMne_info_table info,ONS15454_ne_inventory_table inv,module_type_table moduleWHEREinfo.NEDBAccessID = inv.NEDBAccessID ANDinfo.NEModelType = module.ModelType ANDinv.EquipmentType = module.ModuleType;2.82 ONS15454_MatchStmt_QoS_PM_View
CREATE OR REPLACE ONS15454_matchstmt_qos_pm_view ASSELECTni.NESysID,ni.NEDbaccessid,en.ModuleName,en.ModuleType,mtQos.Physicalloc,mtQos.NEIfIndex,mtQos.TimeStamp,mtQos.NEIfPmStatus,mtQos.InMaintenance,mtQos.CBQosMatchPrePolicyPkt64,mtQos.CBQosMatchPrePolicyByte64,mtQos.IS24H,mtQos.ModelType,mtQos.ObjectType,mtQos.StrObjInstance,mtQos.InvalidityList,mtQos.rowid as myrowFROMONS15454_match_stmt_pm_table mtQos,ne_info_table ni,module_type_table enWHEREmtQos.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDmtQos.NEDBAccessID = ni.NEDBAccessID;2.83 ONS15454_Optics_PM_View
CREATE OR REPLACE VIEW ONS15454_OPTICS_PM_VIEW ASSELECTni.NESysID as NESYSID,en.ModuleName as MODULENAME,phy.PhysicalLoc as PHYSICALLOC,phy.NEIfIndex as NEIFINDEX,phy.TimeStamp as TIMESTAMP,phy.NEIfPMStatus as NEIFPMSTATUS,phy.inMaintenance as INMAINTENANCE,phy.MinLaserBias as MINLASERBIAS,phy.AvgLaserBias as AVGLASERBIAS,phy.MaxLaserBias as MAXLASERBIAS,phy.MinLaserTemp as MINLASERTEMP,phy.AvgLaserTemp as AVGLASERTEMP,phy.MaxLaserTemp as MAXLASERTEMP,phy.MinReceivedLaserTemp as MINRECEIVEDLASERTEMP,phy.AvgReceivedLaserTemp as AVGRECEIVEDLASERTEMP,phy.MaxReceivedLaserTemp as MAXRECEIVEDLASERTEMP,phy.MinTransReceiverVoltage as MINTRANSRECEIVERVOLTAGE,phy.AvgTransReceiverVoltage as AVGTRANSRECEIVERVOLTAGE,phy.MaxTransReceiverVoltage as MAXTRANSRECEIVERVOLTAGE,phy.MinTransmittedPower as MINTRANSMITTEDPOWER,phy.AvgTransmittedPower as AVGTRANSMITTEDPOWER,phy.MaxTransmittedPower as MAXTRANSMITTEDPOWER,phy.MinReceivedPower as MINRECEIVEDPOWER,phy.AvgReceivedPower as AVGRECEIVEDPOWER,phy.MaxReceivedPower as MAXRECEIVEDPOWER,phy.MinPassThroughPower as MINPASSTHROUGHPOWER,phy.AvgPassThroughPower as AVGPASSTHROUGHPOWER,phy.MaxPassThroughPower as MAXPASSTHROUGHPOWER,ni.NEDbaccessid as NEDBACCESSID,phy.thresholdList as ThresholdList,en.ModuleType as MODULETYPE,phy.IS24H as IS24H,phy.ModelType,phy.ObjectType,phy.StrObjInstance,phy.InvalidityList,phy.rowid as myrowFROMONS15454_PHY_LAYER_PM_Table phy,ne_info_table ni,module_type_table enWHEREphy.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDphy.NEDBAccessID = ni.NEDBAccessID;2.84 ONS15454_OSPF_Area_Range_View
CREATE OR REPLACE VIEW ONS15454_OSPF_AREA_RANGE_VIEW asSELECTne.NESysid,mtt.modulename as ModuleName,eit.Physicalloc as Physicalloc,eit.IfIndex as IfIndex,eit.col4 as RangeAddress,eit.col5 as MaskLength,eit.col6 as Mask,eit.col7 as Advertise,eit.NEDbaccessid as NEDbaccessid,eit.ModuleType as ModuleType,ne.rowid as myrowFROMne_info_table ne,eqpt_info_table eit,module_type_table mttWHEREne.NEDbaccessid = eit.NEDbaccessid ANDne.NEModelType = mtt.ModelType ANDeit.ModuleType = mtt.ModuleType ANDmtt.Modeltype = 3 ANDmtt.ModuleType = 0 ANDeit.ObjectIndex = 4003;2.85 ONS15454_OTN_FEC_PM_View
CREATE OR REPLACE VIEW ONS15454_OTN_fec_pm_view ASSELECTni.NESysID as NESysId,en.ModuleName as ModuleName,cotn.PhysicalLoc,cotn.NEIfIndex as NEIfIndex,cotn.TimeStamp as TimeStamp,cotn.NEIfPmStatus as NEIfPmStatus,cotn.InMaintenance as InMaintenance,cotn.BitErrsCorrected as BitErrsCorrected,cotn.ByteErrsCorrected as ByteErrsCorrected,cotn.ZeroBitErrsDetected as ZeroBitErrsDetected,cotn.OneBitErrsDetected as OneBitErrsDetected,cotn.UnCorrectableWord as UnCorrectableWord,cotn.NEDBAccessID as NEDBAccessID,cotn.thresholdList as ThresholdList,en.ModuleType,cotn.IS24H,cotn.ModelType,cotn.ObjectType,cotn.StrObjInstance,cotn.InvalidityList,cotn.rowid as myrowFROMONS15454_OTN_FEC_PM_Table cotn,ne_info_table ni,module_type_table enWHEREcotn.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDcotn.NEDBAccessID = ni.NEDBAccessID;2.86 ONS15454_OTN_Path_PM_FE_View
CREATE OR REPLACE VIEW ONS15454_otn_path_pm_fe_view ASSELECTni.NESysID as NESysId,en.ModuleName as ModuleName,cotn.PhysicalLoc,cotn.NEIfIndex as NEIfIndex,cotn.TimeStamp as TimeStamp,cotn.NEIfPmStatus as NEIfPmStatus,cotn.InMaintenance InMaintenance,cotn.NEDBAccessID as NEDBAccessId,en.ModuleType,cotn.IS24H,cotn.thresholdList as ThresholdList,cotn.FeErrSecs as FeErrSecs,cotn.FeSevErrSecs as FeSevErrSecs,cotn.FeUnavailableSecs as FeUnavailableSecs,cotn.FeBackGroundBlockErrs as FeBackGroundBlockErrs,cotn.FeFailureCount as FeFailureCount,cotn.FeErrSecsRatio as FeErrSecsRatio,cotn.FeSevErrSecsRatio as FeSevErrSecsRatio,cotn.FeBackGroundBlockErrRatio as FeBackGroundBlockErrRatio,cotn.ModelType,cotn.ObjectType,cotn.StrObjInstance,cotn.InvalidityList,cotn.rowid as myrowFROMONS15454_OTN_PATH_PM_Table cotn,ne_info_table ni,module_type_table enWHEREcotn.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDcotn.NEDBAccessID = ni.NEDBAccessID;2.87 ONS15454_OTN_Path_PM_View
CREATE OR REPLACE VIEW ONS15454_OTN_path_pm_view ASSELECTni.NESysID as NESysId,en.ModuleName as ModuleName,cotn.PhysicalLoc,cotn.NEIfIndex as NEIfIndex,cotn.TimeStamp as TimeStamp,cotn.NEIfPmStatus as NEIfPmStatus,cotn.InMaintenance as InMaintenance,cotn.ErrSecs as ErrSecs,cotn.SevErrSecs as SevErrSecs,cotn.UnavailableSecs as UnAvailableSecs,cotn.BackGroundBlockErr as BackGroundBlockErr,cotn.FailureCount as FailureCount,cotn.ErrSecsRatio as ErrSecsRatio,cotn.SevErrSecsRatio as SevErrSecsRatio,cotn.BackGroundBlockErrRatio as BackGroundBlockErrRatio,cotn.NEDBAccessID as NEDBAccessID,cotn.thresholdList as ThresholdList,en.ModuleType,cotn.IS24H,cotn.ObjectType,cotn.StrObjInstance,cotn.InvalidityList,cotn.rowid as myrowFROMONS15454_OTN_PATH_PM_Table cotn,ne_info_table ni,module_type_table enWHEREcotn.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDcotn.NEDBAccessID = ni.NEDBAccessID;2.88 ONS15454_OTN_Sec_PM_FE_View
CREATE OR REPLACE VIEW ONS15454_otn_sec_pm_fe_view ASSELECTni.NESysID as NESysId,en.ModuleName as ModuleName,cotn.PhysicalLoc,cotn.NEIfIndex as NEIfIndex,cotn.TimeStamp as TimeStamp,cotn.NEIfPmStatus as NEIfPmStatus,cotn.InMaintenance InMaintenance,cotn.NEDBAccessID as NEDBAccessId,en.ModuleType,cotn.IS24H,cotn.thresholdList as ThresholdList,cotn.FeErrSecs as FeErrSecs,cotn.FeSevErrSecs as FeSevErrSecs,cotn.FeUnavailableSecs as FeUnavailableSecs,cotn.FeBackGroundBlockErrs as FeBackGroundBlockErrs,cotn.FeFailureCount as FeFailureCount,cotn.FeErrSecsRatio as FeErrSecsRatio,cotn.FeSevErrSecsRatio as FeSevErrSecsRatio,cotn.FeBackGroundBlockErrRatio as FeBackGroundBlockErrRatio,cotn.ModelType,cotn.ObjectType,cotn.StrObjInstance,cotn.InvalidityList,cotn.rowid as myrowFROMONS15454_OTN_SEC_PM_Table cotn,ne_info_table ni,module_type_table enWHEREcotn.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDcotn.NEDBAccessID = ni.NEDBAccessID;2.89 ONS15454_OTN_Sec_PM_View
CREATE OR REPLACE VIEW ONS15454_OTN_sec_pm_view ASSELECTni.NESysID as NESysId,en.ModuleName as ModuleName,cotn.PhysicalLoc,cotn.NEIfIndex as NEIfIndex,cotn.TimeStamp as TimeStamp,cotn.NEIfPmStatus as NEIfPmStatus,cotn.InMaintenance as InMaintenance,cotn.ErrSecs as ErrSecs,cotn.SevErrSecs as SevErrSecs,cotn.UnavailableSecs as UnAvailableSecs,cotn.BackGroundBlockErr as BackGroundBlockErr,cotn.FailureCount as FailureCount,cotn.ErrSecsRatio as ErrSecsRatio,cotn.SevErrSecsRatio as SevErrSecsRatio,cotn.BackGroundBlockErrRatio as BackGroundBlockErrRatio,cotn.NEDBAccessID as NEDBAccessID,cotn.thresholdList as ThresholdList,en.ModuleType,cotn.IS24H,cotn.ModelType,cotn.ObjectType,cotn.StrObjInstance,cotn.InvalidityList,cotn.rowid as myrowFROMONS15454_OTN_SEC_PM_Table cotn,ne_info_table ni,module_type_table enWHEREcotn.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDcotn.NEDBAccessID = ni.NEDBAccessID;2.90 ONS15454_Phy_Layer_PM_VIEW
CREATE OR REPLACE VIEW ONS15454_PHY_LAYER_PM_VIEW ASSELECTni.NESysID,ni.NEDbaccessid,en.ModuleName,en.ModuleType,phy.PhysicalLoc,phy.NEIfIndex,phy.TimeStamp,phy.NEIfPMStatus,phy.inMaintenance,phy.LaserBiasCurrent,phy.OpticalPowerTransmitted,phy.OpticalPowerReceived,phy.thresholdList as ThresholdList,phy.IS24H,phy.ModelType,phy.ObjectType,phy.StrObjInstance,phy.InvalidityList,phy.rowid as myrowFROMONS15454_PHY_LAYER_PM_Table phy,ne_info_table ni,module_type_table enWHEREphy.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDphy.NEDBAccessID = ni.NEDBAccessID;2.91 ONS15454_Policy_QoS_PM_View
CREATE OR REPLACE VIEW ONS15454_policy_qos_pm_view ASSELECTni.NESysID,ni.NEDbaccessid,en.ModuleName,en.ModuleType,plQos.Physicalloc,plQos.NEIfIndex,plQos.TimeStamp,plQos.NEIfPmStatus,plQos.InMaintenance,plQos.CBQosPoliceConformedPkt64,plQos.CBQosPoliceConformedByte64,plQos.CBQosPoliceExceededPkt64,plQos.CBQosPoliceExceededByte64,plQos.CBQosPoliceViolatedPkt64,plQos.CBQosPoliceViolatedByte64,plQos.IS24H,plQos.ModelType,plQos.ObjectType,plQos.StrObjInstance,plQos.InvalidityList,plQos.rowid as myrowFROMONS15454_police_pm_table plQos,ne_info_table ni,module_type_table enWHEREplQos.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDplQos.NEDBAccessID = ni.NEDBAccessID;2.92 ONS15454_POS_PM_View
CREATE OR REPLACE VIEW ONS15454_pos_pm_view ASSELECTni.NESysID,ni.NEDbaccessid,en.ModuleName,en.ModuleType,pos.Physicalloc,pos.NEIfIndex,pos.TimeStamp,pos.NEIfPmStatus,pos.InMaintenance,pos.PosStatsRxPreHdlcBytes,pos.PosStatsRxPostHdlcBytes,pos.PosStatsRxPackets,pos.PosStatsRxNormalPackets,pos.PosStatsRxShorts,pos.PosStatsRxRunts,pos.PosStatsRxLongs,pos.PosStatsRxTotalErrors,pos.PosStatsRxCrcErrors,pos.PosStatsRxInputDropPackets,pos.PosStatsRxInputAbortPackets,pos.PosStatsTxPreHdlcBytes,pos.PosStatsTxPostHdlcBytes,pos.PosStatsTxPackets,pos.PosStatsDropCounts,pos.EtherStatsDropEvents,pos.GfpStatsRxSBitErrors,pos.GfpStatsRxMBitErrors,pos.GfpStatsRxTypeInvalid,pos.GfpStatsRxCRCErrors,pos.GfpStatsRxCIDInvalid,pos.GfpStatsCSFRaised,pos.GfpStatsRxFrame,pos.GfpStatsTxFrame,pos.GfpStatsRxOctets,pos.GfpStatsTxOctets,pos.GfpStatsLFDRaised,pos.MediaIndStatsRxFramesTruncated,pos.MediaIndStatsRxFramesTooLong,pos.MediaIndStatsRxFramesBadCRC,pos.MediaIndStatsRxShortPkts,pos.hdlcInOctets,pos.hdlcRxAborts,pos.hdlcOutOctets,pos.ifInOctets,pos.ifOutOctets,pos.rxPktsDropInternalCongestion,pos.ifInDiscards,pos.RxEtherUtilizationStats as Rx_Utilization_Stats,pos.TxEtherUtilizationStats as Tx_Utilization_Stats,pos.StatsLineLastClearedTime,pos.thresholdList as ThresholdList,pos.IS24H,pos.ModelType,pos.ObjectType,pos.StrObjInstance,pos.InvalidityList,pos.rowid as myrowFROMons15454_pos_pm_table pos,ne_info_table ni,module_type_table enWHEREpos.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDpos.NEDBAccessID = ni.NEDBAccessID;2.93 ONS15454_Ring_Map_View
CREATE OR REPLACE VIEW ONS15454_RING_MAP_VIEW asSELECTne.NESysid,mtt.modulename as ModuleName,eit.Physicalloc as Physicalloc,eit.IfIndex as IfIndex,eit.col4 as NodeId,eit.col5 as IPAddress,eit.NEDbaccessid as NEDbaccessid,eit.ModuleType as ModuleType,ne.rowid as myrowFROMne_info_table ne,eqpt_info_table eit,module_type_table mttWHEREne.NEDbaccessid = eit.NEDbaccessid ANDne.NEModelType = mtt.ModelType ANDeit.ModuleType = mtt.ModuleType ANDmtt.Modeltype = 3 ANDmtt.ModuleType = 0 ANDeit.ObjectIndex = 4008;2.94 ONS15454_Security_View
CREATE OR REPLACE VIEW ONS15454_SECURITY_VIEW asSELECTne.NESysid,mtt.modulename as ModuleName,eit.Physicalloc as Physicalloc,eit.IfIndex as IfIndex,eit.col5 as Name,eit.col6 as Password,eit.col7 as SecurityLevel,eit.NEDbaccessid as NEDbaccessid,eit.ModuleType as ModuleType,ne.rowid as myrowFROMne_info_table ne,eqpt_info_table eit,module_type_table mttWHEREne.NEDbaccessid = eit.NEDbaccessid ANDne.NEModelType = mtt.ModelType ANDeit.ModuleType = mtt.ModuleType ANDmtt.Modeltype = 3 ANDmtt.ModuleType = 0 ANDeit.ObjectIndex = 4051;2.95 ONS15454_SNMP_Trap_Dest_View
CREATE OR REPLACE VIEW ONS15454_SNMP_TRAP_DEST_VIEW asSELECTne.NESysid,mtt.modulename as ModuleName,eit.Physicalloc as Physicalloc,eit.IfIndex as IfIndex,eit.col4 as IPAddress,eit.col5 as CommunityName,eit.col6 as UPDPort,eit.col7 as TrapVersion,eit.col8 as MaxTrapsPerSecond,eit.NEDbaccessid as NEDbaccessid,eit.ModuleType as ModuleType,ne.rowid as myrowFROMne_info_table ne,eqpt_info_table eit,module_type_table mttWHEREne.NEDbaccessid = eit.NEDbaccessid ANDne.NEModelType = mtt.ModelType ANDeit.ModuleType = mtt.ModuleType ANDmtt.Modeltype = 3 ANDmtt.ModuleType = 0 ANDeit.ObjectIndex = 4005;2.96 ONS15454_SONET_Line_PM_FE_View
CREATE OR REPLACE VIEW ONS15454_sonet_line_pm_fe_view ASSELECTni.NESysID as NESysId,en.ModuleName as ModuleName,csonet.PhysicalLoc,csonet.NEIfIndex as NEIfIndex,csonet.TimeStamp as TimeStamp,csonet.NEIfPmStatus as NEIfPmStatus,csonet.InMaintenance InMaintenance,csonet.NEDBAccessID as NEDBAccessId,en.ModuleType,csonet.IS24H,csonet.thresholdList as ThresholdList,csonet.FeCodeViolations as FeCodeViolations,csonet.FeErrSecs as FeErrSecs,csonet.FeSevErrSecs as FeSevErrSecs,csonet.FeUnavailableSecs as FeUnavailableSecs,csonet.FeFcL as FeFcL,csonet.ModelType,csonet.ObjectType,csonet.StrObjInstance,csonet.InvalidityList,csonet.rowid as myrowFROMONS15454_sonet_line_pm_table csonet,ne_info_table ni,module_type_table enWHEREcsonet.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDcsonet.NEDBAccessID = ni.NEDBAccessID;2.97 ONS15454_SONET_Line_PM_View
CREATE OR REPLACE VIEW ONS15454_sonet_line_pm_view ASSELECTni.NESysID as NESysId,en.ModuleName as ModuleName,csonet.PhysicalLoc,csonet.NEIfIndex as NEIfIndex,csonet.TimeStamp as TimeStamp,csonet.NEIfPmStatus as NEIfPmStatus,csonet.InMaintenance InMaintenance,csonet.CodeViolations as CodeViolations,csonet.ErrSecs as ErrSecs,csonet.SevErrSecs as SevErrSecs,csonet.UnavailableSecs as UnavailSecs,csonet.PpjcPdet as PpjcPdet,csonet.NpjcPdet as NpjcPdet,csonet.PpjcPgen as PpjcPgen,csonet.NpjcPgen as NpjcPgen,csonet.FcL as Fcl,csonet.Psc as Psc,csonet.Psd as Psd,csonet.PjDiff as PjDiff,csonet.PjpSec as PjpSec,csonet.PjnSec as PjnSec,csonet.Pscw as Pscw,csonet.Psdw as Psdw,csonet.Pscr as Pscr,csonet.Psdr as Psdr,csonet.Pscs as Pscs,csonet.Psds as Psds,csonet.NEDBAccessID as NEDBAccessId,csonet.thresholdList as ThresholdList,en.ModuleType,csonet.IS24H,csonet.ModelType,csonet.ObjectType,csonet.StrObjInstance,csonet.InvalidityList,csonet.rowid as myrowFROMONS15454_sonet_line_pm_table csonet,ne_info_table ni,module_type_table enWHEREcsonet.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDcsonet.NEDBAccessID = ni.NEDBAccessID;2.98 ONS15454_SONET_Path_PM_FE_View
CREATE OR REPLACE VIEW ONS15454_sonet_path_pm_fe_view ASSELECTni.NESysID as NESysId,en.ModuleName as ModuleName,csonet.PhysicalLoc,csonet.NEIfIndex as NEIfIndex,csonet.TimeStamp as TimeStamp,csonet.NEIfPmStatus as NEIfPmStatus,csonet.InMaintenance as InMaintenance,csonet.NEDBAccessID as NEDBAccessID,csonet.thresholdList as ThresholdList,csonet.FeSonetPathCodeViolations as FePathCodeViolations,csonet.FeSonetPathErrSecs as FePathErrSecs,csonet.FeSonetPathSevErrSecs as FePathSevErrSecs,csonet.FeSonetPathUnavailableSecs as FePathUnavailableSecs,csonet.FeSonetPathFC as FePathFC,en.ModuleType,csonet.IS24H,csonet.ModelType,csonet.ObjectType,csonet.StrObjInstance,csonet.InvalidityList,csonet.rowid as myrowFROMONS15454_sonet_path_pm_table csonet,ne_info_table ni,module_type_table enWHEREcsonet.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDcsonet.NEDBAccessID = ni.NEDBAccessID;2.99 ONS15454_SONET_Path_PM_View
CREATE OR REPLACE VIEW ONS15454_sonet_path_pm_view ASSELECTni.NESysID as NESysId,en.ModuleName as ModuleName,csonet.PhysicalLoc,csonet.NEIfIndex as NEIfIndex,csonet.TimeStamp as TimeStamp,csonet.NEIfPmStatus as NEIfPmStatus,csonet.InMaintenance as InMaintenance,csonet.SonetPathCodeViolations as CodeViolations,csonet.SonetPathErrSecs as ErrSecs,csonet.SonetPathSevErrSecs SevErrSecs,csonet.SonetPathUnavailableSecs as LineUnavailSecs,csonet.SonetPathFC as SonetPathFC,csonet.PpjcPdet as PpjcPdet,csonet.NpjcPdet as NpjcPdet,csonet.PpjcPgen as PpjcPgen,csonet.NpjcPgen as NpjcPgen,csonet.PjDiff as PjDiff,csonet.PjpSec as PjpSec,csonet.PjnSec as PjnSec,csonet.StsPathWidth as StsPathWidth,csonet.NEDBAccessID as NEDBAccessID,csonet.thresholdList as ThresholdList,en.ModuleType,csonet.IS24H,csonet.ModelType,csonet.ObjectType,csonet.StrObjInstance,csonet.InvalidityList,csonet.rowid as myrowFROMONS15454_sonet_path_pm_table csonet,ne_info_table ni,module_type_table enWHEREcsonet.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDcsonet.NEDBAccessID = ni.NEDBAccessID;2.100 ONS15454_SONET_Section_PM_View
CREATE OR REPLACE VIEW ONS15454_sonet_section_pm_view ASSELECTni.NESysID as NESysId,en.ModuleName as ModuleName,csonet.PhysicalLoc,csonet.NEIfIndex as NEIfIndex,csonet.TimeStamp as TimeStamp,csonet.NEIfPmStatus as NEIfPmStatus,csonet.InMaintenance as InMaintenance,csonet.SevErrFrameSecs as ErrFrameSecs,csonet.CodeViolations as CodeViolations,csonet.ErrSecs as ErrSecs,csonet.SevErrSecs as SevErrSecs,csonet.NEDBAccessID as NEDBAccessID,csonet.thresholdList as ThresholdList,en.ModuleType,csonet.IS24H,csonet.ModelType,csonet.ObjectType,csonet.StrObjInstance,csonet.InvalidityList,csonet.rowid as myrowFROMONS15454_sonet_sec_pm_table csonet,ne_info_table ni,module_type_table enWHEREcsonet.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDcsonet.NEDBAccessID = ni.NEDBAccessID;2.101 ONS15454_SONET_VT_PM_FE_View
CREATE OR REPLACE VIEW ONS15454_sonet_vt_pm_fe_view ASSELECTni.NESysID as NESysId,en.ModuleName as ModuleName,csonet.PhysicalLoc,csonet.NEIfIndex as NEIfIndex,csonet.TimeStamp as TimeStamp,csonet.NEIfPmStatus as NEIfPmStatus,csonet.InMaintenance as InMaintenance,csonet.NEDBAccessID as NEDBAccessID,csonet.thresholdList as ThresholdList,csonet.FeSonetVTCodeViolations as FeVTCodeViolations,csonet.FeSonetVTErrSecs as FeVTErrSecs,csonet.FeSonetVTSevErrSecs as FeVTSevErrSecs,csonet.FeSonetLineUnavailableSecs as FeLineUnavailableSecs,en.ModuleType,csonet.IS24H,csonet.ModelType,csonet.ObjectType,csonet.StrObjInstance,csonet.InvalidityList,csonet.rowid as myrowFROMONS15454_sonet_vt_pm_table csonet,ne_info_table ni,module_type_table enWHEREcsonet.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDcsonet.NEDBAccessID = ni.NEDBAccessID;2.102 ONS15454_SONET_VT_PM_View
CREATE OR REPLACE VIEW ONS15454_sonet_vt_pm_view ASSELECTni.NESysID as NESysId,en.ModuleName as ModuleName,csonet.PhysicalLoc,csonet.NEIfIndex as NEIfIndex,csonet.TimeStamp as TimeStamp,csonet.NEIfPmStatus as NEIfPmStatus,csonet.InMaintenance as InMaintenance,csonet.SonetVTCodeViolations as CodeViolations,csonet.SonetVTErrSecs as VtErrSecs,csonet.SonetVTSevErrSecs as LineSevErrSecs,csonet.SonetLineUnavailableSecs as LineUnavailSecs,csonet.NEDBAccessID as NEDBAccessID,csonet.thresholdList as ThresholdList,en.ModuleType,csonet.IS24H,csonet.ModelType,csonet.ObjectType,csonet.StrObjInstance,csonet.InvalidityList,csonet.rowid as myrowFROMONS15454_sonet_vt_pm_table csonet,ne_info_table ni,module_type_table enWHEREcsonet.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDcsonet.NEDBAccessID = ni.NEDBAccessID;2.103 ONS15454_Spanning_Trees_View
CREATE OR REPLACE VIEW ONS15454_SPANING_TREES_VIEW asSELECTne.NESysid,mtt.modulename as ModuleName,eit.Physicalloc as Physicalloc,eit.IfIndex as IfIndex,eit.col5 as RowNo,eit.col6 as Priority,eit.col7 as BridgeMaxAge,eit.col8 as BridgeHelloTime,eit.col8 as BridgeForwardDelay,eit.NEDbaccessid as NEDbaccessid,eit.ModuleType as ModuleType,ne.rowid as myrowFROMne_info_table ne,eqpt_info_table eit,module_type_table mttWHEREne.NEDbaccessid = eit.NEDbaccessid ANDne.NEModelType = mtt.ModelType ANDeit.ModuleType = mtt.ModuleType ANDmtt.Modeltype = 3 ANDmtt.ModuleType = 0 ANDeit.ObjectIndex = 4010;2.104 ONS15454_Static_Route_View
CREATE OR REPLACE VIEW ons15454_static_route_view ASSELECTne.NESysid,mtt.modulename as ModuleName,eit.Physicalloc as Physicalloc,eit.IfIndex as IfIndex,eit.col2 as Destination,eit.col3 as Mask,eit.col4 as NextHop,eit.col5 as Cost,eit.NEDbaccessid as NEDbaccessid,eit.ModuleType as ModuleType,ne.rowid as myrowFROMne_info_table ne,eqpt_info_table eit,module_type_table mttWHEREne.NEDbaccessid = eit.NEDbaccessid ANDne.NEModelType = mtt.ModelType ANDeit.ModuleType = mtt.ModuleType ANDmtt.Modeltype = 3 ANDmtt.ModuleType = 0 ANDeit.ObjectIndex = 4001;2.105 ONS15454_Threshold_View
CREATE OR REPLACE VIEW ONS15454_THRESHOLD_VIEW ASSELECTne.NESysid,mtt.modulename as ModuleName,eit.Physicalloc as Physicalloc,eit.IfIndex as IfIndex,eit.col5 as SlotPort,eit.col6 as Variable,eit.col7 as AlarmType,eit.col8 as SampleType,eit.col9 as SamplePeriod,eit.col10 as RisingThreshold,eit.col11 as FallingThreshold,eit.NEDbaccessid as NEDbaccessid,eit.ModuleType as ModuleType,ne.rowid as myrowFROMne_info_table ne,eqpt_info_table eit,module_type_table mttWHEREne.NEDbaccessid = eit.NEDbaccessid ANDne.NEModelType = mtt.ModelType ANDeit.ModuleType = mtt.ModuleType ANDmtt.Modeltype = 3 ANDmtt.ModuleType = 0 ANDeit.ObjectIndex = 4050;2.106 ONS15454_User_View
CREATE OR REPLACE VIEW ONS15454_User_view ASSELECTa.nesysid as NEId,b.userid as UserId,b.nedbaccessid,c.privilege as Privilege,b.lockout as LockOut,b.lastlogintime as LastLoginTime,b. failedlogincount as FailedLoginCount,b.disabled as Disabled,b.ChangePwdNxtLogin as ChangePasswordOnNextLogin,b.rowid as myrowFROMons15454_user_table b,ne_info_table a,ons15454_privilege_table cWHEREb.nedbaccessid = a.nedbaccessid ANDb.privilegeid = c.privilegeid;2.107 ONS15454_Virtual_Link_View
CREATE OR REPLACE VIEW ONS15454_VIRTUAL_LINK_VIEW ASSELECTne.NESysid,mtt.modulename as ModuleName,eit.Physicalloc as Physicalloc,eit.IfIndex as IfIndex,eit.col4 as Neighbor,eit.col5 as TransitDelay,eit.col6 as RetransmitInt,eit.col7 as HelloInt,eit.col8 as DeadInt,eit.col9 as AuthType,eit.col10 as AuthKey,eit.NEDbaccessid as NEDbaccessid,eit.ModuleType as ModuleType,ne.rowid as myrowFROMne_info_table ne,eqpt_info_table eit,module_type_table mttWHEREne.NEDbaccessid = eit.NEDbaccessid ANDne.NEModelType = mtt.ModelType ANDeit.ModuleType = mtt.ModuleType ANDmtt.Modeltype = 3 ANDmtt.ModuleType = 0 ANDeit.ObjectIndex = 4004;2.108 ONS15454SDH_E1_PM_FE_View
CREATE OR REPLACE VIEW ONS15454sdh_E1_pm_fe_view ASSELECTni.NESysID as NESysId,en.ModuleName as ModuleName,csdh.PhysicalLoc,csdh.NEIfIndex as NEIfIndex,csdh.TimeStamp as TimeStamp,csdh.NEIfPmStatus as NEIfPmStatus,csdh.InMaintenance as InMaintenance,csdh.FeRxPEb,csdh.FeRxPEs,csdh.FeRxPSes,csdh.FeRxPBbe,csdh.FeRxPUas,csdh.FeRxPEsr,csdh.FeRxPSesr,csdh.FeRxPBber,csdh.FeTxPEb,csdh.FeTxPEs,csdh.FeTxPSes,csdh.FeTxPBbe,csdh.FeTxPUas,csdh.FeTxPEsr,csdh.FeTxPSesr,csdh.FeTxPBber,csdh.NEDBAccessID as NEDBAccessID,csdh.thresholdList as ThresholdList,en.ModuleType,csdh.IS24H,csdh.ModelType,csdh.ObjectType,csdh.StrObjInstance,csdh.InvalidityList,csdh.rowid as myrowFROMons15454sdh_e1_pm_table csdh,ne_info_table ni,module_type_table enWHEREcsdh.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDcsdh.NEDBAccessID = ni.NEDBAccessID;2.109 ONS15454SDH_E1_PM_View
CREATE OR REPLACE VIEW ONS15454sdh_E1_pm_view ASSELECTni.NESysID as NESysId,en.ModuleName as ModuleName,csdh.PhysicalLoc,csdh.NEIfIndex as NEIfIndex,csdh.TimeStamp as TimeStamp,csdh.NEIfPmStatus as NEIfPmStatus,csdh.InMaintenance as InMaintenance,csdh.cvl as cvl,csdh.esl as esl,csdh.sesl as sesl,csdh.lossl as lossl,csdh.RxPEb as RxPEb,csdh.RxPBbe as RxPBbe,csdh.RxPes as RxPes,csdh.RxPses as RxPses,csdh.RxPUas as RxPUas,csdh.RxPEsr as RxPEsr,csdh.RxPSesr as RxPSesr,csdh.RxPBber as RxPBber,csdh.TxAiss as TxAiss,csdh.TxPEb as TxPEb,csdh.TxPBbe as TxPBbe,csdh.TxPes as TxPes,csdh.TxPses as TxPses,csdh.TxPUas as TxPUas,csdh.TxPEsr as TxPEsr,csdh.TxPSesr as TxPSesr,csdh.TxPBber as TxPBber,csdh.RxAiss as RxAiss,csdh.NEDBAccessID as NEDBAccessID,csdh.thresholdList as ThresholdList,en.ModuleType,csdh.IS24H,csdh.ModelType,csdh.ObjectType,csdh.StrObjInstance,csdh.InvalidityList,csdh.rowid as myrowFROMons15454sdh_e1_pm_table csdh,ne_info_table ni,module_type_table enWHEREcsdh.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDcsdh.NEDBAccessID = ni.NEDBAccessID;2.110 ONS15454SDH_E3_PM_View
CREATE OR REPLACE VIEW ONS15454sdh_E3_pm_view ASSELECTni.NESysIDen.ModuleName as ModuleName,csdh.PhysicalLoc,csdh.NEIfIndex as NEIfIndex,csdh.TimeStamp as TimeStamp,csdh.NEIfPmStatus as NEIfPmStatus,csdh.InMaintenance as InMaintenance,csdh.cvl as cvl,csdh.esl as esl,csdh.sesl as sesl,csdh.lossl as lossl,csdh.RxPes as RxPes,csdh.RxPses as RxPses,csdh.RxPUas as RxPUas,csdh.RxPEsr as RxPEsr,csdh.RxPSesr as RxPSesr,csdh.NEDBAccessID as NEDBAccessID,csdh.thresholdList as ThresholdList,en.ModuleType,csdh.IS24H,csdh.ModelType,csdh.ObjectType,csdh.StrObjInstance,csdh.InvalidityList,csdh.rowid as myrowFROMons15454sdh_e3_pm_table csdh,ne_info_table ni,module_type_table enWHEREcsdh.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDcsdh.NEDBAccessID = ni.NEDBAccessID;2.111 ONS15454SDH_E4_PM_View
CREATE OR REPLACE VIEW ONS15454sdh_E4_pm_view ASSELECTni.NESysID as NESysId,en.ModuleName as ModuleName,csdh.PhysicalLoc,csdh.NEIfIndex as NEIfIndex,csdh.TimeStamp as TimeStamp,csdh.NEIfPmStatus as NEIfPmStatus,csdh.InMaintenance InMaintenance,csdh.CodeViolations as CV,csdh.ErrSecs as ES,csdh.SevErrSecs as SES,csdh.UnavailableSecs as UAS,csdh.BackGroundBlockErrors as BBE,csdh.ESR as Esr,csdh.SESR as SESR,csdh.BBER as BBER,csdh.NEDBAccessID as NEDBAccessId,csdh.thresholdList as ThresholdList,en.ModuleType,csdh.IS24H,csdh.ModelType,csdh.ObjectType,csdh.StrObjInstance,csdh.InvalidityList,csdh.rowid as myrowFROMONS15454sdh_E4_pm_table csdh,ne_info_table ni,module_type_table enWHEREcsdh.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDcsdh.NEDBAccessID = ni.NEDBAccessID;2.112 ONS15454SDH_HO_PM_FE_View
CREATE OR REPLACE VIEW ONS15454sdh_ho_pm_fe_view ASSELECTni.NESysID as NESysId,en.ModuleName as ModuleName,csdh.PhysicalLoc,csdh.NEIfIndex as NEIfIndex,csdh.TimeStamp as TimeStamp,csdh.NEIfPmStatus as NEIfPmStatus,csdh.InMaintenance as InMaintenance,csdh.FeHpEb as FeHpEb,csdh.FeHpEs as FeHpEs,csdh.FeHpSes as FeHpSes,csdh.FeHpUas as FeHpUas,csdh.FeHpBbe as FeHpBbe,csdh.FeHpEsr as FeHpEsr,csdh.FeHpSesr as FeHpSesr,csdh.FeHpBber as FeHpBberas,csdh.NEDBAccessID as NEDBAccessID,csdh.thresholdList as ThresholdList,en.ModuleType,csdh.ModelType,csdh.ObjectType,csdh.StrObjInstance,csdh.InvalidityList,csdh.rowid as myrowFROMONS15454sdh_ho_pm_table csdh,ne_info_table ni,module_type_table enWHEREcsdh.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDcsdh.NEDBAccessID = ni.NEDBAccessID;2.113 ONS15454SDH_HO_PM_View
CREATE OR REPLACE VIEW ONS15454sdh_ho_pm_view ASSELECTni.NESysID as NESysId,en.ModuleName as ModuleName,csdh.PhysicalLoc,csdh.NEIfIndex as NEIfIndex,csdh.TimeStamp as TimeStamp,csdh.NEIfPmStatus as NEIfPmStatus,csdh.InMaintenance as InMaintenance,csdh.HpEb as HpEb,csdh.HpBbe as HpBbe,csdh.HpEs as HpEs,csdh.HpSes as HpSes,csdh.HpUas as HpUas,csdh.HpEsr as HpEsr,csdh.HpSesr as HpSesr,csdh.HpBber as HpBber,csdh.HpPpjcPdet as HpPpjcPdet,csdh.HpNpjcPdet as HpNpjcPdet,csdh.HpPpjcPGen as HpPpjcPGen,csdh.HpNpjcPGen as HpNpjcPGen,csdh.HpPjDiff as HpPjDiff,csdh. HpPjpSec as HpPjpSec,csdh.StsPathWidth as StsPathWidth,csdh.NEDBAccessID as NEDBAccessID,csdh.thresholdList as ThresholdList,en.ModuleType,csdh.IS24H,csdh.ModelType,csdh.ObjectType,csdh.StrObjInstance,csdh.InvalidityList,csdh.rowid as myrowFROMONS15454sdh_ho_pm_table csdh,ne_info_table ni,module_type_table enWHEREcsdh.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDcsdh.NEDBAccessID = ni.NEDBAccessID;2.114 ONS15454SDH_LO_VC3_PM_FE_View
CREATE OR REPLACE VIEW ONS15454sdh_lo_vc3_pm_fe_view ASSELECTni.NESysID as NESysId,en.ModuleName as ModuleName,csdh.PhysicalLoc,csdh.NEIfIndex as NEIfIndex,csdh.TimeStamp as TimeStamp,csdh.NEIfPmStatus as NEIfPmStatus,csdh.InMaintenance as InMaintenance,csdh.FeLoEb as vc3FeLoEb,csdh.FeLoBbe as vc3FeLoBbe,csdh.FeLoEs as vc3FeLoEs,csdh.FeLoSes as vc3FeLoSes,csdh.FeLoUas as vc3FeLoUas,csdh.FeLoEsr as vc3FeLoEsr,csdh.FeLoSesr as vc3FeLoSesr,csdh.FeLoBber as vc3FeLoBber,csdh.NEDBAccessID as NEDBAccessID,csdh.thresholdList as ThresholdList,en.ModuleType,csdh.IS24H,csdh.ModelType,csdh.ObjectType,csdh.StrObjInstance,csdh.InvalidityList,csdh.rowid as myrowFROMONS15454sdh_lo_pm_table csdh,ne_info_table ni,module_type_table enWHEREcsdh.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDcsdh.NEDBAccessID = ni.NEDBAccessID ANDcsdh.LoType = 0;2.115 ONS15454SDH_LO_VC3_PM_View
CREATE OR REPLACE VIEW ONS15454sdh_lo_vc3_pm_view ASSELECTni.NESysID as NESysId,en.ModuleName as ModuleName,csdh.PhysicalLoc,csdh.NEIfIndex as NEIfIndex,csdh.TimeStamp as TimeStamp,csdh.NEIfPmStatus as NEIfPmStatus,csdh.InMaintenance as InMaintenance,csdh.LoEb as vc3LoEb,csdh.LoBbe as vc3LoBbe,csdh.LoEs as vc3LoEs,csdh.LoSes as vc3LoSes,csdh.LoUas as vc3LoUas,csdh.LoEsr as vc3LoEsr,csdh.LoSesr as vc3LoSesr,csdh.LoBber as vc3LoBber,csdh.NEDBAccessID as NEDBAccessID,csdh.thresholdList as ThresholdList,en.ModuleType,csdh.IS24H,csdh.ModelType,csdh.ObjectType,csdh.StrObjInstance,csdh.InvalidityList,csdh.rowid as myrowFROMONS15454sdh_lo_pm_table csdh,ne_info_table ni,module_type_table enWHEREcsdh.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDcsdh.NEDBAccessID = ni.NEDBAccessID ANDcsdh.LoType = 0;2.116 ONS15454SDH_LO_VC12_PM_FE_View
CREATE OR REPLACE VIEW ONS15454sdh_lo_vc12_pm_fe_view ASSELECTni.NESysID as NESysId,en.ModuleName as ModuleName,csdh.PhysicalLoc,csdh.NEIfIndex as NEIfIndex,csdh.TimeStamp as TimeStamp,csdh.NEIfPmStatus as NEIfPmStatus,csdh.InMaintenance as InMaintenance,csdh.FeLoEb as vc12FeLoEb,csdh.FeLoBbe as vc12FeLoBbe,csdh.FeLoEs as vc12FeLoEs,csdh.FeLoSes as vc12FeLoSes,csdh.FeLoUas as vc12FeLoUas,csdh.FeLoEsr as vc12FeLoEsr,csdh.FeLoSesr as vc12FeLoSesr,csdh.FeLoBber as vc12FeLoBber,csdh.NEDBAccessID as NEDBAccessID,csdh.thresholdList as ThresholdList,en.ModuleType,csdh.IS24H,csdh.ModelType,csdh.ObjectType,csdh.StrObjInstance,csdh.InvalidityList,csdh.rowid as myrowFROMONS15454sdh_lo_pm_table csdh,ne_info_table ni,module_type_table enWHEREcsdh.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDcsdh.NEDBAccessID = ni.NEDBAccessID ANDcsdh.LoType = 1;2.117 ONS15454SDH_LO_VC12_PM_View
CREATE OR REPLACE VIEW ONS15454sdh_lo_vc12_pm_view ASSELECTni.NESysID as NESysId,en.ModuleName as ModuleName,csdh.PhysicalLoc,csdh.NEIfIndex as NEIfIndex,csdh.TimeStamp as TimeStamp,csdh.NEIfPmStatus as NEIfPmStatus,csdh.InMaintenance as InMaintenance,csdh.LoEb as vc12LoEb,csdh.LoBbe as vc12LoBbe,csdh.LoEs as vc12LoEs,csdh.LoSes as vc12LoSes,csdh.LoUas as vc12LoUas,csdh.LoEsr as vc12LoEsr,csdh.LoSesr as vc12LoSesr,csdh.LoBber as vc12LoBber,csdh.NEDBAccessID as NEDBAccessID,csdh.thresholdList as ThresholdList,en.ModuleType,csdh.IS24H,csdh.ModelType,csdh.ObjectType,csdh.StrObjInstance,csdh.InvalidityList,csdh.rowid as myrowFROMONS15454sdh_lo_pm_table csdh,ne_info_table ni,module_type_table enWHEREcsdh.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDcsdh.NEDBAccessID = ni.NEDBAccessID ANDcsdh.LoType = 1;2.118 ONS15454SDH_MS_PM_FE_View
CREATE OR REPLACE VIEW ONS15454sdh_ms_pm_fe_view ASSELECTni.NESysID as NESysId,en.ModuleName as ModuleName,csdh.PhysicalLoc,csdh.NEIfIndex as NEIfIndex,csdh.TimeStamp as TimeStamp,csdh.NEIfPmStatus as NEIfPmStatus,csdh.InMaintenance as InMaintenance,csdh.FeMsEb as FeMsEb,csdh.FeMsEs as FeMsEs,csdh.FeMsSes as FeMsSes,csdh.FeMsUas as FemsUas,csdh.FeMsBbe as FeMsBbe,csdh.FeMsEsr as FeMsEsr,csdh.FeMsSesr as FeMsSesr,csdh.FeMsBber as FeMsBber,csdh.NEDBAccessID as NEDBAccessId,csdh.thresholdList as ThresholdList,en.ModuleType,csdh.IS24H,csdh.ModelType,csdh.ObjectType,csdh.StrObjInstance,csdh.InvalidityList,csdh.rowid as myrowFROMONS15454sdh_ms_pm_table csdh,ne_info_table ni,module_type_table enWHEREcsdh.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDcsdh.NEDBAccessID = ni.NEDBAccessID;2.119 ONS15454SDH_MS_PM_View
CREATE OR REPLACE VIEW ONS15454sdh_ms_pm_view ASSELECTni.NESysID as NESysId,en.ModuleName as ModuleName,csdh.PhysicalLoc,csdh.NEIfIndex as NEIfIndex,csdh.TimeStamp as TimeStamp,csdh.NEIfPmStatus as NEIfPmStatus,csdh.InMaintenance InMaintenance,csdh.MsEb as MsEb,csdh.MsEs as MsEs,csdh.MsSes as MsSes,csdh.MsUas as MsUas,csdh.MsPpjcPdet as MsPpjcPdet,csdh.MsNpjcPdet as MsNpjcPdet,csdh.MsPpjcPGen as MsPpjcPGen,csdh.MsNpjcPGen as MsNpjcPGen,csdh.MsPsc as MsPsc,csdh.MsPsd as MsPsd,csdh.MSPscW as MSPscW,csdh.MSPsdW as MSPsdW,csdh.MSPscS as MSPscS,csdh.MSPsdS as MSPsdS,csdh.MSPscR as MSPscR,csdh.MSPsdR as MSPsdR,csdh.MsBbe as MsBbe,csdh.MSPscmsPsd as MSPscmsPsd,csdh.MsFc as MsFc,csdh.MsEsr,csdh.MsSesr,csdh.MsBber,csdh.NEDBAccessID as NEDBAccessId,csdh.thresholdList as ThresholdList,en.ModuleType,csdh.IS24H,csdh.ModelType,csdh.ObjectType,csdh.StrObjInstance,csdh.InvalidityList,csdh.rowid as myrowFROMONS15454sdh_ms_pm_table csdh,ne_info_table ni,module_type_table enWHEREcsdh.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDcsdh.NEDBAccessID = ni.NEDBAccessID;2.120 ONS15454SDH_RS_PM_View
CREATE OR REPLACE VIEW ONS15454sdh_rs_pm_view ASSELECTni.NESysID as NESysId,en.ModuleName as ModuleName,csdh.PhysicalLoc,csdh.NEIfIndex as NEIfIndex,csdh.TimeStamp as TimeStamp,csdh.NEIfPmStatus as NEIfPmStatus,csdh.InMaintenance as InMaintenance,csdh.RsEb as RsEb,csdh.RsEs as RsEs,csdh.RsSes as RsSes,csdh.RsBbe as RsBbe,csdh.RsSefs as RsSefs,csdh.RsEsr as RsEsr,csdh.RsSesr as RsSesr,csdh.RsBber as RsBber,csdh.NEDBAccessID as NEDBAccessID,csdh.thresholdList as ThresholdList,en.ModuleType,csdh.IS24H,csdh.ModelType,csdh.ObjectType,csdh.StrObjInstance,csdh.InvalidityList,csdh.rowid as myrowFROMONS15454sdh_rs_pm_table csdh,ne_info_table ni,module_type_table enWHEREcsdh.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDcsdh.NEDBAccessID = ni.NEDBAccessID;2.121 ONS15501_Opt_Power_PM_View
CREATE OR REPLACE VIEW ONS15501_opt_power_pm_view ASSELECTni.NESysID,pm.Interval,pm.TimeStamp,pm.NEIfPmStatus,pm.inMaintenance,pm.NEDBAccessID,pm.ThresholdMask,pm.InputOpticalPower,pm.OutputOpticalPower,pm.OutputOpticalSignalPower,pm.OpticalPowerGain,pm.AmbientTemp,pm.PowerSupply1Level,pm.PowerSupply2Level,pm.rowid as myrowFROMONS15501_opt_power_pm_table pm,ne_info_table niWHEREpm.NEDBAccessID = ni.NEDBAccessID ANDpm.NEIfPMStatus != 0;2.122 ONS155xx_CDL_Flow_Config_View
CREATE OR REPLACE VIEW ONS155xx_CDL_FLOW_CONFIG_VIEW ASSELECTcdl.NEDBACCESSID,neInfo.NESysID as NESYSID,ifTable.PHYSICALLOC,ifTable.MODULETYPE,ifTable.NEIFINDEX as IFINDEX,cdl.CDLXMITFLOWID,cdl.CDLRCVFLOWID,ifTable.MODELTYPE,ifTable.OBJECTTYPEFROMONS155xx_CDL_FLOW_CONFIG cdl,NE_INFO_TABLE neInfo,MIB2_INTERFACE_TABLE ifTableWHEREcdl.ifdbaccessid = ifTable.ifdbaccessid andcdl.NEDBACCESSID = neInfo.NEDBACCESSID;2.123 ONS155xx_CDL_PM_View
CREATE OR REPLACE VIEW ONS155xx_CDL_pm_view ASSELECTni.NESysID,en.ModuleName,pm.PhysicalLoc,pm.NEIfIndex,pm.Interval,pm.TimeStamp,pm.NEIfPmStatus,pm.inMaintenance,pm.NEDBAccessID,pm.ThresholdMask,pm.RxHEC,pm.RxNonCDL,pm.RxInvalidFlowID,pm.NetEthernetCRC,en.ModuleType,pm.rowid as myrow,pm.ModelType,pm.ObjectTypeFROMONS155xx_cdl_pm_table pm,ne_info_table ni,module_type_table enWHEREpm.ModuleType = en.ModuleType ANDni.NEModelType = en.ModelType ANDpm.NEDBAccessID = ni.NEDBAccessID ANDpm.NEIfPMStatus != 0;2.124 ONS155xx_Circuit_CC_View
CREATE OR REPLACE VIEW ONS155xx_Circuit_CC_View ASSELECTcircuit.CktName as Name,circuit.CktType as Type,circuit.CktSize as CktSize,neInfo1.NESysID as SrcNodeId,ccSrcDestModuleType.srcmoduleName as SrcModuleType,cccircuit.CktCCSrcPhysicalLoc as SrcPhysicalLoc,cccircuit.CktCCSrcIfIndex as SrcInterfaceId,neInfo1.NESysID as DestNodeId,ccSrcDestModuleType.destmoduleName DestModuleType,cccircuit.CktCCDestPhysicalLoc as DestPhysicalLoc,cccircuit.CktCCDestIfIndex as DestInterfaceId,cccircuit.CktCCSrcWavelength as SrcWavelength,cccircuit.CktCCDestWavelength as DestWavelength,cccircuit.CktCCSrcState as SrcState,cccircuit.CktCCDestState as DestState,cccircuit.IsCktCCWorking as working,cccircuit.IsCktCCActive as active,cccircuit.CktNodeId as NodeId,cccircuit.CktUniqueId as UniqueId,ccLink.CktCCLinkId as LinkId,cccircuit.rowid as myrow,cccircuit.CktCCSrcModelType as SrcModelType,cccircuit.CktCCSrcObjectType as SrcObjectType,cccircuit.CktCCDestModelType as DestModelType,cccircuit.CktCCDestObjectType as DestObjectTypeFROMCIRCUIT_TBL circuit,NE_INFO_TABLE neInfo1,ONS155xx_circuit_cc_tbl cccircuit,ONS155xx_CKT_CC_LINK_View ccLink,ONS155xx_CKT_CC_SRC_DEST_VIEW ccSrcDestModuleTypeWHEREcccircuit.CktNodeId = circuit.CktNodeId andcccircuit.CktUniqueId = circuit.CktUniqueId andcccircuit.CktCCNodeID = neInfo1.NEDBAccessID andcccircuit.CktCCDBID = ccSrcDestModuleType.cktccdbid andcccircuit.CKTCCDBID = ccLink.CktCCDBId(+) ;2.125 ONS155xx_Circuit_Dest_View
CREATE OR REPLACE VIEW ONS155xx_Circuit_Dest_View ASSELECTcircuit.CktName as Name,circuit.CktDescription as Description,circuit.CktType as Type,circuit.CktSize as CktSize,circuit.CktDirection as Direction,circuit.CktState as State,neinfo1.NESYSID as SrcNodeId,circuit.CktSrcModuleType as SrcModuleType,circuit.CktSrcPhysicalLoc as SrcPhysicalLoc,circuit.CktSrcIfIndex as SrcInterfaceId,circuit.CktSecSrcModuleType as SecSrcModuleType,circuit.CktSecSrcPhysicalLoc as SecSrcPhysicalLoc,circuit.CktSecSrcIfIndex as SecSrcInterfaceId,neinfo2.NESYSID as DestNodeId,circuit.CktDestModuleType as DestModuleType,circuit.CktDestPhysicalLoc as DestPhysicalLoc,circuit.CktDestIfIndex as DestInterfaceId,circuit.CktSrcDropProtType as SrcDropProtType,circuit.CktDestDropProtType as DestDropProtType,circuit.wavelength as AdditionalInfo,circuit.CktNodeId as NodeId,circuit.CktUniqueId as UniqueId,circuit.CircuitNote as CircuitNote,circuit.myrow as myrow,circuit.CktSrcModelType as SrcModelType,circuit.CktSrcObjectType as SrcObjectType,circuit.CktSecSrcModelType as SecSrcModelType,circuit.CktSecSrcObjectType as SecSrcObjectType,circuit.CktDestModelType as DestModelType,circuit.CktDestObjectType as DestObjectTypeFROMONS155xx_CIRCUIT_SRCDEST_VIEW circuit,ne_info_table neinfo1,ne_info_table neinfo2WHEREcircuit.CktSrcNodeID = neinfo1.NEDBACCESSID andcircuit.CktDestNodeID = neinfo2.NEDBACCESSID;2.126 ONS155xx_Circuit_Final_View
CREATE OR REPLACE VIEW ONS155xx_Circuit_Final_View ASSELECT DISTINCTcircuit.Name,circuit.Description,circuit.Type,circuit.CktSize,circuit.Direction,circuit.State,circuit.SrcNodeId,circuit.SrcModuleType,circuit.SrcPhysicalLoc,circuit.SrcInterfaceId,circuit.SecSrcModuleType,circuit.SecSrcPhysicalLoc,circuit.SecSrcInterfaceId,circuit.DestNodeId,circuit.DestModuleType,circuit.DestPhysicalLoc,circuit.DestInterfaceId,circuit.SrcDropProtType,circuit.DestDropProtType,circuit.AdditionalInfo,circuit.NodeId,circuit.UniqueId,circuit.SpanSrcNodeId,circuit.SpanDestNodeId,cktLink.LinkId as SpanLinkId,cdl.CDLXMITFLOWID as CdlTxFlowId,cdl.CDLRCVFLOWID as CdlRxFlowId,circuit.SrcModelType,circuit.SrcObjectType,circuit.SecSrcModelType,circuit.SecSrcObjectType,circuit.DestModelType,circuit.DestObjectTypeFROMONS155xx_CIRCUIT_SPAN_VIEW circuit,ONS155xx_CKT_LINK_View cktLink,ONS155xx_CDL_FLOW_CONFIG_VIEW cdlWHEREcircuit.NodeId = cktLink.CktNodeId(+) andcircuit.UniqueId = cktLink.CktUniqueId(+) andcircuit.SrcNodeId = cdl.NESYSID (+) andcircuit.SrcModuleType = cdl.MODULETYPE (+) andcircuit.SrcPhysicalLoc = cdl.PHYSICALLOC (+) andcircuit.SrcModelType = cdl.MODELTYPE (+) andcircuit.SrcObjectType = cdl.OBJECTTYPE (+) andcircuit.SrcInterfaceId = cdl.IFINDEX (+) ;2.127 ONS155xx_Circuit_Path_View
CREATE OR REPLACE VIEW ONS155xx_CIRCUIT_PATH_VIEW ASSELECT DISTINCTcircuitpath.Name,circuitpath.Type,circuitpath.CktSize,circuitpath.PathNumber,circuitpath.SrcNodeId,circuitpath.SrcModuleType,circuitpath.SrcPhysicalLoc,circuitpath.SrcInterfaceId,circuitpath.DestNodeId,circuitpath.DestModuleType,circuitpath.DestPhysicalLoc,circuitpath.DestInterfaceId,circuitpath.PathStatus,circuitpath.IsWorking,circuitpath.IsActive,circuitpath.DownInterfaces,circuitpath.CktNodeId,circuitpath.CktUniqueId,circuitpath.PathDBID,circuitpath.DestOpticalPower,circuitpath.LinkId,circuitpath.PathDescr,circuitpath.PathDestPwrMonNodeID,circuitpath.PathDestPwrMonPhysicalLoc,circuitpath.PathDestPwrMonIfIndex,circuitpath.PathDestPwrMonModuleType,cktstack.LLCktName,cktstack.LLCktType,cktstack.LLCktSize,cktstack.LLCktPathDescr,cktstack.LLCKTNODEID,cktstack.LLCKTUNIQUEID,cktstack.LLCktPathDBID as LLPathDBID,circuitpath.PathDBID as myrow,circuitpath.SrcModelType,circuitpath.SrcObjectType,circuitpath.DestModelType,circuitpath.DestObjectType,circuitpath.PathDestPwrMonModelType,circuitpath.PathDestPwrMonObjectTypeFROMONS155xx_CKT_PATH_STACK_VIEW cktstack,ONS155xx_CKT_PATH_FINAL_VIEW circuitpathWHEREcircuitpath.CktNodeId=cktstack.HLCktNodeId(+) andcircuitpath.CktUniqueId=cktstack.HLCktUniqueId(+) andcircuitpath.PathDBID=cktstack.HLCktPathDBID(+) ;2.128 ONS155xx_Circuit_Segment_View
CREATE OR REPLACE VIEW ONS155xx_Circuit_Segment_View ASSELECTspancircuit.CktName as Name,spancircuit.CktType as Type,spancircuit.CktSize as CktSize,spancircuit.CktSpanSrcNodeId as SrcNodeId,spanModuleType.srcmoduleName as SrcModuleType,spancircuit.CktSpanSrcPhysicalLoc as SrcPhysicalLoc,spancircuit.CktSpanSrcIfIndex as SrcInterfaceId,spancircuit.CktSpanDestNodeId as DestNodeId,spanModuleType.destmoduleName DestModuleType,spancircuit.CktSpanDestPhysicalLoc as DestPhysicalLoc,spancircuit.CktSpanDestIfIndex as DestInterfaceId,spancircuit.CktSpanAdditionalInfo as SrcWavelength,spancircuit.CktSpanAdditionalInfo as DestWavelength,spancircuit.CktSpanSrcState as SrcState,spancircuit.CktSpanDestState as DestState,spancircuit.IsCktSpanWorking as working,spancircuit.IsCktSpanActive as active,spancircuit.CktNodeId as NodeId,spancircuit.CktUniqueId as UniqueId,spancircuit.rowid as myrow,spancircuit.CktSpanSrcModelType as SrcModelType,spancircuit.CktSpanSrcObjectType as SrcObjectType,spancircuit.CktSpanDestModelType as DestModelType,spancircuit.CktSpanDestObjectType as DestObjectTypeFROMONS155xx_CKT_SPAN_JOIN_View spancircuit,ONS155xx_CKT_SPAN_MT_VIEW spanModuleTypeWHEREspancircuit.cktspanid = spanModuleType.cktspanid ;2.129 ONS155xx_Circuit_Span_View
CREATE OR REPLACE VIEW ONS155xx_Circuit_Span_View ASSELECTcircuit.Name,circuit.Description,circuit.Type,circuit.CktSize,circuit.Direction,circuit.State,circuit.SrcNodeId,circuit.SrcModuleType,circuit.SrcPhysicalLoc,circuit.SrcInterfaceId,circuit.SecSrcModuleType,circuit.SecSrcPhysicalLoc,circuit.SecSrcInterfaceId,circuit.DestNodeId,circuit.DestModuleType,circuit.DestPhysicalLoc,circuit.DestInterfaceId,circuit.SrcDropProtType,circuit.DestDropProtType,circuit.AdditionalInfo,circuit.NodeId,circuit.UniqueId,span.CktSpanSrcNodeId as SpanSrcNodeId,span.CktSpanDestNodeId as SpanDestNodeId,span.CktLinkId as SpanLinkId,circuit.CircuitNote as CircuitNote,circuit.myrow as myrow,circuit.SrcModelType,circuit.SrcObjectType,circuit.SecSrcModelType,circuit.SecSrcObjectType,circuit.DestModelType,circuit.DestObjectTypeFROMONS155xx_CIRCUIT_DEST_VIEW circuit,CIRCUIT_SPAN_TBL spanWHEREcircuit.NodeId = span.CKTNODEID(+) andcircuit.UniqueId = span.CKTUNIQUEID(+) ;2.130 ONS155xx_Circuit_SRCDEST_View
CREATE OR REPLACE VIEW ONS155xx_Circuit_SRCDEST_VIEW ASSELECTcircuit.CktNodeId,circuit.CktUniqueId,circuit.CktName,circuit.CktDescription,circuit.CktType,circuit.CktSize,circuit.CktDirection,circuit.CktState,circuit.CktSrcNodeId,circuit.CktSrcModuleType,circuit.CktSrcPhysicalLoc,circuit.CktSrcIfIndex,circuit.CktSecSrcModuleType,circuit.CktSecSrcPhysicalLoc,circuit.CktSecSrcIfIndex,destcircuit.CktDestNodeId,destcircuit.CktDestModuleType,destcircuit.CktDestPhysicalLoc,destcircuit.CktDestIfIndex,circuit.CktSrcDropProt,circuit.CktSrcDropProtType,<