DBA Data[Home] [Help]

APPS.BSC_BIS_DIM_OBJ_PUB dependencies on BSC_KPIS_B

Line 2094: , BSC_KPIS_B B

2090: SELECT DISTINCT A.indicator Indicator
2091: , A.dim_set_id Dim_Set_Id
2092: FROM BSC_KPI_DIM_LEVELS_B A
2093: , BSC_SYS_DIM_LEVELS_B D
2094: , BSC_KPIS_B B
2095: WHERE A.Level_Table_Name = D.Level_Table_Name
2096: AND B.Indicator = A.Indicator
2097: AND B.Share_Flag <> 2
2098: AND D.Dim_Level_Id = l_bsc_dim_obj_rec.Bsc_Level_Id;

Line 2128: BSC_KPIS_B C

2124: SELECT DISTINCT A.INDICATOR Indicator,
2125: A.DIM_SET_ID Dim_Set_Id
2126: FROM BSC_KPI_DIM_LEVELS_VL A,
2127: BSC_SYS_DIM_LEVELS_VL B,
2128: BSC_KPIS_B C
2129: WHERE A.LEVEL_TABLE_NAME=B.LEVEL_TABLE_NAME
2130: AND C.INDICATOR = A.INDICATOR
2131: AND C.SHARE_FLAG <> 2
2132: AND INSTR(','||l_child_dim_obj_list||',', ','||b.dim_level_id||',') > 0;