[Home] [Help] [Dependency Information]
Object Name: | BNE_LAYOUT_COLS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BNE.BNE_LAYOUT_COLS_V |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
BNE_LAYOUT_COLS_V is a business view over BNE_INTERFACE_COLS and BNE_LAYOUT_COLS.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTERFACE_APP_ID | NUMBER | (15) | Yes | Entity column. Refer base entity. |
INTERFACE_CODE | VARCHAR2 | (30) | Yes | Entity column. Refer base entity. |
INTERFACE_SEQ_NUM | NUMBER | (15) | Yes | Entity column. Refer base entity. |
INTERFACE_COL_NAME | VARCHAR2 | (50) | Yes | Entity column. Refer base entity. |
LAYOUT_APP_ID | NUMBER | (15) | Yes | Entity column. Refer base entity. |
LAYOUT_CODE | VARCHAR2 | (30) | Yes | Entity column. Refer base entity. |
BLOCK_ID | NUMBER | (15) | Yes | Entity column. Refer base entity. |
SEQUENCE_NUM | NUMBER | (15) | Yes | Entity column. Refer base entity. |
STYLE_CLASS | VARCHAR2 | (50) | Entity column. Refer base entity. | |
STYLE | VARCHAR2 | (2000) | Entity column. Refer base entity. | |
PROMPT_STYLE_CLASS | VARCHAR2 | (50) | Entity column. Refer base entity. | |
PROMPT_STYLE | VARCHAR2 | (2000) | Entity column. Refer base entity. | |
USER_HINT | VARCHAR2 | (2000) | Entity column. Refer base entity. | |
HINT_STYLE_CLASS | VARCHAR2 | (50) | Entity column. Refer base entity. | |
HINT_STYLE | VARCHAR2 | (2000) | Entity column. Refer base entity. | |
REQUIRED_FLAG | VARCHAR2 | (1) | Yes | Entity column. Refer base entity. |
DISPLAY_FLAG | VARCHAR2 | (1) | Yes | Entity column. Refer base entity. |
PROMPT_LEFT | VARCHAR2 | (240) | Entity column. Refer base entity. | |
PROMPT_ABOVE | VARCHAR2 | (240) | Entity column. Refer base entity. | |
READ_ONLY_FLAG | VARCHAR2 | (1) | Entity column. Refer base entity. | |
VAL_TYPE | VARCHAR2 | (20) | Entity column. Refer base entity. | |
VAL_ID_COL | VARCHAR2 | (240) | Entity column. Refer base entity. | |
VAL_MEAN_COL | VARCHAR2 | (240) | Entity column. Refer base entity. | |
VAL_DESC_COL | VARCHAR2 | (240) | Entity column. Refer base entity. | |
VAL_OBJ_NAME | VARCHAR2 | (240) | Entity column. Refer base entity. | |
GROUP_NAME | VARCHAR2 | (30) | Entity column. Refer base entity. | |
SEGMENT_NUMBER | NUMBER | (15) | Entity column. Refer base entity. | |
VAL_COMPONENT_APP_ID | NUMBER | (15) | Entity column. Refer base entity. | |
VAL_COMPONENT_CODE | VARCHAR2 | (30) | Entity column. Refer base entity. | |
OA_FLEX_CODE | VARCHAR2 | (30) | Entity column. Refer base entity. | |
OA_CONCAT_FLEX | VARCHAR2 | (30) | Entity column. Refer base entity. | |
SUMMARY_FLAG | VARCHAR2 | (1) | Yes | Entity column. Refer base entity. |
DEFAULT_TYPE | VARCHAR2 | (30) | Entity column. Refer base entity. | |
DEFAULT_VALUE | VARCHAR2 | (2000) | Entity column. Refer base entity. | |
DISPLAY_WIDTH | NUMBER | Entity column. Refer base entity. | ||
DATA_TYPE | NUMBER | (15) | Entity column. Refer base entity. | |
OA_FLEX_NUM | VARCHAR2 | (50) | Entity column. Refer base entity. | |
OA_FLEX_APPLICATION_ID | NUMBER | (15) | Entity column. Refer base entity. | |
MAPPING_ENABLED_FLAG | VARCHAR2 | (1) | Yes | Entity column. Refer base entity. |
DISPLAY_ORDER | NUMBER | (15) | Entity column. Refer base entity. | |
UPLOAD_PARAM_LIST_ITEM_NUM | NUMBER | (15) | Entity column. Refer base entity. | |
USER_HELP_TEXT | VARCHAR2 | (2000) | Entity column. Refer base entity. | |
EXPANDED_SQL_QUERY | VARCHAR2 | (2000) | Entity column. Refer base entity. | |
LOV_TYPE | VARCHAR2 | (30) | Entity column. Refer base entity. | |
OFFLINE_LOV_ENABLED_FLAG | VARCHAR2 | (1) | Entity column. Refer base entity. | |
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) | Grouping of columns for use together in Viewer | |
EDIT_TYPE | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT INTERFACE_APP_ID
, INTERFACE_CODE
, INTERFACE_SEQ_NUM
, INTERFACE_COL_NAME
, LAYOUT_APP_ID
, LAYOUT_CODE
, BLOCK_ID
, SEQUENCE_NUM
, STYLE_CLASS
, STYLE
, PROMPT_STYLE_CLASS
, PROMPT_STYLE
, USER_HINT
, HINT_STYLE_CLASS
, HINT_STYLE
, REQUIRED_FLAG
, DISPLAY_FLAG
, PROMPT_LEFT
, PROMPT_ABOVE
, READ_ONLY_FLAG
, VAL_TYPE
, VAL_ID_COL
, VAL_MEAN_COL
, VAL_DESC_COL
, VAL_OBJ_NAME
, GROUP_NAME
, SEGMENT_NUMBER
, VAL_COMPONENT_APP_ID
, VAL_COMPONENT_CODE
, OA_FLEX_CODE
, OA_CONCAT_FLEX
, SUMMARY_FLAG
, DEFAULT_TYPE
, DEFAULT_VALUE
, DISPLAY_WIDTH
, DATA_TYPE
, OA_FLEX_NUM
, OA_FLEX_APPLICATION_ID
, MAPPING_ENABLED_FLAG
, DISPLAY_ORDER
, UPLOAD_PARAM_LIST_ITEM_NUM
, USER_HELP_TEXT
, EXPANDED_SQL_QUERY
, 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
FROM APPS.BNE_LAYOUT_COLS_V;
APPS.BNE_LAYOUT_COLS_V is not referenced by any database object
|
|
|