VIEW: APPS.BIS_SEEDED_MEASURE_RPT_KPI_V

Source

View Text - Preformatted

SELECT bi.indicator_id id, bi.name value, measures.application_id aID, sys.source sc FROM bis_application_measures measures, bis_indicators_vl bi, bsc_sys_datasets_b datasets, bsc_sys_measures sys WHERE bi.indicator_id = measures.indicator_id AND bi.dataset_id = datasets.dataset_id AND datasets.measure_id1 = sys.measure_id
   

View Text - HTML Formatted

SELECT BI.INDICATOR_ID ID
, BI.NAME VALUE
, MEASURES.APPLICATION_ID AID
, SYS.SOURCE SC
FROM BIS_APPLICATION_MEASURES MEASURES
, BIS_INDICATORS_VL BI
, BSC_SYS_DATASETS_B DATASETS
, BSC_SYS_MEASURES SYS
WHERE BI.INDICATOR_ID = MEASURES.INDICATOR_ID
AND BI.DATASET_ID = DATASETS.DATASET_ID
AND DATASETS.MEASURE_ID1 = SYS.MEASURE_ID