VIEW: APPS.BNE_VIEWERS_VL

Source

View Text - Preformatted

SELECT V.ROWID ROW_ID, V.APPLICATION_ID, V.VIEWER_CODE, V.OBJECT_VERSION_NUMBER, V.VIEWER_JAVA_CLASS, V.PARAM_LIST_APP_ID, V.PARAM_LIST_CODE, V.CREATE_DOC_LIST_APP_ID, V.CREATE_DOC_LIST_CODE, V.ENABLED_FLAG, T.USER_NAME, V.CREATED_BY, V.CREATION_DATE, V.LAST_UPDATED_BY, V.LAST_UPDATE_LOGIN, V.LAST_UPDATE_DATE FROM BNE_VIEWERS_B V, BNE_VIEWERS_TL T WHERE V.APPLICATION_ID = T.APPLICATION_ID AND V.VIEWER_CODE = T.VIEWER_CODE AND T.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT V.ROWID ROW_ID
, V.APPLICATION_ID
, V.VIEWER_CODE
, V.OBJECT_VERSION_NUMBER
, V.VIEWER_JAVA_CLASS
, V.PARAM_LIST_APP_ID
, V.PARAM_LIST_CODE
, V.CREATE_DOC_LIST_APP_ID
, V.CREATE_DOC_LIST_CODE
, V.ENABLED_FLAG
, T.USER_NAME
, V.CREATED_BY
, V.CREATION_DATE
, V.LAST_UPDATED_BY
, V.LAST_UPDATE_LOGIN
, V.LAST_UPDATE_DATE
FROM BNE_VIEWERS_B V
, BNE_VIEWERS_TL T
WHERE V.APPLICATION_ID = T.APPLICATION_ID
AND V.VIEWER_CODE = T.VIEWER_CODE
AND T.LANGUAGE = USERENV('LANG')