VIEW: APPS.BNE_LAYOUTS_VL

Source

View Text - Preformatted

SELECT L.ROWID ROW_ID, L.APPLICATION_ID, L.LAYOUT_CODE, L.OBJECT_VERSION_NUMBER, L.STYLESHEET_APP_ID, L.STYLESHEET_CODE, L.INTEGRATOR_APP_ID, L.INTEGRATOR_CODE, L.STYLE, L.STYLE_CLASS, L.REPORTING_FLAG, L.REPORTING_INTERFACE_APP_ID, L.REPORTING_INTERFACE_CODE, L.CREATE_DOC_LIST_APP_ID, L.CREATE_DOC_LIST_CODE, T.USER_NAME, L.IMAGE_FILE_NAME, L.CREATED_BY, L.CREATION_DATE, L.LAST_UPDATED_BY, L.LAST_UPDATE_LOGIN, L.LAST_UPDATE_DATE FROM BNE_LAYOUTS_B L, BNE_LAYOUTS_TL T WHERE L.APPLICATION_ID = T.APPLICATION_ID AND L.LAYOUT_CODE = T.LAYOUT_CODE AND T.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT L.ROWID ROW_ID
, L.APPLICATION_ID
, L.LAYOUT_CODE
, L.OBJECT_VERSION_NUMBER
, L.STYLESHEET_APP_ID
, L.STYLESHEET_CODE
, L.INTEGRATOR_APP_ID
, L.INTEGRATOR_CODE
, L.STYLE
, L.STYLE_CLASS
, L.REPORTING_FLAG
, L.REPORTING_INTERFACE_APP_ID
, L.REPORTING_INTERFACE_CODE
, L.CREATE_DOC_LIST_APP_ID
, L.CREATE_DOC_LIST_CODE
, T.USER_NAME
, L.IMAGE_FILE_NAME
, L.CREATED_BY
, L.CREATION_DATE
, L.LAST_UPDATED_BY
, L.LAST_UPDATE_LOGIN
, L.LAST_UPDATE_DATE
FROM BNE_LAYOUTS_B L
, BNE_LAYOUTS_TL T
WHERE L.APPLICATION_ID = T.APPLICATION_ID
AND L.LAYOUT_CODE = T.LAYOUT_CODE
AND T.LANGUAGE = USERENV('LANG')