VIEW: APPS.BNE_PARAM_LISTS_VL

Source

View Text - Preformatted

SELECT D.ROWID ROW_ID, D.APPLICATION_ID, D.PARAM_LIST_CODE, D.OBJECT_VERSION_NUMBER, D.PERSISTENT_FLAG, D.COMMENTS, D.ATTRIBUTE_APP_ID, D.ATTRIBUTE_CODE, D.LIST_RESOLVER, T.USER_TIP, T.PROMPT_LEFT, T.PROMPT_ABOVE, T.USER_NAME, D.CREATED_BY, D.CREATION_DATE, D.LAST_UPDATED_BY, D.LAST_UPDATE_LOGIN, D.LAST_UPDATE_DATE FROM BNE_PARAM_LISTS_B D, BNE_PARAM_LISTS_TL T WHERE D.APPLICATION_ID = T.APPLICATION_ID AND D.PARAM_LIST_CODE = T.PARAM_LIST_CODE AND T.LANGUAGE = USERENV ('LANG')

View Text - HTML Formatted

SELECT D.ROWID ROW_ID
, D.APPLICATION_ID
, D.PARAM_LIST_CODE
, D.OBJECT_VERSION_NUMBER
, D.PERSISTENT_FLAG
, D.COMMENTS
, D.ATTRIBUTE_APP_ID
, D.ATTRIBUTE_CODE
, D.LIST_RESOLVER
, T.USER_TIP
, T.PROMPT_LEFT
, T.PROMPT_ABOVE
, T.USER_NAME
, D.CREATED_BY
, D.CREATION_DATE
, D.LAST_UPDATED_BY
, D.LAST_UPDATE_LOGIN
, D.LAST_UPDATE_DATE
FROM BNE_PARAM_LISTS_B D
, BNE_PARAM_LISTS_TL T
WHERE D.APPLICATION_ID = T.APPLICATION_ID
AND D.PARAM_LIST_CODE = T.PARAM_LIST_CODE
AND T.LANGUAGE = USERENV ('LANG')