[Home] [Help] [Dependency Information]
Object Name: | BNE_INTERFACE_COLS_B# |
---|---|
Object Type: | VIEW |
Owner: | BNE |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | (15) | Yes | |
INTERFACE_CODE | VARCHAR2 | (30) | Yes | |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Yes | |
SEQUENCE_NUM | NUMBER | (15) | Yes | |
INTERFACE_COL_TYPE | NUMBER | (15) | Yes | |
INTERFACE_COL_NAME | VARCHAR2 | (50) | Yes | |
ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
REQUIRED_FLAG | VARCHAR2 | (1) | Yes | |
DISPLAY_FLAG | VARCHAR2 | (1) | Yes | |
READ_ONLY_FLAG | VARCHAR2 | (1) | Yes | |
NOT_NULL_FLAG | VARCHAR2 | (1) | Yes | |
SUMMARY_FLAG | VARCHAR2 | (1) | Yes | |
MAPPING_ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
DATA_TYPE | NUMBER | (15) | ||
FIELD_SIZE | NUMBER | (15) | ||
DEFAULT_TYPE | VARCHAR2 | (30) | ||
DEFAULT_VALUE | VARCHAR2 | (200) | ||
SEGMENT_NUMBER | NUMBER | (15) | ||
GROUP_NAME | VARCHAR2 | (30) | ||
OA_FLEX_CODE | VARCHAR2 | (30) | ||
OA_CONCAT_FLEX | VARCHAR2 | (30) | ||
VAL_TYPE | VARCHAR2 | (20) | ||
VAL_ID_COL | VARCHAR2 | (240) | ||
VAL_MEAN_COL | VARCHAR2 | (240) | ||
VAL_DESC_COL | VARCHAR2 | (240) | ||
VAL_OBJ_NAME | VARCHAR2 | (240) | ||
VAL_ADDL_W_C | VARCHAR2 | (2000) | ||
VAL_COMPONENT_APP_ID | NUMBER | (15) | ||
VAL_COMPONENT_CODE | VARCHAR2 | (30) | ||
OA_FLEX_NUM | VARCHAR2 | (50) | ||
OA_FLEX_APPLICATION_ID | NUMBER | (15) | ||
DISPLAY_ORDER | NUMBER | (15) | ||
UPLOAD_PARAM_LIST_ITEM_NUM | NUMBER | (15) | ||
EXPANDED_SQL_QUERY | VARCHAR2 | (2000) | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LOV_TYPE | VARCHAR2 | (30) | ||
OFFLINE_LOV_ENABLED_FLAG | VARCHAR2 | (1) | ||
VARIABLE_DATA_TYPE_CLASS | VARCHAR2 | (240) | ||
VAL_QUERY_APP_ID | NUMBER | (15) | ||
VAL_QUERY_CODE | VARCHAR2 | (30) | ||
EXPANDED_SQL_QUERY_APP_ID | NUMBER | (15) | ||
EXPANDED_SQL_QUERY_CODE | VARCHAR2 | (30) | ||
VIEWER_GROUP | VARCHAR2 | (30) | ||
EDIT_TYPE | VARCHAR2 | (30) | ||
DISPLAY_WIDTH | NUMBER | (15) | ||
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICATION_ID
, INTERFACE_CODE
, OBJECT_VERSION_NUMBER
, SEQUENCE_NUM
, INTERFACE_COL_TYPE
, INTERFACE_COL_NAME
, ENABLED_FLAG
, REQUIRED_FLAG
, DISPLAY_FLAG
, READ_ONLY_FLAG
, NOT_NULL_FLAG
, SUMMARY_FLAG
, MAPPING_ENABLED_FLAG
, DATA_TYPE
, FIELD_SIZE
, DEFAULT_TYPE
, DEFAULT_VALUE
, SEGMENT_NUMBER
, GROUP_NAME
, OA_FLEX_CODE
, OA_CONCAT_FLEX
, VAL_TYPE
, VAL_ID_COL
, VAL_MEAN_COL
, VAL_DESC_COL
, VAL_OBJ_NAME
, VAL_ADDL_W_C
, VAL_COMPONENT_APP_ID
, VAL_COMPONENT_CODE
, OA_FLEX_NUM
, OA_FLEX_APPLICATION_ID
, DISPLAY_ORDER
, UPLOAD_PARAM_LIST_ITEM_NUM
, EXPANDED_SQL_QUERY
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LOV_TYPE
, OFFLINE_LOV_ENABLED_FLAG
, VARIABLE_DATA_TYPE_CLASS
, VAL_QUERY_APP_ID
, VAL_QUERY_CODE
, EXPANDED_SQL_QUERY_APP_ID
, EXPANDED_SQL_QUERY_CODE
, VIEWER_GROUP
, EDIT_TYPE
, DISPLAY_WIDTH
, ZD_EDITION_NAME
FROM BNE.BNE_INTERFACE_COLS_B#;
|
|
|