-
UPM to ENIQ SQL Code
Dear E******* Experts,
Does anyone can help me to convert this UPM code to ENIQ SQL code.
SELECT
E1.PERIOD_START_TIME,
OB2.CO_NAME AS ERBS,
--SUBSTR(CO_NAME,INSTR(CO_NAME,'_')+1,5)AS ERBS,
---------------------------------------------------------------------
--VOLTEcounters
pmRrcConnReestAttQci_1 as "pmRrcConnReestAttQci_1",
pmRrcConnReestSuccQci_1 as "pmRrcConnReestSuccQci_1",
pmErabRelAbnormalEnbPeQci_1 as "pmErabRelAbnormalEnbPeQci_1",
pmErabRlAbnEnbCdtAutoQci_1 as "pmErabRlAbnEnbCdtAutoQci_1",
pmErbRlAbEnbCdtAutPnrQci_1 as "pmErbRlAbEnbCdtAutPnrQci_1",
pmErabRelAbnormEnbCdtQci_1 as "pmErabRelAbnormEnbCdtQci_1",
pmErabRelAbnrEnbUeLstQci_1 as "pmErabRelAbnrEnbUeLstQci_1",
pmErabRelAbnrmEnTnFaiQci_1 as "pmErabRelAbnrmEnTnFaiQci_1",
pmErabRelAbnormlEnbHprQci_1 as "pmErabRelAbnormlEnbHprQci_1",
pmErabRelAbnormalEnbHoQci_1 as "pmErabRelAbnormalEnbHoQci_1",
pmErabRelAbnormalMmeQci_1 as "pmErabRelAbnormalMmeQci_1",
pmErabRelAbnormalEnbQci_1 as "pmErabRelAbnormalEnbQci_1",
pmErabRelAbnormalEnbActQci_5 as "pmErabRelAbnormalEnbActQci_5",
pmErabRelAbnormalMmeActQci_5 as "pmErabRelAbnormalMmeActQci_5",
pmErabRelNormalEnbActQci_5 as "pmErabRelNormalEnbActQci_5",
pmErabRelMmeActQci_5 as "pmErabRelMmeActQci_5",
pmErabRelNormalEnbQci_1 as "pmErabRelNormalEnbQci_1",
pmErabRelMmeQci_1 as "pmErabRelMmeQci_1",
pmErabEstabAttAddedQci_1 as "pmErabEstabAttAddedQci_1",
pmErabEstabAttInitQci_1 as "pmErabEstabAttInitQci_1",
pmErabEstabSuccInitQci_1 as "pmErabEstabSuccInitQci_1",
pmErabEstabSuccAddedQci_1 as "pmErabEstabSuccAddedQci_1",
pmErabEstabAttAddedQci_5 as "pmErabEstabAttAddedQci_5",
pmErabEstabAttInitQci_5 as "pmErabEstabAttInitQci_5",
pmErabEstabSuccInitQci_5 as "pmErabEstabSuccInitQci_5",
pmErabEstabSuccAddedQci_5 as "pmErabEstabSuccAddedQci_5",
pmErabEstbAttAddHoOngngQci_1 as "pmErabEstbAttAddHoOngngQci_1",
pmServiceTimeDrbQci_1 as "pmServiceTimeDrbQci_1",
pmErabQciLevSum_1 as "pmErabQciLevSum_1",
pmErabLevSamp as "pmErabLevSamp",
pmErabQciLevSum_5 as "pmErabQciLevSum_5",
pmErabRelAbnormalEnbQci_1 as "pmErabRelAbnormalEnbQci_1",
pmErabRelAbnormalMmeQci_1 as "pmErabRelAbnormalMmeQci_1",
----------------------------------------------------------------------
pmB2BestCellEvalReport as "pmB2BestCellEvalReport",
pmB2BestCellEvalReportRsrp as "pmB2BestCellEvalReportRsrp",
pmHoPrepRejInLicConnUsers as "pmHoPrepRejInLicConnUsers",
pmHoPrepRejInLicMob as "pmHoPrepRejInLicMob",
pmHoPrepRejInLicRlcUm as "pmHoPrepRejInLicRlcUm",
pmHoPrepRejInLicMultiErab as "pmHoPrepRejInLicMultiErab",
pmHoPrepRejInMpOverload as "pmHoPrepRejInMpOverload",
pmHoPrepRejInDuIntens as "pmHoPrepRejInDuIntens",
pmHoPrepRejInDuSwC as "pmHoPrepRejInDuSwC",
pmHoPrepRejInCellIntensDLC as "pmHoPrepRejInCellIntensDLC",
pmHoPrepRejInCellIntensStat as "pmHoPrepRejInCellIntensStat",
pmHoPrepRejInCellIntensSwC as "pmHoPrepRejInCellIntensSwC",
pmHoPrepRejInCellLatency as "pmHoPrepRejInCellLatency",
pmHoPrepRejInOffloadAdmission as "pmHoPrepRejInOffloadAdmission",
pmHoPrepRejInBearerAdmisionRej as "pmHoPrepRejInBearerAdmisionRej",
pmHoPrepRejInMISigQCong as "pmHoPrepRejInMISigQCong",
pmHoPrepRejInDynUeAdmCtrl as "pmHoPrepRejInDynUeAdmCtrl",
pmHoPrepRejInUlThres as "pmHoPrepRejInUlThres",
pmUeThpDlDistr_0 as "pmUeThpDlDistr_0",
pmUeThpDlDistr_1 as "pmUeThpDlDistr_1",
pmUeThpDlDistr_2 as "pmUeThpDlDistr_2",
pmUeThpDlDistr_3 as "pmUeThpDlDistr_3",
pmUeThpDlDistr_4 as "pmUeThpDlDistr_4",
pmUeThpDlDistr_5 as "pmUeThpDlDistr_5",
pmUeThpDlDistr_6 as "pmUeThpDlDistr_6",
pmUeThpDlDistr_7 as "pmUeThpDlDistr_7",
pmUeThpDlDistr_8 as "pmUeThpDlDistr_8",
pmUeThpDlDistr_9 as "pmUeThpDlDistr_9",
pmUeThpDlDistr_10 as "pmUeThpDlDistr_10",
pmUeThpDlDistr_11 as "pmUeThpDlDistr_11",
pmUeThpDlDistr_12 as "pmUeThpDlDistr_12",
pmUeThpDlDistr_13 as "pmUeThpDlDistr_13",
pmUeThpDlDistr_14 as "pmUeThpDlDistr_14",
pmRadioUeRepRankDistr_0 as "pmRadioUeRepRankDistr_0",
pmRadioUeRepRankDistr_1 as "pmRadioUeRepRankDistr_1 ",
pmRadioUeRepRankDistr_2 as "pmRadioUeRepRankDistr_2",
pmRadioUeRepRankDistr_3 as "pmRadioUeRepRankDistr_3",
------------------------------------------------
pmCaScheduledDlSum_0 as "pmCaScheduledDlSum_0",
pmCaScheduledDlSum_1 as "pmCaScheduledDlSum_1",
pmCaScheduledDlSum_2 as "pmCaScheduledDlSum_2",
pmCaScheduledDlSum_3 as "pmCaScheduledDlSum_3",
pmCaScheduledDlSum_4 as "pmCaScheduledDlSum_4",
------------------------------------------------
pmSinrPucchDistr_0 as "pmSinrPucchDistr_0",
pmSinrPucchDistr_1 as "pmSinrPucchDistr_1",
pmSinrPucchDistr_2 as "pmSinrPucchDistr_2",
pmSinrPucchDistr_3 as "pmSinrPucchDistr_3",
pmSinrPucchDistr_4 as "pmSinrPucchDistr_4",
pmSinrPucchDistr_5 as "pmSinrPucchDistr_5",
pmSinrPucchDistr_6 as "pmSinrPucchDistr_6",
pmSinrPucchDistr_7 as "pmSinrPucchDistr_7",
------------------------------------------------
pmRadioUeRepCqiDistr_0 as "pmRadioUeRepCqiDistr_0",
pmRadioUeRepCqiDistr_1 as "pmRadioUeRepCqiDistr_1",
pmRadioUeRepCqiDistr_2 as "pmRadioUeRepCqiDistr_2",
pmRadioUeRepCqiDistr_3 as "pmRadioUeRepCqiDistr_3",
pmRadioUeRepCqiDistr_4 as "pmRadioUeRepCqiDistr_4",
pmRadioUeRepCqiDistr_5 as "pmRadioUeRepCqiDistr_5",
pmRadioUeRepCqiDistr_6 as "pmRadioUeRepCqiDistr_6",
pmRadioUeRepCqiDistr_7 as "pmRadioUeRepCqiDistr_7",
pmRadioUeRepCqiDistr_8 as "pmRadioUeRepCqiDistr_8",
pmRadioUeRepCqiDistr_9 as "pmRadioUeRepCqiDistr_9",
pmRadioUeRepCqiDistr_10 as "pmRadioUeRepCqiDistr_10",
pmRadioUeRepCqiDistr_11 as "pmRadioUeRepCqiDistr_11",
pmRadioUeRepCqiDistr_12 as "pmRadioUeRepCqiDistr_12",
pmRadioUeRepCqiDistr_13 as "pmRadioUeRepCqiDistr_13",
pmRadioUeRepCqiDistr_14 as "pmRadioUeRepCqiDistr_14",
pmRadioUeRepCqiDistr_15 as "pmRadioUeRepCqiDistr_15",
------------------------------------------------
pmRadioUeRepCqiDistr2_0 as "pmRadioUeRepCqiDistr2_0",
pmRadioUeRepCqiDistr2_1 as "pmRadioUeRepCqiDistr2_1",
pmRadioUeRepCqiDistr2_2 as "pmRadioUeRepCqiDistr2_2",
pmRadioUeRepCqiDistr2_3 as "pmRadioUeRepCqiDistr2_3",
pmRadioUeRepCqiDistr2_4 as "pmRadioUeRepCqiDistr2_4",
pmRadioUeRepCqiDistr2_5 as "pmRadioUeRepCqiDistr2_5",
pmRadioUeRepCqiDistr2_6 as "pmRadioUeRepCqiDistr2_6",
pmRadioUeRepCqiDistr2_7 as "pmRadioUeRepCqiDistr2_7",
pmRadioUeRepCqiDistr2_8 as "pmRadioUeRepCqiDistr2_8",
pmRadioUeRepCqiDistr2_9 as "pmRadioUeRepCqiDistr2_9",
pmRadioUeRepCqiDistr2_10 as "pmRadioUeRepCqiDistr2_10",
pmRadioUeRepCqiDistr2_11 as "pmRadioUeRepCqiDistr2_11",
pmRadioUeRepCqiDistr2_12 as "pmRadioUeRepCqiDistr2_12",
pmRadioUeRepCqiDistr2_13 as "pmRadioUeRepCqiDistr2_13",
pmRadioUeRepCqiDistr2_14 as "pmRadioUeRepCqiDistr2_14",
pmRadioUeRepCqiDistr2_15 as "pmRadioUeRepCqiDistr2_15",
pmRadioUeRepCqiDistr3_0 as "pmRadioUeRepCqiDistr3_0",
pmRadioUeRepCqiDistr3_1 as "pmRadioUeRepCqiDistr3_1",
pmRadioUeRepCqiDistr3_2 as "pmRadioUeRepCqiDistr3_2",
pmRadioUeRepCqiDistr3_3 as "pmRadioUeRepCqiDistr3_3",
pmRadioUeRepCqiDistr3_4 as "pmRadioUeRepCqiDistr3_4",
pmRadioUeRepCqiDistr3_5 as "pmRadioUeRepCqiDistr3_5",
pmRadioUeRepCqiDistr3_6 as "pmRadioUeRepCqiDistr3_6",
pmRadioUeRepCqiDistr3_7 as "pmRadioUeRepCqiDistr3_7",
pmRadioUeRepCqiDistr3_8 as "pmRadioUeRepCqiDistr3_8",
pmRadioUeRepCqiDistr3_9 as "pmRadioUeRepCqiDistr3_9",
pmRadioUeRepCqiDistr3_10 as "pmRadioUeRepCqiDistr3_10",
pmRadioUeRepCqiDistr3_11 as "pmRadioUeRepCqiDistr3_11",
pmRadioUeRepCqiDistr3_12 as "pmRadioUeRepCqiDistr3_12",
pmRadioUeRepCqiDistr3_13 as "pmRadioUeRepCqiDistr3_13",
pmRadioUeRepCqiDistr3_14 as "pmRadioUeRepCqiDistr3_14",
pmRadioUeRepCqiDistr3_15 as "pmRadioUeRepCqiDistr3_15",
pmRadioUeRepCqiDistr4_0 as "pmRadioUeRepCqiDistr4_0",
pmRadioUeRepCqiDistr4_1 as "pmRadioUeRepCqiDistr4_1",
pmRadioUeRepCqiDistr4_2 as "pmRadioUeRepCqiDistr4_2",
pmRadioUeRepCqiDistr4_3 as "pmRadioUeRepCqiDistr4_3",
pmRadioUeRepCqiDistr4_4 as "pmRadioUeRepCqiDistr4_4",
pmRadioUeRepCqiDistr4_5 as "pmRadioUeRepCqiDistr4_5",
pmRadioUeRepCqiDistr4_6 as "pmRadioUeRepCqiDistr4_6",
pmRadioUeRepCqiDistr4_7 as "pmRadioUeRepCqiDistr4_7",
pmRadioUeRepCqiDistr4_8 as "pmRadioUeRepCqiDistr4_8",
pmRadioUeRepCqiDistr4_9 as "pmRadioUeRepCqiDistr4_9",
pmRadioUeRepCqiDistr4_10 as "pmRadioUeRepCqiDistr4_10",
pmRadioUeRepCqiDistr4_11 as "pmRadioUeRepCqiDistr4_11",
pmRadioUeRepCqiDistr4_12 as "pmRadioUeRepCqiDistr4_12",
pmRadioUeRepCqiDistr4_13 as "pmRadioUeRepCqiDistr4_13",
pmRadioUeRepCqiDistr4_14 as "pmRadioUeRepCqiDistr4_14",
pmRadioUeRepCqiDistr4_15 as "pmRadioUeRepCqiDistr4_15",
------------------------------------------------
pmPrbUtilUl_0 as "pmPrbUtilUl_0",
pmPrbUtilUl_1 as "pmPrbUtilUl_1",
pmPrbUtilUl_2 as "pmPrbUtilUl_2",
pmPrbUtilUl_3 as "pmPrbUtilUl_3",
pmPrbUtilUl_4 as "pmPrbUtilUl_4",
pmPrbUtilUl_5 as "pmPrbUtilUl_5",
pmPrbUtilUl_6 as "pmPrbUtilUl_6",
pmPrbUtilUl_7 as "pmPrbUtilUl_7",
pmPrbUtilUl_8 as "pmPrbUtilUl_8",
pmPrbUtilUl_9 as "pmPrbUtilUl_9",
------------------------------------------------
pmPrbUtilDl_0 as "pmPrbUtilDl_0",
pmPrbUtilDl_1 as "pmPrbUtilDl_1",
pmPrbUtilDl_2 as "pmPrbUtilDl_2",
pmPrbUtilDl_3 as "pmPrbUtilDl_3",
pmPrbUtilDl_4 as "pmPrbUtilDl_4",
pmPrbUtilDl_5 as "pmPrbUtilDl_5",
pmPrbUtilDl_6 as "pmPrbUtilDl_6",
pmPrbUtilDl_7 as "pmPrbUtilDl_7",
pmPrbUtilDl_8 as "pmPrbUtilDl_8",
pmPrbUtilDl_9 as "pmPrbUtilDl_9",
------------------------------------------------
pmPdcchCceUtil_0 as "pmPdcchCceUtil_0",
pmPdcchCceUtil_1 as "pmPdcchCceUtil_1",
pmPdcchCceUtil_2 as "pmPdcchCceUtil_2 ",
pmPdcchCceUtil_3 as "pmPdcchCceUtil_3 ",
pmPdcchCceUtil_4 as "pmPdcchCceUtil_4 ",
pmPdcchCceUtil_5 as "pmPdcchCceUtil_5 ",
pmPdcchCceUtil_6 as "pmPdcchCceUtil_6 ",
pmPdcchCceUtil_7 as "pmPdcchCceUtil_7 ",
pmPdcchCceUtil_8 as "pmPdcchCceUtil_8 ",
pmPdcchCceUtil_9 as "pmPdcchCceUtil_9 ",
pmPdcchCceUtil_10 as "pmPdcchCceUtil_10",
pmPdcchCceUtil_11 as "pmPdcchCceUtil_11",
pmPdcchCceUtil_12 as "pmPdcchCceUtil_12",
pmPdcchCceUtil_13 as "pmPdcchCceUtil_13",
pmPdcchCceUtil_14 as "pmPdcchCceUtil_14",
pmPdcchCceUtil_15 as "pmPdcchCceUtil_15",
pmPdcchCceUtil_16 as "pmPdcchCceUtil_16",
pmPdcchCceUtil_17 as "pmPdcchCceUtil_17",
pmPdcchCceUtil_18 as "pmPdcchCceUtil_18",
pmPdcchCceUtil_19 as "pmPdcchCceUtil_19",
------------------------------------------------
pmSinrPuschDistr_0 as "pmSinrPuschDistr_0",
pmSinrPuschDistr_1 as "pmSinrPuschDistr_1",
pmSinrPuschDistr_2 as "pmSinrPuschDistr_2",
pmSinrPuschDistr_3 as "pmSinrPuschDistr_3",
pmSinrPuschDistr_4 as "pmSinrPuschDistr_4",
pmSinrPuschDistr_5 as "pmSinrPuschDistr_5",
pmSinrPuschDistr_6 as "pmSinrPuschDistr_6",
pmSinrPuschDistr_7 as "pmSinrPuschDistr_7",
pmSinrPuschDistr_8 as "pmSinrPuschDistr_8",
------------------------------------------------
pmUeCategoryDistr_0 as "pmUeCategoryDistr_0",
pmUeCategoryDistr_1 as "pmUeCategoryDistr_1",
pmUeCategoryDistr_2 as "pmUeCategoryDistr_2",
pmUeCategoryDistr_3 as "pmUeCategoryDistr_3",
pmUeCategoryDistr_4 as "pmUeCategoryDistr_4 ",
pmUeCategoryDistr_5 as "pmUeCategoryDistr_5 ",
pmUeCategoryDistr_6 as "pmUeCategoryDistr_6",
pmUeCategoryDistr_7 as "pmUeCategoryDistr_7",
pmUeCategoryDistr_8 as "pmUeCategoryDistr_8",
pmUeCategoryDistr_9 as "pmUeCategoryDistr_9",
pmUeCategoryDistr_10 as "pmUeCategoryDistr_10",
pmUeCategoryDistr_11 as "pmUeCategoryDistr_11",
------------------------------------------------
pmCaCapableDlSum_0 as "pmCaCapableDlSum_0",
pmCaCapableDlSum_1 as "pmCaCapableDlSum_1 ",
pmCaCapableDlSum_2 as "pmCaCapableDlSum_2 ",
pmCaCapableDlSum_3 as "pmCaCapableDlSum_3",
pmCaCapableDlSum_4 as "pmCaCapableDlSum_4",
------------------------------------------------
pmPdcchCceAggregationDistr_0 as "pmPdcchCceAggregationDistr_0 ",
pmPdcchCceAggregationDistr_1 as "pmPdcchCceAggregationDistr_1 ",
pmPdcchCceAggregationDistr_2 as "pmPdcchCceAggregationDistr_2",
pmPdcchCceAggregationDistr_3 as "pmPdcchCceAggregationDistr_3",
------------------------------------------------
pmCaActivatedDlSum_0 as "pmCaActivatedDlSum_0",
pmCaActivatedDlSum_1 as "pmCaActivatedDlSum_1",
pmCaActivatedDlSum_2 as "pmCaActivatedDlSum_2",
pmCaActivatedDlSum_3 as "pmCaActivatedDlSum_3",
pmCaActivatedDlSum_4 as "pmCaActivatedDlSum_4",
------------------------------------------------
pmPdcchSym0PwrUtil_0 as "pmPdcchSym0PwrUtil_0",
pmPdcchSym0PwrUtil_1 as "pmPdcchSym0PwrUtil_1",
pmPdcchSym0PwrUtil_2 as "pmPdcchSym0PwrUtil_2",
pmPdcchSym0PwrUtil_3 as "pmPdcchSym0PwrUtil_3",
pmPdcchSym0PwrUtil_4 as "pmPdcchSym0PwrUtil_4",
pmPdcchSym0PwrUtil_5 as "pmPdcchSym0PwrUtil_5",
pmPdcchSym0PwrUtil_6 as "pmPdcchSym0PwrUtil_6",
pmPdcchSym0PwrUtil_7 as "pmPdcchSym0PwrUtil_7",
pmPdcchSym0PwrUtil_8 as "pmPdcchSym0PwrUtil_8",
pmPdcchSym0PwrUtil_9 as "pmPdcchSym0PwrUtil_9",
------------------------------------------------
pmPdcchSym1PwrUtil_0 as "pmPdcchSym1PwrUtil_0",
pmPdcchSym1PwrUtil_1 as "pmPdcchSym1PwrUtil_1",
pmPdcchSym1PwrUtil_2 as "pmPdcchSym1PwrUtil_2",
pmPdcchSym1PwrUtil_3 as "pmPdcchSym1PwrUtil_3",
pmPdcchSym1PwrUtil_4 as "pmPdcchSym1PwrUtil_4",
pmPdcchSym1PwrUtil_5 as "pmPdcchSym1PwrUtil_5",
pmPdcchSym1PwrUtil_6 as "pmPdcchSym1PwrUtil_6",
pmPdcchSym1PwrUtil_7 as "pmPdcchSym1PwrUtil_7",
pmPdcchSym1PwrUtil_8 as "pmPdcchSym1PwrUtil_8",
pmPdcchSym1PwrUtil_9 as "pmPdcchSym1PwrUtil_9",
------------------------------------------------
pmPdcchSym2PwrUtil_0 as "pmPdcchSym2PwrUtil_0",
pmPdcchSym2PwrUtil_1 as "pmPdcchSym2PwrUtil_1",
pmPdcchSym2PwrUtil_2 as "pmPdcchSym2PwrUtil_2",
pmPdcchSym2PwrUtil_3 as "pmPdcchSym2PwrUtil_3",
pmPdcchSym2PwrUtil_4 as "pmPdcchSym2PwrUtil_4",
pmPdcchSym2PwrUtil_5 as "pmPdcchSym2PwrUtil_5",
pmPdcchSym2PwrUtil_6 as "pmPdcchSym2PwrUtil_6",
pmPdcchSym2PwrUtil_7 as "pmPdcchSym2PwrUtil_7",
pmPdcchSym2PwrUtil_8 as "pmPdcchSym2PwrUtil_8",
pmPdcchSym2PwrUtil_9 as "pmPdcchSym2PwrUtil_9",
------------------------------------------------
pmPdcchSym3PwrUtil_0 as "pmPdcchSym3PwrUtil_0",
pmPdcchSym3PwrUtil_1 as "pmPdcchSym3PwrUtil_1",
pmPdcchSym3PwrUtil_2 as "pmPdcchSym3PwrUtil_2",
pmPdcchSym3PwrUtil_3 as "pmPdcchSym3PwrUtil_3",
pmPdcchSym3PwrUtil_4 as "pmPdcchSym3PwrUtil_4",
pmPdcchSym3PwrUtil_5 as "pmPdcchSym3PwrUtil_5",
pmPdcchSym3PwrUtil_6 as "pmPdcchSym3PwrUtil_6",
pmPdcchSym3PwrUtil_7 as "pmPdcchSym3PwrUtil_7",
pmPdcchSym3PwrUtil_8 as "pmPdcchSym3PwrUtil_8",
pmPdcchSym3PwrUtil_9 as "pmPdcchSym3PwrUtil_9",
pmRadioTxRankDistr_0 as "pmRadioTxRankDistr_0 ",
pmRadioTxRankDistr_1 as "pmRadioTxRankDistr_1",
pmRadioTxRankDistr_2 as "pmRadioTxRankDistr_2",
pmRadioTxRankDistr_3 as "pmRadioTxRankDistr_3",
pmRadioTxRankDistr_4 as "pmRadioTxRankDistr_4",
pmRadioTxRankDistr_5 as "pmRadioTxRankDistr_5",
pmRadioTxRankDistr_6 as "pmRadioTxRankDistr_6",
pmRadioTxRankDistr_7 as "pmRadioTxRankDistr_7",
pmRadioTxRankDistr_8 as "pmRadioTxRankDistr_8",
pmRadioTxRankDistr_9 as "pmRadioTxRankDistr_9",
pmRadioTxRankDistr_10 as "pmRadioTxRankDistr_10",
pmRadioTxRankDistr_11 as "pmRadioTxRankDistr_11",
pmRadioTxRankDistr_12 as "pmRadioTxRankDistr_12",
pmRadioTxRankDistr_13 as "pmRadioTxRankDistr_13",
PMULGRANTSTRANSNOACK,
pmRrcConnReconfSuccNoMob,
pmUeCtxtFetchAttReconf,
pmUeCtxtFetchSuccReconf,
pmRrcConnReconfAttNoMob,
PMPDCPVOLDLDRBLASTTTICA,
PMPDCPVOLDLDRBCA,
PMUETHPTIMEDLCA,
pmPdcpPktFwdDl,
pmCaConfiguredNoMeasAtt,
pmCaConfiguredMeasAtt,
pmCaConfiguredNoMeasSucc,
pmCaConfiguredMeasSucc,
pmCaDeconfigured,
pmCaDeconfiguredLostCoverage,
pmCaDeconfiguredSCellChange,
pmUeThp2DlDistr_0 as "pmUeThp2DlDistr_0",
pmUeThp2DlDistr_1 as "pmUeThp2DlDistr_1",
pmUeThp2DlDistr_2 as "pmUeThp2DlDistr_2",
pmUeThp2DlDistr_3 as "pmUeThp2DlDistr_3",
pmUeThp2DlDistr_4 as "pmUeThp2DlDistr_4",
pmUeThp2DlDistr_5 as "pmUeThp2DlDistr_5",
pmUeThp2DlDistr_6 as "pmUeThp2DlDistr_6",
pmUeThp2DlDistr_7 as "pmUeThp2DlDistr_7",
pmUeThp2DlDistr_8 as "pmUeThp2DlDistr_8",
pmUeThp2DlDistr_9 as "pmUeThp2DlDistr_9",
pmUeThp2DlDistr_10 as "pmUeThp2DlDistr_10",
pmUeThp2DlDistr_11 as "pmUeThp2DlDistr_11",
pmUeThp2DlDistr_12 as "pmUeThp2DlDistr_12",
pmUeThp2DlDistr_13 as "pmUeThp2DlDistr_13",
pmUeThp2DlDistr_14 as "pmUeThp2DlDistr_14",
pmUeThp2DlDistr_15 as "pmUeThp2DlDistr_15",
pmUeThp2DlDistr_16 as "pmUeThp2DlDistr_16",
pmUeThp2DlDistr_17 as "pmUeThp2DlDistr_17",
pmUeThp2DlDistr_18 as "pmUeThp2DlDistr_18",
pmUeThp2DlDistr_19 as "pmUeThp2DlDistr_19",
pmUeThp2DlDistr_20 as "pmUeThp2DlDistr_20",
pmUeThp2DlDistr_21 as "pmUeThp2DlDistr_21",
pmUeThp2DlDistr_22 as "pmUeThp2DlDistr_22",
pmUeThp2DlDistr_23 as "pmUeThp2DlDistr_23",
pmUeThp2DlDistr_24 as "pmUeThp2DlDistr_24",
pmUeThp2DlDistr_25 as "pmUeThp2DlDistr_25",
pmUeThp2DlDistr_26 as "pmUeThp2DlDistr_26",
pmRadioRecInterferencePwr_0 as "pmRadioRecInterferencePwr_0",
pmRadioRecInterferencePwr_1 as "pmRadioRecInterferencePwr_1",
pmRadioRecInterferencePwr_2 as "pmRadioRecInterferencePwr_2",
pmRadioRecInterferencePwr_3 as "pmRadioRecInterferencePwr_3",
pmRadioRecInterferencePwr_4 as "pmRadioRecInterferencePwr_4",
pmRadioRecInterferencePwr_5 as "pmRadioRecInterferencePwr_5",
pmRadioRecInterferencePwr_6 as "pmRadioRecInterferencePwr_6",
pmRadioRecInterferencePwr_7 as "pmRadioRecInterferencePwr_7",
pmRadioRecInterferencePwr_8 as "pmRadioRecInterferencePwr_8",
pmRadioRecInterferencePwr_9 as "pmRadioRecInterferencePwr_9",
pmRadioRecInterferencePwr_10 as "pmRadioRecInterferencePwr_10",
pmRadioRecInterferencePwr_11 as "pmRadioRecInterferencePwr_11",
pmRadioRecInterferencePwr_12 as "pmRadioRecInterferencePwr_12",
pmRadioRecInterferencePwr_13 as "pmRadioRecInterferencePwr_13",
pmRadioRecInterferencePwr_14 as "pmRadioRecInterferencePwr_14",
pmRadioRecInterferencePwr_15 as "pmRadioRecInterferencePwr_15",
pmRadioUeRepCqiSubband0Sum,
pmRadioUeRepCqiSubband1Sum,
pmRadioUeRepCqiSubband2Sum,
pmRadioUeRepCqiSubband3Sum,
pmRadioUeRepCqiSubband4Sum,
pmRadioUeRepCqiSubband5Sum,
pmRadioUeRepCqiSubband6Sum,
pmRadioUeRepCqiSubband7Sum,
pmRadioUeRepCqiSubband8Sum,
pmRadioUeRepCqiSubband9Sum,
pmRadioUeRepCqiSubband10Sum,
pmRadioUeRepCqiSubband11Sum,
pmRadioUeRepCqiSubband12Sum,
pmRadioUeRepCqiSubbandSamp,
OB.CO_NAME AS EUTRANCELLFDD,
PMA5BESTCELLEVALREPORT ,
PMA5BESTCELLEVALREPORTRSRP ,
PMBADCOVSEARCHEVALREPORT ,
PMDLASSIGSTRANS ,
PMDLASSIGSWITHDETECTEDHARQACK ,
PMGOODCOVSEARCHEVALREPORT ,
PMGOODCOVSEARCHEVALREPORTRSRP ,
PMRRCCONNESTBFAILLICACTUSERS ,
PMUECTXTRELSCEUTRAA2RSRP ,
PMUECTXTRELSCEUTRAA2RSRQ ,
PMUECTXTRELSCEUTRABSTCELLRSRP ,
PMUECTXTRELSCEUTRABSTCELRSRQ ,
PMUECTXTRELSCGSMA2RSRP ,
PMUECTXTRELSCGSMA2RSRQ ,
PMUECTXTRELSCGSMB2RSRP ,
PMUECTXTRELSCGSMB2RSRQ ,
PMULGRANTSTRANS ,
PMULGRANTSWITHDETECTEDPUSCH ,
-----------------
PMRAUNASSIGNEDCFRAFALSE,
PMRAUNASSIGNEDCFRASUM,
PMRRCCONNREESTATTHO,
PMRRCCONNREESTSUCCHO,
PMRRCCONNREESTATT,
PMRRCCONNREESTSUCC,
PMPDCCHTXCONSERVATIVE,
PMPDCCHTXAGGRESSIVE,
PMRAFAILCBRAMSG1DISCOOC,
PMRAFAILCBRAMSG1DISCSCHED,
PMRAFAILCFRAMSG1DISCOOC,
PMRAFAILCFRAMSG1DISCSCHED,
PMB2BESTCELLEVALREPORT,
PMUECTXTRELSCUTRANB2RSRP,
PMUECTXTRELSCUTRANB2RSRQ,
PMB2BESTCELLEVALREPORTRSRP,
PMUECTXTRELSCUTRANA2RSRP,
PMUECTXTRELSCUTRANA2RSRQ,
PMPUCCHSRCQIRESALLOCATT,
PMPUCCHSRCQIRESCONGCQI,
PMPUCCHSRCQIRESCONGSR,
PMRLCARQDLACK,
PMRLCARQDLNACK,
PMRADIOTBSPWRUNRESTRICTED,
PMBADCOVSEARCHEVALREPORTRSRP,
PMCRITICALBORDEREVALREPORTRSRP,
PMCRITICALBORDEREVALREPORT,
PMERABRELMMEACTEUTRA,
PMERABRELMMEACTUSERINACTIVITY,
PMERABRELMMEACTUNSPECIFIED,
PMRADIOTBSPWRRESTRICTED,
PMRLCARQULACK,
PMRLCARQULNACK,
PMCONTDL,
PMCONTDLCAPLIC,
PMCONTDLHW,
PMCONTDLPDCCH,
PMCONTUL,
PMCONTULCAPLIC,
PMCONTULHW,
PMCONTULPDCCH,
PMMACHARQDLACKQPSK,
PMMACHARQULSUCCQPSK,
PMMACHARQDLNACKQPSK,
PMMACHARQULFAILQPSK,
PMMACHARQDLACK16QAM,
PMMACHARQULSUCC16QAM,
PMMACHARQDLNACK16QAM,
PMMACHARQULFAIL16QAM,
PMMACHARQDLACK64QAM,
PMMACHARQDLNACK64QAM,
PMCELLHOEXEATTLTEINTRAF,
PMCELLHOEXESUCCLTEINTRAF,
PMCELLHOPREPATTLTEINTERF,
PMCELLHOPREPSUCCLTEINTERF,
PMCELLHOEXEATTLTEINTERF,
PMCELLHOEXESUCCLTEINTERF,
PMCELLHOPREPATTLTEINTRAF,
PMCELLHOPREPSUCCLTEINTRAF,
PMACTIVEUEDLSUM,
PMACTIVEUEULSUM,
PMUECTXTRELCSFBWCDMA,
PMUECTXTRELCSFBWCDMAEM,
PMUECTXTRELCSFBGSM,
PMUECTXTRELCSFBGSMEM,
PMRRCCONNESTABFAILHIGHLOAD,
PMPAGRECEIVED,
PMPAGDISCARDED,
PMRRCCONNESTABFAILMISIGQCONG,
PMRAATTCBRA,
PMRASUCCCBRA,
PMRAFAILCBRAMSG2DISC,
PMRAATTCFRA,
PMRASUCCCFRA,
PMRAFAILCFRAMSG2DISC,
PMRAALLOCCFRA,
PMRAUNASSIGNEDCFRAFALSE,
PMRAUNASSIGNEDCFRASUM,
PMRRCCONNESTABATTEM,
PMRRCCONNESTABATTHPA,
PMRRCCONNESTABATTMTA,
PMRRCCONNESTABATTMOS,
PMRRCCONNESTABATTMOD,
PMRRCCONNESTABFAILLIC,
PMRRCCONNESTBFAILLICACTUSERS,
PMRRCCONNESTABFAILOVERLOAD,
PMS1SIGCONNESTABATTEM,
PMS1SIGCONNESTABATTHPA,
PMS1SIGCONNESTABATTMOD,
PMS1SIGCONNESTABATTMTA,
PMS1SIGCONNESTABATTMOS,
PMS1SIGCONNESTABATTDTA,
PMS1SIGCONNESTABFAILMMEOVLMOS,
PMERABESTABFAILINITLIC,
PMERABESTABFAILGBRDLENB,
PMERABESTABFAILGBRULENB,
PMERABESTABFAILADDEDLIC,
PMUECTXTRELABNORMALENBPE,
PMUECTXTRELABNORMALENBHO,
PMUECTXTRELABNORMALENBUELOST,
PMUECTXTRELABNRMLENBACTTNFAIL,
PMUECTXTRELABNORMALENBACTHO,
PMUECTXTRELABNRMLENBACTUELOST,
PMUECTXTRELABNORMALENBACTPE,
E3.PMUECTXTRELABNORMALENBACTCDT,
PMUECTXTRELABNORENBACTCDTAUTO,
PMERABRELABNORMALENBTNFAIL,
PMERABRELABNORMALENBHPR,
PMERABRELABNORMALENBHO,
PMERABRELABNORMALENBUELOST,
PMERABRELABNORMALENBPE,
PMERABRELABNORMALENBACTTNFAIL,
PMERABRELABNORMALENBACTHO,
PMERABRELABNORMALENBACTHPR,
E1.PMERABRELABNORMALENBACTCDT,
PMERABRELABNORMALENBACTUELOST,
PMERABRELABNORMALENBACTPE,
PMRLCDELAYTIMEDL,
PMRLCDELAYPKTTRANSDL,
PMMACDELAYTIMEDL,
PMACTIVEDRBDLSUM,
PMACTIVEDRBULSUM,
E1.PMPDCPVOLULDRB,
E1.PMPDCPVOLDLSRB,
PMRRCCONNMAX,
E1.PMPDCPVOLULSRB,
PMRRCCONNESTABATT,
PMRRCCONNESTABATTREATT,
PMRRCCONNESTABSUCC,
PMRRCCONNESTABFAILMMEOVLMOS,
PMRRCCONNESTABFAILMMEOVLMOD,
PMS1SIGCONNESTABSUCC,
PMS1SIGCONNESTABATT,
PMS1SIGCONNESTABFAILMMEOVLMOS,
PMERABESTABSUCCINIT,
PMERABESTABATTINIT,
PMERABESTABSUCCADDED,
PMERABESTABATTADDED,
PMERABESTABATTADDEDHOONGOING,
PMERABRELABNORMALENBACT,
PMERABRELABNORMALMMEACT,
PMERABRELABNORMALENB,
PMERABRELNORMALENB,
PMERABRELMME,
PMSESSIONTIMEUE,
PMCELLDOWNTIMEMAN,
PMCELLDOWNTIMEAUTO,
PMPDCPLATTIMEDL,
PMPDCPLATPKTTRANSDL,
PMPDCPVOLDLDRBLASTTTI,
PMUETHPTIMEDL,
E1.PMPDCPVOLDLDRB,
PMSCHEDACTIVITYCELLDL,
PMUETHPVOLUL,
PMUETHPTIMEUL,
PMSCHEDACTIVITYCELLUL,
PMPDCPPKTDISCDLPELR,
PMPDCPPKTDISCDLPELRUU,
PMPDCPPKTDISCDLHO,
PMPDCPPKTRECEIVEDDL,
PMPDCPPKTLOSTUL,
PMPDCPPKTRECEIVEDUL,
PMUECTXTRELSCEUTRA,
PMUECTXTRELSCWCDMA,
PMPRBUSEDDLBCCH,
PMPRBUSEDDLDTCH,
PMPRBUSEDDLPCCH,
PMPRBUSEDDLSRB,
PMPRBAVAILDL,
PMPRBUSEDULDTCH,
PMPRBUSEDULSRB,
PMPRBUSEDUL,
PMPRBAVAILUL,
PMBADCOVEVALREPORT,
PMBESTCELLEVALREPORT
FROM
MADELA_PS_EUTCFD3_E4UC_day E3 ,
MADELA_PS_EUTCFD76_E4UC_day E76 ,
MADELA_PS_EUTCFD67_E4UC_day E67 ,
MADELA_PS_EUTCFD1_E4UC_day E1 ,
MADELA_PS_EUTCFD70_E4UC_day E70 ,
MADELA_PS_EUTCFD2_E4UC_day E2 ,
MADELA_PS_EUTCFD66_E4UC_day E66 ,
MADELA_PS_ETCF105_E4UC_day E105 ,
MADELA_PS_ETCF102_E4UC_day E102 ,
MADELA_PS_EUTCFD20_E4UC_DAY E20,
MADELA_PS_EUTCFD21_E4UC_DAY E21,
MADELA_PS_EUTCFD22_E4UC_DAY E22,
MADELA_PS_EUTCFD23_E4UC_DAY E23,
MADELA_PS_EUTCFD24_E4UC_DAY E24,
MADELA_PS_EUTCFD71_E4UC_DAY E71,
MADELA_PS_EUTCFD61_E4UC_DAY E61,
MADELA_PS_EUTCFD28_E4UC_DAY E28,
MADELA_PS_EUTCFD31_E4UC_DAY E31,
MADELA_PS_EUTCFD69_E4UC_DAY E69,
MADELA_PS_EUTCFD33_E4UC_DAY E33,
MADELA_PS_EUTCFD35_E4UC_DAY E35,
MADELA_PS_EUTCFD32_E4UC_DAY E32,
MADELA_PS_EUTCFD5_E4UC_DAY E5,
MADELA_PS_EUTCFD34_E4UC_DAY E34,
MADELA_PS_EUTCFD30_E4UC_DAY E30,
MADELA_PS_EUTCFD88_E4UC_DAY E88,
MADELA_PS_EUTCFD89_E4UC_DAY E89,
MADELA_PS_EUTCFD92_E4UC_DAY E92,
MADELA_PS_EUTCFD93_E4UC_DAY E93,
MADELA_PS_EUTCFD85_E4UC_DAY E85,
MADELA_PS_EUTCFD87_E4UC_DAY E87,
MADELA_PS_EUTCFD86_E4UC_DAY E86,
MADELA_PS_EUTCFD91_E4UC_DAY E91,
MADELA_PS_EUTCFD75_E4UC_DAY E75,
MADELA_PS_EUTCFD74_E4UC_DAY E74,
UTP_COMMON_OBJECTS OB ,
UTP_COMMON_OBJECTS OB2
WHERE
OB.CO_GID = E3.E4UC_ID
AND OB2.CO_GID = E3.E4NB_ID
AND E3.E4NB_ID = E76.E4NB_ID
AND E3.E4NF_ID = E76.E4NF_ID
AND E3.E4UC_ID = E76.E4UC_ID
AND E3.PERIOD_START_TIME = E76.PERIOD_START_TIME
AND E3.E4NB_ID = E105.E4NB_ID
AND E3.E4NF_ID = E105.E4NF_ID
AND E3.E4UC_ID = E105.E4UC_ID
AND E3.PERIOD_START_TIME = E105.PERIOD_START_TIME
AND E3.E4NB_ID = E66.E4NB_ID
AND E3.E4NF_ID = E66.E4NF_ID
AND E3.E4UC_ID = E66.E4UC_ID
AND E3.PERIOD_START_TIME = E66.PERIOD_START_TIME
AND E3.E4NB_ID = E67.E4NB_ID
AND E3.E4NF_ID = E67.E4NF_ID
AND E3.E4UC_ID = E67.E4UC_ID
AND E3.PERIOD_START_TIME = E67.PERIOD_START_TIME
AND E3.E4NB_ID = E1.E4NB_ID
AND E3.E4NF_ID = E1.E4NF_ID
AND E3.E4UC_ID = E1.E4UC_ID
AND E3.PERIOD_START_TIME = E1.PERIOD_START_TIME
AND E3.E4NB_ID = E70.E4NB_ID
AND E3.E4NF_ID = E70.E4NF_ID
AND E3.E4UC_ID = E70.E4UC_ID
AND E3.PERIOD_START_TIME = E70.PERIOD_START_TIME
AND E3.E4NB_ID = E2.E4NB_ID
AND E3.E4NF_ID = E2.E4NF_ID
AND E3.E4UC_ID = E2.E4UC_ID
AND E3.PERIOD_START_TIME = E2.PERIOD_START_TIME
AND E3.E4NB_ID = E102.E4NB_ID
AND E3.E4NF_ID = E102.E4NF_ID
AND E3.E4UC_ID = E102.E4UC_ID
AND E3.PERIOD_START_TIME = E102.PERIOD_START_TIME
AND E3.E4NB_ID = E20.E4NB_ID
AND E3.E4NF_ID = E20.E4NF_ID
AND E3.E4UC_ID = E20.E4UC_ID
AND E3.PERIOD_START_TIME = E20.PERIOD_START_TIME
AND E3.E4NB_ID = E21.E4NB_ID
AND E3.E4NF_ID = E21.E4NF_ID
AND E3.E4UC_ID = E21.E4UC_ID
AND E3.PERIOD_START_TIME = E21.PERIOD_START_TIME
AND E3.E4NB_ID = E22.E4NB_ID
AND E3.E4NF_ID = E22.E4NF_ID
AND E3.E4UC_ID = E22.E4UC_ID
AND E3.PERIOD_START_TIME = E22.PERIOD_START_TIME
AND E3.E4NB_ID = E23.E4NB_ID
AND E3.E4NF_ID = E23.E4NF_ID
AND E3.E4UC_ID = E23.E4UC_ID
AND E3.PERIOD_START_TIME = E23.PERIOD_START_TIME
AND E3.E4NB_ID = E24.E4NB_ID
AND E3.E4NF_ID = E24.E4NF_ID
AND E3.E4UC_ID = E24.E4UC_ID
AND E3.PERIOD_START_TIME = E24.PERIOD_START_TIME
AND E3.E4NB_ID = E71.E4NB_ID
AND E3.E4NF_ID = E71.E4NF_ID
AND E3.E4UC_ID = E71.E4UC_ID
AND E3.PERIOD_START_TIME = E71.PERIOD_START_TIME
AND E3.E4NB_ID = E61.E4NB_ID
AND E3.E4NF_ID = E61.E4NF_ID
AND E3.E4UC_ID = E61.E4UC_ID
AND E3.PERIOD_START_TIME = E61.PERIOD_START_TIME
AND E3.E4NB_ID = E28.E4NB_ID
AND E3.E4NF_ID = E28.E4NF_ID
AND E3.E4UC_ID = E28.E4UC_ID
AND E3.PERIOD_START_TIME = E28.PERIOD_START_TIME
AND E3.E4NB_ID = E31.E4NB_ID
AND E3.E4NF_ID = E31.E4NF_ID
AND E3.E4UC_ID = E31.E4UC_ID
AND E3.PERIOD_START_TIME = E31.PERIOD_START_TIME
AND E3.E4NB_ID = E69.E4NB_ID
AND E3.E4NF_ID = E69.E4NF_ID
AND E3.E4UC_ID = E69.E4UC_ID
AND E3.PERIOD_START_TIME = E69.PERIOD_START_TIME
AND E3.E4NB_ID = E33.E4NB_ID
AND E3.E4NF_ID = E33.E4NF_ID
AND E3.E4UC_ID = E33.E4UC_ID
AND E3.PERIOD_START_TIME = E33.PERIOD_START_TIME
AND E3.E4NB_ID = E35.E4NB_ID
AND E3.E4NF_ID = E35.E4NF_ID
AND E3.E4UC_ID = E35.E4UC_ID
AND E3.PERIOD_START_TIME = E35.PERIOD_START_TIME
AND E3.E4NB_ID = E32.E4NB_ID
AND E3.E4NF_ID = E32.E4NF_ID
AND E3.E4UC_ID = E32.E4UC_ID
AND E3.PERIOD_START_TIME = E32.PERIOD_START_TIME
AND E3.E4NB_ID = E5.E4NB_ID
AND E3.E4NF_ID = E5.E4NF_ID
AND E3.E4UC_ID = E5.E4UC_ID
AND E3.PERIOD_START_TIME = E5.PERIOD_START_TIME
AND E3.E4NB_ID = E34.E4NB_ID
AND E3.E4NF_ID = E34.E4NF_ID
AND E3.E4UC_ID = E34.E4UC_ID
AND E3.PERIOD_START_TIME = E34.PERIOD_START_TIME
AND E3.E4NB_ID = E30.E4NB_ID
AND E3.E4NF_ID = E30.E4NF_ID
AND E3.E4UC_ID = E30.E4UC_ID
AND E3.PERIOD_START_TIME = E30.PERIOD_START_TIME
AND E3.E4NB_ID = E88.E4NB_ID
AND E3.E4NF_ID = E88.E4NF_ID
AND E3.E4UC_ID = E88.E4UC_ID
AND E3.PERIOD_START_TIME = E88.PERIOD_START_TIME
AND E3.E4NB_ID = E89.E4NB_ID
AND E3.E4NF_ID = E89.E4NF_ID
AND E3.E4UC_ID = E89.E4UC_ID
AND E3.PERIOD_START_TIME = E89.PERIOD_START_TIME
AND E3.E4NB_ID = E92.E4NB_ID
AND E3.E4NF_ID = E92.E4NF_ID
AND E3.E4UC_ID = E92.E4UC_ID
AND E3.PERIOD_START_TIME = E92.PERIOD_START_TIME
AND E3.E4NB_ID = E93.E4NB_ID
AND E3.E4NF_ID = E93.E4NF_ID
AND E3.E4UC_ID = E93.E4UC_ID
AND E3.PERIOD_START_TIME = E93.PERIOD_START_TIME
AND E3.E4NB_ID = E85.E4NB_ID
AND E3.E4NF_ID = E85.E4NF_ID
AND E3.E4UC_ID = E85.E4UC_ID
AND E3.PERIOD_START_TIME = E85.PERIOD_START_TIME
AND E3.E4NB_ID = E87.E4NB_ID
AND E3.E4NF_ID = E87.E4NF_ID
AND E3.E4UC_ID = E87.E4UC_ID
AND E3.PERIOD_START_TIME = E87.PERIOD_START_TIME
AND E3.E4NB_ID = E86.E4NB_ID
AND E3.E4NF_ID = E86.E4NF_ID
AND E3.E4UC_ID = E86.E4UC_ID
AND E3.PERIOD_START_TIME = E86.PERIOD_START_TIME
AND E3.E4NB_ID = E91.E4NB_ID
AND E3.E4NF_ID = E91.E4NF_ID
AND E3.E4UC_ID = E91.E4UC_ID
AND E3.PERIOD_START_TIME = E91.PERIOD_START_TIME
AND E3.E4NB_ID = E75.E4NB_ID
AND E3.E4NF_ID = E75.E4NF_ID
AND E3.E4UC_ID = E75.E4UC_ID
AND E3.PERIOD_START_TIME = E75.PERIOD_START_TIME
AND E3.E4NB_ID = E74.E4NB_ID
AND E3.E4NF_ID = E74.E4NF_ID
AND E3.E4UC_ID = E74.E4UC_ID
AND E3.PERIOD_START_TIME = E74.PERIOD_START_TIME
AND E3.PERIOD_START_TIME >= TO_DATE('01/01/2023','DD/MM/YYYY')
AND OB2.CO_NAME in (
'L4925'
)
