VIEW: APPS.BNE_CACHE_DIRECTIVES_VL

Source

View Text - Preformatted

SELECT V.ROWID ROW_ID, V.APPLICATION_ID, V.DIRECTIVE_CODE, V.OBJECT_VERSION_NUMBER, V.MAX_SIZE, V.MAX_HITS, V.MAX_AGE, V.DISCRIMINATOR_TYPE, V.DISCRIMINATOR_VALUE, T.USER_NAME, V.CREATED_BY, V.CREATION_DATE, V.LAST_UPDATED_BY, V.LAST_UPDATE_LOGIN, V.LAST_UPDATE_DATE FROM BNE_CACHE_DIRECTIVES_B V, BNE_CACHE_DIRECTIVES_TL T WHERE V.APPLICATION_ID = T.APPLICATION_ID AND V.DIRECTIVE_CODE = T.DIRECTIVE_CODE AND T.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT V.ROWID ROW_ID
, V.APPLICATION_ID
, V.DIRECTIVE_CODE
, V.OBJECT_VERSION_NUMBER
, V.MAX_SIZE
, V.MAX_HITS
, V.MAX_AGE
, V.DISCRIMINATOR_TYPE
, V.DISCRIMINATOR_VALUE
, T.USER_NAME
, V.CREATED_BY
, V.CREATION_DATE
, V.LAST_UPDATED_BY
, V.LAST_UPDATE_LOGIN
, V.LAST_UPDATE_DATE
FROM BNE_CACHE_DIRECTIVES_B V
, BNE_CACHE_DIRECTIVES_TL T
WHERE V.APPLICATION_ID = T.APPLICATION_ID
AND V.DIRECTIVE_CODE = T.DIRECTIVE_CODE
AND T.LANGUAGE = USERENV('LANG')