Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - BNE Tables and Views

TABLE - BNE.BNE_ADMIN_ACTIONS
TABLE - BNE.BNE_ASYNC_UPLOAD_JOBS
TABLE - BNE.BNE_ASYNC_UPLOAD_JOBS_H
TABLE - BNE.BNE_ATTRIBUTES
TABLE - BNE.BNE_CACHE_DIRECTIVES_B
TABLE - BNE.BNE_CACHE_DIRECTIVES_TL
TABLE - BNE.BNE_COMPONENTS_B
TABLE - BNE.BNE_COMPONENTS_TL
TABLE - BNE.BNE_CONTENTS_B
TABLE - BNE.BNE_CONTENTS_TL
TABLE - BNE.BNE_CONTENT_COLS_B
TABLE - BNE.BNE_CONTENT_COLS_TL
TABLE - BNE.BNE_DOCUMENTS
TABLE - BNE.BNE_DOC_ACTIONS
TABLE - BNE.BNE_DOC_CREATION_PARAMS
TABLE - BNE.BNE_DOC_USER_PARAMS
TABLE - BNE.BNE_DUPLICATE_PROFILES_B
TABLE - BNE.BNE_DUPLICATE_PROFILES_TL
TABLE - BNE.BNE_DUP_INTERFACE_COLS
TABLE - BNE.BNE_DUP_INTERFACE_PROFILES
TABLE - BNE.BNE_FILES
TABLE - BNE.BNE_FLEX_OVERRIDES
TABLE - BNE.BNE_GRAPHS_B
TABLE - BNE.BNE_GRAPHS_TL
TABLE - BNE.BNE_GRAPH_COLUMNS
TABLE - BNE.BNE_IMPORT_PROGRAMS
TABLE - BNE.BNE_INTEGRATORS_B
TABLE - BNE.BNE_INTEGRATORS_TL
TABLE - BNE.BNE_INTEGRATOR_VIEWERS
TABLE - BNE.BNE_INTERFACES_B
TABLE - BNE.BNE_INTERFACES_TL
TABLE - BNE.BNE_INTERFACE_COLS_B
TABLE - BNE.BNE_INTERFACE_COLS_TL
TABLE - BNE.BNE_INTERFACE_KEYS
TABLE - BNE.BNE_INTERFACE_KEY_COLS
TABLE - BNE.BNE_LAYOUTS_B
TABLE - BNE.BNE_LAYOUTS_TL
TABLE - BNE.BNE_LAYOUT_BLOCKS_B
TABLE - BNE.BNE_LAYOUT_BLOCKS_TL
TABLE - BNE.BNE_LAYOUT_COLS
TABLE - BNE.BNE_LAYOUT_LOBS
TABLE - BNE.BNE_MAPPINGS_B
TABLE - BNE.BNE_MAPPINGS_TL
TABLE - BNE.BNE_MAPPING_LINES
TABLE - BNE.BNE_MENUS_B
TABLE - BNE.BNE_MENUS_TL
TABLE - BNE.BNE_OBJECTS
TABLE - BNE.BNE_PARAM_DEFNS_B
TABLE - BNE.BNE_PARAM_DEFNS_TL
TABLE - BNE.BNE_PARAM_GROUPS_B
TABLE - BNE.BNE_PARAM_GROUPS_TL
TABLE - BNE.BNE_PARAM_GROUP_ITEMS
TABLE - BNE.BNE_PARAM_LISTS_B
TABLE - BNE.BNE_PARAM_LISTS_TL
TABLE - BNE.BNE_PARAM_LIST_ITEMS
TABLE - BNE.BNE_PARAM_OVERRIDES
TABLE - BNE.BNE_PERF_SETS_B
TABLE - BNE.BNE_PERF_SETS_TL
TABLE - BNE.BNE_PERF_SET_ITEMS
TABLE - BNE.BNE_PERF_STATISTICS_B
TABLE - BNE.BNE_PERF_STATISTICS_H
TABLE - BNE.BNE_PERF_STATISTICS_TL
TABLE - BNE.BNE_QUERIES_B
TABLE - BNE.BNE_QUERIES_TL
TABLE - BNE.BNE_RAW_QUERY
TABLE - BNE.BNE_SECURED_OBJECTS
TABLE - BNE.BNE_SECURITY_RULES
TABLE - BNE.BNE_SIMPLE_QUERY
TABLE - BNE.BNE_STORED_SQL
TABLE - BNE.BNE_STYLES
TABLE - BNE.BNE_STYLESHEETS_B
TABLE - BNE.BNE_STYLESHEETS_TL
TABLE - BNE.BNE_STYLE_PROPERTIES
TABLE - BNE.BNE_UPLOAD_TRANSACTIONS
TABLE - BNE.BNE_USER_SETTINGS
TABLE - BNE.BNE_VIEWERS_B
TABLE - BNE.BNE_VIEWERS_TL
VIEW - APPS.BNE_CACHE_DIRECTIVES_VL
VIEW - APPS.BNE_COMPONENTS_VL
VIEW - APPS.BNE_CONTENTS_VL
VIEW - APPS.BNE_CONTENT_COLS_VL
VIEW - APPS.BNE_DUPLICATE_PROFILES_VL
VIEW - APPS.BNE_GRAPHS_VL
VIEW - APPS.BNE_INTEGRATORS_VL
VIEW - APPS.BNE_INTERFACES_VL
VIEW - APPS.BNE_INTERFACE_COLS_VL
VIEW - APPS.BNE_LAYOUTS_VL
VIEW - APPS.BNE_LAYOUT_BLOCKS_VL
VIEW - APPS.BNE_LAYOUT_COLS_V
VIEW - APPS.BNE_MAPPINGS_VL
VIEW - APPS.BNE_MENUS_VL
VIEW - APPS.BNE_PARAM_DEFNS_VL
VIEW - APPS.BNE_PARAM_GROUPS_VL
VIEW - APPS.BNE_PARAM_LISTS_VL
VIEW - APPS.BNE_PERF_SETS_VL
VIEW - APPS.BNE_PERF_STATISTICS_VL
VIEW - APPS.BNE_QUERIES_VL
VIEW - APPS.BNE_STYLESHEETS_VL
VIEW - APPS.BNE_VIEWERS_VL

Table: BNE_ADMIN_ACTIONS

Description: Administration actions
Primary Key: BNE_ADMIN_ACTIONS_PK
  1. ADMIN_GROUP
  2. ADMIN_OBJECT
Comments

BNE_ADMIN_ACTIONS stores JVM specific actions requested by an administrator. Theses actions may be propogated across JVMs via this table.

Indexes
Index Type Tablespace Column
BNE_ADMIN_ACTIONS_U1 UNIQUE APPS_TS_TX_IDX ADMIN_GROUP
ADMIN_OBJECT
Columns
Name Datatype Length Mandatory Comments
ADMIN_GROUP VARCHAR2 (30) Y Grouping of settings. Can be used to create levels of settings.
ADMIN_OBJECT VARCHAR2 (30) Y Name of setting.
ADMIN_ACTION VARCHAR2 (30) Y Name of setting.
ADMIN_VALUE VARCHAR2 (2000)
Value of setting. This column is deprecated in favour of SETTING_VALUE_CLOB.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.

[top of page]

BNE.BNE_ADMIN_ACTIONS does not reference any database object

BNE.BNE_ADMIN_ACTIONS is referenced by following:

BNE
VIEW - BNE_ADMIN_ACTIONS#

[top of page]

Table: BNE_ASYNC_UPLOAD_JOBS

Description: Storage of upload Jobs. There will be 1 row per Job
Primary Key: BNE_ASYNC_UPLOAD_JOBS_PK
  1. JOB_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_ASYNC_UPLOAD_JOBS.INTEGRATOR_APP_ID
BNE_ASYNC_UPLOAD_JOBS.INTEGRATOR_CODE 		BNE_INTEGRATORS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
BNE_ASYNC_UPLOAD_JOBS_H.JOB_ID BNE_ASYNC_UPLOAD_JOBS
Comments

Bne_ASYNC_UPLOAD_JOBS provides storage of upload Jobs. There will be 1 row per Job.

Indexes
Index Type Tablespace Column
BNE_ASYNC_UPLOAD_UK1 UNIQUE APPS_TS_TX_IDX JOB_ID
BNE_ASYNC_UPLOAD_N1 NONUNIQUE APPS_TS_TX_IDX JOB_CREATION_DATE
Columns
Name Datatype Length Mandatory Comments
JOB_ID NUMBER
Y Asynchronous Job identifier.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
INTEGRATOR_APP_ID NUMBER (15) Y Application Id of the integrator this job is for.
INTEGRATOR_CODE VARCHAR2 (30) Y Integrator code of the integrator this job is for.
UPLOAD_STATE VARCHAR2 (30) Y Current upload state of the upload job.
TRANSLATED_UPLOAD_STATE VARCHAR2 (2000)
Current translated upload state of the upload job.
JOB_CREATION_DATE DATE

Job Creation Date
JOB_START_DATE DATE

Job start date. The date the Job moved out of the SCHEDULED state.
JOB_END_DATE DATE

Job End Date. The date the job went into DONE or, CANCEL state.
CANCEL_UPLOAD_FLAG VARCHAR2 (1) Y Is the Job being asket to cancel (Y/N)?
TRANSACTION_REFERENCE1 VARCHAR2 (30)
Transaction reference to a transaction for failure support.
TRANSACTION_REFERENCE2 VARCHAR2 (30)
Transaction start date for a transaction for failure support.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Unique code identifying this entity for the given APPLICATION_ID.
ATTRIBUTE1 VARCHAR2 (240)
Attribute 1
ATTRIBUTE2 VARCHAR2 (240)
Attribute 2
ATTRIBUTE3 VARCHAR2 (240)
Attribute 3
ATTRIBUTE4 VARCHAR2 (240)
Attribute 4
ATTRIBUTE5 VARCHAR2 (240)
Attribute 5
ATTRIBUTE6 VARCHAR2 (240)
Attribute 6
ATTRIBUTE7 VARCHAR2 (240)
Attribute 7
ATTRIBUTE8 VARCHAR2 (240)
Attribute 8
ATTRIBUTE9 VARCHAR2 (240)
Attribute 9
ATTRIBUTE10 VARCHAR2 (240)
Attribute 110
ATTRIBUTE11 VARCHAR2 (240)
Attribute 11
ATTRIBUTE12 VARCHAR2 (240)
Attribute 12
ATTRIBUTE13 VARCHAR2 (240)
Attribute 13
ATTRIBUTE14 VARCHAR2 (240)
Attribute 14
ATTRIBUTE15 VARCHAR2 (240)
Attribute 15
ATTRIBUTE16 VARCHAR2 (240)
Attribute 16
ATTRIBUTE17 VARCHAR2 (240)
Attribute 17
ATTRIBUTE18 VARCHAR2 (240)
Attribute 18
ATTRIBUTE19 VARCHAR2 (240)
Attribute 19
ATTRIBUTE20 VARCHAR2 (240)
Attribute 20
ATTRIBUTE21 VARCHAR2 (240)
Attribute 21
ATTRIBUTE22 VARCHAR2 (240)
Attribute 22
ATTRIBUTE23 VARCHAR2 (240)
Attribute 23
ATTRIBUTE24 VARCHAR2 (240)
Attribute 24
ATTRIBUTE25 VARCHAR2 (240)
Attribute 25
ATTRIBUTE26 VARCHAR2 (240)
Attribute 26
ATTRIBUTE27 VARCHAR2 (240)
Attribute 27
ATTRIBUTE28 VARCHAR2 (240)
Attribute 28
ATTRIBUTE29 VARCHAR2 (240)
Attribute 29
ATTRIBUTE30 VARCHAR2 (240)
Attribute 30
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
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).

[top of page]

BNE.BNE_ASYNC_UPLOAD_JOBS does not reference any database object

BNE.BNE_ASYNC_UPLOAD_JOBS is referenced by following:

BNE
VIEW - BNE_ASYNC_UPLOAD_JOBS#

[top of page]

Table: BNE_ASYNC_UPLOAD_JOBS_H

Description: Storage of upload Jobs. There will be 1 row per Job
Primary Key: BNE_ASYNC_UPLOAD_JOBS_H_PK
  1. JOB_ID
  2. ACTION_NUM
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_ASYNC_UPLOAD_JOBS_H.JOB_ID BNE_ASYNC_UPLOAD_JOBS
Comments

Bne_ASYNC_UPLOAD_JOBS provides storage of upload Jobs. There will be 1 row per Job.

Indexes
Index Type Tablespace Column
BNE_ASYNC_UPLOAD_H_UK1 UNIQUE APPS_TS_TX_IDX JOB_ID
ACTION_NUM
Columns
Name Datatype Length Mandatory Comments
JOB_ID NUMBER
Y Asynchronous Job identifier.
ACTION_NUM NUMBER
Y Line Number of history row
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
ACTION_CODE VARCHAR2 (30) Y Type of action this row is for. Will determine the contents of other fields.
UPLOAD_STATE VARCHAR2 (30)
Current upload state of the upload job.
TRANSACTION_REFERENCE1 VARCHAR2 (30)
Transaction reference to a transaction for failure support.
TRANSACTION_REFERENCE2 VARCHAR2 (30)
Transaction start date for a transaction for failure support.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
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).

[top of page]

BNE.BNE_ASYNC_UPLOAD_JOBS_H does not reference any database object

BNE.BNE_ASYNC_UPLOAD_JOBS_H is referenced by following:

BNE
VIEW - BNE_ASYNC_UPLOAD_JOBS_H#

[top of page]

Table: BNE_ATTRIBUTES

Description: Generic data stored in parameter lists
Primary Key: BNE_ATTRIBUTES_PK
  1. APPLICATION_ID
  2. ATTRIBUTE_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
BNE_PARAM_DEFNS_B.ATTRIBUTE_CODE
BNE_PARAM_DEFNS_B.ATTRIBUTE_APP_ID 		BNE_ATTRIBUTES
BNE_PARAM_GROUPS_B.ATTRIBUTE_CODE
BNE_PARAM_GROUPS_B.ATTRIBUTE_APP_ID 		BNE_ATTRIBUTES
BNE_PARAM_LISTS_B.ATTRIBUTE_CODE
BNE_PARAM_LISTS_B.ATTRIBUTE_APP_ID 		BNE_ATTRIBUTES
BNE_PARAM_LIST_ITEMS.ATTRIBUTE_CODE
BNE_PARAM_LIST_ITEMS.ATTRIBUTE_APP_ID 		BNE_ATTRIBUTES
Comments

BNE_ATTRIBUTES stores generic information about paramter lists entities which could not be anticipated. There are thirty ATTRIBUTE columns that allow the storage of any data in character form that the developer may wish. The attributes may be saved against a parameter list, list item or list item definition.

Indexes
Index Type Tablespace Column
BNE_ATTRIBUTES_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
ATTRIBUTE_CODE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
ATTRIBUTE_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
ATTRIBUTE1 VARCHAR2 (2000)
Attribute 1
ATTRIBUTE2 VARCHAR2 (2000)
Attribute 2
ATTRIBUTE3 VARCHAR2 (2000)
Attribute 3
ATTRIBUTE4 VARCHAR2 (2000)
Attribute 4
ATTRIBUTE5 VARCHAR2 (2000)
Attribute 5
ATTRIBUTE6 VARCHAR2 (2000)
Attribute 6
ATTRIBUTE7 VARCHAR2 (2000)
Attribute 7
ATTRIBUTE8 VARCHAR2 (2000)
Attribute 8
ATTRIBUTE9 VARCHAR2 (2000)
Attribute 9
ATTRIBUTE10 VARCHAR2 (2000)
Attribute 110
ATTRIBUTE11 VARCHAR2 (2000)
Attribute 11
ATTRIBUTE12 VARCHAR2 (2000)
Attribute 12
ATTRIBUTE13 VARCHAR2 (2000)
Attribute 13
ATTRIBUTE14 VARCHAR2 (2000)
Attribute 14
ATTRIBUTE15 VARCHAR2 (2000)
Attribute 15
ATTRIBUTE16 VARCHAR2 (2000)
Attribute 16
ATTRIBUTE17 VARCHAR2 (2000)
Attribute 17
ATTRIBUTE18 VARCHAR2 (2000)
Attribute 18
ATTRIBUTE19 VARCHAR2 (2000)
Attribute 19
ATTRIBUTE20 VARCHAR2 (2000)
Attribute 20
ATTRIBUTE21 VARCHAR2 (2000)
Attribute 21
ATTRIBUTE22 VARCHAR2 (2000)
Attribute 22
ATTRIBUTE23 VARCHAR2 (2000)
Attribute 23
ATTRIBUTE24 VARCHAR2 (2000)
Attribute 24
ATTRIBUTE25 VARCHAR2 (2000)
Attribute 25
ATTRIBUTE26 VARCHAR2 (2000)
Attribute 26
ATTRIBUTE27 VARCHAR2 (2000)
Attribute 27
ATTRIBUTE28 VARCHAR2 (2000)
Attribute 28
ATTRIBUTE29 VARCHAR2 (2000)
Attribute 29
ATTRIBUTE30 VARCHAR2 (2000)
Attribute 30
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
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).
ATTRIBUTE_NAME1 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME2 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME3 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME4 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME5 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME6 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME7 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME8 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME9 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME10 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME11 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME12 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME13 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME14 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME15 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME16 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME17 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME18 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME19 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME20 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME21 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME22 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME23 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME24 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME25 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME26 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME27 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME28 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME29 VARCHAR2 (30)
Name for corresponding attribute
ATTRIBUTE_NAME30 VARCHAR2 (30)
Name for corresponding attribute
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_ATTRIBUTES does not reference any database object

BNE.BNE_ATTRIBUTES is referenced by following:

BNE
VIEW - BNE_ATTRIBUTES#

[top of page]

Table: BNE_CACHE_DIRECTIVES_B

Description: Definition of Metadata defined cache directived
Primary Key: BNE_CACHE_DIRECTIVES_B_PK
  1. APPLICATION_ID
  2. DIRECTIVE_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
BNE_QUERIES_B.DIRECTIVE_APP_ID
BNE_QUERIES_B.DIRECTIVE_CODE 		BNE_CACHE_DIRECTIVES_B
Comments

BNE_CACHE_DIRECTIVES_B stores the definition of a cache directive. Each directive is uniquely identified by it's APPLICATION_ID and DIRECTIVE_CODE.

Indexes
Index Type Tablespace Column
BNE_CACHE_DIRECTIVES_B_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
DIRECTIVE_CODE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
DIRECTIVE_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
MAX_SIZE NUMBER (15)
Maximum size of object to be cached.
MAX_HITS NUMBER (15) Y Maximum hits for cache
MAX_AGE VARCHAR2 (240) Y Maximum age in cache
DISCRIMINATOR_TYPE VARCHAR2 (30) Y Type setting for entity
DISCRIMINATOR_VALUE VARCHAR2 (2000) Y Value fo the entity
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_CACHE_DIRECTIVES_B does not reference any database object

BNE.BNE_CACHE_DIRECTIVES_B is referenced by following:

BNE
VIEW - BNE_CACHE_DIRECTIVES_B#

[top of page]

Table: BNE_CACHE_DIRECTIVES_TL

Description: Translations for BNE_CACHE_DIRECTIVES_B
Primary Key: BNE_CACHE_DIRECTIVES_TL_PK
  1. APPLICATION_ID
  2. DIRECTIVE_CODE
  3. LANGUAGE
Comments

BNE_CACHE_DIRECTIVES_TL stores the translated name of the viewers defined in BNE_CACHE_DIRECTIVES_B. You need one row for each directive in each of the installed languages.

Indexes
Index Type Tablespace Column
BNE_CACHE_DIRECTIVES_TL_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
DIRECTIVE_CODE
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
DIRECTIVE_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y The language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
USER_NAME VARCHAR2 (240) Y User name for the viewer.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_CACHE_DIRECTIVES_TL does not reference any database object

BNE.BNE_CACHE_DIRECTIVES_TL is referenced by following:

BNE
VIEW - BNE_CACHE_DIRECTIVES_TL#

[top of page]

Table: BNE_COMPONENTS_B

Description: Definition of LOV and XML objects
Primary Key: BNE_COMPONENTS_B_PK
  1. COMPONENT_CODE
  2. APPLICATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_COMPONENTS_B.PARAM_LIST_APP_ID
BNE_COMPONENTS_B.PARAM_LIST_CODE 		BNE_PARAM_LISTS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
BNE_INTERFACE_COLS_B.VAL_COMPONENT_APP_ID
BNE_INTERFACE_COLS_B.VAL_COMPONENT_CODE 		BNE_COMPONENTS_B
Comments

BNE_COMPONENTS_B stores the definition of a component. A component is a generic building block that performs some function when called from other code. Examples of components are LOVs and the XML object used for data download. Each component is uniquely identified by it's APPLICATION_ID and COMPONENT_CODE, and requires the definition of a java class which will run the component, and optional parameter list to define the arguments to the java class.

Indexes
Index Type Tablespace Column
BNE_COMPONENTS_B_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
COMPONENT_CODE
ZD_EDITION_NAME
BNE_COMPONENTS_B_N1 NONUNIQUE APPS_TS_TX_IDX PARAM_LIST_APP_ID
PARAM_LIST_CODE
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
COMPONENT_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
COMPONENT_JAVA_CLASS VARCHAR2 (240) Y Java class name that is used to run the component.
PARAM_LIST_APP_ID NUMBER (15)
Parameter list application id of the component parameter list.
PARAM_LIST_CODE VARCHAR2 (30)
Parameter list code of the component parameter list.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_COMPONENTS_B does not reference any database object

BNE.BNE_COMPONENTS_B is referenced by following:

BNE
VIEW - BNE_COMPONENTS_B#

[top of page]

Table: BNE_COMPONENTS_TL

Description: Translations for BNE_COMPONENTS_B
Primary Key: BNE_COMPONENTS_TL_PK
  1. APPLICATION_ID
  2. COMPONENT_CODE
  3. LANGUAGE
Comments

BNE_COMPONENTS_TL stores the translated name of the components defined in BNE_COMPONENTS_B. You need one row for each component in each of the installed languages.

