[Home] [Help]
View: BNE_QUERIES_VL
Product: | BNE - Web Applications Desktop Integrator |
Description: | BNE_QUERIES_VL is a standard translation view over the BNE_QUERIES entity. |
Implementation/DBA Data: |
APPS.BNE_QUERIES_VL
|
View Text
SELECT V.ROWID ROW_ID
, V.APPLICATION_ID
, V.QUERY_CODE
, V.OBJECT_VERSION_NUMBER
, V.QUERY_CLASS
, V.DIRECTIVE_APP_ID
, V.DIRECTIVE_CODE
, T.USER_NAME
, V.CREATED_BY
, V.CREATION_DATE
, V.LAST_UPDATED_BY
, V.LAST_UPDATE_LOGIN
, V.LAST_UPDATE_DATE
FROM BNE_QUERIES_B V
, BNE_QUERIES_TL T
WHERE V.APPLICATION_ID = T.APPLICATION_ID
AND V.QUERY_CODE = T.QUERY_CODE
AND T.LANGUAGE = USERENV('LANG')
Columns
Name |
ROW_ID |
APPLICATION_ID |
QUERY_CODE |
OBJECT_VERSION_NUMBER |
QUERY_CLASS |
DIRECTIVE_APP_ID |
DIRECTIVE_CODE |
USER_NAME |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
LAST_UPDATE_DATE |