APPS.BSC_METADATA_DESC dependencies on BSC_KPI_DIM_LEVELS_VL

Line 338: , BSC_KPI_DIM_LEVELS_VL B

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)
342: AND B.Indicator = l_Kpi_Id

Line 537: --PART 4 OF INFORMATION, get information about dimension objects within KPI's Dimension Set in table BSC_KPI_DIM_LEVELS_VL

533: IF bsc_dim_cd.Name IS NOT NULL THEN
534: put_line('---> DIM_GROUP_ID (Dimension Id) is <'||bsc_dim_cd.DIM_GROUP_ID||'> ');
535: put_line('...... NAME (Dimension Name) is <'||bsc_dim_cd.NAME||'>');
536: put_line('...... SHORT_NAME is <'||bsc_dim_cd.SHORT_NAME||'>');
537: --PART 4 OF INFORMATION, get information about dimension objects within KPI's Dimension Set in table BSC_KPI_DIM_LEVELS_VL
538: l_dim_id := bsc_dim_cd.Dim_Group_Id;
539: FOR bsc_dim_obj_cd IN c_KPI_Dim_obj LOOP
540: IF bsc_dim_obj_cd.Dim_Level_Id IS NOT NULL THEN
541: put_line('-----> DIM_LEVEL_ID (Dim. Object Id)is <'||bsc_dim_obj_cd.DIM_LEVEL_ID||'> ');

Line 551: put_line('........ Error. LEVEL_TABLE_NAME <'||bsc_dim_obj_cd.Level_Table_Name||'> is invalide in table BSC_KPI_DIM_LEVELS_VL' );

547: put_line('........ DIM_LEVEL_INDEX is <'||bsc_dim_obj_cd.DIM_LEVEL_INDEX||'>');
548: ELSE
549: put_line('-----> DIM_LEVEL_INDEX is <'||bsc_dim_obj_cd.DIM_LEVEL_INDEX||'>');
550: put_line('........ LEVEL_TABLE_NAME is <'||bsc_dim_obj_cd.LEVEL_TABLE_NAME||'>');
551: put_line('........ Error. LEVEL_TABLE_NAME <'||bsc_dim_obj_cd.Level_Table_Name||'> is invalide in table BSC_KPI_DIM_LEVELS_VL' );
552: END IF;
553: END LOOP;
554: ELSE
555: put_line('---> DIM_GROUP_ID (Dimension Id) is <'||bsc_dim_cd.DIM_GROUP_ID||'> ');