Indexes
Index Type Tablespace Column
BNE_COMPONENTS_TL_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
COMPONENT_CODE
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
COMPONENT_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y The language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
USER_NAME VARCHAR2 (240) Y User name for the component.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_COMPONENTS_TL does not reference any database object

BNE.BNE_COMPONENTS_TL is referenced by following:

BNE
VIEW - BNE_COMPONENTS_TL#

[top of page]

Table: BNE_CONTENTS_B

Description: Definition of Content Components
Primary Key: BNE_CONTENT_B_PK
  1. APPLICATION_ID
  2. CONTENT_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_CONTENTS_B.INTEGRATOR_APP_ID
BNE_CONTENTS_B.INTEGRATOR_CODE 		BNE_INTEGRATORS_B
BNE_CONTENTS_B.PARAM_LIST_APP_ID
BNE_CONTENTS_B.PARAM_LIST_CODE 		BNE_PARAM_LISTS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
BNE_CONTENT_COLS_B.APPLICATION_ID
BNE_CONTENT_COLS_B.CONTENT_CODE 		BNE_CONTENTS_B
BNE_FILES.APPLICATION_ID
BNE_FILES.CONTENT_CODE 		BNE_CONTENTS_B
BNE_STORED_SQL.APPLICATION_ID
BNE_STORED_SQL.CONTENT_CODE 		BNE_CONTENTS_B
Comments

BNE_CONTENTS_B stores information that defines data located external to Web ADI. This data may come from a number of sources, and is generally tabular in nature. The java class used to obtain the data is defined in JAVA_CLASS, and any arguments needed are defined in the parameter list (PARAM_LIST_APP_ID, PARAM_LIST_CODE). Contents are used in the document creation process, and whenever data is downloaded to a viewer.

Indexes
Index Type Tablespace Column
BNE_CONTENTS_B_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
CONTENT_CODE
ZD_EDITION_NAME
BNE_CONTENTS_B_N1 NONUNIQUE APPS_TS_TX_IDX INTEGRATOR_APP_ID
INTEGRATOR_CODE
BNE_CONTENTS_B_N2 NONUNIQUE APPS_TS_TX_IDX PARAM_LIST_APP_ID
PARAM_LIST_CODE
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
CONTENT_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
INTEGRATOR_APP_ID NUMBER (15) Y Application Id of the integrator this interface is for.
INTEGRATOR_CODE VARCHAR2 (30) Y Integrator code of the integrator this interface is for.
PARAM_LIST_APP_ID NUMBER (15)
Parameter list application id to supply arguements to this content.
PARAM_LIST_CODE VARCHAR2 (30)
Parameter list application id to supply arguements to this content.
CONTENT_CLASS VARCHAR2 (240)
Java class name that is used to run the content.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created 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).
ONCE_ONLY_DOWNLOAD_FLAG VARCHAR2 (1)
Status flag for downloading once only.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_CONTENTS_B does not reference any database object

BNE.BNE_CONTENTS_B is referenced by following:

BNE
VIEW - BNE_CONTENTS_B#

[top of page]

Table: BNE_CONTENTS_TL

Description: Translations for BNE_CONTENTS_B
Primary Key: BNE_CONTENTS_TL_PK
  1. APPLICATION_ID
  2. CONTENT_CODE
  3. LANGUAGE
Comments

BNE_CONTENTS_TL stores the translated name of the contents defined in BNE_CONTENTS_B. You need one row for each content in each of the installed languages.

Indexes
Index Type Tablespace Column
BNE_CONTENT_TL_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
CONTENT_CODE
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
CONTENT_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y The language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
USER_NAME VARCHAR2 (240) Y User name for the content.
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created 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).
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_CONTENTS_TL does not reference any database object

BNE.BNE_CONTENTS_TL is referenced by following:

BNE
VIEW - BNE_CONTENTS_TL#

[top of page]

Table: BNE_CONTENT_COLS_B

Description: Definition of Content Component columns
Primary Key: BNE_CONTENT_COLS_B_PK
  1. APPLICATION_ID
  2. CONTENT_CODE
  3. SEQUENCE_NUM
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_CONTENT_COLS_B.APPLICATION_ID
BNE_CONTENT_COLS_B.CONTENT_CODE 		BNE_CONTENTS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
BNE_MAPPING_LINES.CONTENT_APP_ID
BNE_MAPPING_LINES.CONTENT_CODE
BNE_MAPPING_LINES.CONTENT_SEQ_NUM 		BNE_CONTENT_COLS_B
Comments

BNE_CONTENT_COLS_TL stores the individual column definitions for a content. It defines thes columns in an order given by SEQUENCE_NUM. Each column has a name defined by COL_NAME which may correspond to a SQL query column or similar named value depending on the implementation of the content component.

Indexes
Index Type Tablespace Column
BNE_CONTENT_COLS_B_UK2 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
CONTENT_CODE
COL_NAME
ZD_EDITION_NAME
BNE_CONTENT_COLS_B_UK1 NONUNIQUE APPS_TS_TX_IDX APPLICATION_ID
CONTENT_CODE
SEQUENCE_NUM
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
CONTENT_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
SEQUENCE_NUM NUMBER (15) Y Sequence of this content column.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
COL_NAME VARCHAR2 (240) Y Column name.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
READ_ONLY_FLAG VARCHAR2 (1)
Status flag for read only of entity
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_CONTENT_COLS_B does not reference any database object

BNE.BNE_CONTENT_COLS_B is referenced by following:

BNE
VIEW - BNE_CONTENT_COLS_B#

[top of page]

Table: BNE_CONTENT_COLS_TL

Description: Translations for BNE_CONTENT_COLS_B
Primary Key: BNE_CONTENT_COLS_TL_PK
  1. APPLICATION_ID
  2. CONTENT_CODE
  3. SEQUENCE_NUM
  4. LANGUAGE
Comments

BNE_CONTENT_COLS_TL stores the translated name of the content columns defined in BNE_CONTENT_COLS_B. You need one row for each content column in each of the installed languages.

Indexes
Index Type Tablespace Column
BNE_CONTENT_COLS_TL_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
CONTENT_CODE
SEQUENCE_NUM
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
CONTENT_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
SEQUENCE_NUM NUMBER (15) Y Sequence of this content column.
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y The language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
USER_NAME VARCHAR2 (240) Y User name for the content column.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_CONTENT_COLS_TL does not reference any database object

BNE.BNE_CONTENT_COLS_TL is referenced by following:

BNE
VIEW - BNE_CONTENT_COLS_TL#

[top of page]

Table: BNE_DOCUMENTS

Description: Generated Document information
Primary Key: BNE_DOCUMENTS_PK
  1. DOCUMENT_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
BNE_DOC_ACTIONS.DOCUMENT_ID BNE_DOCUMENTS
BNE_DOC_CREATION_PARAMS.DOCUMENT_ID BNE_DOCUMENTS
BNE_DOC_USER_PARAMS.DOCUMENT_ID BNE_DOCUMENTS
Comments

Generated Document information

Indexes
Index Type Tablespace Column
BNE_DOCUMENTS_UK UNIQUE APPS_TS_TX_IDX DOCUMENT_ID
Columns
Name Datatype Length Mandatory Comments
DOCUMENT_ID VARCHAR2 (40) Y Unique code identifying this entity.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
DISABLED_FLAG VARCHAR2 (1) Y Disabled Flag
DISABLED_DATE DATE

Date when DISABLED_FLAG transitioned to 'Y'
DISABLED_REASON VARCHAR2 (30)
Reason for disablement.
DOCUMENT_CREATED_FLAG VARCHAR2 (1) Y Document Created Flag
DOCUMENT_CREATED_DATE DATE

Date when DOCUMENT_CREATION_FLAG transitioned to 'Y'
DOCUMENT_CREATED_SESSION NUMBER

ICX session Id document was created in.
FIRST_DOWNLOAD_DONE_FLAG VARCHAR2 (1) Y Has the first download been done?
FIRST_DOWNLOAD_DATE DATE

When the first download was done.
LAST_USED_DATE DATE
Y Date when this document was last used. Very similar to WHO LAST_UPDATE_DATE, but separated for clarity.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.

[top of page]

BNE.BNE_DOCUMENTS does not reference any database object

BNE.BNE_DOCUMENTS is referenced by following:

BNE
VIEW - BNE_DOCUMENTS#

[top of page]

Table: BNE_DOC_ACTIONS

Description: Generated User specific Document information
Primary Key: BNE_DOC_ACTIONS_PK
  1. DOCUMENT_ID
  2. USER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_DOC_ACTIONS.DOCUMENT_ID BNE_DOCUMENTS
Comments

Generated User specific Document information

Indexes
Index Type Tablespace Column
BNE_DOC_ACTIONS_UK1 UNIQUE APPS_TS_TX_IDX DOCUMENT_ID
USER_ID
Columns
Name Datatype Length Mandatory Comments
DOCUMENT_ID VARCHAR2 (40) Y Unique code identifying this entity.
USER_ID NUMBER (15) Y User Id of this document action - FK to FND_USER
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
DOWNLOAD_COUNT NUMBER (15) Y Download Count for this user with this document.
DOWNLOAD_LAST_DATE DATE

Date this user last downloaded data with this document
DOWNLOAD_PARAMS_VALID_FLAG VARCHAR2 (1) Y Are the download parameters valid?
DOWNLOAD_PARAMS_VALID_DATE DATE

Date the download parameters were last validated.
UPLOAD_COUNT NUMBER (15) Y Upload Count for this user with this document.
UPLOAD_LAST_DATE DATE

Date this user last uploaded data with this document
UPLOAD_PARAMS_VALID_FLAG VARCHAR2 (1) Y Are the upload parameters valid?
UPLOAD_PARAMS_VALID_DATE DATE

Date the upload parameters were last validated.
CDOP_REVALIDATED_SESSION NUMBER

ICX Session Id that the CDOP parameters are revalidated in.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.

[top of page]

BNE.BNE_DOC_ACTIONS does not reference any database object

BNE.BNE_DOC_ACTIONS is referenced by following:

BNE
VIEW - BNE_DOC_ACTIONS#

[top of page]

Table: BNE_DOC_CREATION_PARAMS

Description: Generated Document Parameter information
Primary Key: BNE_DOC_CREATION_PARAMS_PK
  1. DOCUMENT_ID
  2. PARAM_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_DOC_CREATION_PARAMS.DOCUMENT_ID BNE_DOCUMENTS
Comments

Generated Document Parameter information

Indexes
Index Type Tablespace Column
BNE_DOC_CREATION_PARAMS_UK1 UNIQUE APPS_TS_TX_IDX DOCUMENT_ID
PARAM_NAME
SYS_IL0000395030C00004$$ UNIQUE APPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
DOCUMENT_ID VARCHAR2 (40) Y Unique code identifying this entity.
PARAM_NAME VARCHAR2 (30) Y Parameter Name
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
PARAM_VALUE CLOB (4000)
Parameter Value
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.

[top of page]

BNE.BNE_DOC_CREATION_PARAMS does not reference any database object

BNE.BNE_DOC_CREATION_PARAMS is referenced by following:

BNE
VIEW - BNE_DOC_CREATION_PARAMS#

[top of page]

Table: BNE_DOC_USER_PARAMS

Description: Generated User Document Parameter information
Primary Key: BNE_DOC_USER_PARAMS_PK
  1. DOCUMENT_ID
  2. USER_ID
  3. PARAM_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_DOC_USER_PARAMS.DOCUMENT_ID BNE_DOCUMENTS
Comments

Generated User Document Parameter information

Indexes
Index Type Tablespace Column
BNE_DOC_USER_PARAMS_UK UNIQUE APPS_TS_TX_IDX DOCUMENT_ID
USER_ID
PARAM_NAME
SYS_IL0000395034C00005$$ UNIQUE APPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
DOCUMENT_ID VARCHAR2 (40) Y Unique document id.
USER_ID NUMBER (15) Y User Id of this document action - FK to FND_USER
PARAM_NAME VARCHAR2 (30) Y Parameter Name
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
PARAM_VALUE CLOB (4000)
Parameter Value
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.

[top of page]

BNE.BNE_DOC_USER_PARAMS does not reference any database object

BNE.BNE_DOC_USER_PARAMS is referenced by following:

BNE
VIEW - BNE_DOC_USER_PARAMS#

[top of page]

Table: BNE_DUPLICATE_PROFILES_B

Description: The definition of a duplicate upload profile.
Primary Key: BNE_DUPLICATE_PROFILES_B_PK
  1. APPLICATION_ID
  2. DUP_PROFILE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_DUPLICATE_PROFILES_B.INTEGRATOR_APP_ID
BNE_DUPLICATE_PROFILES_B.INTEGRATOR_CODE 		BNE_INTEGRATORS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
BNE_DUP_INTERFACE_PROFILES.DUP_PROFILE_APP_ID
BNE_DUP_INTERFACE_PROFILES.DUP_PROFILE_CODE 		BNE_DUPLICATE_PROFILES_B
Comments

The definition of a duplicate upload profile.

Indexes
Index Type Tablespace Column
BNE_DUPLICATE_PROFILES_B_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
DUP_PROFILE_CODE
ZD_EDITION_NAME
BNE_DUPLICATE_PROFILES_B_N1 NONUNIQUE APPS_TS_TX_IDX INTEGRATOR_APP_ID
INTEGRATOR_CODE
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
DUP_PROFILE_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
INTEGRATOR_APP_ID NUMBER (15) Y Application Id of the integrator this interface is for.
INTEGRATOR_CODE VARCHAR2 (30) Y Integrator code of the integrator this interface is for.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_DUPLICATE_PROFILES_B does not reference any database object

BNE.BNE_DUPLICATE_PROFILES_B is referenced by following:

BNE
VIEW - BNE_DUPLICATE_PROFILES_B#

[top of page]

Table: BNE_DUPLICATE_PROFILES_TL

Description: The definition of a duplicate upload profile.
Primary Key: BNE_DUPLICATE_PROFILES_TL_PK
  1. APPLICATION_ID
  2. DUP_PROFILE_CODE
  3. LANGUAGE
Comments

The definition of a duplicate upload profile.

Indexes
Index Type Tablespace Column
BNE_DUPLICATE_PROFILES_TL_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
DUP_PROFILE_CODE
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
DUP_PROFILE_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y The language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
USER_NAME VARCHAR2 (240) Y SQL Query text. May contain tokens.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_DUPLICATE_PROFILES_TL does not reference any database object

BNE.BNE_DUPLICATE_PROFILES_TL is referenced by following:

BNE
VIEW - BNE_DUPLICATE_PROFILES_TL#

[top of page]

Table: BNE_DUP_INTERFACE_COLS

Description: The definition of a duplicate upload profile for an interface column.
Primary Key: BNE_DUP_INTERFACE_COLS_PK
  1. INTERFACE_APP_ID
  2. INTERFACE_CODE
  3. INTERFACE_SEQ_NUM
  4. DUP_PROFILE_APP_ID
  5. DUP_PROFILE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_DUP_INTERFACE_COLS.INTERFACE_APP_ID
BNE_DUP_INTERFACE_COLS.INTERFACE_CODE
BNE_DUP_INTERFACE_COLS.DUP_PROFILE_APP_ID
BNE_DUP_INTERFACE_COLS.DUP_PROFILE_CODE 		BNE_DUP_INTERFACE_PROFILES
BNE_DUP_INTERFACE_COLS.INTERFACE_APP_ID
BNE_DUP_INTERFACE_COLS.INTERFACE_CODE
BNE_DUP_INTERFACE_COLS.INTERFACE_SEQ_NUM 		BNE_INTERFACE_COLS_B
Comments

The definition of a duplicate upload profile for an interface column.

Indexes
Index Type Tablespace Column
BNE_DUP_INTERFACE_COLS_UK1 UNIQUE APPS_TS_TX_IDX INTERFACE_APP_ID
INTERFACE_CODE
INTERFACE_SEQ_NUM
DUP_PROFILE_APP_ID
DUP_PROFILE_CODE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
INTERFACE_APP_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
INTERFACE_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
INTERFACE_SEQ_NUM NUMBER (15) Y Unique code identifying this entity for the given APPLICATION_ID.
DUP_PROFILE_APP_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
DUP_PROFILE_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
RESOLVER_CLASSNAME VARCHAR2 (240) Y Fully qualified classname of class that performs resolution for columns that are not given a specific resolver (interface level defeult).
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_DUP_INTERFACE_COLS does not reference any database object

BNE.BNE_DUP_INTERFACE_COLS is referenced by following:

BNE
VIEW - BNE_DUP_INTERFACE_COLS#

[top of page]

Table: BNE_DUP_INTERFACE_PROFILES

Description: The definition of a duplicate upload profile for an interface.
Primary Key: BNE_DUP_INTERFACE_PROFILES_PK
  1. INTERFACE_APP_ID
  2. INTERFACE_CODE
  3. DUP_PROFILE_APP_ID
  4. DUP_PROFILE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_DUP_INTERFACE_PROFILES.DUP_PROFILE_APP_ID
BNE_DUP_INTERFACE_PROFILES.DUP_PROFILE_CODE 		BNE_DUPLICATE_PROFILES_B
BNE_DUP_INTERFACE_PROFILES.INTERFACE_APP_ID
BNE_DUP_INTERFACE_PROFILES.INTERFACE_CODE 		BNE_INTERFACES_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
BNE_DUP_INTERFACE_COLS.INTERFACE_APP_ID
BNE_DUP_INTERFACE_COLS.INTERFACE_CODE
BNE_DUP_INTERFACE_COLS.DUP_PROFILE_APP_ID
BNE_DUP_INTERFACE_COLS.DUP_PROFILE_CODE 		BNE_DUP_INTERFACE_PROFILES
Comments

The definition of a duplicate upload profile for an interface.
This entity associates a duplicate profile with an interface to define interface level duplicate handling.

Indexes
Index Type Tablespace Column
BNE_DUP_INTERFACE_PROFILES_UK1 UNIQUE APPS_TS_TX_IDX INTERFACE_APP_ID
INTERFACE_CODE
DUP_PROFILE_APP_ID
DUP_PROFILE_CODE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
INTERFACE_APP_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
INTERFACE_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
DUP_PROFILE_APP_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
DUP_PROFILE_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
DUP_HANDLING_CODE VARCHAR2 (30) Y Duplicate Handling Code: FAIL, ROW_ERROR, TRANSFORM.
DEFAULT_RESOLVER_CLASSNAME VARCHAR2 (240)
Fully qualified classname of class that performs resolution for columns that are not given a specific resolver (interface level defeult).
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_DUP_INTERFACE_PROFILES does not reference any database object

BNE.BNE_DUP_INTERFACE_PROFILES is referenced by following:

BNE
VIEW - BNE_DUP_INTERFACE_PROFILES#

[top of page]

Table: BNE_FILES

Description: Storage of definition and location of uploaded files
Primary Key: BNE_FILES_PK
  1. APPLICATION_ID
  2. CONTENT_CODE
  3. USER_FILE_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_FILES.APPLICATION_ID
BNE_FILES.CONTENT_CODE 		BNE_CONTENTS_B
Comments

BNE_FILES stores the name and location of a file uploaded to the Web ADI middle tier by the Text File content component. It also stores metadata on how to parse the file.

Indexes
Index Type Tablespace Column
BNE_FILES_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
CONTENT_CODE
USER_FILE_NAME
BNE_FILES_UK2 UNIQUE APPS_TS_TX_IDX MIDDLE_TIER_FILE_NAME
BNE_FILES_UK3 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
CONTENT_CODE
SEQUENCE_NUM
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
CONTENT_CODE VARCHAR2 (30) Y Unique content code the file is saved under (foreign key to BNE_CONTENT.CONTENT_CODE).
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
SEQUENCE_NUM NUMBER (15) Y Sequence number
MIDDLE_TIER_FILE_NAME VARCHAR2 (240) Y Internal name used to save this file on the Web ADI middle tier. This name is guarenteed unique.
USER_FILE_NAME VARCHAR2 (240) Y User file name.
START_LINE NUMBER (15) Y Line to start importing from. One based.
COLUMN_DELIMITER_CHAR VARCHAR2 (30) Y Character that delimits columns in the file. Often a comma or tab.
IGNORE_CONSEC_DELIMS_FLAG VARCHAR2 (1) Y Do we ignore consecutive delimiters in the file.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.

[top of page]

BNE.BNE_FILES does not reference any database object

BNE.BNE_FILES is referenced by following:

BNE
VIEW - BNE_FILES#

[top of page]

Table: BNE_FLEX_OVERRIDES

Description: Flexfield over-ride storage for right justify and zero pad.
Primary Key: BNE_FLEX_OVERRIDES_PK
  1. OA_FLEX_APPLICATION_ID
  2. OA_FLEX_CODE
  3. OA_FLEX_NUM
Comments

Flexfield over-ride storage for right justify and zero pad.
There will be one row per key flexfield instance to be over-ridden.

Indexes
Index Type Tablespace Column
BNE_FLEX_OVERRIDES_UK1 UNIQUE APPS_TS_TX_IDX OA_FLEX_APPLICATION_ID
OA_FLEX_CODE
OA_FLEX_NUM
Columns
Name Datatype Length Mandatory Comments
OA_FLEX_APPLICATION_ID NUMBER (15) Y Flexfield Application Id.
OA_FLEX_CODE VARCHAR2 (30) Y Flexfield Code
OA_FLEX_NUM NUMBER (15) Y Flexfield number
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
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).

[top of page]

BNE.BNE_FLEX_OVERRIDES does not reference any database object

BNE.BNE_FLEX_OVERRIDES is referenced by following:

BNE
VIEW - BNE_FLEX_OVERRIDES#

[top of page]

Table: BNE_GRAPHS_B

Description: base table for graphs information
Primary Key: BNE_GRAPHS_B_PK
  1. APPLICATION_ID
  2. INTEGRATOR_CODE
  3. SEQUENCE_NUM
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_GRAPHS_B.APPLICATION_ID
BNE_GRAPHS_B.INTEGRATOR_CODE 		BNE_INTEGRATORS_B
BNE_GRAPHS_B.LAYOUT_APP_ID
BNE_GRAPHS_B.LAYOUT_CODE 		BNE_LAYOUTS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
BNE_GRAPH_COLUMNS.APPLICATION_ID
BNE_GRAPH_COLUMNS.INTEGRATOR_CODE
BNE_GRAPH_COLUMNS.GRAPH_SEQ_NUM 		BNE_GRAPHS_B
Comments

