DBA Data[Home] [Help]

VIEW: APPS.BNE_STYLESHEETS_VL

Source

View Text - Preformatted

SELECT S.ROWID ROW_ID, S.APPLICATION_ID, S.STYLESHEET_CODE, S.OBJECT_VERSION_NUMBER, T.USER_NAME, T.DESCRIPTION, NVL(S.DEFAULT_FLAG, 'N'), NVL(S.READ_ONLY_FLAG, 'N'), S.IMAGE_FILE_NAME, S.CREATED_BY, S.CREATION_DATE, S.LAST_UPDATED_BY, S.LAST_UPDATE_LOGIN, S.LAST_UPDATE_DATE FROM BNE_STYLESHEETS_B S, BNE_STYLESHEETS_TL T WHERE S.APPLICATION_ID = T.APPLICATION_ID AND S.STYLESHEET_CODE = T.STYLESHEET_CODE AND T.LANGUAGE = USERENV('LANG')
View Text - HTML Formatted

SELECT S.ROWID ROW_ID
, S.APPLICATION_ID
, S.STYLESHEET_CODE
, S.OBJECT_VERSION_NUMBER
, T.USER_NAME
, T.DESCRIPTION
, NVL(S.DEFAULT_FLAG
, 'N')
, NVL(S.READ_ONLY_FLAG
, 'N')
, S.IMAGE_FILE_NAME
, S.CREATED_BY
, S.CREATION_DATE
, S.LAST_UPDATED_BY
, S.LAST_UPDATE_LOGIN
, S.LAST_UPDATE_DATE
FROM BNE_STYLESHEETS_B S
, BNE_STYLESHEETS_TL T
WHERE S.APPLICATION_ID = T.APPLICATION_ID
AND S.STYLESHEET_CODE = T.STYLESHEET_CODE
AND T.LANGUAGE = USERENV('LANG')