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_BIS_MEASURE_PUB dependencies on BSC_SYS_DATASETS_VL

Line 63: -- 24-MAY-04 adrao Delete unwanted Measure Columns based on BSC_SYS_DATASETS_VL.MEASURE_ID2

59: -- 08-APR-04 ankgoel Modified for bug#3557236
60: -- 13-APR-04 ppandey Bug# 3530050- Dynamically generating unique measure col if not unique
61: -- 11-MAY-04 kyadamak Bug# 3616756 - Changed query to get KPIs affected while changing the color method
62: -- 13-MAY-04 adrao Added Exception after BIS_MEASURE_PUB.Create_Measure in Create_Measure API
63: -- 24-MAY-04 adrao Delete unwanted Measure Columns based on BSC_SYS_DATASETS_VL.MEASURE_ID2
64: -- for Bug#3628113
65: -- 25-MAY-04 PAJOHRI Bug #3642186
66: -- 05-JUL-04 ankgoel Bug#3700439 Made changed for rollback issues
67: -- 28-JUL-04 adrao Bug#3798834 Made Aggr. Method change to render a Color warning

Line 207: , BSC_SYS_DATASETS_VL BSC_DSET

203: , BIS_IND.Indicator_Id Bis_Ind_Id
204: , BIS_IND.Actual_Data_Source Bis_Act_Source
205: FROM BIS_INDICATORS BIS_IND
206: , BSC_SYS_MEASURES BSC_MEAS
207: , BSC_SYS_DATASETS_VL BSC_DSET
208: , BIS_TARGET_LEVELS BIS_TAR
209: WHERE UPPER(TRIM(BSC_DSET.Name)) = UPPER(x_measure_name)
210: AND BIS_IND.Indicator_Id = BIS_TAR.Indicator_Id(+)
211: AND BIS_IND.Short_Name = BSC_MEAS.Short_Name

Line 222: , BSC_SYS_DATASETS_VL BSC_DSET

218: , BIS_IND.Indicator_Id Bis_Ind_Id
219: , BIS_IND.Actual_Data_Source Bis_Act_Source
220: FROM BIS_INDICATORS BIS_IND
221: , BSC_SYS_MEASURES BSC_MEAS
222: , BSC_SYS_DATASETS_VL BSC_DSET
223: , BIS_TARGET_LEVELS BIS_TAR
224: WHERE UPPER(TRIM(BSC_DSET.Name)) = UPPER(x_measure_name)
225: AND BIS_IND.Indicator_Id = BIS_TAR.Indicator_Id(+)
226: AND BIS_IND.Short_Name = BSC_MEAS.Short_Name

Line 245: FROM BSC_SYS_DATASETS_VL

241: IF(p_dataset_source = c_BSC) THEN
242:
243: SELECT COUNT(0)
244: INTO l_Count
245: FROM BSC_SYS_DATASETS_VL
246: WHERE UPPER(TRIM(Name)) =UPPER(x_measure_name)
247: AND Source = c_BSC;
248:
249: IF(l_Count>0) THEN

Line 274: FROM BSC_SYS_DATASETS_VL

270: IF(p_dataset_source = c_BSC) THEN
271:
272: SELECT COUNT(0)
273: INTO l_Count
274: FROM BSC_SYS_DATASETS_VL
275: WHERE UPPER(TRIM(Name)) =UPPER(x_measure_name)
276: AND Source = c_BSC
277: AND Dataset_id <> p_dataset_id;
278:

Line 1543: l_Dataset_Name BSC_SYS_DATASETS_VL.Name%TYPE;

1539: l_measure_type BSC_DB_MEASURE_COLS_TL.Measure_Type%TYPE;
1540:
1541: l_Del_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
1542: l_Delete_Source BOOLEAN;
1543: l_Dataset_Name BSC_SYS_DATASETS_VL.Name%TYPE;
1544: l_Same_Name BOOLEAN := FALSE;
1545:
1546: l_last_update_date BIS_INDICATORS.LAST_UPDATE_DATE%TYPE;
1547:

Line 1577: FROM BSC_SYS_DATASETS_VL