base table for graphs information

Indexes
Index Type Tablespace Column
BNE_GRAPHS_B_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
INTEGRATOR_CODE
SEQUENCE_NUM
ZD_EDITION_NAME
BNE_GRAPHS_B_N1 NONUNIQUE APPS_TS_TX_IDX LAYOUT_APP_ID
LAYOUT_CODE
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
INTEGRATOR_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
SEQUENCE_NUM NUMBER (15) Y Sequence Num
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
LAYOUT_APP_ID NUMBER (15)
Interface App Id
LAYOUT_CODE VARCHAR2 (30)
Interface Code
GRAPH_DIMENSION_CODE VARCHAR2 (30)
Interface Seq Num
GRAPH_TYPE_CODE VARCHAR2 (30)
Location Code
AUTO_GRAPH_FLAG VARCHAR2 (1)
Auto Graph Code
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_GRAPHS_B does not reference any database object

BNE.BNE_GRAPHS_B is referenced by following:

BNE
VIEW - BNE_GRAPHS_B#

[top of page]

Table: BNE_GRAPHS_TL

Description: Translations for BNE_GRAPHS_B
Primary Key: BNE_GRAPHS_TL_PK
  1. APPLICATION_ID
  2. INTEGRATOR_CODE
  3. SEQUENCE_NUM
  4. LANGUAGE
Comments

BNE_GRAPHS_TL stores the translated name of the viewers defined in BNE_GRAPHS_B. You need one row for each viewer in each of the installed languages.

Indexes
Index Type Tablespace Column
BNE_GRAPHS_TL_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
INTEGRATOR_CODE
SEQUENCE_NUM
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
INTEGRATOR_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
SEQUENCE_NUM NUMBER (15) Y Sequence Number
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y The language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
CHART_TITLE VARCHAR2 (240)
Chart Title
X_AXIS_LABEL VARCHAR2 (240)
X Axis Label
Y_AXIS_LABEL VARCHAR2 (240)
Y Axis Label
Z_AXIS_LABEL VARCHAR2 (240)
Z Axis Label
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_GRAPHS_TL does not reference any database object

BNE.BNE_GRAPHS_TL is referenced by following:

BNE
VIEW - BNE_GRAPHS_TL#

[top of page]

Table: BNE_GRAPH_COLUMNS

Description: base table for graphs information
Primary Key: BNE_GRAPH_COLUMNS_PK
  1. APPLICATION_ID
  2. INTEGRATOR_CODE
  3. GRAPH_SEQ_NUM
  4. SEQUENCE_NUM
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_GRAPH_COLUMNS.APPLICATION_ID
BNE_GRAPH_COLUMNS.INTEGRATOR_CODE
BNE_GRAPH_COLUMNS.GRAPH_SEQ_NUM 		BNE_GRAPHS_B
BNE_GRAPH_COLUMNS.INTERFACE_APP_ID
BNE_GRAPH_COLUMNS.INTERFACE_CODE
BNE_GRAPH_COLUMNS.INTERFACE_SEQ_NUM 		BNE_INTERFACE_COLS_B
Comments

base table for graphs information

Indexes
Index Type Tablespace Column
BNE_GRAPH_COLUMNS_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
INTEGRATOR_CODE
GRAPH_SEQ_NUM
SEQUENCE_NUM
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
INTEGRATOR_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
GRAPH_SEQ_NUM NUMBER (15) Y Graph Seq Num
SEQUENCE_NUM NUMBER (15) Y Sequence Num
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
INTERFACE_APP_ID NUMBER (15) Y Interface App Id
INTERFACE_CODE VARCHAR2 (30) Y Interface Code
INTERFACE_SEQ_NUM NUMBER (15) Y Interface Seq Num
LOCATION_CODE VARCHAR2 (30) Y Location Code
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_GRAPH_COLUMNS does not reference any database object

BNE.BNE_GRAPH_COLUMNS is referenced by following:

BNE
VIEW - BNE_GRAPH_COLUMNS#

[top of page]

Table: BNE_IMPORT_PROGRAMS

Description: Definition of a multiple import programs for an integrator.
Primary Key: BNE_IMPORT_PROGRAMS_PK
  1. APPLICATION_ID
  2. INTEGRATOR_CODE
  3. SEQUENCE_NUM
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_IMPORT_PROGRAMS.APPLICATION_ID
BNE_IMPORT_PROGRAMS.INTEGRATOR_CODE 		BNE_INTEGRATORS_B
BNE_IMPORT_PROGRAMS.IMPORT_PARAM_LIST_APP_ID
BNE_IMPORT_PROGRAMS.IMPORT_PARAM_LIST_CODE 		BNE_PARAM_LISTS_B
BNE_IMPORT_PROGRAMS.APPLICATION_ID
BNE_IMPORT_PROGRAMS.INTEGRATOR_CODE
BNE_IMPORT_PROGRAMS.PARENT_SEQ_NUM 		BNE_IMPORT_PROGRAMS
Foreign Keys to this table:
Foreign Key Column Foreign Table
BNE_IMPORT_PROGRAMS.APPLICATION_ID
BNE_IMPORT_PROGRAMS.INTEGRATOR_CODE
BNE_IMPORT_PROGRAMS.PARENT_SEQ_NUM 		BNE_IMPORT_PROGRAMS
Comments

BNE_IMPORT_PROGRAMS stores the definition of multiple import programs available for an upload for the referenced integrator.

Indexes
Index Type Tablespace Column
BNE_IMPORT_PROGRAMS_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
INTEGRATOR_CODE
SEQUENCE_NUM
ZD_EDITION_NAME
BNE_IMPORT_PROGRAMS_N1 NONUNIQUE APPS_TS_TX_IDX IMPORT_PARAM_LIST_APP_ID
IMPORT_PARAM_LIST_CODE
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
INTEGRATOR_CODE VARCHAR2 (30) Y Integrator code of the integrator this interface is for.
SEQUENCE_NUM NUMBER (15) Y Unique sequence number for entity
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
PARENT_SEQ_NUM NUMBER (15)
Parent sequence number
IMPORT_TYPE NUMBER (15) Y Type of import. Valid values: 1 - synchronous, 2 - asyncronous, 3 - API.
IMPORT_PARAM_LIST_APP_ID NUMBER (15)
Parameter list application id of the import parameter list.
IMPORT_PARAM_LIST_CODE VARCHAR2 (30)
Parameter list code of the import parameter list.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_IMPORT_PROGRAMS does not reference any database object

BNE.BNE_IMPORT_PROGRAMS is referenced by following:

BNE
VIEW - BNE_IMPORT_PROGRAMS#

[top of page]

Table: BNE_INTEGRATORS_B

Description: Definition of Integrator
Primary Key: BNE_INTEGRATORS_B_PK
  1. INTEGRATOR_CODE
  2. APPLICATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_INTEGRATORS_B.IMPORT_PARAM_LIST_APP_ID
BNE_INTEGRATORS_B.IMPORT_PARAM_LIST_CODE 		BNE_PARAM_LISTS_B
BNE_INTEGRATORS_B.UPLOAD_PARAM_LIST_APP_ID
BNE_INTEGRATORS_B.UPLOAD_PARAM_LIST_CODE 		BNE_PARAM_LISTS_B
BNE_INTEGRATORS_B.UPLOAD_SERV_PARAM_LIST_APP_ID
BNE_INTEGRATORS_B.UPLOAD_SERV_PARAM_LIST_CODE 		BNE_PARAM_LISTS_B
BNE_INTEGRATORS_B.CREATE_DOC_LIST_APP_ID
BNE_INTEGRATORS_B.CREATE_DOC_LIST_CODE 		BNE_PARAM_LISTS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
BNE_ASYNC_UPLOAD_JOBS.INTEGRATOR_APP_ID
BNE_ASYNC_UPLOAD_JOBS.INTEGRATOR_CODE 		BNE_INTEGRATORS_B
BNE_CONTENTS_B.INTEGRATOR_APP_ID
BNE_CONTENTS_B.INTEGRATOR_CODE 		BNE_INTEGRATORS_B
BNE_DUPLICATE_PROFILES_B.INTEGRATOR_APP_ID
BNE_DUPLICATE_PROFILES_B.INTEGRATOR_CODE 		BNE_INTEGRATORS_B
BNE_GRAPHS_B.APPLICATION_ID
BNE_GRAPHS_B.INTEGRATOR_CODE 		BNE_INTEGRATORS_B
BNE_IMPORT_PROGRAMS.APPLICATION_ID
BNE_IMPORT_PROGRAMS.INTEGRATOR_CODE 		BNE_INTEGRATORS_B
BNE_INTEGRATOR_VIEWERS.INTEGRATOR_APP_ID
BNE_INTEGRATOR_VIEWERS.INTEGRATOR_CODE 		BNE_INTEGRATORS_B
BNE_INTERFACES_B.INTEGRATOR_APP_ID
BNE_INTERFACES_B.INTEGRATOR_CODE 		BNE_INTEGRATORS_B
BNE_LAYOUTS_B.INTEGRATOR_APP_ID
BNE_LAYOUTS_B.INTEGRATOR_CODE 		BNE_INTEGRATORS_B
BNE_MAPPINGS_B.INTEGRATOR_APP_ID
BNE_MAPPINGS_B.INTEGRATOR_CODE 		BNE_INTEGRATORS_B
BNE_MENUS_B.INTEGRATOR_APP_ID
BNE_MENUS_B.INTEGRATOR_CODE 		BNE_INTEGRATORS_B
Comments

BNE_INTEGRATORS_B stores the definition of an integration solution between desktop applications such as Word and Excel, and Oracle Applications. It is this highest level entity in the Web ADI data model.

Indexes
Index Type Tablespace Column
BNE_INTEGRATORS_B_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
INTEGRATOR_CODE
ZD_EDITION_NAME
BNE_INTEGRATORS_B_N1 NONUNIQUE APPS_TS_TX_IDX DISPLAY_FLAG
BNE_INTEGRATORS_B_N2 NONUNIQUE APPS_TS_TX_IDX CREATE_DOC_LIST_APP_ID
CREATE_DOC_LIST_CODE
BNE_INTEGRATORS_B_N3 NONUNIQUE APPS_TS_TX_IDX UPLOAD_PARAM_LIST_APP_ID
UPLOAD_PARAM_LIST_CODE
BNE_INTEGRATORS_B_N4 NONUNIQUE APPS_TS_TX_IDX UPLOAD_SERV_PARAM_LIST_APP_ID
UPLOAD_SERV_PARAM_LIST_CODE
BNE_INTEGRATORS_B_N5 NONUNIQUE APPS_TS_TX_IDX IMPORT_PARAM_LIST_APP_ID
IMPORT_PARAM_LIST_CODE
BNE_INTEGRATORS_B_N6 NONUNIQUE APPS_TS_TX_IDX SESSION_PARAM_LIST_APP_ID
SESSION_PARAM_LIST_CODE
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
INTEGRATOR_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
ENABLED_FLAG VARCHAR2 (1) Y Is this Integrator to be seen (Y/N)
UPLOAD_PARAM_LIST_APP_ID NUMBER (15)
Parameter list application id of the upload parameter list.
UPLOAD_PARAM_LIST_CODE VARCHAR2 (30)
Parameter list code of the upload parameter list.
UPLOAD_SERV_PARAM_LIST_APP_ID NUMBER (15)
Parameter list application id of the upload service parameter list.
UPLOAD_SERV_PARAM_LIST_CODE VARCHAR2 (30)
Parameter list code of the upload service parameter list.
IMPORT_PARAM_LIST_APP_ID NUMBER (15)
Parameter list application id of the import parameter list.
IMPORT_PARAM_LIST_CODE VARCHAR2 (30)
Parameter list code of the import parameter list.
UPLOADER_CLASS VARCHAR2 (240)
Java class name that is used to run the uploader.
DATE_FORMAT VARCHAR2 (100) Y Date format. Current supported value is yyyy-MM-dd.
IMPORT_TYPE NUMBER (15)
Type of import. Valid values: 1 - synchronous, 2 - asyncronous, 3 - API.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
CREATE_DOC_LIST_APP_ID NUMBER (15)
Additional parameters required during create document process. FK to BNE_PARAM_LISTS_B.
CREATE_DOC_LIST_CODE VARCHAR2 (30)
Additional parameters required during create document process. FK to BNE_PARAM_LISTS_B.
NEW_SESSION_FLAG VARCHAR2 (1)
Status flag to create a new session.
LAYOUT_RESOLVER_CLASS VARCHAR2 (240)
Fully qualified java class for document generation time layout modification.
LAYOUT_VERIFIER_CLASS VARCHAR2 (240)
Fully qualified java class for layout verification during layout creation.
SESSION_CONFIG_CLASS VARCHAR2 (240)
Session configuration classes
SESSION_PARAM_LIST_APP_ID NUMBER (15)
session parameter list application code identifier
SESSION_PARAM_LIST_CODE VARCHAR2 (30)
Sessions parameter list code identifier
DISPLAY_FLAG VARCHAR2 (1)
Status flag for displaying the entity
SOURCE VARCHAR2 (1)
Source of Integrator created. Valid values: O - Oracle; C - Custom
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_INTEGRATORS_B does not reference any database object

BNE.BNE_INTEGRATORS_B is referenced by following:

BNE
VIEW - BNE_INTEGRATORS_B#

[top of page]

Table: BNE_INTEGRATORS_TL

Description: Translations for BNE_INTEGRATORS_B
Primary Key: BNE_INTEGRATORS_TL_PK
  1. APPLICATION_ID
  2. INTEGRATOR_CODE
  3. LANGUAGE
Comments

BNE_INTEGRATORS_TL stores the translated name, as well as upload headers of the integrators defined in BNE_INTEGRATORS_B. You need one row for each integrator in each of the installed languages.

Indexes
Index Type Tablespace Column
BNE_INTEGRATORS_TL_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
INTEGRATOR_CODE
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
INTEGRATOR_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y The language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
USER_NAME VARCHAR2 (240) Y User name for the integrator.
UPLOAD_HEADER VARCHAR2 (240)
Header text used in upload screen.
UPLOAD_TITLE_BAR VARCHAR2 (240)
Text used in upload screen title bar.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_INTEGRATORS_TL does not reference any database object

BNE.BNE_INTEGRATORS_TL is referenced by following:

BNE
VIEW - BNE_INTEGRATORS_TL#

[top of page]

Table: BNE_INTEGRATOR_VIEWERS

Description: Definition of Viewers
Primary Key: BNE_INTEGRATOR_VIEWERS_PK
  1. INTEGRATOR_APP_ID
  2. INTEGRATOR_CODE
  3. VIEWER_APP_ID
  4. VIEWER_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_INTEGRATOR_VIEWERS.INTEGRATOR_APP_ID
BNE_INTEGRATOR_VIEWERS.INTEGRATOR_CODE 		BNE_INTEGRATORS_B
BNE_INTEGRATOR_VIEWERS.VIEWER_APP_ID
BNE_INTEGRATOR_VIEWERS.VIEWER_CODE 		BNE_VIEWERS_B
Comments

BNE_VIEWERS_B stores the definition of a viewer. A viewer is the definition of the code that is run to start and run a desktop application such as Word and Excel. Examples of components are LOVs and the XML object used for data download. Each component is uniquely identified by it's APPLICATION_ID and VIEWER_CODE, and requires the definition of a java class which will run to generate the viewer, and optional parameter list to define the arguments to the java class.

Indexes
Index Type Tablespace Column
BNE_INTEGRATOR_VIEWERS_UK1 UNIQUE APPS_TS_TX_IDX INTEGRATOR_APP_ID
INTEGRATOR_CODE
VIEWER_APP_ID
VIEWER_CODE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
INTEGRATOR_APP_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
INTEGRATOR_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
VIEWER_APP_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
VIEWER_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_INTEGRATOR_VIEWERS does not reference any database object

BNE.BNE_INTEGRATOR_VIEWERS is referenced by following:

BNE
VIEW - BNE_INTEGRATOR_VIEWERS#

[top of page]

Table: BNE_INTERFACES_B

Description: Definition of a single Interface of an Integrator
Primary Key: BNE_INTERFACES_B_PK
  1. APPLICATION_ID
  2. INTERFACE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_INTERFACES_B.INTEGRATOR_APP_ID
BNE_INTERFACES_B.INTEGRATOR_CODE 		BNE_INTEGRATORS_B
BNE_INTERFACES_B.UPLOAD_PARAM_LIST_APP_ID
BNE_INTERFACES_B.UPLOAD_PARAM_LIST_CODE 		BNE_PARAM_LISTS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
BNE_DUP_INTERFACE_PROFILES.INTERFACE_APP_ID
BNE_DUP_INTERFACE_PROFILES.INTERFACE_CODE 		BNE_INTERFACES_B
BNE_INTERFACE_COLS_B.APPLICATION_ID
BNE_INTERFACE_COLS_B.INTERFACE_CODE 		BNE_INTERFACES_B
BNE_INTERFACE_KEYS.INTERFACE_APP_ID
BNE_INTERFACE_KEYS.INTERFACE_CODE 		BNE_INTERFACES_B
BNE_LAYOUTS_B.REPORTING_INTERFACE_APP_ID
BNE_LAYOUTS_B.REPORTING_INTERFACE_CODE 		BNE_INTERFACES_B
BNE_MAPPINGS_B.REPORTING_INTERFACE_APP_ID
BNE_MAPPINGS_B.REPORTING_INTERFACE_CODE 		BNE_INTERFACES_B
Comments

BNE_INTERFACES_B stores the definition of an integrator interface. An interface is an external boundary over which data is passed in a Web ADI upload. An interface is typically a table (open interface table) used to pass data between applications, for example GL_INTERFACE for Journal upload. It is possible to use multiple interfaces in an integrator.

Indexes
Index Type Tablespace Column
BNE_INTERFACES_B_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
INTERFACE_CODE
ZD_EDITION_NAME
BNE_INTERFACES_B_N1 NONUNIQUE APPS_TS_TX_IDX INTEGRATOR_APP_ID
INTEGRATOR_CODE
BNE_INTERFACES_B_N2 NONUNIQUE APPS_TS_TX_IDX UPLOAD_PARAM_LIST_APP_ID
UPLOAD_PARAM_LIST_CODE
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
INTERFACE_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
INTEGRATOR_APP_ID NUMBER (15) Y Application Id of the integrator this interface is for.
INTEGRATOR_CODE VARCHAR2 (30) Y Integrator code of the integrator this interface is for.
INTERFACE_NAME VARCHAR2 (50) Y Name of interface. This will often correspond to an interface table - table name.
UPLOAD_TYPE NUMBER (15) Y Upload type. Valid values: 0 - Custom, 1 - SQL, 2 - PL/SQL, 3, - Validation only, 4 - None.
UPLOAD_OBJ_NAME VARCHAR2 (240)
Fully qualified java class to call if UPLOAD_TYPE = 0.
UPLOAD_PARAM_LIST_APP_ID NUMBER (15)
Parameter list application id of the upload parameter list.
UPLOAD_PARAM_LIST_CODE VARCHAR2 (30)
Parameter list code of the upload parameter list.
UPLOAD_ORDER NUMBER (15)
Order interface is uploaded out of all the interfaces for this integrator.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_INTERFACES_B does not reference any database object

BNE.BNE_INTERFACES_B is referenced by following:

BNE
VIEW - BNE_INTERFACES_B#

[top of page]

Table: BNE_INTERFACES_TL

Description: Translations for BNE_INTERFACES_B
Primary Key: BNE_INTERFACES_TL_PK
  1. APPLICATION_ID
  2. INTERFACE_CODE
  3. LANGUAGE
Comments

BNE_INTERFACES_TL stores the translated name of the interfaces defined in BNE_INTERFACES_B. You need one row for each interface in each of the installed languages.

Indexes
Index Type Tablespace Column
BNE_INTERFACES_TL_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
INTERFACE_CODE
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
INTERFACE_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y The language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
USER_NAME VARCHAR2 (240) Y User name for the interface.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_INTERFACES_TL does not reference any database object

BNE.BNE_INTERFACES_TL is referenced by following:

BNE
VIEW - BNE_INTERFACES_TL#

[top of page]

Table: BNE_INTERFACE_COLS_B

Description: Definition of individual columns in an Interface
Primary Key: BNE_INTERFACE_COLS_B_PK
  1. APPLICATION_ID
  2. INTERFACE_CODE
  3. SEQUENCE_NUM
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_INTERFACE_COLS_B.VAL_COMPONENT_APP_ID
BNE_INTERFACE_COLS_B.VAL_COMPONENT_CODE 		BNE_COMPONENTS_B
BNE_INTERFACE_COLS_B.APPLICATION_ID
BNE_INTERFACE_COLS_B.INTERFACE_CODE 		BNE_INTERFACES_B
BNE_INTERFACE_COLS_B.VAL_QUERY_APP_ID
BNE_INTERFACE_COLS_B.VAL_QUERY_CODE 		BNE_QUERIES_B
BNE_INTERFACE_COLS_B.EXPANDED_SQL_QUERY_APP_ID
BNE_INTERFACE_COLS_B.EXPANDED_SQL_QUERY_CODE 		BNE_QUERIES_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
BNE_DUP_INTERFACE_COLS.INTERFACE_APP_ID
BNE_DUP_INTERFACE_COLS.INTERFACE_CODE
BNE_DUP_INTERFACE_COLS.INTERFACE_SEQ_NUM 		BNE_INTERFACE_COLS_B
BNE_GRAPH_COLUMNS.INTERFACE_APP_ID
BNE_GRAPH_COLUMNS.INTERFACE_CODE
BNE_GRAPH_COLUMNS.INTERFACE_SEQ_NUM 		BNE_INTERFACE_COLS_B
BNE_INTERFACE_KEY_COLS.INTERFACE_APP_ID
BNE_INTERFACE_KEY_COLS.INTERFACE_CODE
BNE_INTERFACE_KEY_COLS.INTERFACE_SEQ_NUM 		BNE_INTERFACE_COLS_B
BNE_LAYOUT_COLS.INTERFACE_APP_ID
BNE_LAYOUT_COLS.INTERFACE_CODE
BNE_LAYOUT_COLS.INTERFACE_SEQ_NUM 		BNE_INTERFACE_COLS_B
BNE_MAPPING_LINES.INTERFACE_APP_ID
BNE_MAPPING_LINES.INTERFACE_CODE
BNE_MAPPING_LINES.INTERFACE_SEQ_NUM 		BNE_INTERFACE_COLS_B
Comments

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

