View: BIS_APP_NAMES_RPTS_V

Product:	BIS - Applications BIS
Description:
Implementation/DBA Data:	APPS.BIS_APP_NAMES_RPTS_V

View Text

SELECT FA.APPLICATION_ID AS ID
, FA.APPLICATION_NAME AS VALUE
, SYS.SOURCE AS SOURCE
FROM BIS_INDICATORS INDICATORS
, BSC_SYS_DATASETS_VL DATASETS
, BSC_SYS_MEASURES SYS
, FND_APPLICATION_VL FA
, BIS_APPLICATION_MEASURES MEASURES
WHERE INDICATORS.DATASET_ID = DATASETS.DATASET_ID
AND DATASETS.MEASURE_ID1 = SYS.MEASURE_ID
AND INDICATORS.INDICATOR_ID = MEASURES.INDICATOR_ID
AND FA.APPLICATION_ID = MEASURES.APPLICATION_ID GROUP BY FA.APPLICATION_ID
, FA.APPLICATION_NAME
, SYS.SOURCE