VIEW: APPS.BNE_LAYOUT_BLOCKS_VL

Source

View Text - Preformatted

SELECT H.ROWID ROW_ID, H.APPLICATION_ID, H.LAYOUT_CODE, H.BLOCK_ID, H.OBJECT_VERSION_NUMBER, H.PARENT_ID, H.LAYOUT_ELEMENT, H.STYLE_CLASS, H.STYLE, H.ROW_STYLE_CLASS, H.ROW_STYLE, H.COL_STYLE_CLASS, H.COL_STYLE, H.PROMPT_DISPLAYED_FLAG, H.PROMPT_STYLE_CLASS, H.PROMPT_STYLE, H.HINT_DISPLAYED_FLAG, H.HINT_STYLE_CLASS, H.HINT_STYLE, H.ORIENTATION, H.LAYOUT_CONTROL, H.DISPLAY_FLAG, H.BLOCKSIZE, H.MINSIZE, H.MAXSIZE, H.SEQUENCE_NUM, H.PROMPT_COLSPAN, H.HINT_COLSPAN, H.ROW_COLSPAN, H.SUMMARY_STYLE_CLASS, H.SUMMARY_STYLE, H.TITLE_STYLE_CLASS, H.TITLE_STYLE, T.USER_NAME, T.PROMPT_ABOVE, H.CREATED_BY, H.CREATION_DATE, H.LAST_UPDATED_BY, H.LAST_UPDATE_LOGIN, H.LAST_UPDATE_DATE FROM BNE_LAYOUT_BLOCKS_B H, BNE_LAYOUT_BLOCKS_TL T WHERE H.APPLICATION_ID = T.APPLICATION_ID AND H.LAYOUT_CODE = T.LAYOUT_CODE AND H.BLOCK_ID = T.BLOCK_ID AND T.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT H.ROWID ROW_ID
, H.APPLICATION_ID
, H.LAYOUT_CODE
, H.BLOCK_ID
, H.OBJECT_VERSION_NUMBER
, H.PARENT_ID
, H.LAYOUT_ELEMENT
, H.STYLE_CLASS
, H.STYLE
, H.ROW_STYLE_CLASS
, H.ROW_STYLE
, H.COL_STYLE_CLASS
, H.COL_STYLE
, H.PROMPT_DISPLAYED_FLAG
, H.PROMPT_STYLE_CLASS
, H.PROMPT_STYLE
, H.HINT_DISPLAYED_FLAG
, H.HINT_STYLE_CLASS
, H.HINT_STYLE
, H.ORIENTATION
, H.LAYOUT_CONTROL
, H.DISPLAY_FLAG
, H.BLOCKSIZE
, H.MINSIZE
, H.MAXSIZE
, H.SEQUENCE_NUM
, H.PROMPT_COLSPAN
, H.HINT_COLSPAN
, H.ROW_COLSPAN
, H.SUMMARY_STYLE_CLASS
, H.SUMMARY_STYLE
, H.TITLE_STYLE_CLASS
, H.TITLE_STYLE
, T.USER_NAME
, T.PROMPT_ABOVE
, H.CREATED_BY
, H.CREATION_DATE
, H.LAST_UPDATED_BY
, H.LAST_UPDATE_LOGIN
, H.LAST_UPDATE_DATE
FROM BNE_LAYOUT_BLOCKS_B H
, BNE_LAYOUT_BLOCKS_TL T
WHERE H.APPLICATION_ID = T.APPLICATION_ID
AND H.LAYOUT_CODE = T.LAYOUT_CODE
AND H.BLOCK_ID = T.BLOCK_ID
AND T.LANGUAGE = USERENV('LANG')