1573: WHERE DATASET_ID = p_dataset_id;
1574:
1575: CURSOR c_Bsc_Dataset_Name IS
1576: SELECT NAME
1577: FROM BSC_SYS_DATASETS_VL
1578: WHERE DATASET_ID = p_dataset_id;
1579:
1580: CURSOR c_Bis_Measure_Name IS
1581: SELECT NAME

Line 2498: from bsc_sys_datasets_vl

2494: for i in 1..p_causes_table.count loop
2495: for j in 1..p_effects_table.count loop
2496: if p_effects_table(j) = p_causes_table(i) then
2497: select name into l_name
2498: from bsc_sys_datasets_vl
2499: where dataset_id = p_causes_table(i);
2500:
2501: if (l_measure_names is null) then
2502: l_measure_names := l_name;

Line 3642: FROM bsc_sys_datasets_vl d

3638: l_measure_group_id NUMBER;
3639:
3640: CURSOR c_Meas_Grp IS
3641: SELECT measure_group_id
3642: FROM bsc_sys_datasets_vl d
3643: , bsc_sys_measures m
3644: , bsc_db_measure_cols_vl db
3645: WHERE d.dataset_id = p_dataset_id
3646: AND m.measure_id = d.measure_id1

Line 3656: from bsc_sys_datasets_vl d, bsc_sys_measures m, bsc_db_measure_cols_vl c

3652:
3653: if bsc_utility.isBscInProductionMode then
3654: select count(c.projection_id)
3655: into l_count
3656: from bsc_sys_datasets_vl d, bsc_sys_measures m, bsc_db_measure_cols_vl c
3657: where m.measure_id = d.measure_id1
3658: and c.measure_col = m.measure_col
3659: and d.dataset_id = p_dataset_id;
3660:

Line 3667: from bsc_sys_datasets_vl d, bsc_sys_measures m, bsc_db_measure_cols_vl c

3663:
3664: if(l_count <> 0) then
3665: select c.projection_id, c.measure_type
3666: into l_proj_id, l_measure_type
3667: from bsc_sys_datasets_vl d, bsc_sys_measures m, bsc_db_measure_cols_vl c
3668: where m.measure_id = d.measure_id1
3669: and c.measure_col = m.measure_col
3670: and d.dataset_id = p_dataset_id;
3671: end if;

Line 3701: from bsc_sys_datasets_vl d, bsc_sys_measures m

3697:
3698: if(p_rollup_calc is not null) then
3699: select decode(nvl(BSC_APPS.Get_Property_Value(m.S_COLOR_FORMULA, 'pAvgL'), 'N'), 'Y', 'AVL', m.operation) rollup
3700: into l_rollup_calc
3701: from bsc_sys_datasets_vl d, bsc_sys_measures m
3702: where m.measure_id = d.measure_id1
3703: and d.dataset_id = p_dataset_id ;
3704: end if;
3705:

Line 3709: from bsc_sys_datasets_vl d, bsc_sys_measures m

3705:
3706: if(p_formula is not null) then
3707: select m.measure_col formula
3708: into l_formula
3709: from bsc_sys_datasets_vl d, bsc_sys_measures m
3710: where m.measure_id = d.measure_id1
3711: and d.dataset_id = p_dataset_id ;
3712: end if;
3713:

Line 4007: BSC_SYS_DATASETS_VL C

4003: cursor c_Dataset_Color is
4004: select B.DATASET_ID DATASET_ID, C.COLOR_METHOD COLOR_METHOD
4005: from BSC_OAF_ANALYSYS_OPT_COMB_V A,
4006: BSC_KPI_ANALYSIS_MEASURES_VL B,
4007: BSC_SYS_DATASETS_VL C
4008: where A.INDICATOR = B.INDICATOR
4009: and A.SERIES_ID = B.SERIES_ID
4010: and A.ANALYSIS_OPTION0 = B.ANALYSIS_OPTION0
4011: and A.ANALYSIS_OPTION1 = B.ANALYSIS_OPTION1

Line 4428: FROM bsc_sys_datasets_vl

4424:
4425:
4426: CURSOR c_chk_measid_in_measure(p_measure_id VARCHAR2) IS
4427: SELECT name
4428: FROM bsc_sys_datasets_vl
4429: WHERE measure_id1 = p_measure_id
4430: OR measure_id2 = p_measure_id;
4431:
4432: BEGIN