Indexes
Index Type Tablespace Column
BNE_INTERFACE_COLS_B_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
INTERFACE_CODE
SEQUENCE_NUM
ZD_EDITION_NAME
BNE_INTERFACE_COLS_B_N1 NONUNIQUE APPS_TS_TX_IDX VAL_COMPONENT_APP_ID
VAL_COMPONENT_CODE
BNE_INTERFACE_COLS_B_N2 NONUNIQUE APPS_TS_TX_IDX VAL_QUERY_APP_ID
VAL_QUERY_CODE
BNE_INTERFACE_COLS_B_N3 NONUNIQUE APPS_TS_TX_IDX EXPANDED_SQL_QUERY_APP_ID
EXPANDED_SQL_QUERY_CODE
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
INTERFACE_CODE VARCHAR2 (30) Y Code identifying this entity for the given APPLICATION_ID (foreign key to BNE_INTERFACES.INTERFACE_CODE).
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
SEQUENCE_NUM NUMBER (15) Y Unique number identifying this interface column.
INTERFACE_COL_TYPE NUMBER (15) Y Interface column type. Valid values: 1 - Physical column, 2 - Alias column.
INTERFACE_COL_NAME VARCHAR2 (50) Y Name of the interface column. This will most often correspond to the column name of an open interface table.
ENABLED_FLAG VARCHAR2 (1) Y Is this column enabled?
REQUIRED_FLAG VARCHAR2 (1) Y Is this column required for upload?
DISPLAY_FLAG VARCHAR2 (1) Y is this column able to be displayed?
READ_ONLY_FLAG VARCHAR2 (1) Y Is this column read-only?
NOT_NULL_FLAG VARCHAR2 (1) Y Is this column mandatory?
SUMMARY_FLAG VARCHAR2 (1) Y Value can be sumirized (Y/N)?
MAPPING_ENABLED_FLAG VARCHAR2 (1) Y 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) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y 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
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_INTERFACE_COLS_B does not reference any database object

BNE.BNE_INTERFACE_COLS_B is referenced by following:

BNE
VIEW - BNE_INTERFACE_COLS_B#

[top of page]

Table: BNE_INTERFACE_COLS_TL

Description: Translations for BNE_INTERFACE_COLS_B
Primary Key: BNE_INTERFACE_COLS_TL_PK
  1. INTERFACE_CODE
  2. SEQUENCE_NUM
  3. APPLICATION_ID
  4. LANGUAGE
Comments

BNE_INTERFACE_COLS_TL stores the translated prompts for the interface column defined in BNE_INTERFACE_COLS_B. You need one row for each interface column in each of the installed languages.

Indexes
Index Type Tablespace Column
BNE_INTERFACE_COLS_TL_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
INTERFACE_CODE
SEQUENCE_NUM
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
INTERFACE_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
SEQUENCE_NUM NUMBER (15) Y Unique number identifying this interface column.
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y The language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
USER_HINT VARCHAR2 (2000)
User hint.
PROMPT_LEFT VARCHAR2 (240)
Left prompt.
USER_HELP_TEXT VARCHAR2 (2000)
Help text.
PROMPT_ABOVE VARCHAR2 (240)
Prompt above.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_INTERFACE_COLS_TL does not reference any database object

BNE.BNE_INTERFACE_COLS_TL is referenced by following:

BNE
VIEW - BNE_INTERFACE_COLS_TL#

[top of page]

Table: BNE_INTERFACE_KEYS

Description: Definition of logical keys over an interface.
Primary Key: BNE_INTERFACE_KEYS_PK
  1. APPLICATION_ID
  2. KEY_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_INTERFACE_KEYS.INTERFACE_APP_ID
BNE_INTERFACE_KEYS.INTERFACE_CODE 		BNE_INTERFACES_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
BNE_INTERFACE_KEY_COLS.APPLICATION_ID
BNE_INTERFACE_KEY_COLS.KEY_CODE 		BNE_INTERFACE_KEYS
Comments

Definition of logical keys over an interface.

Indexes
Index Type Tablespace Column
BNE_INTERFACE_KEYS_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
KEY_CODE
ZD_EDITION_NAME
BNE_INTERFACE_KEYS_N1 NONUNIQUE APPS_TS_TX_IDX INTERFACE_APP_ID
INTERFACE_CODE
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
KEY_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
INTERFACE_APP_ID NUMBER (15) Y Interface application id this key is for.
INTERFACE_CODE VARCHAR2 (30) Y Interface Code this key is for.
KEY_TYPE VARCHAR2 (30) Y Type of Key.
KEY_CLASS VARCHAR2 (240) Y Pluggable Java class for duplicate key generation.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_INTERFACE_KEYS does not reference any database object

BNE.BNE_INTERFACE_KEYS is referenced by following:

BNE
VIEW - BNE_INTERFACE_KEYS#

[top of page]

Table: BNE_INTERFACE_KEY_COLS

Description: Definition of logical key columns.
Primary Key: BNE_INTERFACE_KEY_COLS_PK
  1. APPLICATION_ID
  2. KEY_CODE
  3. SEQUENCE_NUM
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_INTERFACE_KEY_COLS.APPLICATION_ID
BNE_INTERFACE_KEY_COLS.KEY_CODE 		BNE_INTERFACE_KEYS
BNE_INTERFACE_KEY_COLS.INTERFACE_APP_ID
BNE_INTERFACE_KEY_COLS.INTERFACE_CODE
BNE_INTERFACE_KEY_COLS.INTERFACE_SEQ_NUM 		BNE_INTERFACE_COLS_B
Comments

Definition of logical keys columns.

Indexes
Index Type Tablespace Column
BNE_INTERFACE_KEY_COLS_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
KEY_CODE
SEQUENCE_NUM
ZD_EDITION_NAME
BNE_INTERFACE_KEY_COLS_N1 NONUNIQUE APPS_TS_TX_IDX INTERFACE_APP_ID
INTERFACE_CODE
INTERFACE_SEQ_NUM
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
KEY_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
SEQUENCE_NUM NUMBER (15) Y Ordered Sequence Number of key column.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
INTERFACE_APP_ID NUMBER (15) Y Interface application id this key is for.
INTERFACE_CODE VARCHAR2 (30) Y Interface Code this key is for.
INTERFACE_SEQ_NUM NUMBER (15) Y Interface Code this key sequence is for.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_INTERFACE_KEY_COLS does not reference any database object

BNE.BNE_INTERFACE_KEY_COLS is referenced by following:

BNE
VIEW - BNE_INTERFACE_KEY_COLS#

[top of page]

Table: BNE_LAYOUTS_B

Description: Definition of an instance of the display of an Integrator
Primary Key: BNE_LAYOUTS_B_PK
  1. LAYOUT_CODE
  2. APPLICATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_LAYOUTS_B.REPORTING_INTERFACE_APP_ID
BNE_LAYOUTS_B.REPORTING_INTERFACE_CODE 		BNE_INTERFACES_B
BNE_LAYOUTS_B.INTEGRATOR_APP_ID
BNE_LAYOUTS_B.INTEGRATOR_CODE 		BNE_INTEGRATORS_B
BNE_LAYOUTS_B.STYLESHEET_CODE
BNE_LAYOUTS_B.STYLESHEET_APP_ID 		BNE_STYLESHEETS_B
BNE_LAYOUTS_B.CREATE_DOC_LIST_APP_ID
BNE_LAYOUTS_B.CREATE_DOC_LIST_CODE 		BNE_PARAM_LISTS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
BNE_GRAPHS_B.LAYOUT_APP_ID
BNE_GRAPHS_B.LAYOUT_CODE 		BNE_LAYOUTS_B
BNE_LAYOUT_LOBS.APPLICATION_ID
BNE_LAYOUT_LOBS.LAYOUT_CODE 		BNE_LAYOUTS_B
BNE_LAYOUT_BLOCKS_B.APPLICATION_ID
BNE_LAYOUT_BLOCKS_B.LAYOUT_CODE 		BNE_LAYOUTS_B
Comments

BNE_LAYOUTS_B stores the definition of a layout. A layout is a hierachical structure contianinf BNE_INTERFACE_COL columns. It is by means of a layout that a viewer is able to display data in a meaningful way.

Indexes
Index Type Tablespace Column
BNE_LAYOUTS_B_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
LAYOUT_CODE
ZD_EDITION_NAME
BNE_LAYOUTS_B_N1 NONUNIQUE APPS_TS_TX_IDX INTEGRATOR_APP_ID
INTEGRATOR_CODE
BNE_LAYOUTS_B_N2 NONUNIQUE APPS_TS_TX_IDX CREATE_DOC_LIST_APP_ID
CREATE_DOC_LIST_CODE
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
LAYOUT_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
STYLESHEET_APP_ID NUMBER (15) Y Application id of style sheet used by this layout by default.
STYLESHEET_CODE VARCHAR2 (30) Y Style sheet used by this layout by default.
INTEGRATOR_APP_ID NUMBER (15) Y Application Id of the integrator this interface is for.
INTEGRATOR_CODE VARCHAR2 (30) Y Integrator code of the integrator this interface is for.
STYLE VARCHAR2 (2000)
Optional free form style text to over-ride STYLE_CLASS.
STYLE_CLASS VARCHAR2 (50)
Style class name.
REPORTING_FLAG VARCHAR2 (1) Y Type of layout this is. Valid values are 'Y' - Reporting and 'N' - data-entry.
REPORTING_INTERFACE_APP_ID NUMBER (15)
Interface Id of reporting interface.
REPORTING_INTERFACE_CODE VARCHAR2 (30)
Interface code of interface if this layout is a reporting layout (REPORTING_FLAG = Y).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
CREATE_DOC_LIST_APP_ID NUMBER (15)
Additional parameters required during create document process. FK to BNE_PARAM_LISTS_B.
CREATE_DOC_LIST_CODE VARCHAR2 (30)
Additional parameters required during create document process. FK to BNE_PARAM_LISTS_B.
IMAGE_FILE_NAME VARCHAR2 (40)
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_LAYOUTS_B does not reference any database object

BNE.BNE_LAYOUTS_B is referenced by following:

BNE
VIEW - BNE_LAYOUTS_B#

[top of page]

Table: BNE_LAYOUTS_TL

Description: Translations for BNE_LAYOUTS_B
Primary Key: BNE_LAYOUTS_TL_PK
  1. APPLICATION_ID
  2. LAYOUT_CODE
  3. LANGUAGE
Comments

BNE_LAYOUTS_TL stores the translated name of the layouts defined in BNE_LAYOUTS_B. You need one row for each layout in each of the installed languages.

Indexes
Index Type Tablespace Column
BNE_LAYOUTS_TL_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
LAYOUT_CODE
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
LAYOUT_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y The language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
USER_NAME VARCHAR2 (240) Y User name for the layout.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_LAYOUTS_TL does not reference any database object

BNE.BNE_LAYOUTS_TL is referenced by following:

BNE
VIEW - BNE_LAYOUTS_TL#

[top of page]

Table: BNE_LAYOUT_BLOCKS_B

Description: Definition of sub-levels in a Layout
Primary Key: BNE_LAYOUT_BLOCKS_B_PK
  1. APPLICATION_ID
  2. LAYOUT_CODE
  3. BLOCK_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_LAYOUT_BLOCKS_B.APPLICATION_ID
BNE_LAYOUT_BLOCKS_B.LAYOUT_CODE 		BNE_LAYOUTS_B
BNE_LAYOUT_BLOCKS_B.APPLICATION_ID
BNE_LAYOUT_BLOCKS_B.PARENT_ID
BNE_LAYOUT_BLOCKS_B.LAYOUT_CODE 		BNE_LAYOUT_BLOCKS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
BNE_LAYOUT_BLOCKS_B.APPLICATION_ID
BNE_LAYOUT_BLOCKS_B.PARENT_ID
BNE_LAYOUT_BLOCKS_B.LAYOUT_CODE 		BNE_LAYOUT_BLOCKS_B
BNE_LAYOUT_COLS.APPLICATION_ID
BNE_LAYOUT_COLS.BLOCK_ID
BNE_LAYOUT_COLS.LAYOUT_CODE 		BNE_LAYOUT_BLOCKS_B
Comments

BNE_LAYOUT_BLOCKS_B defines logical grouping of BNE_INTERFACE_COLS columns in a layout. Each block may have a parent, it may be oriented in different ways and given a block size (number of rows to show). Each layout block may use styles for formatting.

Indexes
Index Type Tablespace Column
BNE_LAYOUT_BLOCKS_B_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
LAYOUT_CODE
BLOCK_ID
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
LAYOUT_CODE VARCHAR2 (30) Y Code identifying this entity for the given APPLICATION_ID.
BLOCK_ID NUMBER (15) Y Unique sequence number of block.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
PARENT_ID NUMBER (15)
Parent layout block.
LAYOUT_ELEMENT VARCHAR2 (240) Y Valid values: CONTEXT, HEADER, LINES.
STYLE_CLASS VARCHAR2 (50)
Style class name.
STYLE VARCHAR2 (2000)
Optional free form style text to over-ride STYLE_CLASS.
ROW_STYLE_CLASS VARCHAR2 (50)
Row style class name.
ROW_STYLE VARCHAR2 (2000)
Optional free form style text to over-ride ROW_STYLE_CLASS.
COL_STYLE_CLASS VARCHAR2 (50)
Column style class name.
COL_STYLE VARCHAR2 (2000)
Optional free form style text to over-ride COL_STYLE_CLASS.
PROMPT_DISPLAYED_FLAG VARCHAR2 (1) Y Do we display prompt (Y/N)?
PROMPT_STYLE_CLASS VARCHAR2 (50)
Prompt style class name.
PROMPT_STYLE VARCHAR2 (2000)
Optional free form style text to over-ride PROMPT_STYLE_CLASS.
HINT_DISPLAYED_FLAG VARCHAR2 (1) Y Do we display hint text (Y/N).
HINT_STYLE_CLASS VARCHAR2 (50)
Hint style class name.
HINT_STYLE VARCHAR2 (2000)
Optional free form style text to over-ride HINT_STYLE_CLASS.
ORIENTATION VARCHAR2 (20) Y Block layout orientation. Valid values: VERTICAL, HORIZONTAL.
LAYOUT_CONTROL VARCHAR2 (20) Y Valid values: TABLE_FLOW, COLUMN_FLOW.
DISPLAY_FLAG VARCHAR2 (1) Y Do we display this block (Y/N)?
BLOCKSIZE NUMBER (15) Y Number of rows to show in this block.
MINSIZE NUMBER (15) Y For future use.
MAXSIZE NUMBER (15) Y For future use.
SEQUENCE_NUM NUMBER (15) Y The order in which the columns are rendered.
PROMPT_COLSPAN NUMBER (15)
Number of viewer columns a prompt overlays.
HINT_COLSPAN NUMBER (15)
Number of columns a hint overlays.
ROW_COLSPAN NUMBER (15)
Number of cloumns to skip befor showing this block.
SUMMARY_STYLE_CLASS VARCHAR2 (50)
Summary style class name.
SUMMARY_STYLE VARCHAR2 (2000)
Optional free form style text to over-ride SUMMARY_STYLE_CLASS.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
TITLE_STYLE_CLASS VARCHAR2 (50)
Title style class name.
TITLE_STYLE VARCHAR2 (2000)
Optional free form style text to over-ride TITLE_STYLE_CLASS.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_LAYOUT_BLOCKS_B does not reference any database object

BNE.BNE_LAYOUT_BLOCKS_B is referenced by following:

BNE
VIEW - BNE_LAYOUT_BLOCKS_B#

[top of page]

Table: BNE_LAYOUT_BLOCKS_TL

Description: Translations for BNE_LAYOUT_BLOCKS_B
Primary Key: BNE_LAYOUT_BLOCKS_TL_PK
  1. APPLICATION_ID
  2. LAYOUT_CODE
  3. BLOCK_ID
  4. LANGUAGE
Comments

BNE_LAYOUT_BLOCKS_TL stores the translated name of the layout blocks defined in BNE_LAYOUT_BLOCKS_B. You need one row for each layout block in each of the installed languages.

Indexes
Index Type Tablespace Column
BNE_LAYOUT_BLOCKS_TL_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
LAYOUT_CODE
BLOCK_ID
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
LAYOUT_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
BLOCK_ID NUMBER (15) Y Unique sequence number of block.
USER_NAME VARCHAR2 (240) Y User name for the layout block.
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y The language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
PROMPT_ABOVE VARCHAR2 (240)
Language text to appear above the prompt
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_LAYOUT_BLOCKS_TL does not reference any database object

BNE.BNE_LAYOUT_BLOCKS_TL is referenced by following:

BNE
VIEW - BNE_LAYOUT_BLOCKS_TL#

[top of page]

Table: BNE_LAYOUT_COLS

Description: Definition of individual columns in a Layout Block
Primary Key: BNE_LAYOUT_COLS_PK
  1. APPLICATION_ID
  2. BLOCK_ID
  3. LAYOUT_CODE
  4. SEQUENCE_NUM
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_LAYOUT_COLS.APPLICATION_ID
BNE_LAYOUT_COLS.BLOCK_ID
BNE_LAYOUT_COLS.LAYOUT_CODE 		BNE_LAYOUT_BLOCKS_B
BNE_LAYOUT_COLS.INTERFACE_APP_ID
BNE_LAYOUT_COLS.INTERFACE_CODE
BNE_LAYOUT_COLS.INTERFACE_SEQ_NUM 		BNE_INTERFACE_COLS_B
Comments

BNE_LAYOUT_COLS stores individual column positioning within a BNE_LAYOUT_BLOCK_B.

Indexes
Index Type Tablespace Column
BNE_LAYOUT_COLS_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
BLOCK_ID
LAYOUT_CODE
SEQUENCE_NUM
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
LAYOUT_CODE VARCHAR2 (30) Y Code identifying this entity for the given APPLICATION_ID.
BLOCK_ID NUMBER (15) Y Sequence number for column block.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
INTERFACE_APP_ID NUMBER (15) Y Interface Id of Interface column being layed out.
INTERFACE_CODE VARCHAR2 (30) Y Interface code of Interface column being layed out.
INTERFACE_SEQ_NUM NUMBER (15) Y Sequence number of Interface column being layed out.
SEQUENCE_NUM NUMBER (15) Y Sequence number for column.
STYLE VARCHAR2 (2000)
Optional free form style text to over-ride STYLE_CLASS.
STYLE_CLASS VARCHAR2 (50)
Style class name.
HINT_STYLE VARCHAR2 (2000)
Optional free form style text to over-ride HINT_STYLE_CLASS.
HINT_STYLE_CLASS VARCHAR2 (50)
Hint style class name.
PROMPT_STYLE VARCHAR2 (2000)
Optional free form style text to over-ride PROMPT_STYLE_CLASS.
PROMPT_STYLE_CLASS VARCHAR2 (50)
Prompt style class name.
DEFAULT_TYPE VARCHAR2 (30)
Valid Values: CONSTANT, ENVIRONMENT, SQL, PARAMETER
DEFAULT_VALUE VARCHAR2 (2000)
Value depending upon DEFAULT_TYPE.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
DISPLAY_WIDTH NUMBER (15)
Width to display column
READ_ONLY_FLAG VARCHAR2 (1)
Is this layout columne read only?
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_LAYOUT_COLS does not reference any database object

BNE.BNE_LAYOUT_COLS is referenced by following:

BNE
VIEW - BNE_LAYOUT_COLS#

[top of page]

Table: BNE_LAYOUT_LOBS

Description: Reference to Data stored in FND_LOBS for a Layout
Primary Key: BNE_LAYOUT_LOBS_PK
  1. APPLICATION_ID
  2. LAYOUT_CODE
  3. FILE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_LAYOUT_LOBS.APPLICATION_ID
BNE_LAYOUT_LOBS.LAYOUT_CODE 		BNE_LAYOUTS_B
Comments

BNE_LAYOUT_LOBS stored the reference between a Layout and large object data stored in FND_LOBS.

Indexes
Index Type Tablespace Column
BNE_LAYOUT_LOBS_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
LAYOUT_CODE
FILE_ID
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y LAYOUT_ID from BNE_LAYOUTS
LAYOUT_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
FILE_ID NUMBER (15) Y FILE_ID from FND_LOBS table
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
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).

[top of page]

BNE.BNE_LAYOUT_LOBS does not reference any database object

BNE.BNE_LAYOUT_LOBS is referenced by following:

BNE
VIEW - BNE_LAYOUT_LOBS#

[top of page]

Table: BNE_MAPPINGS_B

Description: Definition of Mappings between Contents and Interface Columns
Primary Key: BNE_MAPPINGS_B_PK
  1. MAPPING_CODE
  2. APPLICATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_MAPPINGS_B.REPORTING_INTERFACE_APP_ID
BNE_MAPPINGS_B.REPORTING_INTERFACE_CODE 		BNE_INTERFACES_B
BNE_MAPPINGS_B.INTEGRATOR_APP_ID
BNE_MAPPINGS_B.INTEGRATOR_CODE 		BNE_INTEGRATORS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
BNE_MAPPING_LINES.APPLICATION_ID
BNE_MAPPING_LINES.MAPPING_CODE 		BNE_MAPPINGS_B
Comments

BNE_MAPPINGS_B stores the definition of a mapping between a content (BNE_CONTENTS_B - data external to Web ADI that is to be downloaded), and an interface (BNE_INTERFACES_B). Having a mapping allows data to be placed in the correct interface column when layed out in a viewer, and when uploaded will ensure the data is inserted into the correct interface column.

