[Home] [Help] [Dependency Information]
Object Name: | BNE_INTERFACE_COLS_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BNE.BNE_INTERFACE_COLS_VL |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
BNE_INTERFACE_COLS_VL is a standard translation view over the BNE_INTERFACE_COLS entity.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Base table Row ID | |
APPLICATION_ID | NUMBER | (15) | Yes | Entity column. Refer base entity. |
INTERFACE_CODE | VARCHAR2 | (30) | Yes | Entity column. Refer base entity. |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Yes | Entity column. Refer base entity. |
SEQUENCE_NUM | NUMBER | (15) | Yes | Entity column. Refer base entity. |
INTERFACE_COL_TYPE | NUMBER | (15) | Yes | Entity column. Refer base entity. |
INTERFACE_COL_NAME | VARCHAR2 | (50) | Yes | Entity column. Refer base entity. |
ENABLED_FLAG | VARCHAR2 | (1) | Yes | 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. |
READ_ONLY_FLAG | VARCHAR2 | (1) | Yes | Entity column. Refer base entity. |
NOT_NULL_FLAG | VARCHAR2 | (1) | Yes | Entity column. Refer base entity. |
SUMMARY_FLAG | VARCHAR2 | (1) | Yes | Entity column. Refer base entity. |
MAPPING_ENABLED_FLAG | VARCHAR2 | (1) | Yes | Entity column. Refer base entity. |
DATA_TYPE | NUMBER | (15) | Entity column. Refer base entity. | |
FIELD_SIZE | NUMBER | (15) | Entity column. Refer base entity. | |
DEFAULT_TYPE | VARCHAR2 | (30) | Entity column. Refer base entity. | |
DEFAULT_VALUE | VARCHAR2 | (200) | Entity column. Refer base entity. | |
SEGMENT_NUMBER | NUMBER | (15) | Entity column. Refer base entity. | |
GROUP_NAME | 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. | |
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. | |
VAL_ADDL_W_C | VARCHAR2 | (2000) | 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_NUM | VARCHAR2 | (50) | Entity column. Refer base entity. | |
OA_FLEX_APPLICATION_ID | NUMBER | (15) | 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. | |
EXPANDED_SQL_QUERY | VARCHAR2 | (2000) | Entity column. Refer base entity. | |
USER_HINT | VARCHAR2 | (2000) | Entity column. Refer base entity. | |
PROMPT_LEFT | VARCHAR2 | (240) | Entity column. Refer base entity. | |
USER_HELP_TEXT | VARCHAR2 | (2000) | Entity column. Refer base entity. | |
PROMPT_ABOVE | VARCHAR2 | (240) | Entity column. Refer base entity. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
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) | ||
DISPLAY_WIDTH | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, 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
, USER_HINT
, PROMPT_LEFT
, USER_HELP_TEXT
, PROMPT_ABOVE
, 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
FROM APPS.BNE_INTERFACE_COLS_VL;
|
|
|