DBA Data[Home] [Help]

APPS.BSC_METADATA_DESC dependencies on BSC_SYS_MEASURES

Line 171: , BSC_SYS_MEASURES B

167: ,A.SOURCE ,A.Measure_Id1,
168: B.Measure_ID M_FLAG, B.Short_Name Short_Name1, B.MEASURE_COL, B.SOURCE SOURCE1
169: ,A.Measure_Id2
170: FROM BSC_SYS_DATASETS_VL A
171: , BSC_SYS_MEASURES B
172: WHERE B.Measure_ID (+) = A.Measure_ID1
173: AND A.dataset_id = l_Dataset_id;
174: -------------------------------------
175: -- Show Measure Information

Line 179: FROM BSC_SYS_MEASURES

175: -- Show Measure Information
176: -- Used to show information in the secod measure of the dataset
177: CURSOR c_measure IS
178: SELECT Short_Name, MEASURE_COL, SOURCE
179: FROM BSC_SYS_MEASURES
180: WHERE Measure_ID = l_Measure_id;
181:
182: BEGIN
183: l_Kpi_Id := p_Kpi_Id;

Line 214: put_line(getMargin('.', g_margin+6)||'ERROR. Measuare Id <'||bsc_dset_cd.MEASURE_ID1 ||'> is invalid. I does not exists in BSC_SYS_MEASURES .' );

210: put_line(getMargin('.', g_margin+4)||'MEASURE_ID1 is <'||bsc_dset_cd.MEASURE_ID1 ||'> ' );
211: put_line(getMargin('.', g_margin+6)||'SHORT_NAME is <'||bsc_dset_cd.SHORT_NAME1 ||'> ' );
212: put_line(getMargin('.', g_margin+6)||'SOURCE is <'||bsc_dset_cd.SOURCE1 ||'> ' );
213: IF bsc_dset_cd.M_FLAG IS NULL THEN
214: put_line(getMargin('.', g_margin+6)||'ERROR. Measuare Id <'||bsc_dset_cd.MEASURE_ID1 ||'> is invalid. I does not exists in BSC_SYS_MEASURES .' );
215: END IF;
216: IF bsc_dset_cd.MEASURE_ID2 IS NOT NULL THEN
217: put_line(getMargin('.', g_margin+6)||'MEASURE_ID2 is <'||bsc_dset_cd.MEASURE_ID2 ||'> ' );
218: l_not_found_msg3 := getMargin('.', g_margin+8)||'ERROR. Measuare Id <'||bsc_dset_cd.MEASURE_ID2 ||'> is invalid. I does not exists in BSC_SYS_MEASURES .' ;

Line 218: l_not_found_msg3 := getMargin('.', g_margin+8)||'ERROR. Measuare Id <'||bsc_dset_cd.MEASURE_ID2 ||'> is invalid. I does not exists in BSC_SYS_MEASURES .' ;

214: put_line(getMargin('.', g_margin+6)||'ERROR. Measuare Id <'||bsc_dset_cd.MEASURE_ID1 ||'> is invalid. I does not exists in BSC_SYS_MEASURES .' );
215: END IF;
216: IF bsc_dset_cd.MEASURE_ID2 IS NOT NULL THEN
217: put_line(getMargin('.', g_margin+6)||'MEASURE_ID2 is <'||bsc_dset_cd.MEASURE_ID2 ||'> ' );
218: l_not_found_msg3 := getMargin('.', g_margin+8)||'ERROR. Measuare Id <'||bsc_dset_cd.MEASURE_ID2 ||'> is invalid. I does not exists in BSC_SYS_MEASURES .' ;
219: FOR bsc_m_cd IN c_measure LOOP
220: l_not_found_msg3 := NULL;
221: put_line(getMargin('.', g_margin+8)||'SHORT_NAME is <'||bsc_m_cd.SHORT_NAME ||'> ' );
222: put_line(getMargin('.', g_margin+8)||'MEASURE_COL is <'||bsc_m_cd.MEASURE_COL ||'> ' );