DBA Data[Home] [Help]

VIEW: APPS.BIS_INDICATORS_VL

Source

View Text - Preformatted

SELECT IND.ROWID ROW_ID , IND.INDICATOR_ID , IND.SHORT_NAME , IND.CREATION_DATE , IND.CREATED_BY , IND.LAST_UPDATE_DATE , IND.LAST_UPDATED_BY , IND.LAST_UPDATE_LOGIN , IND_TL.NAME , IND_TL.DESCRIPTION , IND.DATASET_ID , IND.ENABLED , IND.OBSOLETE , IND.MEASURE_TYPE FROM BIS_INDICATORS IND , BIS_INDICATORS_TL IND_TL WHERE IND.INDICATOR_ID = IND_TL.INDICATOR_ID AND IND_TL.LANGUAGE = USERENV('LANG')
   
View Text - HTML Formatted

SELECT IND.ROWID ROW_ID
, IND.INDICATOR_ID
, IND.SHORT_NAME
, IND.CREATION_DATE
, IND.CREATED_BY
, IND.LAST_UPDATE_DATE
, IND.LAST_UPDATED_BY
, IND.LAST_UPDATE_LOGIN
, IND_TL.NAME
, IND_TL.DESCRIPTION
, IND.DATASET_ID
, IND.ENABLED
, IND.OBSOLETE
, IND.MEASURE_TYPE
FROM BIS_INDICATORS IND
, BIS_INDICATORS_TL IND_TL
WHERE IND.INDICATOR_ID = IND_TL.INDICATOR_ID
AND IND_TL.LANGUAGE = USERENV('LANG')