DBA Data[Home] [Help]

VIEW: APPS.BISBV_APPLICATION_MEASURES

Source

View Text - Preformatted

SELECT am.indicator_id , i.SHORT_NAME , itl.NAME , am.APPLICATION_ID , am.owning_application , i.DATASET_ID from bis_application_measures am , bis_indicators i , bis_indicators_tl itl WHERE am.indicator_id = i.INDICATOR_ID AND i.INDICATOR_ID = itl.INDICATOR_ID AND itl.LANGUAGE = USERENV('LANG') WITH READ ONLY
View Text - HTML Formatted

SELECT AM.INDICATOR_ID
, I.SHORT_NAME
, ITL.NAME
, AM.APPLICATION_ID
, AM.OWNING_APPLICATION
, I.DATASET_ID
FROM BIS_APPLICATION_MEASURES AM
, BIS_INDICATORS I
, BIS_INDICATORS_TL ITL
WHERE AM.INDICATOR_ID = I.INDICATOR_ID
AND I.INDICATOR_ID = ITL.INDICATOR_ID
AND ITL.LANGUAGE = USERENV('LANG') WITH READ ONLY