VIEW: APPS.BNE_QUERIES_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')