DBA Data[Home] [Help]

VIEW: APPS.BNE_COMPONENTS_VL

Source

View Text - Preformatted

SELECT C.ROWID ROW_ID, C.APPLICATION_ID, C.COMPONENT_CODE, C.OBJECT_VERSION_NUMBER, C.COMPONENT_JAVA_CLASS, C.PARAM_LIST_APP_ID, C.PARAM_LIST_CODE, T.USER_NAME, C.CREATED_BY, C.CREATION_DATE, C.LAST_UPDATED_BY, C.LAST_UPDATE_LOGIN, C.LAST_UPDATE_DATE FROM BNE_COMPONENTS_B C, BNE_COMPONENTS_TL T WHERE C.APPLICATION_ID = T.APPLICATION_ID AND C.COMPONENT_CODE = T.COMPONENT_CODE AND T.LANGUAGE = USERENV('LANG')
View Text - HTML Formatted

SELECT C.ROWID ROW_ID
, C.APPLICATION_ID
, C.COMPONENT_CODE
, C.OBJECT_VERSION_NUMBER
, C.COMPONENT_JAVA_CLASS
, C.PARAM_LIST_APP_ID
, C.PARAM_LIST_CODE
, T.USER_NAME
, C.CREATED_BY
, C.CREATION_DATE
, C.LAST_UPDATED_BY
, C.LAST_UPDATE_LOGIN
, C.LAST_UPDATE_DATE
FROM BNE_COMPONENTS_B C
, BNE_COMPONENTS_TL T
WHERE C.APPLICATION_ID = T.APPLICATION_ID
AND C.COMPONENT_CODE = T.COMPONENT_CODE
AND T.LANGUAGE = USERENV('LANG')