View: BNE_LAYOUT_COLS_V

Product:	BNE - Web Applications Desktop Integrator
Description:	BNE_LAYOUT_COLS_V is a business view over BNE_INTERFACE_COLS and BNE_LAYOUT_COLS.
Implementation/DBA Data:	APPS.BNE_LAYOUT_COLS_V

View Text

SELECT L.INTERFACE_APP_ID
, L.INTERFACE_CODE
, L.INTERFACE_SEQ_NUM
, I.INTERFACE_COL_NAME
, L.APPLICATION_ID
, L.LAYOUT_CODE
, L.BLOCK_ID
, L.SEQUENCE_NUM
, L.STYLE_CLASS
, L.STYLE
, L.PROMPT_STYLE_CLASS
, L.PROMPT_STYLE
, I.USER_HINT
, L.HINT_STYLE_CLASS
, L.HINT_STYLE
, I.REQUIRED_FLAG
, I.DISPLAY_FLAG
, I.PROMPT_LEFT
, I.PROMPT_ABOVE
, DECODE(L.READ_ONLY_FLAG
, 'Y'
, 'Y'
, I.READ_ONLY_FLAG)
, I.VAL_TYPE
, I.VAL_ID_COL
, I.VAL_MEAN_COL
, I.VAL_DESC_COL
, I.VAL_OBJ_NAME
, I.GROUP_NAME
, I.SEGMENT_NUMBER
, I.VAL_COMPONENT_APP_ID
, I.VAL_COMPONENT_CODE
, I.OA_FLEX_CODE
, I.OA_CONCAT_FLEX
, I.SUMMARY_FLAG
, NVL(L.DEFAULT_TYPE
, I.DEFAULT_TYPE)
, NVL(L.DEFAULT_VALUE
, I.DEFAULT_VALUE)
, NVL(L.DISPLAY_WIDTH
, I.DISPLAY_WIDTH)
, I.DATA_TYPE
, I.OA_FLEX_NUM
, I.OA_FLEX_APPLICATION_ID
, I.MAPPING_ENABLED_FLAG
, I.DISPLAY_ORDER
, I.UPLOAD_PARAM_LIST_ITEM_NUM
, I.USER_HELP_TEXT
, I.EXPANDED_SQL_QUERY
, I.LOV_TYPE
, I.OFFLINE_LOV_ENABLED_FLAG
, I.VARIABLE_DATA_TYPE_CLASS
, I.VAL_QUERY_APP_ID
, I.VAL_QUERY_CODE
, I.EXPANDED_SQL_QUERY_APP_ID
, I.EXPANDED_SQL_QUERY_CODE
, I.VIEWER_GROUP
, I.EDIT_TYPE
FROM BNE_LAYOUT_COLS L
, BNE_INTERFACE_COLS_VL I
WHERE L.INTERFACE_APP_ID = I.APPLICATION_ID
AND L.INTERFACE_CODE = I.INTERFACE_CODE
AND L.INTERFACE_SEQ_NUM = I.SEQUENCE_NUM
AND I.DISPLAY_FLAG = 'Y'

Columns