APPS.BSC_METADATA_DESC dependencies on BSC_SYS_DIM_LEVELS_BY_GROUP

Line 339: , BSC_SYS_DIM_LEVELS_BY_GROUP C

335: SELECT A.Name, A.Short_Name, A.Dim_Level_Id, A.Source, B.Level_Table_Name
336: ,B.LEVEL_VIEW_NAME, B.LEVEL_PK_COL, B.DIM_LEVEL_INDEX
337: FROM BSC_SYS_DIM_LEVELS_VL A
338: , BSC_KPI_DIM_LEVELS_VL B
339: , BSC_SYS_DIM_LEVELS_BY_GROUP C
340: WHERE A.Level_Table_Name (+) = B.Level_Table_Name
341: AND C.dim_level_id = nvl(A.dim_level_id, C.dim_level_id)
342: AND B.Indicator = l_Kpi_Id
343: AND B.Dim_Set_Id = l_Dim_set_Id