APPS.BSC_METADATA_DESC dependencies on BSC_SYS_DATASETS_VL

Line 170: FROM BSC_SYS_DATASETS_VL A

166: SELECT A.dataset_id, A.Name, A.COLOR_METHOD
167: ,A.SOURCE ,A.Measure_Id1,
168: B.Measure_ID M_FLAG, B.Short_Name Short_Name1, B.MEASURE_COL, B.SOURCE SOURCE1
169: ,A.Measure_Id2
170: FROM BSC_SYS_DATASETS_VL A
171: , BSC_SYS_MEASURES B
172: WHERE B.Measure_ID (+) = A.Measure_ID1
173: AND A.dataset_id = l_Dataset_id;
174: -------------------------------------

Line 203: || '> assigned to invalid Data Set Id in table BSC_KPI_ANALYSIS_MEASURES_VL. Dataset Id <'||bsc_cd.DATASET_ID||'> not exitst in table BSC_SYS_DATASETS_VL.' ;

199: put_line(getMargin('.', g_margin+2)||'DIM_SET_ID is <'||bsc_cd.DIM_SET_ID ||'> ' );
200: put_line(getMargin('.', g_margin+2)||'DATASET_ID is <'||bsc_cd.DATASET_ID ||'> ' );
201: -------------- Sys Data sets
202: l_not_found_msg2 := getMargin('-', g_margin+4)||'ERROR. Objective ID <' ||l_Kpi_Id
203: || '> assigned to invalid Data Set Id in table BSC_KPI_ANALYSIS_MEASURES_VL. Dataset Id <'||bsc_cd.DATASET_ID||'> not exitst in table BSC_SYS_DATASETS_VL.' ;
204: l_Dataset_id := bsc_cd.DATASET_ID;
205: FOR bsc_dset_cd IN c_Data_Set LOOP
206: l_not_found_msg2 := NULL;
207: put_line(getMargin('.', g_margin+4)||'NAME (Data set Name)is <'||bsc_dset_cd.NAME ||'> ' );