VIEW: APPS.BNE_LAYOUT_COLS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'