Indexes
Index Type Tablespace Column
BNE_MAPPINGS_B_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
MAPPING_CODE
ZD_EDITION_NAME
BNE_MAPPINGS_B_N1 NONUNIQUE APPS_TS_TX_IDX INTEGRATOR_APP_ID
INTEGRATOR_CODE
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
MAPPING_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
INTEGRATOR_APP_ID NUMBER (15) Y Application Id of the integrator this interface is for.
INTEGRATOR_CODE VARCHAR2 (30) Y Integrator code of the integrator this interface is for.
REPORTING_FLAG VARCHAR2 (1) Y Type of Mapping this is. Valid values are 'Y' - Reporting and 'N' - Data-entry.
REPORTING_INTERFACE_APP_ID NUMBER (15)
Interface id of reporting interface if this is a reporting only mapping (REPORTING_FLAG = Y).
REPORTING_INTERFACE_CODE VARCHAR2 (30)
Interface code of reporting interface if this is a reporting only mapping (REPORTING_FLAG = Y).
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_MAPPINGS_B does not reference any database object

BNE.BNE_MAPPINGS_B is referenced by following:

BNE
VIEW - BNE_MAPPINGS_B#

[top of page]

Table: BNE_MAPPINGS_TL

Description: Translations for BNE_MAPPINGS_B
Primary Key: BNE_MAPPINGS_TL_PK
  1. APPLICATION_ID
  2. MAPPING_CODE
  3. LANGUAGE
Comments

BNE_MAPPINGS_TL stores the translated name of the mappings defined in BNE_MAPPINGS_B. You need one row for each mapping in each of the installed languages.

Indexes
Index Type Tablespace Column
BNE_MAPPINGS_TL_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
MAPPING_CODE
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
MAPPING_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y The language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
USER_NAME VARCHAR2 (240) Y User name for the mapping.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_MAPPINGS_TL does not reference any database object

BNE.BNE_MAPPINGS_TL is referenced by following:

BNE
VIEW - BNE_MAPPINGS_TL#

[top of page]

Table: BNE_MAPPING_LINES

Description: Definition of individual column mappings
Primary Key: BNE_MAPPING_LINES_PK
  1. APPLICATION_ID
  2. MAPPING_CODE
  3. SEQUENCE_NUM
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_MAPPING_LINES.APPLICATION_ID
BNE_MAPPING_LINES.MAPPING_CODE 		BNE_MAPPINGS_B
BNE_MAPPING_LINES.INTERFACE_APP_ID
BNE_MAPPING_LINES.INTERFACE_CODE
BNE_MAPPING_LINES.INTERFACE_SEQ_NUM 		BNE_INTERFACE_COLS_B
BNE_MAPPING_LINES.CONTENT_APP_ID
BNE_MAPPING_LINES.CONTENT_CODE
BNE_MAPPING_LINES.CONTENT_SEQ_NUM 		BNE_CONTENT_COLS_B
Comments

BNE_MAPPING_LINES stores the individual content column to interface column mapping.

Indexes
Index Type Tablespace Column
BNE_MAPPING_LINES_UK2 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
MAPPING_CODE
SEQUENCE_NUM
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
MAPPING_CODE VARCHAR2 (30) Y Code identifying this entity for the given APPLICATION_ID.
SEQUENCE_NUM NUMBER (15) Y sequence Number.
CONTENT_APP_ID NUMBER (15) Y Application id of content column being mapped.
CONTENT_CODE VARCHAR2 (30) Y Content code of content column being mapped.
CONTENT_SEQ_NUM NUMBER (15) Y Sequence number of content column being mapped.
INTERFACE_APP_ID NUMBER (15) Y Application id of interface column being mapped.
INTERFACE_CODE VARCHAR2 (30) Y Interface code of interface column being mapped.
INTERFACE_SEQ_NUM NUMBER (15) Y Sequence number of interface column being mapped.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
DECODE_FLAG VARCHAR2 (1)
Should the content column be decoded via the interface column 'TABLE' validation query.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_MAPPING_LINES does not reference any database object

BNE.BNE_MAPPING_LINES is referenced by following:

BNE
VIEW - BNE_MAPPING_LINES#

[top of page]

Table: BNE_MENUS_B

Description: Definition of Menus
Primary Key: BNE_MENUS_B_PK
  1. APPLICATION_ID
  2. MENU_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_MENUS_B.PARAM_LIST_APP_ID
BNE_MENUS_B.PARAM_LIST_CODE 		BNE_PARAM_LISTS_B
BNE_MENUS_B.PARENT_APP_ID
BNE_MENUS_B.PARENT_CODE 		BNE_MENUS_B
BNE_MENUS_B.INTEGRATOR_APP_ID
BNE_MENUS_B.INTEGRATOR_CODE 		BNE_INTEGRATORS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
BNE_MENUS_B.PARENT_APP_ID
BNE_MENUS_B.PARENT_CODE 		BNE_MENUS_B
Comments

BNE_MENUS_B stores the definition of a viewer menu.

Indexes
Index Type Tablespace Column
BNE_MENUS_B_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
MENU_CODE
ZD_EDITION_NAME
BNE_MENUS_B_N1 NONUNIQUE APPS_TS_TX_IDX PARENT_APP_ID
PARENT_CODE
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
MENU_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
PARENT_APP_ID NUMBER (15)
Menu parent code application identifier
PARENT_CODE VARCHAR2 (30)
Menu parent code identifier
SEQUENCE_NUM NUMBER (15)
Menu sequence/order number
INTEGRATOR_APP_ID NUMBER (15)
Integrator code application identifier foreign key
INTEGRATOR_CODE VARCHAR2 (30)
Intergator code foreign key
RESOLVER_CLASS VARCHAR2 (240)
Java class for the resolver
ACCESS_POINT VARCHAR2 (240)
Starting access point for menu.
PARAM_LIST_APP_ID NUMBER (15)
Param list code application identifier
PARAM_LIST_CODE VARCHAR2 (30)
Parameter list code foreign key
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_MENUS_B does not reference any database object

BNE.BNE_MENUS_B is referenced by following:

BNE
VIEW - BNE_MENUS_B#

[top of page]

Table: BNE_MENUS_TL

Description: Translations for BNE_MENUS_B
Primary Key: BNE_MENUS_TL_PK
  1. APPLICATION_ID
  2. MENU_CODE
  3. LANGUAGE
Comments

BNE_MENUS_TL stores the translated name of the viewers defined in BNE_MENUS_B. You need one row for each viewer in each of the installed languages.

Indexes
Index Type Tablespace Column
BNE_MENUS_TL_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
MENU_CODE
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
MENU_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y The language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
USER_NAME VARCHAR2 (240) Y User name for the viewer.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_MENUS_TL does not reference any database object

BNE.BNE_MENUS_TL is referenced by following:

BNE
VIEW - BNE_MENUS_TL#

[top of page]

Table: BNE_OBJECTS

Description: Base table for all objects in BNE
Primary Key: BNE_OBJECTS_PK
  1. APPLICATION_ID
  2. OBJECT_CODE
Comments

Base table for all objects in BNE

Indexes
Index Type Tablespace Column
BNE_OBJECTS_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
OBJECT_CODE
SYS_IL0000395316C00005$$ UNIQUE APPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
OBJECT_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
OBJECT_TYPE VARCHAR2 (30)
Object Type
OBJECT_DATA BLOB (4000)
Object Data
ORACLE_CHARSET VARCHAR2 (30)
Oracle Charset
TEXT_CHARSET VARCHAR2 (30)
Text Charset
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.

[top of page]

BNE.BNE_OBJECTS does not reference any database object

BNE.BNE_OBJECTS is referenced by following:

BNE
VIEW - BNE_OBJECTS#

[top of page]

Table: BNE_PARAM_DEFNS_B

Description: Definition of parameter UI metadata
Primary Key: BNE_PARAM_DEFNS_B_PK
  1. APPLICATION_ID
  2. PARAM_DEFN_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_PARAM_DEFNS_B.ATTRIBUTE_CODE
BNE_PARAM_DEFNS_B.ATTRIBUTE_APP_ID 		BNE_ATTRIBUTES
Foreign Keys to this table:
Foreign Key Column Foreign Table
BNE_PARAM_LIST_ITEMS.PARAM_DEFN_APP_ID
BNE_PARAM_LIST_ITEMS.PARAM_DEFN_CODE 		BNE_PARAM_DEFNS_B
BNE_PARAM_OVERRIDES.APPLICATION_ID
BNE_PARAM_OVERRIDES.PARAM_DEFN_CODE 		BNE_PARAM_DEFNS_B
Comments

BNE_PARAM_DEFNS_B stores information regarding the definition of a parameter. The definition is separated from the instance of the parameter in a paramter list (BNE_PARAM_LIST_ITEMS), so that this information can be reused between parameter instances. Each parameter definition may reference attributes (BNE_ATTRIBUTES_B) for generic storage of data.

Indexes
Index Type Tablespace Column
BNE_PARAM_DEFNS_B_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
PARAM_DEFN_CODE
ZD_EDITION_NAME
BNE_PARAM_DEFNS_B_N1 NONUNIQUE APPS_TS_TX_IDX VAL_TYPE
BNE_PARAM_DEFNS_B_N2 NONUNIQUE APPS_TS_TX_IDX ATTRIBUTE_APP_ID
ATTRIBUTE_CODE
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
PARAM_DEFN_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
PARAM_NAME VARCHAR2 (240) Y Name of the parameter.
PARAM_SOURCE VARCHAR2 (240) Y Source of the parameter.
PARAM_CATEGORY NUMBER (5) Y Category of the parameter. Valid values are: 1 - Miscellaneous, 2 - position, 3 - appearence, 4 - behavior, 5 - data, 6 - field.
DATATYPE NUMBER (1) Y Data type of the parameter, Valid values are: 1 - String, 2 - Number, 3 - Date, 4 - boolean.
ATTRIBUTE_APP_ID NUMBER (15)
Application id of any attributes.
ATTRIBUTE_CODE VARCHAR2 (30)
Attribute code of any attributes.
PARAM_RESOLVER VARCHAR2 (240)
Fully qualified java class name of a java class used to perform parameter pre-processing and validation.
DEFAULT_REQUIRED_FLAG VARCHAR2 (1) Y Required flag.
DEFAULT_VISIBLE_FLAG VARCHAR2 (1) Y Visible flag.
DEFAULT_USER_MODIFYABLE_FLAG VARCHAR2 (1) Y User modifyable flag.
DEFAULT_STRING VARCHAR2 (2000)
Default string value if DATATYPE = 1
DEFAULT_DATE DATE

Default date value if DATATYPE = 3
DEFAULT_NUMBER NUMBER

Default number value if DATATYPE = 2
DEFAULT_BOOLEAN_FLAG VARCHAR2 (1)
Default boolean value if DATATYPE = 4
DEFAULT_FORMULA VARCHAR2 (240)
Default formula.
VAL_TYPE VARCHAR2 (2) Y Validation type. Valid values are: 1 - None, 2 - Value set, 3 - Fnd Lookup.
VAL_VALUE VARCHAR2 (30)
Validation value. If VAL_TYPE = 2 - value set id, 3 - lookup code.
MAX_SIZE NUMBER (5) Y Maximum size for parameter.
DISPLAY_TYPE NUMBER (1) Y Display wigit type. Valid values are: 1 - check box, 2 - radio button, 3 - list box, 4 - text area, 5 - password box.
DISPLAY_STYLE NUMBER (1) Y Style of display. Valid values are: 1 - None, 2 - Vertical, 3 - Horizontal. These values are only relevant for some values of DISPLAY_TYPE.
DISPLAY_SIZE NUMBER (5) Y Size to display UI wigit.
HELP_URL VARCHAR2 (240)
URL used to link to help.
FORMAT_MASK VARCHAR2 (240)
Format mask for restricting user input. Only valid for some DISPLAY_TYPE and DATATYPE values.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
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).
OA_FLEX_APPLICATION_ID NUMBER (15)
OA Flex application idenfier code
OA_FLEX_CODE VARCHAR2 (30)
OA Flex code identifier
OA_FLEX_NUM VARCHAR2 (2000)
OA Flex code number identifier
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_PARAM_DEFNS_B does not reference any database object

BNE.BNE_PARAM_DEFNS_B is referenced by following:

BNE
VIEW - BNE_PARAM_DEFNS_B#

[top of page]

Table: BNE_PARAM_DEFNS_TL

Description: Translations for BNE_PARAM_DEFNS_B
Primary Key: BNE_PARAM_DEFNS_TL_PK
  1. APPLICATION_ID
  2. PARAM_DEFN_CODE
  3. LANGUAGE
Comments

BNE_PARAM_DEFNS_TL stores the translated default value and prompts of the parameter definitions defined in BNE_PARAM_DEFNS_B. You need one row for each parameter definition in each of the installed languages.

Indexes
Index Type Tablespace Column
BNE_PARAM_DEFNS_TL_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
PARAM_DEFN_CODE
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
PARAM_DEFN_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y The language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
USER_NAME VARCHAR2 (240) Y User Name.
DEFAULT_STRING VARCHAR2 (2000)
Default translatable string value if BNE_PARAM_DEFN_B.DATATYPE = 1
DEFAULT_DESC VARCHAR2 (240)
default description for parameter value.
PROMPT_LEFT VARCHAR2 (240)
Prompt left.
PROMPT_ABOVE VARCHAR2 (240)
Prompt above.
USER_TIP VARCHAR2 (2000)
User tip.
ACCESS_KEY VARCHAR2 (30)
Access key.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
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).
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_PARAM_DEFNS_TL does not reference any database object

BNE.BNE_PARAM_DEFNS_TL is referenced by following:

BNE
VIEW - BNE_PARAM_DEFNS_TL#

[top of page]

Table: BNE_PARAM_GROUPS_B

Description: Definition of a group of parameters in a group
Primary Key: BNE_PARAM_GROUPS_B_PK
  1. PARAM_LIST_CODE
  2. APPLICATION_ID
  3. SEQUENCE_NUM
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_PARAM_GROUPS_B.ATTRIBUTE_CODE
BNE_PARAM_GROUPS_B.ATTRIBUTE_APP_ID 		BNE_ATTRIBUTES
BNE_PARAM_GROUPS_B.APPLICATION_ID
BNE_PARAM_GROUPS_B.PARAM_LIST_CODE 		BNE_PARAM_LISTS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
BNE_PARAM_GROUP_ITEMS.APPLICATION_ID
BNE_PARAM_GROUP_ITEMS.PARAM_LIST_CODE
BNE_PARAM_GROUP_ITEMS.GROUP_SEQ_NUM 		BNE_PARAM_GROUPS_B
Comments

BNE_PARAM_GROUPS_B stores the definition of a parameter group. A parameter group is an ordered collection of parameters from within a list. Each parameter list may reference attributes (BNE_ATTRIBUTES_B) for generic storage of data.

Indexes
Index Type Tablespace Column
BNE_PARAM_GROUPS_B_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
PARAM_LIST_CODE
SEQUENCE_NUM
ZD_EDITION_NAME
BNE_PARAM_GROUPS_N1 NONUNIQUE APPS_TS_TX_IDX ATTRIBUTE_APP_ID
ATTRIBUTE_CODE
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
PARAM_LIST_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
SEQUENCE_NUM NUMBER (15) Y Ordinal number of this group for the parameter list
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
ATTRIBUTE_APP_ID NUMBER (15)
Application Id of any attributes.
ATTRIBUTE_CODE VARCHAR2 (30)
Attribute code of any attributes.
GROUP_RESOLVER VARCHAR2 (240)
Fully qualified java class name of a java class used to perform parameter group pre-processing and validation.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
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).
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_PARAM_GROUPS_B does not reference any database object

BNE.BNE_PARAM_GROUPS_B is referenced by following:

BNE
VIEW - BNE_PARAM_GROUPS_B#

[top of page]

Table: BNE_PARAM_GROUPS_TL

Description: Translations for BNE_PARAM_LISTS_B
Primary Key: BNE_PARAM_GROUPS_TL_PK
  1. APPLICATION_ID
  2. PARAM_LIST_CODE
  3. SEQUENCE_NUM
  4. LANGUAGE
Comments

BNE_PARAM_LISTS_TL stores the translated name and prompts of the parameter lists defined in BNE_PARAM_LISTS_B. You need one row for each parameter list in each of the installed languages.

Indexes
Index Type Tablespace Column
BNE_PARAM_GROUPS_TL_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
PARAM_LIST_CODE
SEQUENCE_NUM
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
PARAM_LIST_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
SEQUENCE_NUM NUMBER (15) Y Sequence numbers for the parameter groups identifier
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y The language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
USER_NAME VARCHAR2 (240) Y User name for the parameter group.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
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).
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_PARAM_GROUPS_TL does not reference any database object

BNE.BNE_PARAM_GROUPS_TL is referenced by following:

BNE
VIEW - BNE_PARAM_GROUPS_TL#

[top of page]

Table: BNE_PARAM_GROUP_ITEMS

Description: Definition of the individual parameter items in a parameter list
Primary Key: BNE_PARAM_GROUP_ITEMS_PK
  1. APPLICATION_ID
  2. PARAM_LIST_CODE
  3. GROUP_SEQ_NUM
  4. SEQUENCE_NUM
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_PARAM_GROUP_ITEMS.APPLICATION_ID
BNE_PARAM_GROUP_ITEMS.PARAM_LIST_CODE
BNE_PARAM_GROUP_ITEMS.GROUP_SEQ_NUM 		BNE_PARAM_GROUPS_B
BNE_PARAM_GROUP_ITEMS.APPLICATION_ID
BNE_PARAM_GROUP_ITEMS.PARAM_LIST_CODE
BNE_PARAM_GROUP_ITEMS.PARAM_SEQ_NUM 		BNE_PARAM_LIST_ITEMS
Comments

BNE_PARAM_LIST_ITEMS stores the ordered collection of parameters in a parameter list. Each parameter may reference a parameter definition (BNE_PARAM_DEFN_B) as well as attributes (BNE_ATTRIBUTES_B) for generic storage of data.

Indexes
Index Type Tablespace Column
BNE_PARAM_GROUP_ITEMS_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
PARAM_LIST_CODE
GROUP_SEQ_NUM
SEQUENCE_NUM
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
PARAM_LIST_CODE VARCHAR2 (30) Y Code identifying this entity for the given APPLICATION_ID.
GROUP_SEQ_NUM NUMBER (15) Y Group Sequence Number
SEQUENCE_NUM NUMBER (15) Y Sequenc number of the parameter in the parameter group.
PARAM_SEQ_NUM NUMBER (15) Y Parameter sequence number
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
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).
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_PARAM_GROUP_ITEMS does not reference any database object

BNE.BNE_PARAM_GROUP_ITEMS is referenced by following:

BNE
VIEW - BNE_PARAM_GROUP_ITEMS#

[top of page]

Table: BNE_PARAM_LISTS_B

Description: Definition of a list of parameters
Primary Key: BNE_PARAM_LISTS_B_PK
  1. APPLICATION_ID
  2. PARAM_LIST_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_PARAM_LISTS_B.ATTRIBUTE_CODE
BNE_PARAM_LISTS_B.ATTRIBUTE_APP_ID 		BNE_ATTRIBUTES
Foreign Keys to this table:
Foreign Key Column Foreign Table
BNE_COMPONENTS_B.PARAM_LIST_APP_ID
BNE_COMPONENTS_B.PARAM_LIST_CODE 		BNE_PARAM_LISTS_B
BNE_CONTENTS_B.PARAM_LIST_APP_ID
BNE_CONTENTS_B.PARAM_LIST_CODE 		BNE_PARAM_LISTS_B
BNE_IMPORT_PROGRAMS.IMPORT_PARAM_LIST_APP_ID
BNE_IMPORT_PROGRAMS.IMPORT_PARAM_LIST_CODE 		BNE_PARAM_LISTS_B
BNE_INTEGRATORS_B.IMPORT_PARAM_LIST_APP_ID
BNE_INTEGRATORS_B.IMPORT_PARAM_LIST_CODE 		BNE_PARAM_LISTS_B
BNE_INTEGRATORS_B.UPLOAD_PARAM_LIST_APP_ID
BNE_INTEGRATORS_B.UPLOAD_PARAM_LIST_CODE 		BNE_PARAM_LISTS_B
BNE_INTEGRATORS_B.UPLOAD_SERV_PARAM_LIST_APP_ID
BNE_INTEGRATORS_B.UPLOAD_SERV_PARAM_LIST_CODE 		BNE_PARAM_LISTS_B
BNE_INTEGRATORS_B.CREATE_DOC_LIST_APP_ID
BNE_INTEGRATORS_B.CREATE_DOC_LIST_CODE 		BNE_PARAM_LISTS_B
BNE_INTERFACES_B.UPLOAD_PARAM_LIST_APP_ID
BNE_INTERFACES_B.UPLOAD_PARAM_LIST_CODE 		BNE_PARAM_LISTS_B
BNE_LAYOUTS_B.CREATE_DOC_LIST_APP_ID
BNE_LAYOUTS_B.CREATE_DOC_LIST_CODE 		BNE_PARAM_LISTS_B
BNE_MENUS_B.PARAM_LIST_APP_ID
BNE_MENUS_B.PARAM_LIST_CODE 		BNE_PARAM_LISTS_B
BNE_PARAM_GROUPS_B.APPLICATION_ID
BNE_PARAM_GROUPS_B.PARAM_LIST_CODE 		BNE_PARAM_LISTS_B
BNE_PARAM_LIST_ITEMS.APPLICATION_ID
BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE 		BNE_PARAM_LISTS_B
BNE_VIEWERS_B.PARAM_LIST_APP_ID
BNE_VIEWERS_B.PARAM_LIST_CODE 		BNE_PARAM_LISTS_B
BNE_VIEWERS_B.CREATE_DOC_LIST_APP_ID
BNE_VIEWERS_B.CREATE_DOC_LIST_CODE 		BNE_PARAM_LISTS_B
Comments

BNE_PARAM_LISTS_B stores the definition of a parameter list. A parameter list is an ordered collection of parameters that may be used to store the required values needed to run some code. For example, the content components require a parameter list (BNE_CONTENTS.PARAM_LIST_APP_ID, BNE_CONTENTS.PARAM_LIST_CODE) to define the parameters they need to run. Parameter lists are also used by components (BNE_COMPONENTS_B), viewers (BNE_VIEWERS_B) and the upload and import process. Each parameter list may reference attributes (BNE_ATTRIBUTES_B) for generic storage of data.

