APPS.BSC_METADATA_OPTIMIZER_PKG dependencies on BSC_KPIS_VL

Line 280: select count(1) from bsc_kpis_vl

276: END;
277:
278: function is_totally_shared_obj(p_objective in number) return boolean is
279: cursor cShared(p_pattern varchar2) is
280: select count(1) from bsc_kpis_vl
281: where indicator=p_objective
282: and share_flag=2
283: and not exists (select 1 from bsc_db_tables where instr(table_name, p_pattern)>0);
284: l_count number;

Line 781: FROM BSC_KPIS_VL KPIS, BSC_KPI_PROPERTIES prop

777:
778: PROCEDURE writeKPIList IS
779: cursor cList IS
780: SELECT KPIS.INDICATOR, KPIS.NAME, KPIS.PROTOTYPE_FLAG , decode(nvl(prop.property_value, 1), 1, 'Summary Tables/MVs', 'Analytical Workspace') impl_type
781: FROM BSC_KPIS_VL KPIS, BSC_KPI_PROPERTIES prop
782: WHERE kpis.INDICATOR IN
783: (SELECT INDICATOR FROM BSC_TMP_OPT_UI_KPIS WHERE process_id=g_processID)
784: AND kpis.indicator=prop.indicator(+)
785: and prop.property_code(+) = 'IMPLEMENTATION_TYPE'