APPS.BSC_UPGRADES dependencies on BSC_SYS_DATASETS_B

Line 151: -- they were not fetched. We need to join is with bsc_sys_datasets_b

147: IS
148: -- part of bug#3436393: the previous query was not getting all
149: -- the bsc datasets from pmf repository. It was joining with bsc_sys_measures
150: -- but in case of datasets that are formulas between measures
151: -- they were not fetched. We need to join is with bsc_sys_datasets_b
152: CURSOR c_bsc_measures_in_pmf IS
153: SELECT indicator_id, measure_id1, i.short_name
154: FROM bis_indicators i, bsc_sys_datasets_b d
155: WHERE d.dataset_id = i.dataset_id

Line 154: FROM bis_indicators i, bsc_sys_datasets_b d

150: -- but in case of datasets that are formulas between measures
151: -- they were not fetched. We need to join is with bsc_sys_datasets_b
152: CURSOR c_bsc_measures_in_pmf IS
153: SELECT indicator_id, measure_id1, i.short_name
154: FROM bis_indicators i, bsc_sys_datasets_b d
155: WHERE d.dataset_id = i.dataset_id
156: AND d.source = 'BSC';
157:
158: CURSOR c_s2e_kpis(p_indicator_id NUMBER) IS

Line 161: ,bsc_sys_datasets_b BSC_DTS

157:
158: CURSOR c_s2e_kpis(p_indicator_id NUMBER) IS
159: SELECT count(1)
160: FROM bis_indicators BIS_IND
161: ,bsc_sys_datasets_b BSC_DTS
162: ,bsc_sys_measures BSC_MEAS
163: WHERE BIS_IND.dataset_id = BSC_DTS.dataset_id
164: AND BSC_DTS.measure_id1 = BSC_MEAS.measure_id
165: AND BIS_IND.indicator_id = p_indicator_id;

Line 191: FROM bsc_sys_datasets_b;

187: SELECT nvl(max(dataset_id),0) INTO l_max_ds_id_bis
188: FROM bis_indicators;
189:
190: SELECT nvl(max(dataset_id),0) INTO l_max_ds_id_bsc
191: FROM bsc_sys_datasets_b;
192:
193: IF (l_max_ds_id_bis <> l_max_ds_id_bsc) THEN -- dataset ids are out of synch
194: -- remove BSC measures from pmf repository
195: -- Exclude non-corrupt s2e measures.

Line 1108: from bis_indicators i, bis_indicators_tl itl, bsc_sys_datasets_b d, bsc_sys_datasets_tl dtl

1104: cursor synch_lang_cursor is
1105: select i.indicator_id, itl.language, itl.source_lang, i.short_name, d.source, d.dataset_id,
1106: itl.name indicator_name, dtl.name dataset_name,
1107: itl.description, dtl.help
1108: from bis_indicators i, bis_indicators_tl itl, bsc_sys_datasets_b d, bsc_sys_datasets_tl dtl
1109: where i.indicator_id = itl.indicator_id
1110: and i.dataset_id = dtl.dataset_id
1111: and d.dataset_id = dtl.dataset_id
1112: and itl.language = dtl.language

Line 2672: BSC_SYS_DATASETS_B D,

2668: D.MEASURE_ID1,
2669: M.MEASURE_COL,
2670: D.SOURCE
2671: FROM
2672: BSC_SYS_DATASETS_B D,
2673: BSC_SYS_MEASURES M
2674: WHERE
2675: D.SOURCE = BSC_BIS_MEASURE_PUB.c_PMF AND
2676: M.MEASURE_ID = D.MEASURE_ID1;