eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_DIM_FILTERS_PVT dependencies on BSC_KPI_DIM_LEVELS_B

Line 71: , BSC_KPI_DIM_LEVELS_B K

67: AND TF.Source_Code = p_Tab_Id
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

Line 376: l_Kpi_View_Name BSC_KPI_DIM_LEVELS_B.Level_View_Name%TYPE;

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
380: -- tab dimension filters

Line 377: l_New_View_Name BSC_KPI_DIM_LEVELS_B.Level_View_Name%TYPE;

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
380: -- tab dimension filters
381:

Line 389: , BSC_KPI_DIM_LEVELS_B KD

385: , SD.Level_View_Name SYS_VIEW
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

Line 413: , BSC_KPI_DIM_LEVELS_B KD

409: , SD.Level_Table_Name SYS_TABLE
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

Line 440: -- update table BSC_KPI_DIM_LEVELS_B

436: , l_New_View_Name;
437:
438: EXIT WHEN c_Kpi_Dim_Obj_To_Synch%NOTFOUND;
439:
440: -- update table BSC_KPI_DIM_LEVELS_B
441: UPDATE BSC_KPI_DIM_LEVELS_B
442: SET Level_View_Name = l_New_View_Name
443: WHERE INDICATOR = l_indicator
444: AND Level_Table_Name = l_Sys_Table_Name;

Line 441: UPDATE BSC_KPI_DIM_LEVELS_B

437:
438: EXIT WHEN c_Kpi_Dim_Obj_To_Synch%NOTFOUND;
439:
440: -- update table BSC_KPI_DIM_LEVELS_B
441: UPDATE BSC_KPI_DIM_LEVELS_B
442: SET Level_View_Name = l_New_View_Name
443: WHERE INDICATOR = l_indicator
444: AND Level_Table_Name = l_Sys_Table_Name;
445:

Line 446: ----DBMS_OUTPUT.PUT_LINE(' Upated BSC_KPI_DIM_LEVELS_B for INDICATOR = ' || l_indicator || ' AND LEVEL_TABLE_NAME = ' || l_New_View_Name );

442: SET Level_View_Name = l_New_View_Name
443: WHERE INDICATOR = l_indicator
444: AND Level_Table_Name = l_Sys_Table_Name;
445:
446: ----DBMS_OUTPUT.PUT_LINE(' Upated BSC_KPI_DIM_LEVELS_B for INDICATOR = ' || l_indicator || ' AND LEVEL_TABLE_NAME = ' || l_New_View_Name );
447:
448: -- Update KPI Prototype flag
449: IF (l_Kpi_View_Name = l_Sys_View_Name) THEN
450: --It change from No-Filter To Filter

Line 480: -- update table BSC_KPI_DIM_LEVELS_B

476: , l_Kpi_View_Name;
477:
478: EXIT WHEN c_Kpi_Dim_Obj_To_Synch2%NOTFOUND;
479:
480: -- update table BSC_KPI_DIM_LEVELS_B
481: UPDATE BSC_KPI_DIM_LEVELS_B
482: SET Level_View_Name = l_Sys_View_Name
483: WHERE INDICATOR = l_indicator
484: AND Level_Table_Name = l_Sys_Table_Name;

Line 481: UPDATE BSC_KPI_DIM_LEVELS_B

477:
478: EXIT WHEN c_Kpi_Dim_Obj_To_Synch2%NOTFOUND;
479:
480: -- update table BSC_KPI_DIM_LEVELS_B
481: UPDATE BSC_KPI_DIM_LEVELS_B
482: SET Level_View_Name = l_Sys_View_Name
483: WHERE INDICATOR = l_indicator
484: AND Level_Table_Name = l_Sys_Table_Name;
485:

Line 486: ----DBMS_OUTPUT.PUT_LINE(' Upated BSC_KPI_DIM_LEVELS_B for INDICATOR = ' || l_indicator || ' AND LEVEL_TABLE_NAME = ' || l_Sys_View_Name );

482: SET Level_View_Name = l_Sys_View_Name
483: WHERE INDICATOR = l_indicator
484: AND Level_Table_Name = l_Sys_Table_Name;
485:
486: ----DBMS_OUTPUT.PUT_LINE(' Upated BSC_KPI_DIM_LEVELS_B for INDICATOR = ' || l_indicator || ' AND LEVEL_TABLE_NAME = ' || l_Sys_View_Name );
487: END LOOP;
488: CLOSE c_Kpi_Dim_Obj_To_Synch2;
489:
490: END IF;