Indexes
Index Type Tablespace Column
BNE_PARAM_LISTS_B_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
PARAM_LIST_CODE
ZD_EDITION_NAME
BNE_PARAM_LISTS_B_N1 NONUNIQUE APPS_TS_TX_IDX ATTRIBUTE_APP_ID
ATTRIBUTE_CODE
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
PARAM_LIST_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
PERSISTENT_FLAG VARCHAR2 (1) Y Is the parameter list to be persistent (Y/N). Persistent list should not be deleted. non-persistent lists may be deleted after a list has been passed from a client to a server (to ensure the list is cleaned up).
COMMENTS VARCHAR2 (240)
Any developer defined comments about this parameter list.
ATTRIBUTE_APP_ID NUMBER (15)
Application Id of any attributes.
ATTRIBUTE_CODE VARCHAR2 (30)
Attribute code of any attributes.
LIST_RESOLVER VARCHAR2 (240)
Fully qualified java class name of a java class used to perform parameter list pre-processing and validation.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
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).
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_PARAM_LISTS_B does not reference any database object

BNE.BNE_PARAM_LISTS_B is referenced by following:

BNE
VIEW - BNE_PARAM_LISTS_B#

[top of page]

Table: BNE_PARAM_LISTS_TL

Description: Translations for BNE_PARAM_LISTS_B
Primary Key: BNE_PARAM_LISTS_TL_PK
  1. APPLICATION_ID
  2. PARAM_LIST_CODE
  3. LANGUAGE
Comments

BNE_PARAM_LISTS_TL stores the translated name and prompts of the parameter lists defined in BNE_PARAM_LISTS_B. You need one row for each parameter list in each of the installed languages.

Indexes
Index Type Tablespace Column
BNE_PARAM_LISTS_TL_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
PARAM_LIST_CODE
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
PARAM_LIST_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y The language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
USER_NAME VARCHAR2 (240) Y User name for the parameter list.
USER_TIP VARCHAR2 (2000)
Tip text used when displaying the parameter list in UI.
PROMPT_LEFT VARCHAR2 (240)
Left prompt used when displaying the parameter list in UI.
PROMPT_ABOVE VARCHAR2 (240)
Above prompt used when displaying the parameter list in UI.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
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).
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_PARAM_LISTS_TL does not reference any database object

BNE.BNE_PARAM_LISTS_TL is referenced by following:

BNE
VIEW - BNE_PARAM_LISTS_TL#

[top of page]

Table: BNE_PARAM_LIST_ITEMS

Description: Definition of the individual parameter items in a parameter list
Primary Key: BNE_PARAM_LIST_ITEMS_PK
  1. APPLICATION_ID
  2. PARAM_LIST_CODE
  3. SEQUENCE_NUM
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_PARAM_LIST_ITEMS.PARAM_DEFN_APP_ID
BNE_PARAM_LIST_ITEMS.PARAM_DEFN_CODE 		BNE_PARAM_DEFNS_B
BNE_PARAM_LIST_ITEMS.ATTRIBUTE_CODE
BNE_PARAM_LIST_ITEMS.ATTRIBUTE_APP_ID 		BNE_ATTRIBUTES
BNE_PARAM_LIST_ITEMS.APPLICATION_ID
BNE_PARAM_LIST_ITEMS.PARAM_LIST_CODE 		BNE_PARAM_LISTS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
BNE_PARAM_GROUP_ITEMS.APPLICATION_ID
BNE_PARAM_GROUP_ITEMS.PARAM_LIST_CODE
BNE_PARAM_GROUP_ITEMS.PARAM_SEQ_NUM 		BNE_PARAM_LIST_ITEMS
Comments

BNE_PARAM_LIST_ITEMS stores the ordered collection of parameters in a parameter list. Each parameter may reference a parameter definition (BNE_PARAM_DEFN_B) as well as attributes (BNE_ATTRIBUTES_B) for generic storage of data.

Indexes
Index Type Tablespace Column
BNE_PARAM_LIST_ITEMS_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
PARAM_LIST_CODE
SEQUENCE_NUM
ZD_EDITION_NAME
BNE_PARAM_LIST_ITEMS_N1 NONUNIQUE APPS_TS_TX_IDX PARAM_DEFN_APP_ID
PARAM_DEFN_CODE
BNE_PARAM_LIST_ITEMS_N2 NONUNIQUE APPS_TS_TX_IDX ATTRIBUTE_APP_ID
ATTRIBUTE_CODE
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
PARAM_LIST_CODE VARCHAR2 (30) Y Code identifying this entity for the given APPLICATION_ID.
SEQUENCE_NUM NUMBER (15) Y Sequenc number of the parameter in the parameter list.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
PARAM_DEFN_APP_ID NUMBER (15)
Application Id of the parameter definition linked to this parameter.
PARAM_DEFN_CODE VARCHAR2 (30)
Parameter definition code of the parameter definition linked to this parameter.
PARAM_NAME VARCHAR2 (240)
Name of the parameter. Will over-ride any name in the parameter definition. A name must be supplied here, or in the parameter definition.
ATTRIBUTE_APP_ID NUMBER (15)
Application Id of any attributes.
ATTRIBUTE_CODE VARCHAR2 (30)
Attribute code of any attributes.
STRING_VALUE VARCHAR2 (2000)
String value if parameter is a String.
DATE_VALUE DATE

Date value if parameter is a date.
NUMBER_VALUE NUMBER

Number value if parameter is a number.
BOOLEAN_VALUE_FLAG VARCHAR2 (1)
Boolean value if parameter is a boolean.
FORMULA_VALUE VARCHAR2 (240)
Formula to use to generate parameter value. May include token values.
DESC_VALUE VARCHAR2 (240)
Description of parameter value.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
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).
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_PARAM_LIST_ITEMS does not reference any database object

BNE.BNE_PARAM_LIST_ITEMS is referenced by following:

BNE
VIEW - BNE_PARAM_LIST_ITEMS#

[top of page]

Table: BNE_PARAM_OVERRIDES

Description: Definition of over-ridden parameter definition values
Primary Key: BNE_PARAM_OVERRIDES_PK
  1. APPLICATION_ID
  2. PARAM_DEFN_CODE
  3. LVL
  4. OVERRIDE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_PARAM_OVERRIDES.APPLICATION_ID
BNE_PARAM_OVERRIDES.PARAM_DEFN_CODE 		BNE_PARAM_DEFNS_B
Comments

BNE_PARAM_OVERRIDES stores the definition of values in a parameter definition that may be over-ridden at a user/responsibility/application/site level. The values that may be over-ridden are the required, visible and User Modifyable flags, the default value/description and default formula.

Indexes
Index Type Tablespace Column
BNE_PARAM_OVERRIDES_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
PARAM_DEFN_CODE
LVL
OVERRIDE_ID
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
PARAM_DEFN_CODE VARCHAR2 (30) Y Code identifying this entity for the given APPLICATION_ID.
LVL NUMBER (1) Y Level of over-ride. Valid values are: 1 - Site, 2 - Application, 3 - Responsibility, 4 - user.
OVERRIDE_ID NUMBER (15) Y Id of over-ride. Valid values for LVL: 1 - null, 2 - Application Id, 3 - Responsibility Id, 4 - User id.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
REQUIRED_FLAG VARCHAR2 (1)
Over-ridden required flag, if it is to be over-ridden.
VISIBLE_FLAG VARCHAR2 (1)
Over-ridden visible flag, if it is to be over-ridden.
USER_MODIFYABLE_FLAG VARCHAR2 (1)
Over-ridden user modifyable flag, if it is to be over-ridden.
DEFAULT_STRING VARCHAR2 (2000)
Over-ridden default string, if it is to be over-ridden and parameter definition data type is String.
DEFAULT_DATE DATE

Over-ridden default date, if it is to be over-ridden and parameter definition data type is Date.
DEFAULT_NUMBER NUMBER

Over-ridden default number, if it is to be over-ridden and parameter definition data type is Number.
DEFAULT_BOOLEAN_FLAG VARCHAR2 (1)
Over-ridden default boolean, if it is to be over-ridden and parameter definition data type is Boolean.
DEFAULT_FORMULA VARCHAR2 (240)
Over-ridden default formula, if it is to be over-ridden.
DESC_VALUE VARCHAR2 (240)
Over-ridden description. This must be set if a defult value is set.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Y Standard Who column - date when a user last updated this row.
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).
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_PARAM_OVERRIDES does not reference any database object

BNE.BNE_PARAM_OVERRIDES is referenced by following:

BNE
VIEW - BNE_PARAM_OVERRIDES#

[top of page]

Table: BNE_PERF_SETS_B

Description: Definition of a set of performance statistics.
Primary Key: BNE_PERF_SETS_B_PK
  1. SET_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
BNE_PERF_SET_ITEMS.SET_CODE BNE_PERF_SETS_B
Comments

Definition of a set of performance statistics.

Indexes
Index Type Tablespace Column
BNE_PERF_SETS_B_UK1 UNIQUE APPS_TS_TX_IDX SET_CODE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
SET_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
ENABLED_FLAG VARCHAR2 (1) Y SQL Query text. May contain tokens.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_PERF_SETS_B does not reference any database object

BNE.BNE_PERF_SETS_B is referenced by following:

BNE
VIEW - BNE_PERF_SETS_B#

[top of page]

Table: BNE_PERF_SETS_TL

Description: Definition of a set of performance statistics.
Primary Key: BNE_PERF_SETS_TL_PK
  1. SET_CODE
  2. LANGUAGE
Comments

Definition of a set of performance statistics.

Indexes
Index Type Tablespace Column
BNE_PERF_SETS_TL_UK1 UNIQUE APPS_TS_TX_IDX SET_CODE
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
SET_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y The language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
USER_NAME VARCHAR2 (240) Y SQL Query text. May contain tokens.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_PERF_SETS_TL does not reference any database object

BNE.BNE_PERF_SETS_TL is referenced by following:

BNE
VIEW - BNE_PERF_SETS_TL#

[top of page]

Table: BNE_PERF_SET_ITEMS

Description: All Statistics in a performance set.
Primary Key: BNE_PERF_SET_ITEMS_PK
  1. SET_CODE
  2. STATISTIC_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_PERF_SET_ITEMS.SET_CODE BNE_PERF_SETS_B
BNE_PERF_SET_ITEMS.STATISTIC_CODE BNE_PERF_STATISTICS_B
Comments

All Statistics in a performance set. This is an unorded "set" of statistics.

Indexes
Index Type Tablespace Column
BNE_PERF_SET_ITEMS_UK1 UNIQUE APPS_TS_TX_IDX SET_CODE
STATISTIC_CODE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
SET_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
STATISTIC_CODE VARCHAR2 (30) Y Performance statistic code
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_PERF_SET_ITEMS does not reference any database object

BNE.BNE_PERF_SET_ITEMS is referenced by following:

BNE
VIEW - BNE_PERF_SET_ITEMS#

[top of page]

Table: BNE_PERF_STATISTICS_B

Description: Definition of a performance statistic.
Primary Key: BNE_PERF_STATISTICS_B_PK
  1. STATISTIC_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
BNE_PERF_SET_ITEMS.STATISTIC_CODE BNE_PERF_STATISTICS_B
BNE_PERF_STATISTICS_H.STATISTIC_CODE BNE_PERF_STATISTICS_B
Comments

Definition of a performance statistic.

Indexes
Index Type Tablespace Column
BNE_PERF_STATISTICS_B_UK1 UNIQUE APPS_TS_TX_IDX STATISTIC_CODE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
STATISTIC_CODE VARCHAR2 (30) Y Unique code identifying this entity.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_PERF_STATISTICS_B does not reference any database object

BNE.BNE_PERF_STATISTICS_B is referenced by following:

BNE
VIEW - BNE_PERF_STATISTICS_B#

[top of page]

Table: BNE_PERF_STATISTICS_H

Description: History of performance statistic measurements.
Primary Key: BNE_PERF_STATISTICS_H_PK
  1. SEQUENCE_NUM
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_PERF_STATISTICS_H.STATISTIC_CODE BNE_PERF_STATISTICS_B
Comments

History of performance statistic measurements.

Indexes
Index Type Tablespace Column
BNE_PERF_STATISTICS_H_UK1 UNIQUE APPS_TS_TX_IDX SEQUENCE_NUM
BNE_PERF_STATISTICS_H_N1 NONUNIQUE APPS_TS_TX_IDX CREATED_BY
STAT_START_DATE
BNE_PERF_STATISTICS_H_N2 NONUNIQUE APPS_TS_TX_IDX STAT_START_DATE
Columns
Name Datatype Length Mandatory Comments
SEQUENCE_NUM NUMBER (15) Y Unique sequence number
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
STATISTIC_CODE VARCHAR2 (30) Y Unique code identifying this entity.
STAT_ATTRIBUTE_1 VARCHAR2 (2000)
Runtime attribute of statistic.
STAT_ATTRIBUTE_2 VARCHAR2 (2000)
Runtime attribute of statistic.
STAT_ATTRIBUTE_3 VARCHAR2 (2000)
Runtime attribute of statistic.
STAT_ATTRIBUTE_4 VARCHAR2 (2000)
Runtime attribute of statistic.
STAT_ATTRIBUTE_5 VARCHAR2 (2000)
Runtime attribute of statistic.
STAT_ATTRIBUTE_6 VARCHAR2 (2000)
Runtime attribute of statistic.
STAT_ATTRIBUTE_7 VARCHAR2 (2000)
Runtime attribute of statistic.
STAT_ATTRIBUTE_8 VARCHAR2 (2000)
Runtime attribute of statistic.
STAT_ATTRIBUTE_9 VARCHAR2 (2000)
Runtime attribute of statistic.
STAT_ATTRIBUTE_10 VARCHAR2 (2000)
Runtime attribute of statistic.
STAT_START_DATE DATE
Y The Date/time of the first call of this statistic.
STAT_DURATION NUMBER (15) Y The total time span of this statistic in milliseconds.
STAT_CALL_COUNT NUMBER (15) Y The number of times that this statistic has been triggered. For a validator, expect it to be once per upload row.
STAT_CALL_DURATION NUMBER (15) Y Total time spent in this statistic in milliseconds. This number divided by the STAT_CALL_COUNT will be the average statistic time (single shot time).
SESSION_ID NUMBER (15) Y Session of user being measured.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.

[top of page]

BNE.BNE_PERF_STATISTICS_H does not reference any database object

BNE.BNE_PERF_STATISTICS_H is referenced by following:

BNE
VIEW - BNE_PERF_STATISTICS_H#

[top of page]

Table: BNE_PERF_STATISTICS_TL

Description: Definition of a performance statistic.
Primary Key: BNE_PERF_STATISTICS_TL_PK
  1. STATISTIC_CODE
  2. LANGUAGE
Comments

Definition of a performance statistic.

Indexes
Index Type Tablespace Column
BNE_PERF_STATISTICS_TL_UK1 UNIQUE APPS_TS_TX_IDX STATISTIC_CODE
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
STATISTIC_CODE VARCHAR2 (30) Y Unique code identifying this entity.
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y The language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
USER_NAME VARCHAR2 (240) Y SQL Query text. May contain tokens.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_PERF_STATISTICS_TL does not reference any database object

BNE.BNE_PERF_STATISTICS_TL is referenced by following:

BNE
VIEW - BNE_PERF_STATISTICS_TL#

[top of page]

Table: BNE_QUERIES_B

Description: Definition of Metadata defined queries
Primary Key: BNE_QUERIES_B_PK
  1. APPLICATION_ID
  2. QUERY_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_QUERIES_B.DIRECTIVE_APP_ID
BNE_QUERIES_B.DIRECTIVE_CODE 		BNE_CACHE_DIRECTIVES_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
BNE_INTERFACE_COLS_B.VAL_QUERY_APP_ID
BNE_INTERFACE_COLS_B.VAL_QUERY_CODE 		BNE_QUERIES_B
BNE_INTERFACE_COLS_B.EXPANDED_SQL_QUERY_APP_ID
BNE_INTERFACE_COLS_B.EXPANDED_SQL_QUERY_CODE 		BNE_QUERIES_B
BNE_RAW_QUERY.APPLICATION_ID
BNE_RAW_QUERY.QUERY_CODE 		BNE_QUERIES_B
BNE_SIMPLE_QUERY.APPLICATION_ID
BNE_SIMPLE_QUERY.QUERY_CODE 		BNE_QUERIES_B
BNE_STORED_SQL.QUERY_APP_ID
BNE_STORED_SQL.QUERY_CODE 		BNE_QUERIES_B
Comments

BNE_QUERIES_B stores the definition of a query. Each query is uniquely identified by it's APPLICATION_ID and QUERY_CODE, and requires the definition of a java class which will run to generate the query.

Indexes
Index Type Tablespace Column
BNE_QUERIES_B_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
QUERY_CODE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
QUERY_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
QUERY_CLASS VARCHAR2 (240) Y Java class name that is used to run the viewer.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
DIRECTIVE_APP_ID NUMBER (15)
Directive identifier application
DIRECTIVE_CODE VARCHAR2 (30)
Directive identifier code
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_QUERIES_B does not reference any database object

BNE.BNE_QUERIES_B is referenced by following:

BNE
VIEW - BNE_QUERIES_B#

[top of page]

Table: BNE_QUERIES_TL

Description: Translations for BNE_QUERIES_B
Primary Key: BNE_QUERIES_TL_PK
  1. APPLICATION_ID
  2. QUERY_CODE
  3. LANGUAGE
Comments

BNE_QUERIES_TL stores the translated name of the viewers defined in BNE_QUERIES_B. You need one row for each viewer in each of the installed languages.

Indexes
Index Type Tablespace Column
BNE_QUERIES_TL_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
QUERY_CODE
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
QUERY_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y The language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
USER_NAME VARCHAR2 (240) Y User name for the viewer.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_QUERIES_TL does not reference any database object

BNE.BNE_QUERIES_TL is referenced by following:

BNE
VIEW - BNE_QUERIES_TL#

[top of page]

Table: BNE_RAW_QUERY

Description: Definition of Metadata defined queries
Primary Key: BNE_RAW_QUERY_PK
  1. APPLICATION_ID
  2. QUERY_CODE
  3. SEQUENCE_NUM
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_RAW_QUERY.APPLICATION_ID
BNE_RAW_QUERY.QUERY_CODE 		BNE_QUERIES_B
Comments

BNE_SIMPLE_QUERY stores the definition of a query. Each query is uniquely identified by it's APPLICATION_ID and QUERY_CODE, and requires the definition of a java class which will run to generate the query.

Indexes
Index Type Tablespace Column
BNE_RAW_QUERY_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
QUERY_CODE
SEQUENCE_NUM
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
QUERY_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
SEQUENCE_NUM NUMBER (15) Y Sequence number
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
QUERY VARCHAR2 (2000) Y is column alias
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_RAW_QUERY does not reference any database object

BNE.BNE_RAW_QUERY is referenced by following:

BNE
VIEW - BNE_RAW_QUERY#

[top of page]

Table: BNE_SECURED_OBJECTS

Description: A secured object in the BNE repository.
Primary Key: BNE_SECURED_OBJECTS_PK
  1. APPLICATION_ID
  2. OBJECT_CODE
  3. OBJECT_TYPE
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_SECURED_OBJECTS.SECURITY_RULE_APP_ID
BNE_SECURED_OBJECTS.SECURITY_RULE_CODE 		BNE_SECURITY_RULES
Comments

A secured object in the BNE repository.

Indexes
Index Type Tablespace Column
BNE_SECURED_OBJECTS_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
OBJECT_CODE
OBJECT_TYPE
ZD_EDITION_NAME
BNE_SECURED_OBJECTS_N1 NONUNIQUE APPS_TS_TX_IDX SECURITY_RULE_APP_ID
SECURITY_RULE_CODE
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
OBJECT_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
OBJECT_TYPE VARCHAR2 (30) Y Type of Object being secured.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
SECURITY_RULE_APP_ID NUMBER (15) Y FK to BNE_SECURITY_RULES
SECURITY_RULE_CODE VARCHAR2 (30) Y FK to BNE_SECURITY_RULES
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_SECURED_OBJECTS does not reference any database object

BNE.BNE_SECURED_OBJECTS is referenced by following:

BNE
VIEW - BNE_SECURED_OBJECTS#

[top of page]

Table: BNE_SECURITY_RULES

Description: Definition of a security rule
Primary Key: BNE_SECURITY_RULES_PK
  1. APPLICATION_ID
  2. SECURITY_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
BNE_SECURED_OBJECTS.SECURITY_RULE_APP_ID
BNE_SECURED_OBJECTS.SECURITY_RULE_CODE 		BNE_SECURITY_RULES
Comments

This table stores the definition of a security rule.

Indexes
Index Type Tablespace Column
BNE_SECURITY_RULES_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
SECURITY_CODE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
SECURITY_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
SECURITY_TYPE VARCHAR2 (30) Y Security rule type
SECURITY_VALUE VARCHAR2 (2000) Y Security value, dependent on SECURITY_TYPE.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_SECURITY_RULES does not reference any database object

BNE.BNE_SECURITY_RULES is referenced by following:

BNE
VIEW - BNE_SECURITY_RULES#

[top of page]

Table: BNE_SIMPLE_QUERY

Description: Definition of Metadata defined queries
Primary Key: BNE_SIMPLE_QUERY_PK
  1. APPLICATION_ID
  2. QUERY_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_SIMPLE_QUERY.APPLICATION_ID
BNE_SIMPLE_QUERY.QUERY_CODE 		BNE_QUERIES_B
Comments

BNE_SIMPLE_QUERY stores the definition of a query. Each query is uniquely identified by it's APPLICATION_ID and QUERY_CODE, and requires the definition of a java class which will run to generate the query.

Indexes
Index Type Tablespace Column
BNE_SIMPLE_QUERY_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
QUERY_CODE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
QUERY_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
ID_COL VARCHAR2 (2000) Y id column name
ID_COL_ALIAS VARCHAR2 (2000) Y is column alias
MEANING_COL VARCHAR2 (2000) Y meaning column name
MEANING_COL_ALIAS VARCHAR2 (2000) Y meaning column alias
DESCRIPTION_COL VARCHAR2 (2000)
description of column
DESCRIPTION_COL_ALIAS VARCHAR2 (2000)
alias for the column description
ADDITIONAL_COLS VARCHAR2 (2000)
additional columns
OBJECT_NAME VARCHAR2 (2000) Y additional columns for select clause
ADDITIONAL_WHERE_CLAUSE VARCHAR2 (2000)
additional where clause
ORDER_BY_CLAUSE VARCHAR2 (2000)
query order by clause
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_SIMPLE_QUERY does not reference any database object

