DBA Data[Home] [Help]

APPS.BSC_BIS_DIM_OBJ_PUB dependencies on BSC_KPI_DIM_LEVELS_VL

Line 470: FROM bsc_kpi_dim_levels_vl K

466: SELECT K.indicator
467: ,K.dim_set_id
468: ,K.dim_level_index
469: ,K.level_table_name
470: FROM bsc_kpi_dim_levels_vl K
471: ,bsc_sys_dim_levels_b S
472: WHERE S.level_Table_name = K.level_table_name
473: AND S.dim_level_id IN ( p_Dim_Level_Id,p_Parent_Dim_Level_Id)
474: AND K.parent_level_rel IS NOT NULL

Line 2126: FROM BSC_KPI_DIM_LEVELS_VL A,

2122:
2123: CURSOR c_Kpi_Dim_Set1 IS
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