DBA Data[Home] [Help]

VIEW: APPS.BIS_MEASURES_EXTENSION_VL

Source

View Text - Preformatted

SELECT MEAS_EXT.MEASURE_SHORT_NAME , MEAS_EXT_TL.NAME , MEAS_EXT_TL.DESCRIPTION, MEAS_EXT.FUNCTIONAL_AREA_ID, MEAS_EXT.CREATED_BY , MEAS_EXT.CREATION_DATE , MEAS_EXT.LAST_UPDATED_BY, MEAS_EXT.LAST_UPDATE_DATE, MEAS_EXT.LAST_UPDATE_LOGIN FROM BIS_MEASURES_EXTENSION MEAS_EXT, BIS_MEASURES_EXTENSION_TL MEAS_EXT_TL WHERE MEAS_EXT.MEASURE_SHORT_NAME = MEAS_EXT_TL.MEASURE_SHORT_NAME AND MEAS_EXT_TL.LANGUAGE = USERENV('LANG')
   
View Text - HTML Formatted

SELECT MEAS_EXT.MEASURE_SHORT_NAME
, MEAS_EXT_TL.NAME
, MEAS_EXT_TL.DESCRIPTION
, MEAS_EXT.FUNCTIONAL_AREA_ID
, MEAS_EXT.CREATED_BY
, MEAS_EXT.CREATION_DATE
, MEAS_EXT.LAST_UPDATED_BY
, MEAS_EXT.LAST_UPDATE_DATE
, MEAS_EXT.LAST_UPDATE_LOGIN
FROM BIS_MEASURES_EXTENSION MEAS_EXT
, BIS_MEASURES_EXTENSION_TL MEAS_EXT_TL
WHERE MEAS_EXT.MEASURE_SHORT_NAME = MEAS_EXT_TL.MEASURE_SHORT_NAME
AND MEAS_EXT_TL.LANGUAGE = USERENV('LANG')