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.

VIEW: APPS.BIS_APP_NAMES_RPTS_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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