DBA Data[Home] [Help]

APPS.BSC_METADATA_DESC dependencies on BSC_SYS_DIM_LEVELS_VL

Line 337: FROM BSC_SYS_DIM_LEVELS_VL A

333: CURSOR c_KPI_Dim_obj IS
334: SELECT * FROM (
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)