VIEW: APPS.BNE_PARAM_GROUPS_VL

Source

View Text - Preformatted

SELECT D.ROWID ROW_ID, D.APPLICATION_ID, D.PARAM_LIST_CODE, D.SEQUENCE_NUM, D.OBJECT_VERSION_NUMBER, D.ATTRIBUTE_APP_ID, D.ATTRIBUTE_CODE, D.GROUP_RESOLVER, T.USER_NAME, D.CREATED_BY, D.CREATION_DATE, D.LAST_UPDATED_BY, D.LAST_UPDATE_LOGIN, D.LAST_UPDATE_DATE FROM BNE_PARAM_GROUPS_B D, BNE_PARAM_GROUPS_TL T WHERE D.APPLICATION_ID = T.APPLICATION_ID AND D.PARAM_LIST_CODE = T.PARAM_LIST_CODE AND D.SEQUENCE_NUM = T.SEQUENCE_NUM AND T.LANGUAGE = USERENV ('LANG')

View Text - HTML Formatted

SELECT D.ROWID ROW_ID
, D.APPLICATION_ID
, D.PARAM_LIST_CODE
, D.SEQUENCE_NUM
, D.OBJECT_VERSION_NUMBER
, D.ATTRIBUTE_APP_ID
, D.ATTRIBUTE_CODE
, D.GROUP_RESOLVER
, T.USER_NAME
, D.CREATED_BY
, D.CREATION_DATE
, D.LAST_UPDATED_BY
, D.LAST_UPDATE_LOGIN
, D.LAST_UPDATE_DATE
FROM BNE_PARAM_GROUPS_B D
, BNE_PARAM_GROUPS_TL T
WHERE D.APPLICATION_ID = T.APPLICATION_ID
AND D.PARAM_LIST_CODE = T.PARAM_LIST_CODE
AND D.SEQUENCE_NUM = T.SEQUENCE_NUM
AND T.LANGUAGE = USERENV ('LANG')