VIEW: BNE.BNE_INTERFACE_COLS_B#

Source

View Text - Preformatted

select APPLICATION_ID APPLICATION_ID, INTERFACE_CODE INTERFACE_CODE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, SEQUENCE_NUM SEQUENCE_NUM, INTERFACE_COL_TYPE INTERFACE_COL_TYPE, INTERFACE_COL_NAME INTERFACE_COL_NAME, ENABLED_FLAG ENABLED_FLAG, REQUIRED_FLAG REQUIRED_FLAG, DISPLAY_FLAG DISPLAY_FLAG, READ_ONLY_FLAG READ_ONLY_FLAG, NOT_NULL_FLAG NOT_NULL_FLAG, SUMMARY_FLAG SUMMARY_FLAG, MAPPING_ENABLED_FLAG MAPPING_ENABLED_FLAG, DATA_TYPE DATA_TYPE, FIELD_SIZE FIELD_SIZE, DEFAULT_TYPE DEFAULT_TYPE, DEFAULT_VALUE DEFAULT_VALUE, SEGMENT_NUMBER SEGMENT_NUMBER, GROUP_NAME GROUP_NAME, OA_FLEX_CODE OA_FLEX_CODE, OA_CONCAT_FLEX OA_CONCAT_FLEX, VAL_TYPE VAL_TYPE, VAL_ID_COL VAL_ID_COL, VAL_MEAN_COL VAL_MEAN_COL, VAL_DESC_COL VAL_DESC_COL, VAL_OBJ_NAME VAL_OBJ_NAME, VAL_ADDL_W_C VAL_ADDL_W_C, VAL_COMPONENT_APP_ID VAL_COMPONENT_APP_ID, VAL_COMPONENT_CODE VAL_COMPONENT_CODE, OA_FLEX_NUM OA_FLEX_NUM, OA_FLEX_APPLICATION_ID OA_FLEX_APPLICATION_ID, DISPLAY_ORDER DISPLAY_ORDER, UPLOAD_PARAM_LIST_ITEM_NUM UPLOAD_PARAM_LIST_ITEM_NUM, EXPANDED_SQL_QUERY EXPANDED_SQL_QUERY, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, LOV_TYPE LOV_TYPE, OFFLINE_LOV_ENABLED_FLAG OFFLINE_LOV_ENABLED_FLAG, VARIABLE_DATA_TYPE_CLASS VARIABLE_DATA_TYPE_CLASS, VAL_QUERY_APP_ID VAL_QUERY_APP_ID, VAL_QUERY_CODE VAL_QUERY_CODE, EXPANDED_SQL_QUERY_APP_ID EXPANDED_SQL_QUERY_APP_ID, EXPANDED_SQL_QUERY_CODE EXPANDED_SQL_QUERY_CODE, VIEWER_GROUP VIEWER_GROUP, EDIT_TYPE EDIT_TYPE, DISPLAY_WIDTH DISPLAY_WIDTH, ZD_EDITION_NAME ZD_EDITION_NAME from "BNE"."BNE_INTERFACE_COLS_B"

View Text - HTML Formatted

SELECT APPLICATION_ID APPLICATION_ID
, INTERFACE_CODE INTERFACE_CODE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SEQUENCE_NUM SEQUENCE_NUM
, INTERFACE_COL_TYPE INTERFACE_COL_TYPE
, INTERFACE_COL_NAME INTERFACE_COL_NAME
, ENABLED_FLAG ENABLED_FLAG
, REQUIRED_FLAG REQUIRED_FLAG
, DISPLAY_FLAG DISPLAY_FLAG
, READ_ONLY_FLAG READ_ONLY_FLAG
, NOT_NULL_FLAG NOT_NULL_FLAG
, SUMMARY_FLAG SUMMARY_FLAG
, MAPPING_ENABLED_FLAG MAPPING_ENABLED_FLAG
, DATA_TYPE DATA_TYPE
, FIELD_SIZE FIELD_SIZE
, DEFAULT_TYPE DEFAULT_TYPE
, DEFAULT_VALUE DEFAULT_VALUE
, SEGMENT_NUMBER SEGMENT_NUMBER
, GROUP_NAME GROUP_NAME
, OA_FLEX_CODE OA_FLEX_CODE
, OA_CONCAT_FLEX OA_CONCAT_FLEX
, VAL_TYPE VAL_TYPE
, VAL_ID_COL VAL_ID_COL
, VAL_MEAN_COL VAL_MEAN_COL
, VAL_DESC_COL VAL_DESC_COL
, VAL_OBJ_NAME VAL_OBJ_NAME
, VAL_ADDL_W_C VAL_ADDL_W_C
, VAL_COMPONENT_APP_ID VAL_COMPONENT_APP_ID
, VAL_COMPONENT_CODE VAL_COMPONENT_CODE
, OA_FLEX_NUM OA_FLEX_NUM
, OA_FLEX_APPLICATION_ID OA_FLEX_APPLICATION_ID
, DISPLAY_ORDER DISPLAY_ORDER
, UPLOAD_PARAM_LIST_ITEM_NUM UPLOAD_PARAM_LIST_ITEM_NUM
, EXPANDED_SQL_QUERY EXPANDED_SQL_QUERY
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LOV_TYPE LOV_TYPE
, OFFLINE_LOV_ENABLED_FLAG OFFLINE_LOV_ENABLED_FLAG
, VARIABLE_DATA_TYPE_CLASS VARIABLE_DATA_TYPE_CLASS
, VAL_QUERY_APP_ID VAL_QUERY_APP_ID
, VAL_QUERY_CODE VAL_QUERY_CODE
, EXPANDED_SQL_QUERY_APP_ID EXPANDED_SQL_QUERY_APP_ID
, EXPANDED_SQL_QUERY_CODE EXPANDED_SQL_QUERY_CODE
, VIEWER_GROUP VIEWER_GROUP
, EDIT_TYPE EDIT_TYPE
, DISPLAY_WIDTH DISPLAY_WIDTH
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "BNE"."BNE_INTERFACE_COLS_B"