View: BNE_INTERFACE_COLS_VL

Product:	BNE - Web Applications Desktop Integrator
Description:	BNE_INTERFACE_COLS_VL is a standard translation view over the BNE_INTERFACE_COLS entity.
Implementation/DBA Data:	APPS.BNE_INTERFACE_COLS_VL

View Text

SELECT B.ROWID ROW_ID
, B . APPLICATION_ID
, B . INTERFACE_CODE
, OBJECT_VERSION_NUMBER
, B . 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
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.LAST_UPDATE_DATE
, B.LOV_TYPE
, B.OFFLINE_LOV_ENABLED_FLAG
, B.VARIABLE_DATA_TYPE_CLASS
, B.VAL_QUERY_APP_ID
, B.VAL_QUERY_CODE
, B.EXPANDED_SQL_QUERY_APP_ID
, B.EXPANDED_SQL_QUERY_CODE
, B.VIEWER_GROUP
, B.EDIT_TYPE
, B.DISPLAY_WIDTH
FROM BNE_INTERFACE_COLS_B B
, BNE_INTERFACE_COLS_TL T
WHERE B . APPLICATION_ID = T . APPLICATION_ID
AND B . INTERFACE_CODE = T . INTERFACE_CODE
AND B . SEQUENCE_NUM = T . SEQUENCE_NUM
AND T.LANGUAGE = USERENV('LANG')

Columns