BNE.BNE_SIMPLE_QUERY is referenced by following:

BNE
VIEW - BNE_SIMPLE_QUERY#

[top of page]

Table: BNE_STORED_SQL

Description: Definition of SQL statements for the Stored SQL Content
Primary Key: BNE_STORED_SQL_PK
  1. CONTENT_CODE
  2. APPLICATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_STORED_SQL.APPLICATION_ID
BNE_STORED_SQL.CONTENT_CODE 		BNE_CONTENTS_B
BNE_STORED_SQL.QUERY_APP_ID
BNE_STORED_SQL.QUERY_CODE 		BNE_QUERIES_B
Comments

BNE_STORED_SQL stores a SQL query used by the Stored SQL content component.

Indexes
Index Type Tablespace Column
BNE_STORED_SQL_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
CONTENT_CODE
ZD_EDITION_NAME
BNE_STORED_SQL_N1 NONUNIQUE APPS_TS_TX_IDX QUERY_APP_ID
QUERY_CODE
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
CONTENT_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
QUERY VARCHAR2 (2000)
SQL Query text. May contain tokens.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
QUERY_APP_ID NUMBER (15)
Foreign key link to query table
QUERY_CODE VARCHAR2 (30)
Foreign key link query table
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_STORED_SQL does not reference any database object

BNE.BNE_STORED_SQL is referenced by following:

BNE
VIEW - BNE_STORED_SQL#

[top of page]

Table: BNE_STYLES

Description: Definition of a named Stylesheet Style
Primary Key: BNE_STYLES_PK
  1. APPLICATION_ID
  2. STYLE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_STYLES.STYLESHEET_CODE
BNE_STYLES.STYLESHEET_APP_ID 		BNE_STYLESHEETS_B
BNE_STYLES.PARENT_STYLE_APP_ID
BNE_STYLES.PARENT_STYLE_CODE 		BNE_STYLES
Foreign Keys to this table:
Foreign Key Column Foreign Table
BNE_STYLES.PARENT_STYLE_APP_ID
BNE_STYLES.PARENT_STYLE_CODE 		BNE_STYLES
BNE_STYLE_PROPERTIES.APPLICATION_ID
BNE_STYLE_PROPERTIES.STYLE_CODE 		BNE_STYLES
Comments

BNE_STYLES stored the definition of named style values within a style sheet.

Indexes
Index Type Tablespace Column
BNE_STYLES_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
STYLE_CODE
ZD_EDITION_NAME
BNE_STYLES_UK2 NONUNIQUE APPS_TS_TX_IDX STYLESHEET_APP_ID
STYLESHEET_CODE
STYLE_CLASS
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
STYLE_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
STYLESHEET_APP_ID NUMBER (15) Y Application Id of style sheet this style is for.
STYLESHEET_CODE VARCHAR2 (30) Y Stylesheet code style sheet this style is for.
PARENT_STYLE_APP_ID NUMBER (15)
Parent Style Application Id. If this style forms a part of a heirarchy, this specifies the parent.
PARENT_STYLE_CODE VARCHAR2 (30)
Parent Style Code. If this style forms a part of a heirarchy, this specifies the parent.
STYLE_CLASS VARCHAR2 (50) Y Name of style class.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_STYLES does not reference any database object

BNE.BNE_STYLES is referenced by following:

BNE
VIEW - BNE_STYLES#

[top of page]

Table: BNE_STYLESHEETS_B

Description: Definition of a collection of Styles
Primary Key: BNE_STYLESHEETS_B_PK
  1. APPLICATION_ID
  2. STYLESHEET_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
BNE_LAYOUTS_B.STYLESHEET_CODE
BNE_LAYOUTS_B.STYLESHEET_APP_ID 		BNE_STYLESHEETS_B
BNE_STYLES.STYLESHEET_CODE
BNE_STYLES.STYLESHEET_APP_ID 		BNE_STYLESHEETS_B
Comments

BNE_STYLESHEETS_B stores the definition of a style sheet. A style sheet is a hierachical set of style definitions used for formatting purposes. It follows CSS (Cascading Style Sheet) standards.

Indexes
Index Type Tablespace Column
BNE_STYLESHEETS_B_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
STYLESHEET_CODE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
STYLESHEET_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
DEFAULT_FLAG VARCHAR2 (1)
Is stylesheet the default?
READ_ONLY_FLAG VARCHAR2 (1)
Is stylesheet read only?
IMAGE_FILE_NAME VARCHAR2 (40)
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_STYLESHEETS_B does not reference any database object

BNE.BNE_STYLESHEETS_B is referenced by following:

BNE
VIEW - BNE_STYLESHEETS_B#

[top of page]

Table: BNE_STYLESHEETS_TL

Description: Translations for BNE_STYLESHEETS_B
Primary Key: BNE_STYLESHEETS_TL_PK
  1. APPLICATION_ID
  2. STYLESHEET_CODE
  3. LANGUAGE
Comments

BNE_STYLESHEETS_TL stores the translated name of the stylesheets defined in BNE_STYLESHEETS_B. You need one row for each stylesheet in each of the installed languages.

Indexes
Index Type Tablespace Column
BNE_STYLESHEETS_TL_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
STYLESHEET_CODE
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
STYLESHEET_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y The language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
USER_NAME VARCHAR2 (240) Y User name for the style sheet.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
DESCRIPTION VARCHAR2 (2000)
Language text for desctipion of style sheet
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_STYLESHEETS_TL does not reference any database object

BNE.BNE_STYLESHEETS_TL is referenced by following:

BNE
VIEW - BNE_STYLESHEETS_TL#

[top of page]

Table: BNE_STYLE_PROPERTIES

Description: Definition of Individual Style values
Primary Key: BNE_STYLE_PROPERTIES_PK
  1. APPLICATION_ID
  2. STYLE_CODE
  3. STYLE_PROPERTY_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_STYLE_PROPERTIES.APPLICATION_ID
BNE_STYLE_PROPERTIES.STYLE_CODE 		BNE_STYLES
Comments

BNE_STYLE_PROPERTIES stores the properties for each style defined in BNE_STYLES.

Indexes
Index Type Tablespace Column
BNE_STYLES_PROPERTIES_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
STYLE_CODE
STYLE_PROPERTY_NAME
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
STYLE_CODE VARCHAR2 (30) Y Code identifying this entity for the given APPLICATION_ID.
STYLE_PROPERTY_NAME VARCHAR2 (50) Y Name of style property. This name will need to be relevant to the viewer the layout is being rendered in. Example: font-family.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
VALUE VARCHAR2 (250) Y Style value. Example: WingDings
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
DATA_TYPE VARCHAR2 (30)
Style properties data type
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_STYLE_PROPERTIES does not reference any database object

BNE.BNE_STYLE_PROPERTIES is referenced by following:

BNE
VIEW - BNE_STYLE_PROPERTIES#

[top of page]

Table: BNE_UPLOAD_TRANSACTIONS

Description: A Runtime table to create transaction on. There should be no data in this table.
Primary Key: BNE_UPLOAD_TRANSACTIONS_PK
  1. TRANSACTION_ID
Comments

A Runtime table to create database transaction on (as seen by GV$TRANSACTION) by inserting and deleting a row to create rollback. There should be no data in this table.

Indexes
Index Type Tablespace Column
BNE_UPLOAD_TRANSACTIONS_UK1 UNIQUE APPS_TS_TX_IDX TRANSACTION_ID
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER
Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.

[top of page]

BNE.BNE_UPLOAD_TRANSACTIONS does not reference any database object

BNE.BNE_UPLOAD_TRANSACTIONS is referenced by following:

BNE
VIEW - BNE_UPLOAD_TRANSACTIONS#

[top of page]

Table: BNE_USER_SETTINGS

Description: Per user storage for persistent data
Primary Key: BNE_USER_SETTINGS_PK
  1. SETTING_GROUP
  2. SETTING_NAME
  3. USER_ID
Comments

BNE_USER_SETTINGS stores user specific data values used by the run-time application. These data values are used to remember previous decisions the user has made in Web ADI, across multiple sessions. For example, the document creation settings are stored so that the next time the user creates a document, their previous selections are defaulted for them.

Indexes
Index Type Tablespace Column
BNE_USER_SETTINGS_U1 UNIQUE APPS_TS_TX_IDX USER_ID
SETTING_GROUP
SETTING_NAME
SYS_IL0000239830C00010$$ UNIQUE APPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
USER_ID NUMBER (15) Y User Id (foreign key to FND_USER.USER_ID).
SETTING_GROUP VARCHAR2 (255) Y Grouping of settings. Can be used to create levels of settings.
SETTING_NAME VARCHAR2 (255) Y Name of setting.
SETTING_VALUE VARCHAR2 (2000)
Value of setting. This column is deprecated in favour of SETTING_VALUE_CLOB.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
SETTING_VALUE_CLOB CLOB (4000)
A replacement for SETTING_VALUE for settings greater then 2000 characters.

[top of page]

BNE.BNE_USER_SETTINGS does not reference any database object

BNE.BNE_USER_SETTINGS is referenced by following:

BNE
VIEW - BNE_USER_SETTINGS#

[top of page]

Table: BNE_VIEWERS_B

Description: Definition of Viewers
Primary Key: BNE_VIEWERS_B_PK
  1. VIEWER_CODE
  2. APPLICATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BNE_VIEWERS_B.PARAM_LIST_APP_ID
BNE_VIEWERS_B.PARAM_LIST_CODE 		BNE_PARAM_LISTS_B
BNE_VIEWERS_B.CREATE_DOC_LIST_APP_ID
BNE_VIEWERS_B.CREATE_DOC_LIST_CODE 		BNE_PARAM_LISTS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
BNE_INTEGRATOR_VIEWERS.VIEWER_APP_ID
BNE_INTEGRATOR_VIEWERS.VIEWER_CODE 		BNE_VIEWERS_B
Comments

BNE_VIEWERS_B stores the definition of a viewer. A viewer is the definition of the code that is run to start and run a desktop application such as Word and Excel. Examples of components are LOVs and the XML object used for data download. Each component is uniquely identified by it's APPLICATION_ID and VIEWER_CODE, and requires the definition of a java class which will run to generate the viewer, and optional parameter list to define the arguments to the java class.

Indexes
Index Type Tablespace Column
BNE_VIEWERS_B_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
VIEWER_CODE
ZD_EDITION_NAME
BNE_VIEWERS_B_N1 NONUNIQUE APPS_TS_TX_IDX PARAM_LIST_APP_ID
PARAM_LIST_CODE
BNE_VIEWERS_B_N2 NONUNIQUE APPS_TS_TX_IDX CREATE_DOC_LIST_APP_ID
CREATE_DOC_LIST_CODE
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
VIEWER_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
VIEWER_JAVA_CLASS VARCHAR2 (240) Y Java class name that is used to run the viewer.
PARAM_LIST_APP_ID NUMBER (15)
Parameter list application id of the viewer parameter list.
PARAM_LIST_CODE VARCHAR2 (30)
Parameter list code of the viewer parameter list.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
CREATE_DOC_LIST_APP_ID NUMBER (15)
Additional parameters required during create document process. FK to BNE_PARAM_LISTS_B.
CREATE_DOC_LIST_CODE VARCHAR2 (30)
Additional parameters required during create document process. FK to BNE_PARAM_LISTS_B.
ENABLED_FLAG VARCHAR2 (1)
Is the viewer enabled?
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_VIEWERS_B does not reference any database object

BNE.BNE_VIEWERS_B is referenced by following:

BNE
VIEW - BNE_VIEWERS_B#

[top of page]

Table: BNE_VIEWERS_TL

Description: Translations for BNE_VIEWERS_B
Primary Key: BNE_VIEWERS_TL_PK
  1. APPLICATION_ID
  2. VIEWER_CODE
  3. LANGUAGE
Comments

BNE_VIEWERS_TL stores the translated name of the viewers defined in BNE_VIEWERS_B. You need one row for each viewer in each of the installed languages.

Indexes
Index Type Tablespace Column
BNE_VIEWERS_TL_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
VIEWER_CODE
LANGUAGE
ZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
VIEWER_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
LANGUAGE VARCHAR2 (4) Y Language
SOURCE_LANG VARCHAR2 (4) Y The language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
USER_NAME VARCHAR2 (240) Y User name for the viewer.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BNE.BNE_VIEWERS_TL does not reference any database object

BNE.BNE_VIEWERS_TL is referenced by following:

BNE
VIEW - BNE_VIEWERS_TL#

[top of page]

View: BNE_CACHE_DIRECTIVES_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Base table Row ID
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
DIRECTIVE_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
MAX_SIZE NUMBER (15)
Maximum size of object to be cached.
MAX_HITS NUMBER (15) Y
MAX_AGE VARCHAR2 (240) Y
DISCRIMINATOR_TYPE VARCHAR2 (30) Y
DISCRIMINATOR_VALUE VARCHAR2 (2000) Y
USER_NAME VARCHAR2 (240) Y User name for the viewer.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.

[top of page]

APPS.BNE_CACHE_DIRECTIVES_VL references the following:

APPS
SYNONYM - BNE_CACHE_DIRECTIVES_B
SYNONYM - BNE_CACHE_DIRECTIVES_TL

APPS.BNE_CACHE_DIRECTIVES_VL is not referenced by any database object

[top of page]

View: BNE_COMPONENTS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BNE_COMPONENTS_VL is a standard translation view over the BNE_COMPONENTS entity.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Base table Row ID
APPLICATION_ID NUMBER (15) Y Entity column. Refer base entity.
COMPONENT_CODE VARCHAR2 (30) Y Entity column. Refer base entity.
OBJECT_VERSION_NUMBER NUMBER (15) Y Entity column. Refer base entity.
COMPONENT_JAVA_CLASS VARCHAR2 (240) Y Entity column. Refer base entity.
PARAM_LIST_APP_ID NUMBER (15)
Entity column. Refer base entity.
PARAM_LIST_CODE VARCHAR2 (30)
Entity column. Refer base entity.
USER_NAME VARCHAR2 (240) Y Entity column. Refer base entity.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.

[top of page]

APPS.BNE_COMPONENTS_VL references the following:

APPS
SYNONYM - BNE_COMPONENTS_B
SYNONYM - BNE_COMPONENTS_TL

APPS.BNE_COMPONENTS_VL is not referenced by any database object

[top of page]

View: BNE_CONTENTS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BNE_CONTENTS_VL is a standard translation view over the BNE_CONTENTS entity.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Base table Row ID
APPLICATION_ID NUMBER (15) Y Entity column. Refer base entity.
CONTENT_CODE VARCHAR2 (30) Y Entity column. Refer base entity.
OBJECT_VERSION_NUMBER NUMBER (15) Y Entity column. Refer base entity.
INTEGRATOR_APP_ID NUMBER (15) Y Entity column. Refer base entity.
INTEGRATOR_CODE VARCHAR2 (30) Y Entity column. Refer base entity.
PARAM_LIST_APP_ID NUMBER (15)
Entity column. Refer base entity.
PARAM_LIST_CODE VARCHAR2 (30)
Entity column. Refer base entity.
CONTENT_CLASS VARCHAR2 (240)
Entity column. Refer base entity.
USER_NAME VARCHAR2 (240) Y Entity column. Refer base entity.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
ONCE_ONLY_DOWNLOAD_FLAG VARCHAR2 (1)

[top of page]

APPS.BNE_CONTENTS_VL references the following:

APPS
SYNONYM - BNE_CONTENTS_B
SYNONYM - BNE_CONTENTS_TL

APPS.BNE_CONTENTS_VL is not referenced by any database object

[top of page]

View: BNE_CONTENT_COLS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BNE_CONTENT_COLS_VL is a standard translation view over the BNE_CONTENT_COLS entity.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Base table Row ID
APPLICATION_ID NUMBER (15) Y Entity column. Refer base entity.
CONTENT_CODE VARCHAR2 (30) Y Entity column. Refer base entity.
SEQUENCE_NUM NUMBER (15) Y Entity column. Refer base entity.
OBJECT_VERSION_NUMBER NUMBER (15) Y Entity column. Refer base entity.
COL_NAME VARCHAR2 (240) Y Entity column. Refer base entity.
USER_NAME VARCHAR2 (240) Y Entity column. Refer base entity.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
READ_ONLY_FLAG VARCHAR2 (1)

[top of page]

APPS.BNE_CONTENT_COLS_VL references the following:

APPS
SYNONYM - BNE_CONTENT_COLS_B
SYNONYM - BNE_CONTENT_COLS_TL

APPS.BNE_CONTENT_COLS_VL is not referenced by any database object

[top of page]

View: BNE_DUPLICATE_PROFILES_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BNE_DUPLICATE_PROFILES_VL is a standard translation view over the BNE_DUPLICATE_PROFILES entity.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Base table Row ID
APPLICATION_ID NUMBER (15) Y Entity column. Refer base entity.
DUP_PROFILE_CODE VARCHAR2 (30) Y Entity column. Refer base entity.
OBJECT_VERSION_NUMBER NUMBER (15) Y Entity column. Refer base entity.
INTEGRATOR_APP_ID NUMBER (15) Y Entity column. Refer base entity.
INTEGRATOR_CODE VARCHAR2 (30) Y Entity column. Refer base entity.
USER_NAME VARCHAR2 (240) Y Entity column. Refer base entity.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.

[top of page]

APPS.BNE_DUPLICATE_PROFILES_VL references the following:

APPS
SYNONYM - BNE_DUPLICATE_PROFILES_B
SYNONYM - BNE_DUPLICATE_PROFILES_TL

APPS.BNE_DUPLICATE_PROFILES_VL is not referenced by any database object

[top of page]

View: BNE_GRAPHS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Base table Row ID
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
INTEGRATOR_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
SEQUENCE_NUM NUMBER (15) Y Sequence Num
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
LAYOUT_APP_ID NUMBER (15)
Interface App Id
LAYOUT_CODE VARCHAR2 (30)
Interface Code
GRAPH_DIMENSION_CODE VARCHAR2 (30)
Interface Seq Num
GRAPH_TYPE_CODE VARCHAR2 (30)
Location Code
AUTO_GRAPH_FLAG VARCHAR2 (1)
Auto Graph Code
CHART_TITLE VARCHAR2 (240)
Chart Title
X_AXIS_LABEL VARCHAR2 (240)
X Axis Label
Y_AXIS_LABEL VARCHAR2 (240)
Y Axis Label
Z_AXIS_LABEL VARCHAR2 (240)
Z Axis Label
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.

[top of page]

APPS.BNE_GRAPHS_VL references the following:

APPS
SYNONYM - BNE_GRAPHS_B
SYNONYM - BNE_GRAPHS_TL

APPS.BNE_GRAPHS_VL is not referenced by any database object

[top of page]

View: BNE_INTEGRATORS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BNE_INTEGRATORS_VL is a standard translation view over the BNE_INTEGRATORS entity.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Base table Row ID
APPLICATION_ID NUMBER (15) Y Entity column. Refer base entity.
INTEGRATOR_CODE VARCHAR2 (30) Y Entity column. Refer base entity.
OBJECT_VERSION_NUMBER NUMBER (15) Y Entity column. Refer base entity.
ENABLED_FLAG VARCHAR2 (1) Y Entity column. Refer base entity.
UPLOAD_PARAM_LIST_APP_ID NUMBER (15)
Entity column. Refer base entity.
UPLOAD_PARAM_LIST_CODE VARCHAR2 (30)
Entity column. Refer base entity.
UPLOAD_SERV_PARAM_LIST_APP_ID NUMBER (15)
Entity column. Refer base entity.
UPLOAD_SERV_PARAM_LIST_CODE VARCHAR2 (30)
Entity column. Refer base entity.
IMPORT_PARAM_LIST_APP_ID NUMBER (15)
Entity column. Refer base entity.
IMPORT_PARAM_LIST_CODE VARCHAR2 (30)
Entity column. Refer base entity.
UPLOADER_CLASS VARCHAR2 (240)
Entity column. Refer base entity.
DATE_FORMAT VARCHAR2 (100) Y Entity column. Refer base entity.
IMPORT_TYPE NUMBER (15)
Entity column. Refer base entity.
CREATE_DOC_LIST_APP_ID NUMBER (15)
CREATE_DOC_LIST_CODE VARCHAR2 (30)
NEW_SESSION_FLAG VARCHAR2 (1)
USER_NAME VARCHAR2 (240) Y Entity column. Refer base entity.
UPLOAD_TITLE_BAR VARCHAR2 (240)
Entity column. Refer base entity.
UPLOAD_HEADER VARCHAR2 (240)
Entity column. Refer base entity.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
LAYOUT_RESOLVER_CLASS VARCHAR2 (240)
Fully qualified java class for document generation time layout modification.
LAYOUT_VERIFIER_CLASS VARCHAR2 (240)
Fully qualified java class for layout verification during layout creation.
SESSION_CONFIG_CLASS VARCHAR2 (240)
Fully qualified java class for layout verification during layout creation.
SESSION_PARAM_LIST_APP_ID NUMBER (15)
Entity column. Refer base entity.
SESSION_PARAM_LIST_CODE VARCHAR2 (30)
Entity column. Refer base entity.
DISPLAY_FLAG VARCHAR2 (1)
Entity column. Refer base entity.
SOURCE VARCHAR2 (1)
Entity column. Refer base entity

[top of page]

APPS.BNE_INTEGRATORS_VL references the following:

APPS
SYNONYM - BNE_INTEGRATORS_B
SYNONYM - BNE_INTEGRATORS_TL

APPS.BNE_INTEGRATORS_VL is not referenced by any database object

[top of page]

