Product: | BNE - Web Applications Desktop Integrator |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BNE_CACHE_DIRECTIVES_VL |
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')