APPS.BSC_METADATA_DESC dependencies on BSC_KPI_DIM_SETS_VL

Line 322: FROM BSC_KPI_DIM_SETS_VL

318: AND K.RESPONSIBILITY_ID = R.RESPONSIBILITY_ID (+);
319: -------------------------------------
320: CURSOR c_KPI_Dim_sets IS
321: SELECT DIM_SET_ID, NAME
322: FROM BSC_KPI_DIM_SETS_VL
323: WHERE INDICATOR = l_Kpi_Id;
324: -------------------------------------
325: CURSOR c_KPI_Dimensions IS
326: SELECT A.Name, A.Short_Name, B.Dim_Group_Id

Line 429: FROM BSC_KPI_DIM_SETS_VL

425: FROM BSC_KPI_DIM_GROUPS K
426: WHERE K.Indicator = l_Kpi_Id
427: AND K.Dim_Set_Id NOT IN (
428: SELECT DIM_SET_ID
429: FROM BSC_KPI_DIM_SETS_VL
430: WHERE INDICATOR = l_Kpi_Id
431: );
432:
433: BEGIN

Line 521: --PART 2 OF INFORMATION, get information about dimension sets from BSC_KPI_DIM_SETS_VL table

517: IF (l_not_found_msg IS NOT NULL) THEN
518: put_line(l_not_found_msg);
519: END IF;
520:
521: --PART 2 OF INFORMATION, get information about dimension sets from BSC_KPI_DIM_SETS_VL table
522: l_not_found_msg := ' There is not Dimension Sets defined in BSC_KPI_DIM_SETS_VL table ';
523: put_line('---------------------------------------------------------------------------');
524: put_line('Objective Dimension Sets Information from BSC_KPI_DIM_SETS_VL table:');
525: put_line('---------------------------------------------------------------------------');

Line 522: l_not_found_msg := ' There is not Dimension Sets defined in BSC_KPI_DIM_SETS_VL table ';

518: put_line(l_not_found_msg);
519: END IF;
520:
521: --PART 2 OF INFORMATION, get information about dimension sets from BSC_KPI_DIM_SETS_VL table
522: l_not_found_msg := ' There is not Dimension Sets defined in BSC_KPI_DIM_SETS_VL table ';
523: put_line('---------------------------------------------------------------------------');
524: put_line('Objective Dimension Sets Information from BSC_KPI_DIM_SETS_VL table:');
525: put_line('---------------------------------------------------------------------------');
526: FOR bsc_cd IN c_KPI_Dim_sets LOOP

Line 524: put_line('Objective Dimension Sets Information from BSC_KPI_DIM_SETS_VL table:');

520:
521: --PART 2 OF INFORMATION, get information about dimension sets from BSC_KPI_DIM_SETS_VL table
522: l_not_found_msg := ' There is not Dimension Sets defined in BSC_KPI_DIM_SETS_VL table ';
523: put_line('---------------------------------------------------------------------------');
524: put_line('Objective Dimension Sets Information from BSC_KPI_DIM_SETS_VL table:');
525: put_line('---------------------------------------------------------------------------');
526: FOR bsc_cd IN c_KPI_Dim_sets LOOP
527: l_not_found_msg := NULL;
528: put_line('-> DIM_SET_ID (Dimension Set Id) is <'||bsc_cd.DIM_SET_ID||'>');