APPS.BSC_SIMULATION_VIEW_PUB dependencies on BSC_SYS_MEASURES

Line 44: l_measure_col bsc_sys_measures.measure_col%TYPE;

40: (
41: p_DatasetId IN bsc_sys_datasets_b.dataset_id%TYPE
42: ) RETURN VARCHAR2 IS
43:
44: l_measure_col bsc_sys_measures.measure_col%TYPE;
45: BEGIN
46:
47: IF(p_DatasetId IS NOT NULL) THEN
48: SELECT measure_col

Line 51: , bsc_sys_measures a

47: IF(p_DatasetId IS NOT NULL) THEN
48: SELECT measure_col
49: INTO l_measure_col
50: FROM bsc_sys_datasets_b b
51: , bsc_sys_measures a
52: WHERE b.measure_id1 =a.measure_id
53: AND b.dataset_id =p_DatasetId;
54: END IF;
55: RETURN l_measure_col;

Line 64: ,p_Meas_Col IN bsc_sys_measures.measure_col%TYPE

60: FUNCTION Get_Formula_Base_Columns
61: (
62: p_indicator IN bsc_kpis_b.indicator%TYPE
63: ,p_Dataset_Id IN bsc_sys_datasets_b.dataset_id%TYPE
64: ,p_Meas_Col IN bsc_sys_measures.measure_col%TYPE
65: ) RETURN VARCHAR2 IS
66:
67: l_measure_col bsc_sys_measures.measure_col%TYPE;
68: l_short_name bsc_kpis_b.short_name%TYPE;

Line 67: l_measure_col bsc_sys_measures.measure_col%TYPE;

63: ,p_Dataset_Id IN bsc_sys_datasets_b.dataset_id%TYPE
64: ,p_Meas_Col IN bsc_sys_measures.measure_col%TYPE
65: ) RETURN VARCHAR2 IS
66:
67: l_measure_col bsc_sys_measures.measure_col%TYPE;
68: l_short_name bsc_kpis_b.short_name%TYPE;
69: l_kpi_short_name bis_indicators.short_name%TYPE;
70: l_formula VARCHAR2(32000);
71: l_count NUMBER;

Line 82: ,bsc_sys_measures b

78: v.attribute2,
79: v.attribute3,
80: b.operation|| '('|| b.measure_col || ')' as measure_col
81: FROM ak_region_items_vl v
82: ,bsc_sys_measures b
83: WHERE v.attribute2 =b.short_name
84: AND v.region_code =l_short_name
85: AND v.attribute1 =BSC_SIMULATION_VIEW_PUB.c_MEASURE_NO_TARGET
86: AND v.attribute3 IS NULL

Line 96: ,bsc_sys_measures b

92: v.attribute2,
93: v.attribute3,
94: b.measure_col
95: FROM ak_region_items_vl v
96: ,bsc_sys_measures b
97: WHERE v.attribute2 =b.short_name
98: AND v.region_code =l_short_name
99: AND v.attribute1 =BSC_SIMULATION_VIEW_PUB.c_MEASURE_NO_TARGET
100: AND v.attribute3 IS NOT NULL