FND Design Data [Home] [Help]

View: BISFV_APPLICATION_MEASURES

Product: BIS - Applications BIS
Description:
Implementation/DBA Data: Not implemented in this database
View Text

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

Columns

Name
MEASURE_ID
MEASURE_SHORT_NAME
MEASURE_NAME
APPLICATION_ID
APPLICATION_SHORT_NAME
APPLICATION_NAME
OWNING_APPLICATION