APPS.BIS_DIMS_AND_LEVELS_PKG dependencies on BIS_INDICATORS_VL

Line 106: bis_indicators_vl bi

102: , SUBSTR(NVL(bi.description, '' ''),1,180) KPI_DESCRIPTION1
103: , SUBSTR(NVL(BIS_DIMS_AND_LEVELS_PKG.get_level_names(bi.indicator_id), '' ''),1,180) LEVEL_NAMES
104: , SUBSTR(NVL(f.application_name, '' ''),1,180) Owning_applicn_name2
105: FROM
106: bis_indicators_vl bi
107: , bis_levels_vl bl
108: , BIS_IND_TL_LVL_V bitlv
109: , bis_application_measures bam
110: , fnd_application_vl f

Line 166: bis_indicators_vl bi,

162: ,SUBSTR(NVL(bi.description, '' ''),1,180) KPI_DESCRIPTION1
163: ,bi.short_name LEVEL_NAMES
164: ,SUBSTR(NVL(f.application_name, '' ''),1,180) Owning_applicn_name2
165: FROM
166: bis_indicators_vl bi,
167: bis_application_measures measures,
168: bis_indicators indicators,
169: bsc_sys_datasets_vl datasets,
170: bsc_sys_measures sys,

Line 242: l_kpi_table_names := ' , bis_indicators_vl bi ' ||

238: ELSIF ( l_pname = 'KPI_NM+KPI_NM' ) THEN
239:
240: IF (l_pvalue <> 'All') THEN
241: l_kpi_nm_filter := ' AND bi.name = ''' || l_pvalue || ''' ';
242: l_kpi_table_names := ' , bis_indicators_vl bi ' ||
243: ' , BIS_IND_TL_LVL_V bitlv ';
244: l_kpi_where_clause := ' AND bitlv.indicator_id = bi.indicator_id ' ||
245: ' AND bitlv.level_id = bl.level_id ';
246: END IF;

Line 633: l_kpi_name bis_indicators_vl.name%TYPE;

629: FUNCTION get_kpi_names ( lvl_id IN NUMBER )
630: RETURN VARCHAR2 IS
631:
632: l_kpi_names VARCHAR2(32000) := NULL;
633: l_kpi_name bis_indicators_vl.name%TYPE;
634:
635: CURSOR cur_get_kpi_name IS
636: SELECT DISTINCT name
637: FROM bis_indicators_vl bi

Line 637: FROM bis_indicators_vl bi

633: l_kpi_name bis_indicators_vl.name%TYPE;
634:
635: CURSOR cur_get_kpi_name IS
636: SELECT DISTINCT name
637: FROM bis_indicators_vl bi
638: , BIS_IND_TL_LVL_V bitlv
639: WHERE bitlv.indicator_id = bi.indicator_id
640: AND bitlv.level_id = lvl_id;
641: