DBA Data[Home] [Help]

APPS.BSC_DIM_FILTERS_PVT dependencies on BSC_TAB_INDICATORS

Line 70: FROM BSC_TAB_INDICATORS TI

66: WHERE TF.Source_Type = BSC_DIM_FILTERS_PUB.SOURCE_TYPE_TAB
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

Line 388: FROM BSC_TAB_INDICATORS TI

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

Line 412: FROM BSC_TAB_INDICATORS TI

408: SELECT DISTINCT KD.INDICATOR --Distinct need it
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