68: AND TF.Dim_Level_Id NOT IN
69: ( SELECT SL.Dim_Level_Id
70: FROM BSC_TAB_INDICATORS TI
71: , BSC_KPI_DIM_LEVELS_B K
72: , BSC_SYS_DIM_LEVELS_B SL
73: WHERE SL.SOURCE <> 'PMF'
74: AND TI.Tab_Id = p_Tab_Id
75: AND K.INDICATOR = TI.INDICATOR
76: AND SL.Level_Table_Name = K.Level_Table_Name
370: ) IS
371: l_indicator NUMBER;
372: l_kpi_flag NUMBER;
373:
374: l_Sys_Table_Name BSC_SYS_DIM_LEVELS_B.Level_Table_Name%TYPE;
375: l_Sys_View_Name BSC_SYS_DIM_LEVELS_B.Level_View_Name%TYPE;
376: l_Kpi_View_Name BSC_KPI_DIM_LEVELS_B.Level_View_Name%TYPE;
377: l_New_View_Name BSC_KPI_DIM_LEVELS_B.Level_View_Name%TYPE;
378:
371: l_indicator NUMBER;
372: l_kpi_flag NUMBER;
373:
374: l_Sys_Table_Name BSC_SYS_DIM_LEVELS_B.Level_Table_Name%TYPE;
375: l_Sys_View_Name BSC_SYS_DIM_LEVELS_B.Level_View_Name%TYPE;
376: l_Kpi_View_Name BSC_KPI_DIM_LEVELS_B.Level_View_Name%TYPE;
377: l_New_View_Name BSC_KPI_DIM_LEVELS_B.Level_View_Name%TYPE;
378:
379: -- CURSOT to get the KPI Dimension Levels that need to be synchronize with the
386: , KD.Level_View_Name KPI_VIEW
387: , NVL(FV.Level_View_Name, SD.Level_View_Name) NEW_VIEW
388: FROM BSC_TAB_INDICATORS TI
389: , BSC_KPI_DIM_LEVELS_B KD
390: , BSC_SYS_DIM_LEVELS_B SD
391: , (
392: SELECT *
393: FROM BSC_SYS_FILTERS_VIEWS A
394: WHERE A.Source_Type = BSC_DIM_FILTERS_PUB.SOURCE_TYPE_TAB
410: , SD.Level_View_Name SYS_VIEW
411: , KD.Level_View_Name KPI_VIEW
412: FROM BSC_TAB_INDICATORS TI
413: , BSC_KPI_DIM_LEVELS_B KD
414: , BSC_SYS_DIM_LEVELS_B SD
415: WHERE KD.INDICATOR = TI.INDICATOR (+)
416: AND TI.Tab_Id IS NULL
417: AND KD.Level_Table_Name = SD.Level_Table_Name
418: AND KD.Level_View_Name <> SD.Level_View_Name;