View: BNE_INTERFACES_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BNE_INTERFACES_VL is a standard translation view over the BNE_INTERFACES entity.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Base table Row ID
APPLICATION_ID NUMBER (15) Y Entity column. Refer base entity.
INTERFACE_CODE VARCHAR2 (30) Y Entity column. Refer base entity.
OBJECT_VERSION_NUMBER NUMBER (15) Y Entity column. Refer base entity.
INTEGRATOR_APP_ID NUMBER (15) Y Entity column. Refer base entity.
INTEGRATOR_CODE VARCHAR2 (30) Y Entity column. Refer base entity.
INTERFACE_NAME VARCHAR2 (50) Y Entity column. Refer base entity.
UPLOAD_TYPE NUMBER (15) Y Entity column. Refer base entity.
UPLOAD_OBJ_NAME VARCHAR2 (240)
Entity column. Refer base entity.
UPLOAD_PARAM_LIST_APP_ID NUMBER (15)
Entity column. Refer base entity.
UPLOAD_PARAM_LIST_CODE VARCHAR2 (30)
Entity column. Refer base entity.
UPLOAD_ORDER NUMBER (15)
Entity column. Refer base entity.
USER_NAME VARCHAR2 (240) Y Entity column. Refer base entity.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.

[top of page]

APPS.BNE_INTERFACES_VL references the following:

APPS
SYNONYM - BNE_INTERFACES_B
SYNONYM - BNE_INTERFACES_TL

APPS.BNE_INTERFACES_VL is not referenced by any database object

[top of page]

View: BNE_INTERFACE_COLS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BNE_INTERFACE_COLS_VL is a standard translation view over the BNE_INTERFACE_COLS entity.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Base table Row ID
APPLICATION_ID NUMBER (15) Y Entity column. Refer base entity.
INTERFACE_CODE VARCHAR2 (30) Y Entity column. Refer base entity.
OBJECT_VERSION_NUMBER NUMBER (15) Y Entity column. Refer base entity.
SEQUENCE_NUM NUMBER (15) Y Entity column. Refer base entity.
INTERFACE_COL_TYPE NUMBER (15) Y Entity column. Refer base entity.
INTERFACE_COL_NAME VARCHAR2 (50) Y Entity column. Refer base entity.
ENABLED_FLAG VARCHAR2 (1) Y Entity column. Refer base entity.
REQUIRED_FLAG VARCHAR2 (1) Y Entity column. Refer base entity.
DISPLAY_FLAG VARCHAR2 (1) Y Entity column. Refer base entity.
READ_ONLY_FLAG VARCHAR2 (1) Y Entity column. Refer base entity.
NOT_NULL_FLAG VARCHAR2 (1) Y Entity column. Refer base entity.
SUMMARY_FLAG VARCHAR2 (1) Y Entity column. Refer base entity.
MAPPING_ENABLED_FLAG VARCHAR2 (1) Y 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) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y 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)

[top of page]

APPS.BNE_INTERFACE_COLS_VL references the following:

APPS
SYNONYM - BNE_INTERFACE_COLS_B
SYNONYM - BNE_INTERFACE_COLS_TL
APPS.BNE_INTERFACE_COLS_VL is referenced by following:

APPS
VIEW - BNE_LAYOUT_COLS_V

[top of page]

View: BNE_LAYOUTS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BNE_LAYOUTS_VL is a standard translation view over the BNE_LAYOUTS entity.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Base table Row ID
APPLICATION_ID NUMBER (15) Y Entity column. Refer base entity.
LAYOUT_CODE VARCHAR2 (30) Y Entity column. Refer base entity.
OBJECT_VERSION_NUMBER NUMBER (15) Y Entity column. Refer base entity.
STYLESHEET_APP_ID NUMBER (15) Y Entity column. Refer base entity.
STYLESHEET_CODE VARCHAR2 (30) Y Entity column. Refer base entity.
INTEGRATOR_APP_ID NUMBER (15) Y Entity column. Refer base entity.
INTEGRATOR_CODE VARCHAR2 (30) Y Entity column. Refer base entity.
STYLE VARCHAR2 (2000)
Entity column. Refer base entity.
STYLE_CLASS VARCHAR2 (50)
Entity column. Refer base entity.
REPORTING_FLAG VARCHAR2 (1) Y Entity column. Refer base entity.
REPORTING_INTERFACE_APP_ID NUMBER (15)
Entity column. Refer base entity.
REPORTING_INTERFACE_CODE VARCHAR2 (30)
Entity column. Refer base entity.
CREATE_DOC_LIST_APP_ID NUMBER (15)
CREATE_DOC_LIST_CODE VARCHAR2 (30)
USER_NAME VARCHAR2 (240) Y Entity column. Refer base entity.
IMAGE_FILE_NAME VARCHAR2 (40)
File Name of the Image for the Stylesheet
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.

[top of page]

APPS.BNE_LAYOUTS_VL references the following:

APPS
SYNONYM - BNE_LAYOUTS_B
SYNONYM - BNE_LAYOUTS_TL

APPS.BNE_LAYOUTS_VL is not referenced by any database object

[top of page]

View: BNE_LAYOUT_BLOCKS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BNE_LAYOUT_BLOCKS_VL is a standard translation view over the BNE_LAYOUT_BLOCKS entity.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Base table Row ID
APPLICATION_ID NUMBER (15) Y Entity column. Refer base entity.
LAYOUT_CODE VARCHAR2 (30) Y Entity column. Refer base entity.
BLOCK_ID NUMBER (15) Y Entity column. Refer base entity.
OBJECT_VERSION_NUMBER NUMBER (15) Y Entity column. Refer base entity.
PARENT_ID NUMBER (15)
Entity column. Refer base entity.
LAYOUT_ELEMENT VARCHAR2 (240) Y Entity column. Refer base entity.
STYLE_CLASS VARCHAR2 (50)
Entity column. Refer base entity.
STYLE VARCHAR2 (2000)
Entity column. Refer base entity.
ROW_STYLE_CLASS VARCHAR2 (50)
Entity column. Refer base entity.
ROW_STYLE VARCHAR2 (2000)
Entity column. Refer base entity.
COL_STYLE_CLASS VARCHAR2 (50)
Entity column. Refer base entity.
COL_STYLE VARCHAR2 (2000)
Entity column. Refer base entity.
PROMPT_DISPLAYED_FLAG VARCHAR2 (1) Y Entity column. Refer base entity.
PROMPT_STYLE_CLASS VARCHAR2 (50)
Entity column. Refer base entity.
PROMPT_STYLE VARCHAR2 (2000)
Entity column. Refer base entity.
HINT_DISPLAYED_FLAG VARCHAR2 (1) Y Entity column. Refer base entity.
HINT_STYLE_CLASS VARCHAR2 (50)
Entity column. Refer base entity.
HINT_STYLE VARCHAR2 (2000)
Entity column. Refer base entity.
ORIENTATION VARCHAR2 (20) Y Entity column. Refer base entity.
LAYOUT_CONTROL VARCHAR2 (20) Y Entity column. Refer base entity.
DISPLAY_FLAG VARCHAR2 (1) Y Entity column. Refer base entity.
BLOCKSIZE NUMBER (15) Y Entity column. Refer base entity.
MINSIZE NUMBER (15) Y Entity column. Refer base entity.
MAXSIZE NUMBER (15) Y Entity column. Refer base entity.
SEQUENCE_NUM NUMBER (15) Y Entity column. Refer base entity.
PROMPT_COLSPAN NUMBER (15)
Entity column. Refer base entity.
HINT_COLSPAN NUMBER (15)
Entity column. Refer base entity.
ROW_COLSPAN NUMBER (15)
Entity column. Refer base entity.
SUMMARY_STYLE_CLASS VARCHAR2 (50)
Entity column. Refer base entity.
SUMMARY_STYLE VARCHAR2 (2000)
Entity column. Refer base entity.
TITLE_STYLE_CLASS VARCHAR2 (50)
TITLE_STYLE VARCHAR2 (2000)
USER_NAME VARCHAR2 (240) Y Entity column. Refer base entity.
PROMPT_ABOVE VARCHAR2 (240)
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.

[top of page]

APPS.BNE_LAYOUT_BLOCKS_VL references the following:

APPS
SYNONYM - BNE_LAYOUT_BLOCKS_B
SYNONYM - BNE_LAYOUT_BLOCKS_TL

APPS.BNE_LAYOUT_BLOCKS_VL is not referenced by any database object

[top of page]

View: BNE_LAYOUT_COLS_V

Comments
View Type

A Business Intelligence System view

BNE_LAYOUT_COLS_V is a business view over BNE_INTERFACE_COLS and BNE_LAYOUT_COLS.

Columns
Name Datatype Length Mandatory Comments
INTERFACE_APP_ID NUMBER (15) Y Entity column. Refer base entity.
INTERFACE_CODE VARCHAR2 (30) Y Entity column. Refer base entity.
INTERFACE_SEQ_NUM NUMBER (15) Y Entity column. Refer base entity.
INTERFACE_COL_NAME VARCHAR2 (50) Y Entity column. Refer base entity.
LAYOUT_APP_ID NUMBER (15) Y Entity column. Refer base entity.
LAYOUT_CODE VARCHAR2 (30) Y Entity column. Refer base entity.
BLOCK_ID NUMBER (15) Y Entity column. Refer base entity.
SEQUENCE_NUM NUMBER (15) Y 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) Y Entity column. Refer base entity.
DISPLAY_FLAG VARCHAR2 (1) Y 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) Y 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) Y 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)

[top of page]

APPS.BNE_LAYOUT_COLS_V references the following:

APPS
VIEW - BNE_INTERFACE_COLS_VL
SYNONYM - BNE_LAYOUT_COLS

APPS.BNE_LAYOUT_COLS_V is not referenced by any database object

[top of page]

View: BNE_MAPPINGS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BNE_MAPPINGS_VL is a standard translation view over the BNE_MAPPINGS entity.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Base table Row ID
APPLICATION_ID NUMBER (15) Y Entity column. Refer base entity.
MAPPING_CODE VARCHAR2 (30) Y Entity column. Refer base entity.
OBJECT_VERSION_NUMBER NUMBER (15) Y Entity column. Refer base entity.
INTEGRATOR_APP_ID NUMBER (15) Y Entity column. Refer base entity.
INTEGRATOR_CODE VARCHAR2 (30) Y Entity column. Refer base entity.
REPORTING_FLAG VARCHAR2 (1) Y Entity column. Refer base entity.
REPORTING_INTERFACE_APP_ID NUMBER (15)
Entity column. Refer base entity.
REPORTING_INTERFACE_CODE VARCHAR2 (30)
Entity column. Refer base entity.
USER_NAME VARCHAR2 (240) Y Entity column. Refer base entity.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.

[top of page]

APPS.BNE_MAPPINGS_VL references the following:

APPS
SYNONYM - BNE_MAPPINGS_B
SYNONYM - BNE_MAPPINGS_TL

APPS.BNE_MAPPINGS_VL is not referenced by any database object

[top of page]

View: BNE_MENUS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Base table Row ID
APPLICATION_ID NUMBER (15) Y Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
MENU_CODE VARCHAR2 (30) Y Unique code identifying this entity for the given APPLICATION_ID.
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
PARENT_APP_ID NUMBER (15)
PARENT_CODE VARCHAR2 (30)
SEQUENCE_NUM NUMBER (15)
INTEGRATOR_APP_ID NUMBER (15)
INTEGRATOR_CODE VARCHAR2 (30)
RESOLVER_CLASS VARCHAR2 (240)
ACCESS_POINT VARCHAR2 (240)
PARAM_LIST_APP_ID NUMBER (15)
PARAM_LIST_CODE VARCHAR2 (30)
USER_NAME VARCHAR2 (240) Y Entity column. Refer base entity.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.

[top of page]

APPS.BNE_MENUS_VL references the following:

APPS
SYNONYM - BNE_MENUS_B
SYNONYM - BNE_MENUS_TL

APPS.BNE_MENUS_VL is not referenced by any database object

[top of page]

View: BNE_PARAM_DEFNS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BNE_PARAM_DEFNS_VL is a standard translation view over the BNE_PARAM_DEFNS entity.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Base table Row ID
APPLICATION_ID NUMBER (15) Y Entity column. Refer base entity.
PARAM_DEFN_CODE VARCHAR2 (30) Y Entity column. Refer base entity.
OBJECT_VERSION_NUMBER NUMBER (15) Y Entity column. Refer base entity.
PARAM_NAME VARCHAR2 (240) Y Entity column. Refer base entity.
PARAM_SOURCE VARCHAR2 (240) Y Entity column. Refer base entity.
PARAM_CATEGORY NUMBER (5) Y Entity column. Refer base entity.
USER_NAME VARCHAR2 (240) Y Entity column. Refer base entity.
DATATYPE NUMBER (1) Y Entity column. Refer base entity.
ATTRIBUTE_APP_ID NUMBER (15)
Entity column. Refer base entity.
ATTRIBUTE_CODE VARCHAR2 (30)
Entity column. Refer base entity.
PARAM_RESOLVER VARCHAR2 (240)
Entity column. Refer base entity.
DEFAULT_REQUIRED_FLAG VARCHAR2 (1) Y Entity column. Refer base entity.
DEFAULT_VISIBLE_FLAG VARCHAR2 (1) Y Entity column. Refer base entity.
DEFAULT_USER_MODIFYABLE_FLAG VARCHAR2 (1) Y Entity column. Refer base entity.
DEFAULT_STRING VARCHAR2 (2000)
Entity column. Refer base entity.
DEFAULT_STRING_TRANS_FLAG VARCHAR2 (1)
Entity column. Refer base entity.
DEFAULT_DATE DATE

Entity column. Refer base entity.
DEFAULT_NUMBER NUMBER

Entity column. Refer base entity.
DEFAULT_BOOLEAN_FLAG VARCHAR2 (1)
Entity column. Refer base entity.
DEFAULT_FORMULA VARCHAR2 (240)
Entity column. Refer base entity.
VAL_TYPE VARCHAR2 (2) Y Entity column. Refer base entity.
VAL_VALUE VARCHAR2 (30)
Entity column. Refer base entity.
MAX_SIZE NUMBER (5) Y Entity column. Refer base entity.
DISPLAY_TYPE NUMBER (1) Y Entity column. Refer base entity.
DISPLAY_STYLE NUMBER (1) Y Entity column. Refer base entity.
DISPLAY_SIZE NUMBER (5) Y Entity column. Refer base entity.
DEFAULT_DESC VARCHAR2 (240)
Entity column. Refer base entity.
PROMPT_LEFT VARCHAR2 (240)
Entity column. Refer base entity.
PROMPT_ABOVE VARCHAR2 (240)
Entity column. Refer base entity.
USER_TIP VARCHAR2 (2000)
Entity column. Refer base entity.
HELP_URL VARCHAR2 (240)
Entity column. Refer base entity.
FORMAT_MASK VARCHAR2 (240)
Entity column. Refer base entity.
ACCESS_KEY VARCHAR2 (30)
Entity column. Refer base entity.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.
OA_FLEX_APPLICATION_ID NUMBER (15)
OA_FLEX_CODE VARCHAR2 (30)
OA_FLEX_NUM VARCHAR2 (2000)

[top of page]

APPS.BNE_PARAM_DEFNS_VL references the following:

APPS
SYNONYM - BNE_PARAM_DEFNS_B
SYNONYM - BNE_PARAM_DEFNS_TL

APPS.BNE_PARAM_DEFNS_VL is not referenced by any database object

[top of page]

View: BNE_PARAM_GROUPS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BNE_PARAM_GROUPS_VL is a standard translation view over the BNE_PARAM_GROUPS entity.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Base table Row ID
APPLICATION_ID NUMBER (15) Y Entity column. Refer base entity.
PARAM_LIST_CODE VARCHAR2 (30) Y Entity column. Refer base entity.
SEQUENCE_NUM NUMBER (15) Y
OBJECT_VERSION_NUMBER NUMBER (15) Y Entity column. Refer base entity.
ATTRIBUTE_APP_ID NUMBER (15)
Entity column. Refer base entity.
ATTRIBUTE_CODE VARCHAR2 (30)
Entity column. Refer base entity.
GROUP_RESOLVER VARCHAR2 (240)
Entity column. Refer base entity.
USER_NAME VARCHAR2 (240) Y Entity column. Refer base entity.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.

[top of page]

APPS.BNE_PARAM_GROUPS_VL references the following:

APPS
SYNONYM - BNE_PARAM_GROUPS_B
SYNONYM - BNE_PARAM_GROUPS_TL

APPS.BNE_PARAM_GROUPS_VL is not referenced by any database object

[top of page]

View: BNE_PARAM_LISTS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BNE_PARAM_LISTS_VL is a standard translation view over the BNE_PARAM_LISTS entity.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Base table Row ID
APPLICATION_ID NUMBER (15) Y Entity column. Refer base entity.
PARAM_LIST_CODE VARCHAR2 (30) Y Entity column. Refer base entity.
OBJECT_VERSION_NUMBER NUMBER (15) Y Entity column. Refer base entity.
PERSISTENT_FLAG VARCHAR2 (1) Y Entity column. Refer base entity.
COMMENTS VARCHAR2 (240)
Entity column. Refer base entity.
ATTRIBUTE_APP_ID NUMBER (15)
Entity column. Refer base entity.
ATTRIBUTE_CODE VARCHAR2 (30)
Entity column. Refer base entity.
LIST_RESOLVER VARCHAR2 (240)
Entity column. Refer base entity.
USER_TIP VARCHAR2 (2000)
Entity column. Refer base entity.
PROMPT_LEFT VARCHAR2 (240)
Entity column. Refer base entity.
PROMPT_ABOVE VARCHAR2 (240)
Entity column. Refer base entity.
USER_NAME VARCHAR2 (240) Y Entity column. Refer base entity.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.

[top of page]

APPS.BNE_PARAM_LISTS_VL references the following:

APPS
SYNONYM - BNE_PARAM_LISTS_B
SYNONYM - BNE_PARAM_LISTS_TL

APPS.BNE_PARAM_LISTS_VL is not referenced by any database object

[top of page]

View: BNE_PERF_SETS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BNE_PERF_SETS_VL is a standard translation view over the BNE_PERF_SETS entity.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Base table Row ID
SET_CODE VARCHAR2 (30) Y Entity column. Refer base entity.
OBJECT_VERSION_NUMBER NUMBER (15) Y Entity column. Refer base entity.
ENABLED_FLAG VARCHAR2 (1) Y Entity column. Refer base entity.
USER_NAME VARCHAR2 (240) Y Entity column. Refer base entity.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.

[top of page]

APPS.BNE_PERF_SETS_VL references the following:

APPS
SYNONYM - BNE_PERF_SETS_B
SYNONYM - BNE_PERF_SETS_TL

APPS.BNE_PERF_SETS_VL is not referenced by any database object

[top of page]

View: BNE_PERF_STATISTICS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BNE_PERF_STATISTICS_VL is a standard translation view over the BNE_PERF_STATISTICS entity.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Base table Row ID
STATISTIC_CODE VARCHAR2 (30) Y Entity column. Refer base entity.
OBJECT_VERSION_NUMBER NUMBER (15) Y Entity column. Refer base entity.
USER_NAME VARCHAR2 (240) Y Entity column. Refer base entity.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.

[top of page]

APPS.BNE_PERF_STATISTICS_VL references the following:

APPS
SYNONYM - BNE_PERF_STATISTICS_B
SYNONYM - BNE_PERF_STATISTICS_TL

APPS.BNE_PERF_STATISTICS_VL is not referenced by any database object

[top of page]

View: BNE_QUERIES_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BNE_QUERIES_VL is a standard translation view over the BNE_QUERIES entity.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Base table Row ID
APPLICATION_ID NUMBER (15) Y Entity column. Refer base entity.
QUERY_CODE VARCHAR2 (30) Y Entity column. Refer base entity.
OBJECT_VERSION_NUMBER NUMBER (15) Y Entity column. Refer base entity.
QUERY_CLASS VARCHAR2 (240) Y Entity column. Refer base entity.
DIRECTIVE_APP_ID NUMBER (15)
DIRECTIVE_CODE VARCHAR2 (30)
USER_NAME VARCHAR2 (240) Y Entity column. Refer base entity.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.

[top of page]

APPS.BNE_QUERIES_VL references the following:

APPS
SYNONYM - BNE_QUERIES_B
SYNONYM - BNE_QUERIES_TL

APPS.BNE_QUERIES_VL is not referenced by any database object

[top of page]

View: BNE_STYLESHEETS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BNE_STYLESHEETS_VL is a standard translation view over the BNE_STYLESHEETS entity.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Base table Row ID
APPLICATION_ID NUMBER (15) Y Entity column. Refer base entity.
STYLESHEET_CODE VARCHAR2 (30) Y Entity column. Refer base entity.
OBJECT_VERSION_NUMBER NUMBER (15) Y Entity column. Refer base entity.
USER_NAME VARCHAR2 (240) Y Entity column. Refer base entity.
DESCRIPTION VARCHAR2 (2000)
DEFAULT_FLAG VARCHAR2 (1)
READ_ONLY_FLAG VARCHAR2 (1)
IMAGE_FILE_NAME VARCHAR2 (40)
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.

[top of page]

APPS.BNE_STYLESHEETS_VL references the following:

APPS
SYNONYM - BNE_STYLESHEETS_B
SYNONYM - BNE_STYLESHEETS_TL

APPS.BNE_STYLESHEETS_VL is not referenced by any database object

[top of page]

View: BNE_VIEWERS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BNE_VIEWERS_VL is a standard translation view over the BNE_VIEWERS entity.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Base table Row ID
APPLICATION_ID NUMBER (15) Y Entity column. Refer base entity.
VIEWER_CODE VARCHAR2 (30) Y Entity column. Refer base entity.
OBJECT_VERSION_NUMBER NUMBER (15) Y Entity column. Refer base entity.
VIEWER_JAVA_CLASS VARCHAR2 (240) Y Entity column. Refer base entity.
PARAM_LIST_APP_ID NUMBER (15)
Entity column. Refer base entity.
PARAM_LIST_CODE VARCHAR2 (30)
Entity column. Refer base entity.
CREATE_DOC_LIST_APP_ID NUMBER (15)
CREATE_DOC_LIST_CODE VARCHAR2 (30)
ENABLED_FLAG VARCHAR2 (1)
USER_NAME VARCHAR2 (240) Y Entity column. Refer base entity.
CREATED_BY NUMBER (15) Y Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Y Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Y 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
Y Standard Who column - date when a user last updated this row.

[top of page]

APPS.BNE_VIEWERS_VL references the following:

APPS
SYNONYM - BNE_VIEWERS_B
SYNONYM - BNE_VIEWERS_TL

APPS.BNE_VIEWERS_VL is not referenced by any database object

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract