eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_METADATA_DESC dependencies on BSC_KPI_ANALYSIS_MEASURES_VL

Line 152: FROM BSC_KPI_ANALYSIS_MEASURES_VL A

148: -- Datasets and Dimension Sets
149: CURSOR c_KPI_Data_Series IS
150: SELECT A.series_id, A.Name, A.default_value
151: ,A.dataset_id, E.dim_set_id
152: FROM BSC_KPI_ANALYSIS_MEASURES_VL A
153: , bsc_db_dataset_dim_sets_v E
154: WHERE E.INDICATOR = A.INDICATOR
155: AND E.A0 = A.Analysis_Option0
156: AND E.A1 = A.Analysis_Option1

Line 192: || '>. There is any Data Series defined in table BSC_KPI_ANALYSIS_MEASURES_VL for analysis combination <' || l_Anaysis_option0 || '-'

188: g_margin := 0;
189: end if;
190: -------------- kpi Data Series
191: l_not_found_msg := getMargin('-', g_margin)||'Objective ID <'||l_Kpi_Id
192: || '>. There is any Data Series defined in table BSC_KPI_ANALYSIS_MEASURES_VL for analysis combination <' || l_Anaysis_option0 || '-'
193: || l_Anaysis_option1 || '-' || l_Anaysis_option2 || '> in the table BSC_KPI_ANALYSIS_MEASURES_VL ' ;
194: FOR bsc_cd IN c_KPI_Data_Series LOOP
195: l_not_found_msg := NULL;
196: put_line(getMargin('-', g_margin)|| 'SERIES_ID is <'||bsc_cd.SERIES_ID ||'> ' );

Line 193: || l_Anaysis_option1 || '-' || l_Anaysis_option2 || '> in the table BSC_KPI_ANALYSIS_MEASURES_VL ' ;

189: end if;
190: -------------- kpi Data Series
191: l_not_found_msg := getMargin('-', g_margin)||'Objective ID <'||l_Kpi_Id
192: || '>. There is any Data Series defined in table BSC_KPI_ANALYSIS_MEASURES_VL for analysis combination <' || l_Anaysis_option0 || '-'
193: || l_Anaysis_option1 || '-' || l_Anaysis_option2 || '> in the table BSC_KPI_ANALYSIS_MEASURES_VL ' ;
194: FOR bsc_cd IN c_KPI_Data_Series LOOP
195: l_not_found_msg := NULL;
196: put_line(getMargin('-', g_margin)|| 'SERIES_ID is <'||bsc_cd.SERIES_ID ||'> ' );
197: put_line(getMargin('.', g_margin+2)||'NAME is <'||bsc_cd.NAME ||'> ' );

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 ||'> ' );