APPS.BSC_METADATA_DESC dependencies on BSC_KPIS_VL

Line 289: FROM BSC_KPIS_VL

285: , Indicator_Type
286: , Share_Flag
287: , Short_Name
288: , Source_Indicator
289: FROM BSC_KPIS_VL
290: WHERE Indicator = l_Kpi_Id;
291: -------------------------------------
292: CURSOR c_Share_Kpi_Ids IS
293: SELECT indicator

Line 296: FROM BSC_KPIS_VL

292: CURSOR c_Share_Kpi_Ids IS
293: SELECT indicator
294: , Name
295: , Short_Name
296: FROM BSC_KPIS_VL
297: WHERE Source_Indicator = l_Kpi_Id;
298: -------------------------------------
299: CURSOR c_Tab_Ids IS
300: SELECT TI.TAB_ID, T.NAME

Line 438: --PART 1 OF INFORMATION, get general information from BSC_KPIS_VL table

434: l_Kpi_Id := p_kpi_id;
435: put_line('**** METADATA DESCRIPTION OBJECTIVE <'||l_Kpi_Id||'> BEGIN HERE ****');
436: SELECT Name INTO l_database FROM V$DATABASE;
437: l_error_msg := ' Objective ID <'||l_Kpi_Id||'> does not exists in '||l_database||' envionment';
438: --PART 1 OF INFORMATION, get general information from BSC_KPIS_VL table
439: put_line('---------------------------------------------------------------------------');
440: put_line('General Objective Information from BSC_KPIS_VL table');
441: put_line('---------------------------------------------------------------------------');
442: FOR bsc_cd IN c_KPI_Info LOOP

Line 440: put_line('General Objective Information from BSC_KPIS_VL table');

436: SELECT Name INTO l_database FROM V$DATABASE;
437: l_error_msg := ' Objective ID <'||l_Kpi_Id||'> does not exists in '||l_database||' envionment';
438: --PART 1 OF INFORMATION, get general information from BSC_KPIS_VL table
439: put_line('---------------------------------------------------------------------------');
440: put_line('General Objective Information from BSC_KPIS_VL table');
441: put_line('---------------------------------------------------------------------------');
442: FOR bsc_cd IN c_KPI_Info LOOP
443: l_error_msg := NULL;
444: put_line('-> INDICATOR (Objective Id) is <'||bsc_cd.INDICATOR||'>');