Search Results not_null_flag

Overview

BNE_INTERFACE_COLS_VL is a standard translation (MLS) view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is part of the BNE product, Web Applications Desktop Integrator (Web ADI), which drives the desktop integration and spreadsheet upload/download framework across EBS. The view exposes the column-level definition of Web ADI interfaces — that is, the metadata that determines how each column of a BNE interface is rendered, validated, mapped, and uploaded.

As a "_VL" view, it joins the base entity table to its translation table and filters on the session language via USERENV('LANG'), returning a single row per interface column for the current language. This makes it the canonical, language-resolved source for interface column metadata, and it is the object that consumers should query rather than the underlying _B table when translated prompt text or help text is required. In the context of the user's search for val_component_app_id, the view is the published access point for that attribute along with the broader set of value-list and validation descriptors.

Underlying Base Objects

The view is defined over two documented base objects, both referenced through APPS synonyms:

• BNE_INTERFACE_COLS_B — the base (non-translated) table holding the operational column definitions, including application, interface code, sequence, data type, validation, and mapping attributes. Aliased as B in the view text.
• BNE_INTERFACE_COLS_TL — the translation table holding language-specific text such as prompts and user help. Aliased as T.

The join predicates are B.APPLICATION_ID = T.APPLICATION_ID AND B.INTERFACE_CODE = T.INTERFACE_CODE AND B.SEQUENCE_NUM = T.SEQUENCE_NUM, with the additional filter T.LANGUAGE = USERENV('LANG'). Because the _B and _TL tables are synonymous with APPS, the view resolves entirely within the APPS schema and follows the standard EBS MLS view pattern.

Key Columns

The view exposes the full column set of the base entity. Notable columns include:

• ROW_ID, APPLICATION_ID, INTERFACE_CODE, SEQUENCE_NUM — the identifying keys; APPLICATION_ID and INTERFACE_CODE identify the interface, SEQUENCE_NUM orders columns within it.
• INTERFACE_COL_NAME, INTERFACE_COL_TYPE — the logical column name and its type.
• ENABLED_FLAG, REQUIRED_FLAG, DISPLAY_FLAG, READ_ONLY_FLAG, NOT_NULL_FLAG, SUMMARY_FLAG, MAPPING_ENABLED_FLAG — behavioral flags controlling rendering and validation.
• DATA_TYPE, FIELD_SIZE, DEFAULT_TYPE, DEFAULT_VALUE — data typing and defaulting behavior.
• VAL_TYPE, VAL_ID_COL, VAL_MEAN_COL, VAL_DESC_COL, VAL_OBJ_NAME, VAL_ADDL_W_C — value-list/validation configuration.
• VAL_COMPONENT_APP_ID, VAL_COMPONENT_CODE — the application and code identifying the validation component (the value-list or lookup source) used for the column. VAL_COMPONENT_APP_ID is the application owning that component.
• OA_FLEX_CODE, OA_CONCAT_FLEX, OA_FLEX_NUM, OA_FLEX_APPLICATION_ID — Oracle Applications Flexfield integration attributes.
• LOV_TYPE, OFFLINE_LOV_ENABLED_FLAG, VAL_QUERY_APP_ID, VAL_QUERY_CODE, EXPANDED_SQL_QUERY, EXPANDED_SQL_QUERY_APP_ID, EXPANDED_SQL_QUERY_CODE — list-of-values and dynamic query configuration.
• PROMPT_LEFT, PROMPT_ABOVE, USER_HINT, USER_HELP_TEXT, DISPLAY_WIDTH, DISPLAY_ORDER, VIEWER_GROUP, EDIT_TYPE — presentation and translated text attributes.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE — standard audit columns inherited from _B.

Common Use Cases and Queries

Typical uses include diagnosing why a Web ADI column validates or uploads incorrectly, auditing value-list configuration, and reporting on interface column layout. A common starting point is to list columns for a given interface:

• SELECT interface_col_name, data_type, val_type, val_component_app_id, val_component_code FROM bne_interface_cols_vl WHERE application_id = :app_id AND interface_code = :iface ORDER BY sequence_num;
• SELECT interface_code, sequence_num, val_component_app_id, val_component_code FROM bne_interface_cols_vl WHERE val_component_app_id IS NOT NULL;
• SELECT interface_col_name, prompt_left, user_help_text FROM bne_interface_cols_vl WHERE application_id = :app_id AND interface_code = :iface;

Because the view applies the language filter automatically, it is preferred over querying BNE_INTERFACE_COLS_B directly when translated prompts or help text are required.