eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: BNE.BNE_INTERFACE_COLS_B

Object Details

Object Name:	BNE_INTERFACE_COLS_B
Object Type:	TABLE
Owner:	BNE
FND Design Data:	BNE.BNE_INTERFACE_COLS_B
Subobject Name:
Status:	VALID

BNE_INTERFACE_COLS_B stores the definition of an individual column in an interface.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BNE_INTERFACE_COLS_B_UK1	NORMAL	UNIQUE	APPS_TS_TX_IDX	APPLICATION_ID INTERFACE_CODE SEQUENCE_NUM
BNE_INTERFACE_COLS_B_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VAL_COMPONENT_APP_ID VAL_COMPONENT_CODE
BNE_INTERFACE_COLS_B_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VAL_QUERY_APP_ID VAL_QUERY_CODE
BNE_INTERFACE_COLS_B_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXPANDED_SQL_QUERY_APP_ID EXPANDED_SQL_QUERY_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
APPLICATION_ID	NUMBER	(15)	Yes	Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
INTERFACE_CODE	VARCHAR2	(30)	Yes	Code identifying this entity for the given APPLICATION_ID (foreign key to BNE_INTERFACES.INTERFACE_CODE).
OBJECT_VERSION_NUMBER	NUMBER	(15)	Yes	Object Version Number
SEQUENCE_NUM	NUMBER	(15)	Yes	Unique number identifying this interface column.
INTERFACE_COL_TYPE	NUMBER	(15)	Yes	Interface column type. Valid values: 1 - Physical column, 2 - Alias column.
INTERFACE_COL_NAME	VARCHAR2	(50)	Yes	Name of the interface column. This will most often correspond to the column name of an open interface table.
ENABLED_FLAG	VARCHAR2	(1)	Yes	Is this column enabled?
REQUIRED_FLAG	VARCHAR2	(1)	Yes	Is this column required for upload?
DISPLAY_FLAG	VARCHAR2	(1)	Yes	is this column able to be displayed?
READ_ONLY_FLAG	VARCHAR2	(1)	Yes	Is this column read-only?
NOT_NULL_FLAG	VARCHAR2	(1)	Yes	Is this column mandatory?
SUMMARY_FLAG	VARCHAR2	(1)	Yes	Value can be sumirized (Y/N)?
MAPPING_ENABLED_FLAG	VARCHAR2	(1)	Yes	Enabled for text import mapping
DATA_TYPE	NUMBER	(15)		Date type of column. Valid values are: 1 - Number, 2 - String, 3 - Date.
FIELD_SIZE	NUMBER	(15)		Size of column in interface column.
DEFAULT_TYPE	VARCHAR2	(30)		Type of default value. Valid values are: CONSTANT, JAVA, PROFILE, ENVIRONMENT, SQL.
DEFAULT_VALUE	VARCHAR2	(200)		Default value. Will depend on DEFAULT_TYPE.
SEGMENT_NUMBER	NUMBER	(15)		Position within group.
GROUP_NAME	VARCHAR2	(30)		Name which associates interface columns into a group.
OA_FLEX_CODE	VARCHAR2	(30)		Code to retrieve flexfields. Example GL#.
OA_CONCAT_FLEX	VARCHAR2	(30)		Concatenated value entered into one cell of a spreadsheet.
VAL_TYPE	VARCHAR2	(20)		Validation type. Valid values are: TABLE, JAVA, KEYFLEX, KEYFLEXSEG, EXPANDEDSQL, DESCFLEX, DESCFLEXSEG, DESCFLEXCONTEXT, GROUP
VAL_ID_COL	VARCHAR2	(240)		Name of Id column used for table validation and mapping.
VAL_MEAN_COL	VARCHAR2	(240)		Name of meaning column used for table validation and mapping.
VAL_DESC_COL	VARCHAR2	(240)		Name of description column used for table validation and mapping.
VAL_OBJ_NAME	VARCHAR2	(240)		Fully qualified java validator class name if VAL_TYPE = JAVA, name of the database table if VAL_TYPE = TABLE.
VAL_ADDL_W_C	VARCHAR2	(2000)		Additional where clause used to further qualify table validated row queries.
VAL_COMPONENT_APP_ID	NUMBER	(15)		Application Id of component used for LOVs.
VAL_COMPONENT_CODE	VARCHAR2	(30)		Component code of component used for LOVs.
OA_FLEX_NUM	VARCHAR2	(50)		Unused at this time.
OA_FLEX_APPLICATION_ID	NUMBER	(15)		Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
DISPLAY_ORDER	NUMBER	(15)		Order column is displayed in layout.
UPLOAD_PARAM_LIST_ITEM_NUM	NUMBER	(15)		Index into the BNE_INTERFACE_B.UPLOAD_PARAM_LIST parameter list to identifiy the upload parameter.
EXPANDED_SQL_QUERY	VARCHAR2	(2000)		SQL query text used to determine expanded columns.
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)		List of Values Type. Valid Values NONE, STANDARD and POPLIST
OFFLINE_LOV_ENABLED_FLAG	VARCHAR2	(1)		Does this column support offline LOV enablement?
VARIABLE_DATA_TYPE_CLASS	VARCHAR2	(240)		Fully qualified class name user to determine data types and format masks for columns with variable types.
VAL_QUERY_APP_ID	NUMBER	(15)		Validation query application identifier
VAL_QUERY_CODE	VARCHAR2	(30)		Validation query code identifier
EXPANDED_SQL_QUERY_APP_ID	NUMBER	(15)		Expanded SQL query application identifier
EXPANDED_SQL_QUERY_CODE	VARCHAR2	(30)		Expanded SQL query code identifier
VIEWER_GROUP	VARCHAR2	(30)		Grouping of columns for use together in Viewer
EDIT_TYPE	VARCHAR2	(30)		Type for editing
DISPLAY_WIDTH	NUMBER	(15)		Display width for record

Query Text

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
FROM BNE.BNE_INTERFACE_COLS_B;

Dependencies

[top of page]

BNE.BNE_INTERFACE_COLS_B does not reference any database object

BNE.BNE_INTERFACE_COLS_B is referenced by following:

APPS: BNE_INTERFACE_COLS_B