DBA Data[Home] [Help]

APPS.BSC_BIS_MEASURE_PUB dependencies on BIS_TARGET_LEVELS

Line 208: , BIS_TARGET_LEVELS BIS_TAR

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
212: AND BSC_MEAS.Measure_Id = BSC_DSET.Measure_Id1;

Line 223: , BIS_TARGET_LEVELS BIS_TAR

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
227: AND BSC_MEAS.Measure_Id = BSC_DSET.Measure_Id1