FND_AUDIT_BOSS_USAGES

This table contains the mapping between existing ADF and Business Objects

Details

  • Schema: FND_AUDIT

  • Object owner: FND

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

FND_AUDIT_BOSS_USAGES_PK

VIEW_OBJECT, BO_NAME, BO_MODULE_NAME, BASE_APP_PACKAGE_NAME

Columns

Name Datatype Length Not-null Comments
VIEW_OBJECT VARCHAR2 240 Yes Name of the View Object
PARENT_OBJECT VARCHAR2 240 Yes Name of the Parent Object
TABLE_NAME VARCHAR2 30 Yes Name of the Table
TABLE_USAGE_CODE VARCHAR2 40 The associated descriptive flexfield code
BO_MODULE_NAME VARCHAR2 70 Yes Module Name which contains the Business Object
BO_NAME VARCHAR2 240 Yes Name of the Business Object
BO_PARENT_NAME VARCHAR2 240 Yes Name of the Parent Business Object
BASE_APP_PACKAGE_NAME VARCHAR2 400 Yes Name of the Application Package
BASE_APP_PACKAGE_VERSION VARCHAR2 64 Version of the Application Package
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
SEED_DATA_SOURCE VARCHAR2 512 Seed data file from which the row originates.
ORA_SEED_SET1 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N.
ORA_SEED_SET2 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N.

Indexes

Index Uniqueness Tablespace Columns
FND_AUDIT_BOSS_USAGES_U1 Unique Default VIEW_OBJECT, BO_NAME, BO_MODULE_NAME, BASE_APP_PACKAGE_NAME, ORA_SEED_SET1
FND_AUDIT_BOSS_USAGES_U11 Unique Default VIEW_OBJECT, BO_NAME, BO_MODULE_NAME, BASE_APP_PACKAGE_NAME, ORA_SEED_SET2