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 - BIS Tables and Views

TABLE - BIS.BIS_BUCKET
TABLE - BIS.BIS_BUCKET_CUSTOMIZATIONS
TABLE - BIS.BIS_BUCKET_CUSTOMIZATIONS_TL
TABLE - BIS.BIS_BUCKET_TL
TABLE - BIS.BIS_DIMENSIONS
TABLE - BIS.BIS_DIMENSIONS_TL
TABLE - BIS.BIS_FLEX_SEG_MAPPING_LINES
TABLE - BIS.BIS_LEVELS
TABLE - BIS.BIS_LEVELS_TL
TABLE - BIS.BIS_OBJ_DEPENDENCY
TABLE - BIS.BIS_OBJ_INDEXES
TABLE - BIS.BIS_OBJ_PROG_LINKAGES
TABLE - BIS.BIS_OBJ_PROPERTIES
TABLE - BIS.BIS_OBJ_REFRESH_HISTORY
TABLE - BIS.BIS_REFRESH_LOG
TABLE - BIS.BIS_REQUEST_SET_OBJECTS
TABLE - BIS.BIS_REQUEST_SET_OPTIONS
TABLE - BIS.BIS_RS_PROG_RUN_HISTORY
TABLE - BIS.BIS_RS_RUN_HISTORY
TABLE - BIS.BIS_RS_STAGE_RUN_HISTORY
TABLE - BIS.BIS_SYSTEM_DATE
TABLE - BIS.BIS_TERRITORY_HIERARCHIES
TABLE - BIS.BIS_USER_ATTRIBUTES
TABLE - OPI.EDW_MTL_ILDM_LOCATOR_LSTG
TABLE - OPI.EDW_MTL_ILDM_LOCATOR_LTC
TABLE - OPI.EDW_MTL_ILDM_PLANT_LSTG
TABLE - OPI.EDW_MTL_ILDM_PLANT_LTC
TABLE - OPI.EDW_MTL_ILDM_SUB_INV_LSTG
TABLE - OPI.EDW_MTL_ILDM_SUB_INV_LTC
TABLE - OPI.EDW_MTL_INVENTORY_LOC_M
VIEW - APPS.BIS_BUCKET_CUSTOMIZATIONS_VL
VIEW - APPS.BIS_DIMENSIONS_VL
VIEW - APPS.BIS_FLEX_FIELDS_V
VIEW - APPS.BIS_FLEX_MAPPINGS_V
VIEW - APPS.BIS_LEVELS_VL
VIEW - APPS.BIS_ORGANIZATIONS_V
VIEW - APPS.BIS_TERRITORIES_V
VIEW - APPS.BIS_TERRITORY_HIERARCHIES_V

Table: BIS_BUCKET

Description:
Comments

This table stores the bucket information.

Indexes
Index Type Tablespace Column
BIS_BUCKET_U1 UNIQUE APPS_TS_TX_IDX BUCKET_ID
BIS_BUCKET_U2 UNIQUE APPS_TS_TX_IDX SHORT_NAME
Columns
Name Datatype Length Mandatory Comments
BUCKET_ID NUMBER
Y The Bucket ID
SHORT_NAME VARCHAR2 (30) Y The Bucket Short Name
TYPE VARCHAR2 (30) Y The Bucket Type
APPLICATION_ID NUMBER
Y The Application ID
RANGE1_LOW NUMBER

Bucket Value
RANGE1_HIGH NUMBER

Bucket Value
RANGE2_LOW NUMBER

Bucket Value
RANGE2_HIGH NUMBER

Bucket Value
RANGE3_LOW NUMBER

Bucket Value
RANGE3_HIGH NUMBER

Bucket Value
RANGE4_LOW NUMBER

Bucket Value
RANGE4_HIGH NUMBER

Bucket Value
RANGE5_LOW NUMBER

Bucket Value
RANGE5_HIGH NUMBER

Bucket Value
RANGE6_LOW NUMBER

Bucket Value
RANGE6_HIGH NUMBER

Bucket Value
RANGE7_LOW NUMBER

Bucket Value
RANGE7_HIGH NUMBER

Bucket Value
RANGE8_LOW NUMBER

Bucket Value
RANGE8_HIGH NUMBER

Bucket Value
RANGE9_LOW NUMBER

Bucket Value
RANGE9_HIGH NUMBER

Bucket Value
RANGE10_LOW NUMBER

Bucket Value
RANGE10_HIGH NUMBER

Bucket Value
UPDATABLE VARCHAR2 (1)
Updatable Flag(T/F)
EXPANDABLE VARCHAR2 (1)
Expandable Flag(T/F)
DISCONTINUOUS VARCHAR2 (1)
Discontinuous Flag(T/F)
OVERLAPPING VARCHAR2 (1)
Overlapping Flag(T/F)
UOM VARCHAR2 (10)
Unit of Measure
CREATION_DATE DATE
Y The Creation Date
CREATED_BY NUMBER
Y The Created By Column
LAST_UPDATE_DATE DATE
Y Last Update Date Column
LAST_UPDATED_BY NUMBER
Y The Updated By Column
LAST_UPDATE_LOGIN NUMBER

Last Update Login Column

[top of page]

BIS.BIS_BUCKET does not reference any database object

BIS.BIS_BUCKET is referenced by following:

BIS
VIEW - BIS_BUCKET#

[top of page]

Table: BIS_BUCKET_CUSTOMIZATIONS

Description:
Comments

This is a customization table for bis bucket.

Indexes
Index Type Tablespace Column
BIS_BUCKET_CUSTOMIZATIONS_U1 UNIQUE APPS_TS_TX_IDX BUCKET_ID
USER_ID
RESPONSIBILITY_ID
ORG_ID
APPLICATION_ID
SITE_ID
PAGE_ID
FUNCTION_ID
Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Y Customization id.
BUCKET_ID NUMBER
Y Bucket id.
USER_ID NUMBER

User id.
RESPONSIBILITY_ID NUMBER

Responsibility id.
ORG_ID NUMBER

Org id.
APPLICATION_ID NUMBER

Application id.
SITE_ID NUMBER

Site id.
PAGE_ID NUMBER

Page id.
FUNCTION_ID NUMBER

Function id.
RANGE1_LOW NUMBER

Low range number for bucket1.
RANGE1_HIGH NUMBER

High range number for bucket1.
RANGE2_LOW NUMBER

Low range number for bucket2.
RANGE2_HIGH NUMBER

High range number for bucket2.
RANGE3_LOW NUMBER

Low range number for bucket3.
RANGE3_HIGH NUMBER

High range number for bucket3.
RANGE4_LOW NUMBER

Low range number for bucket4.
RANGE4_HIGH NUMBER

High range number for bucket4.
RANGE5_LOW NUMBER

Low range number for bucket5.
RANGE5_HIGH NUMBER

High range number for bucket5.
RANGE6_LOW NUMBER

Low range number for bucket6.
RANGE6_HIGH NUMBER

High range number for bucket6.
RANGE7_LOW NUMBER

Low range number for bucket7.
RANGE7_HIGH NUMBER

High range number for bucket7.
RANGE8_LOW NUMBER

Low range number for bucket8.
RANGE8_HIGH NUMBER

High range number for bucket8.
RANGE9_LOW NUMBER

Low range number for bucket9.
RANGE9_HIGH NUMBER

High range number for bucket9.
RANGE10_LOW NUMBER

Low range number for bucket10.
RANGE10_HIGH NUMBER

High range number for bucket10.
CREATED_BY NUMBER
Y Standard who column.
CREATION_DATE DATE
Y Standard who column.
LAST_UPDATED_BY NUMBER
Y Standard who column.
LAST_UPDATE_DATE DATE
Y Standard who column.
LAST_UPDATE_LOGIN NUMBER

Standard who column.
CUSTOMIZED VARCHAR2 (1)
Customized

[top of page]

BIS.BIS_BUCKET_CUSTOMIZATIONS does not reference any database object

BIS.BIS_BUCKET_CUSTOMIZATIONS is referenced by following:

BIS
VIEW - BIS_BUCKET_CUSTOMIZATIONS#

[top of page]

Table: BIS_BUCKET_CUSTOMIZATIONS_TL

Description:
Comments

This is the customization tl table for bis bucket.

Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Y Customization id.
RANGE1_NAME VARCHAR2 (80)
Range name for bucket1.
RANGE2_NAME VARCHAR2 (80)
Range name for bucket2.
RANGE3_NAME VARCHAR2 (80)
Range name for bucket3.
RANGE4_NAME VARCHAR2 (80)
Range name for bucket4.
RANGE5_NAME VARCHAR2 (80)
Range name for bucket5.
RANGE6_NAME VARCHAR2 (80)
Range name for bucket6.
RANGE7_NAME VARCHAR2 (80)
Range name for bucket7.
RANGE8_NAME VARCHAR2 (80)
Range name for bucket8.
RANGE9_NAME VARCHAR2 (80)
Range name for bucket9.
RANGE10_NAME VARCHAR2 (80)
Range name for bucket10.
LANGUAGE VARCHAR2 (4) Y Language.
TRANSLATED VARCHAR2 (1)
Translated flag.
SOURCE_LANG VARCHAR2 (4) Y Source language.
CREATED_BY NUMBER
Y Standard who column.
CREATION_DATE DATE
Y Standard who column.
LAST_UPDATED_BY NUMBER
Y Standard who column.
LAST_UPDATE_DATE DATE
Y Standard who column.
LAST_UPDATE_LOGIN NUMBER

Standard who column.

[top of page]

BIS.BIS_BUCKET_CUSTOMIZATIONS_TL does not reference any database object

BIS.BIS_BUCKET_CUSTOMIZATIONS_TL is referenced by following:

BIS
VIEW - BIS_BUCKET_CUSTOMIZATIONS_TL#

[top of page]

Table: BIS_BUCKET_TL

Description:
Comments

This table stores the translatable values for the Bucket.

Indexes
Index Type Tablespace Column
BIS_BUCKET_TL_U1 NONUNIQUE APPS_TS_TX_IDX BUCKET_ID
LANGUAGE
NAME
Columns
Name Datatype Length Mandatory Comments
BUCKET_ID NUMBER
Y Bucket Id
LANGUAGE VARCHAR2 (4) Y Language
NAME VARCHAR2 (80) Y The Bucket Name Column
RANGE1_NAME VARCHAR2 (80)
The Range Name Column
RANGE2_NAME VARCHAR2 (80)
The Range Name Column
RANGE3_NAME VARCHAR2 (80)
The Range Name Column
RANGE4_NAME VARCHAR2 (80)
The Range Name Column
RANGE5_NAME VARCHAR2 (80)
The Range Name Column
RANGE6_NAME VARCHAR2 (80)
The Range Name Column
RANGE7_NAME VARCHAR2 (80)
The Range Name Column
RANGE8_NAME VARCHAR2 (80)
The Range Name Column
RANGE9_NAME VARCHAR2 (80)
The Range Name Column
RANGE10_NAME VARCHAR2 (80)
The Range Name Column
DESCRIPTION VARCHAR2 (240)
The Description Column
TRANSLATED VARCHAR2 (1)
This column denotes if the value has been translated.
SOURCE_LANG VARCHAR2 (4) Y The Source Language Column
CREATION_DATE DATE
Y The Creation Date
CREATED_BY NUMBER
Y The Created By Column
LAST_UPDATE_DATE DATE
Y The Last Update Date Column
LAST_UPDATED_BY NUMBER
Y The Last Updated By Column
LAST_UPDATE_LOGIN NUMBER

Last Update Login Column

[top of page]

BIS.BIS_BUCKET_TL does not reference any database object

BIS.BIS_BUCKET_TL is referenced by following:

BIS
VIEW - BIS_BUCKET_TL#

[top of page]

Table: BIS_DIMENSIONS

Description:

A dimension represents a unique way of partitioning rows in a transaction table.
Examples of dimensions include time, geography, organization, and product.
A transaction usually happens at a well-defined time, at a well-defined

Comments

A dimension represents a unique way of partitioning rows in a transaction table.
Examples of dimensions include time, geography, organization, and product.
A transaction usually happens at a well-defined time, at a well-defined place,
in a particular organizational unit.
BIS_DIMENSIONS is a flat list of all dimensions used throughout the BIS product.

Indexes
Index Type Tablespace Column
BIS_DIMENSIONS_U1 UNIQUE APPS_TS_TX_IDX DIMENSION_ID
BIS_DIMENSIONS_U2 UNIQUE APPS_TS_TX_IDX SHORT_NAME
Columns
Name Datatype Length Mandatory Comments
DIMENSION_ID NUMBER
Y Dimension Defining Column
SHORT_NAME VARCHAR2 (30) Y Short Name for the Dimensions
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created 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_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
DIM_GRP_ID NUMBER

Dimension Group Describing Column
APPLICATION_ID NUMBER

Application Id
HIDE_IN_DESIGN VARCHAR2 (1)

[top of page]

BIS.BIS_DIMENSIONS does not reference any database object

BIS.BIS_DIMENSIONS is referenced by following:

BIS
VIEW - BIS_DIMENSIONS#

[top of page]

Table: BIS_DIMENSIONS_TL

Description:
Comments

Table contains translated names and descriptions for each row in BIS_DIMENSIONS,
in each supported language.

Indexes
Index Type Tablespace Column
BIS_DIMENSIONS_TL_U1 UNIQUE APPS_TS_TX_IDX DIMENSION_ID
LANGUAGE
BIS_DIMENSIONS_TL_U2 UNIQUE APPS_TS_TX_IDX LANGUAGE
NAME
Columns
Name Datatype Length Mandatory Comments
DIMENSION_ID NUMBER
Y Dimension Defining Column
LANGUAGE VARCHAR2 (30) Y Language code
NAME VARCHAR2 (255) Y Long Name for the Dimension
DESCRIPTION VARCHAR2 (1024)
Description for Dimension
TRANSLATED VARCHAR2 (1)
TRANSLATED
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.
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created 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_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).

[top of page]

BIS.BIS_DIMENSIONS_TL does not reference any database object

BIS.BIS_DIMENSIONS_TL is referenced by following:

BIS
VIEW - BIS_DIMENSIONS_TL#

[top of page]

Table: BIS_FLEX_SEG_MAPPING_LINES

Description:
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
BIS_FLEX_SEG_MAPPING_LINES_U1 UNIQUE APPS_TS_TX_IDX SEG_MAPPING_LINE_ID
Columns
Name Datatype Length Mandatory Comments
SEG_MAPPING_LINE_ID NUMBER (10) Y
SEGMENT_NAME VARCHAR2 (30) Y
APPLICATION_ID NUMBER (10) Y
ID_FLEX_CODE VARCHAR2 (40) Y
STRUCTURE_NUM NUMBER (15)
STRUCTURE_NAME VARCHAR2 (30)
APPLICATION_COLUMN_NAME VARCHAR2 (30) Y
VALUE_SET_ID NUMBER (10) Y
INSTANCE_CODE VARCHAR2 (30)
DIMENSION_ID NUMBER (10) Y
LEVEL_ID NUMBER (10) Y
WH_DIMENSION_NAME VARCHAR2 (30)
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).
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).
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.

[top of page]

BIS.BIS_FLEX_SEG_MAPPING_LINES does not reference any database object

BIS.BIS_FLEX_SEG_MAPPING_LINES is referenced by following:

BIS
VIEW - BIS_FLEX_SEG_MAPPING_LINES#

[top of page]

Table: BIS_LEVELS

Description:

BIS_LEVELS lists all the terms which can be used to define a level of partitioning along a particular dimension. For example, "month", "quarter" and "year" are all levels at which records can grouped in the time domension.
Levels

Comments

BIS_LEVELS lists all the terms which can be used to define a level of partitioning along a particular dimension. For example, "month", "quarter" and "year" are all levels at which records can grouped in the time domension.
Levels for the geography dimesion would include "city", "state" and "country".

Indexes
Index Type Tablespace Column
BIS_LEVELS_U1 UNIQUE APPS_TS_TX_IDX LEVEL_ID
BIS_LEVELS_U2 UNIQUE APPS_TS_TX_IDX SHORT_NAME
BIS_LEVELS_N1 NONUNIQUE APPS_TS_TX_IDX LEVEL_VALUES_VIEW_NAME
Columns
Name Datatype Length Mandatory Comments
LEVEL_ID NUMBER
Y Dimension Level ID
SHORT_NAME VARCHAR2 (30) Y Dimension Level Short Name
DIMENSION_ID NUMBER
Y Dimension ID. The dimension that the level belongs to.
LEVEL_VALUES_VIEW_NAME VARCHAR2 (30)
View associated to the Level. This view provides the data from the source system for the level.
WHERE_CLAUSE VARCHAR2 (2000)
No Longer Used
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created 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_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SOURCE VARCHAR2 (30) Y Source system type for the dimension level, such as OLTP or EDW.
COMPARISON_LABEL_CODE VARCHAR2 (30)
Comparison Label Code
ATTRIBUTE_CODE VARCHAR2 (30)
Attribute Code
APPLICATION_ID NUMBER

Application Id
VIEW_OBJECT_NAME VARCHAR2 (255)
View Object Name
DEFAULT_VALUES_API VARCHAR2 (255)
Default Values API
DEFAULT_SEARCH VARCHAR2 (480)
Default Search
LONG_LOV VARCHAR2 (1)
Long LOV
MASTER_LEVEL VARCHAR2 (30)
Master Level
ENABLED VARCHAR2 (1)
Enabled , T or F
DRILL_TO_FORM_FUNCTION VARCHAR2 (480)
Drill To Form Function
HIDE_IN_DESIGN VARCHAR2 (1)

[top of page]

BIS.BIS_LEVELS does not reference any database object

BIS.BIS_LEVELS is referenced by following:

BIS
VIEW - BIS_LEVELS#

[top of page]

Table: BIS_LEVELS_TL

Description:
Comments

Table contains translated names and descriptions for each row in BIS_LEVELS,,
in each supported language.

Indexes
Index Type Tablespace Column
BIS_LEVELS_TL_U1 UNIQUE APPS_TS_TX_IDX LEVEL_ID
LANGUAGE
BIS_LEVELS_TL_U2 UNIQUE APPS_TS_TX_IDX LANGUAGE
NAME
LEVEL_ID
Columns
Name Datatype Length Mandatory Comments
LEVEL_ID NUMBER
Y Dimension Level ID
LANGUAGE VARCHAR2 (30) Y Language code
NAME VARCHAR2 (255) Y Long name for the dimension level
DESCRIPTION VARCHAR2 (1024)
Description for the dimension level
TRANSLATED VARCHAR2 (1)
TRANSLATED
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.
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created 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_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).

[top of page]

BIS.BIS_LEVELS_TL does not reference any database object

BIS.BIS_LEVELS_TL is referenced by following:

BIS
VIEW - BIS_LEVELS_TL#

[top of page]

Table: BIS_OBJ_DEPENDENCY

Description:
Comments

This table stores the relationship between objects

Indexes
Index Type Tablespace Column
BIS_OBJ_DEPENDENCY_U1 UNIQUE APPS_TS_TX_IDX OBJECT_TYPE
OBJECT_NAME
DEPEND_OBJECT_TYPE
DEPEND_OBJECT_NAME
ZD_EDITION_NAME
BIS_OBJ_DEPENDENCY_N1 NONUNIQUE APPS_TS_TX_IDX DEPEND_OBJECT_NAME
BIS_OBJ_DEPENDENCY_N3 NONUNIQUE APPS_TS_TX_IDX OBJECT_NAME
DEPEND_OBJECT_NAME
Columns
Name Datatype Length Mandatory Comments
OBJECT_TYPE VARCHAR2 (30) Y Description
OBJECT_OWNER VARCHAR2 (50) Y Description
OBJECT_NAME VARCHAR2 (480) Y Description
ENABLED_FLAG VARCHAR2 (1)
Description
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.
DEPEND_OBJECT_TYPE VARCHAR2 (30) Y Description
DEPEND_OBJECT_OWNER VARCHAR2 (30) Y Description
DEPEND_OBJECT_NAME VARCHAR2 (480) Y Description
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BIS.BIS_OBJ_DEPENDENCY does not reference any database object

BIS.BIS_OBJ_DEPENDENCY is referenced by following:

BIS
VIEW - BIS_OBJ_DEPENDENCY#

[top of page]

Table: BIS_OBJ_INDEXES

Description: BIS_OBJ_INDEXES stores the Indexes for Business Intelligence Objects.
Comments
Indexes
Index Type Tablespace Column
BIS_OBJ_INDEXES_U1 UNIQUE APPS_TS_TX_IDX OBJECT_NAME
OBJECT_TYPE
INDEX_NAME
SYS_IL0000394932C00004$$ UNIQUE APPS_TS_TX_DATA
BIS_OBJ_INDEXES_N2 NONUNIQUE APPS_TS_TX_IDX INDEX_NAME
Columns
Name Datatype Length Mandatory Comments
OBJECT_NAME VARCHAR2 (240) Y Materialized view name
OBJECT_TYPE VARCHAR2 (30) Y Type of the object.
INDEX_NAME VARCHAR2 (30) Y Index name
INDEX_SQL CLOB (4000)
Index creation statementThe value will be populated by MV refresh program before the MV being refreshed
CREATION_DATE DATE
Y Who Column
CREATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)
Who Column for login info

[top of page]

BIS.BIS_OBJ_INDEXES does not reference any database object

BIS.BIS_OBJ_INDEXES is referenced by following:

BIS
VIEW - BIS_OBJ_INDEXES#

[top of page]

Table: BIS_OBJ_PROG_LINKAGES

Description:
Comments

This table stores the refresh programs for each object

Indexes
Index Type Tablespace Column
BIS_OBJ_PROG_LINKAGES_U1 UNIQUE APPS_TS_TX_IDX OBJECT_TYPE
OBJECT_NAME
CONC_APP_ID
CONC_PROGRAM_NAME
ZD_EDITION_NAME
BIS_OBJ_PROG_LINKAGES_N1 NONUNIQUE APPS_TS_TX_IDX CONC_APP_ID
CONC_PROGRAM_NAME
Columns
Name Datatype Length Mandatory Comments
OBJECT_TYPE VARCHAR2 (30) Y Description
OBJECT_OWNER VARCHAR2 (50) Y Description
OBJECT_NAME VARCHAR2 (480) Y Description
CONC_PROGRAM_NAME VARCHAR2 (30) Y Description
CONC_APP_ID NUMBER (15) Y Description
CONC_APP_SHORT_NAME VARCHAR2 (50)
Description
ENABLED_FLAG VARCHAR2 (1)
Description
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.
REFRESH_MODE VARCHAR2 (30)
Description
ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BIS.BIS_OBJ_PROG_LINKAGES does not reference any database object

BIS.BIS_OBJ_PROG_LINKAGES is referenced by following:

BIS
VIEW - BIS_OBJ_PROG_LINKAGES#

[top of page]

Table: BIS_OBJ_PROPERTIES

Description:

This table stores business intelligence objects properties

Comments

This table stores business intelligence objects properties

Indexes
Index Type Tablespace Column
BIS_OBJ_PROPERTIES_U1 UNIQUE APPS_TS_TX_IDX OBJECT_NAME
OBJECT_TYPE
ZD_EDITION_NAME
SYS_IL0000323826C00014$$ UNIQUE APPS_TS_TX_DATA
BIS_OBJ_PROPERTIES_N1 NONUNIQUE APPS_TS_TX_IDX OBJECT_TYPE
Columns
Name Datatype Length Mandatory Comments
OBJECT_TYPE VARCHAR2 (30) Y
OBJECT_NAME VARCHAR2 (480) Y
OBJECT_OWNER VARCHAR2 (50)
FAST_REFRESH_FLAG VARCHAR2 (1)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Y
LAST_REFRESH_DATE DATE

DIMENSION_FLAG VARCHAR2 (1)
IMPLEMENTATION_FLAG VARCHAR2 (1)
Implementation flag
CUSTOM_API VARCHAR2 (80)
SNAPSHOT_LOG_SQL CLOB (4000)
DROP_CREATE_INDEX_FLAG VARCHAR2 (1)
MV_LOG_STATUS VARCHAR2 (30)
STATUS_TIME_STAMP DATE

OBJECT_CREATION_DATE DATE

ZD_EDITION_NAME VARCHAR2 (30) Y

[top of page]

BIS.BIS_OBJ_PROPERTIES does not reference any database object

BIS.BIS_OBJ_PROPERTIES is referenced by following:

BIS
VIEW - BIS_OBJ_PROPERTIES#

[top of page]

Table: BIS_OBJ_REFRESH_HISTORY

Description: BIS_OBJ_REFRESH_HISTORY stores the Objects Refresh Information along with the programs used to refresh this objects.
Comments
Indexes
Index Type Tablespace Column
BIS_OBJ_REFRESH_HISTORY_U1 UNIQUE APPS_TS_TX_IDX PROG_REQUEST_ID
OBJECT_NAME
OBJECT_TYPE
BIS_OBJ_REFRESH_HISTORY_N2 NONUNIQUE APPS_TS_TX_IDX OBJECT_NAME
OBJECT_TYPE
Columns
Name Datatype Length Mandatory Comments
PROG_REQUEST_ID NUMBER
Y Concurrent request id for the object refresh program
OBJECT_TYPE VARCHAR2 (30) Y Object type for the object refreshed by the program
OBJECT_NAME VARCHAR2 (480) Y Object name for the object refreshed by the program
REFRESH_TYPE VARCHAR2 (30)
The way that the object gets refreshed in current run. Incremental (INCR), initial (INIT), or consider refresh for MV or analyzed.
OBJECT_ROW_COUNT NUMBER

The number of rows in an object
OBJECT_SPACE_USAGE NUMBER

The space occupied by the object
TABLESPACE_NAME VARCHAR2 (30)
The tablespace name
FREE_TABLESPACE_SIZE NUMBER

The size of the free tablespace
CREATION_DATE DATE
Y Row Creation Date (Who Column)
CREATED_BY NUMBER
Y Row created by (Who Column)
LAST_UPDATE_DATE DATE
Y Row Last Update date (Who Column)
LAST_UPDATED_BY NUMBER
Y row Last updated by (Who Column)

[top of page]

BIS.BIS_OBJ_REFRESH_HISTORY does not reference any database object

BIS.BIS_OBJ_REFRESH_HISTORY is referenced by following:

BIS
VIEW - BIS_OBJ_REFRESH_HISTORY#

[top of page]

Table: BIS_REFRESH_LOG

Description:
Comments

BIS_REFRESH_LOG

Indexes
Index Type Tablespace Column
BIS_REFRESH_LOG_N1 NONUNIQUE APPS_TS_TX_IDX REQUEST_ID
BIS_REFRESH_LOG_N2 NONUNIQUE APPS_TS_TX_IDX OBJECT_TYPE
BIS_REFRESH_LOG_N3 NONUNIQUE APPS_TS_TX_IDX OBJECT_NAME
Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
CONCURRENT_ID NUMBER

Description
OBJECT_TYPE VARCHAR2 (100)
Description
OBJECT_NAME VARCHAR2 (2000)
Description
STATUS VARCHAR2 (40)
Description
START_DATE DATE

Description
PERIOD_FROM DATE

Description
PERIOD_TO DATE

Description
NUMBER_PROCESSED_RECORD NUMBER

Description
EXCEPTION_MESSAGE VARCHAR2 (4000)
Description
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ERROR_TYPE VARCHAR2 (30)
Validation type
CORRECTIVE_ACTION_FF VARCHAR2 (30)
Form function name

[top of page]

BIS.BIS_REFRESH_LOG does not reference any database object

BIS.BIS_REFRESH_LOG is referenced by following:

BIS
VIEW - BIS_REFRESH_LOG#

[top of page]

Table: BIS_REQUEST_SET_OBJECTS

Description:

This table stores the relationship between objects and request sets

Comments

This table stores the relationship between objects and request sets

Indexes
Index Type Tablespace Column
BIS_REQUEST_SET_OBJECTS_U1 UNIQUE APPS_TS_TX_IDX REQUEST_SET_NAME
SET_APP_ID
OBJECT_TYPE
OBJECT_NAME
BIS_REQUEST_SET_OBJECTS_N1 NONUNIQUE APPS_TS_TX_IDX OBJECT_NAME
Columns
Name Datatype Length Mandatory Comments
REQUEST_SET_NAME VARCHAR2 (30) Y
SET_APP_ID NUMBER (15) Y
OBJECT_TYPE VARCHAR2 (30) Y
OBJECT_NAME VARCHAR2 (480) Y
OBJECT_OWNER VARCHAR2 (30)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE

[top of page]

BIS.BIS_REQUEST_SET_OBJECTS does not reference any database object

BIS.BIS_REQUEST_SET_OBJECTS is referenced by following:

BIS
VIEW - BIS_REQUEST_SET_OBJECTS#

[top of page]

Table: BIS_REQUEST_SET_OPTIONS

Description:

This table stores the request set options

Comments

This table stores the request set options

Indexes
Index Type Tablespace Column
BIS_REQUEST_SET_OPTIONS_N1 NONUNIQUE APPS_TS_TX_IDX REQUEST_SET_NAME
Columns
Name Datatype Length Mandatory Comments
REQUEST_SET_NAME VARCHAR2 (30) Y
SET_APP_ID NUMBER (15) Y
OPTION_NAME VARCHAR2 (30)
OPTION_VALUE VARCHAR2 (30)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE

[top of page]

BIS.BIS_REQUEST_SET_OPTIONS does not reference any database object

BIS.BIS_REQUEST_SET_OPTIONS is referenced by following:

BIS
VIEW - BIS_REQUEST_SET_OPTIONS#

[top of page]

Table: BIS_RS_PROG_RUN_HISTORY

Description: BIS_RS_PROG_RUN_HISTORY stores the Program Information for each RequestSet at various stages.
Comments
Indexes
Index Type Tablespace Column
BIS_RS_PROG_RUN_HISTORY_U1 UNIQUE APPS_TS_TX_IDX REQUEST_ID
BIS_RS_PROG_RUN_HISTORY_N1 NONUNIQUE APPS_TS_TX_IDX PROGRAM_ID
PROG_APP_ID
Columns
Name Datatype Length Mandatory Comments
SET_REQUEST_ID NUMBER
Y The request id for the request set
STAGE_REQUEST_ID NUMBER

The request id for the stage
REQUEST_ID NUMBER
Y Concurrent request id for the program
PROGRAM_ID NUMBER
Y Concurrent program id
PROG_APP_ID NUMBER
Y Concurrent program application id
STATUS_CODE VARCHAR2 (1)
Concurrent request status
PHASE_CODE VARCHAR2 (1)
The request phase code
START_DATE DATE
Y The request start date
COMPLETION_DATE DATE

The request completion date
COMPLETION_TEXT VARCHAR2 (240)
The request Completion text.
CREATION_DATE DATE
Y Row Creation Date (Who Column)
CREATED_BY NUMBER
Y Row created by (Who Column)
LAST_UPDATED_BY NUMBER
Y row Last updated by (Who Column)
LAST_UPDATE_DATE DATE
Y Row Last Update date (Who Column)

[top of page]

BIS.BIS_RS_PROG_RUN_HISTORY does not reference any database object

BIS.BIS_RS_PROG_RUN_HISTORY is referenced by following:

BIS
VIEW - BIS_RS_PROG_RUN_HISTORY#

[top of page]

Table: BIS_RS_RUN_HISTORY

Description: BIS_RS_RUN_HISTORY stores the Request Set Information.
Comments
Indexes
Index Type Tablespace Column
BIS_RS_RUN_HISTORY_U1 UNIQUE APPS_TS_TX_IDX REQUEST_ID
BIS_RS_RUN_HISTORY_N1 NONUNIQUE APPS_TS_TX_IDX REQUEST_SET_ID
SET_APP_ID
Columns
Name Datatype Length Mandatory Comments
REQUEST_SET_NAME VARCHAR2 (30)
REQUEST_SET_ID NUMBER
Y Request set identifier
SET_APP_ID NUMBER
Y Request set application identifier
REQUEST_SET_TYPE VARCHAR2 (30) Y Request set Type
REQUEST_ID NUMBER
Y Concurrent request identifier for the request set
START_DATE DATE
Y The request start date
COMPLETION_DATE DATE

The request end date
STATUS_CODE VARCHAR2 (1)
The request status
PHASE_CODE VARCHAR2 (1)
The request phase code
COMPLETION_TEXT VARCHAR2 (240)
The request Completion text.
CREATION_DATE DATE
Y Creation Date of the row
CREATED_BY NUMBER
Y Row created by (Who Column)
LAST_UPDATE_DATE DATE
Y Row Last Updated by (Who Column)
LAST_UPDATED_BY NUMBER
Y row Last updated by (Who Column)

[top of page]

BIS.BIS_RS_RUN_HISTORY does not reference any database object

BIS.BIS_RS_RUN_HISTORY is referenced by following:

BIS
VIEW - BIS_RS_RUN_HISTORY#

[top of page]

Table: BIS_RS_STAGE_RUN_HISTORY

Description: BIS_RS_STAGE_RUN_HISTORY stores the various stages of a Request Set
Comments
Indexes
Index Type Tablespace Column
BIS_RS_STAGE_RUN_HISTORY_U1 UNIQUE APPS_TS_TX_IDX REQUEST_ID
BIS_RS_STAGE_RUN_HISTORY_N1 NONUNIQUE APPS_TS_TX_IDX REQUEST_SET_ID
SET_APP_ID
STAGE_ID
BIS_RS_STAGE_RUN_HISTORY_N2 NONUNIQUE APPS_TS_TX_IDX SET_REQUEST_ID
Columns
Name Datatype Length Mandatory Comments
REQUEST_SET_ID NUMBER
Y Request set identifier
SET_APP_ID NUMBER
Y Request set application identifier
STAGE_ID NUMBER
Y Stage identifier
SET_REQUEST_ID NUMBER
Y Request id for the request set
REQUEST_ID NUMBER
Y Conc. Req. identifier for the stage
START_DATE DATE
Y The request start date
COMPLETION_DATE DATE

The request end date
STATUS_CODE VARCHAR2 (1)
The request status
PHASE_CODE VARCHAR2 (1)
The request phase code
COMPLETION_TEXT VARCHAR2 (240)
The request Completion text.
CREATION_DATE DATE
Y Row Creation Date (Who Column)
CREATED_BY NUMBER
Y Row created by (Who Column)
LAST_UPDATE_DATE DATE
Y row Last updated by (Who Column)
LAST_UPDATED_BY NUMBER
Y row Last updated by (Who Column)

[top of page]

BIS.BIS_RS_STAGE_RUN_HISTORY does not reference any database object

BIS.BIS_RS_STAGE_RUN_HISTORY is referenced by following:

BIS
VIEW - BIS_RS_STAGE_RUN_HISTORY#

[top of page]

Table: BIS_SYSTEM_DATE

Description:
Comments

BIS_SYSTEM_DATE

Columns
Name Datatype Length Mandatory Comments
CURRENT_DATE_ID DATE
Y Description

[top of page]

BIS.BIS_SYSTEM_DATE does not reference any database object

BIS.BIS_SYSTEM_DATE is referenced by following:

BIS
VIEW - BIS_SYSTEM_DATE#

[top of page]

Table: BIS_TERRITORY_HIERARCHIES

Description:
Comments

BIS_TERRITORY_HIERARCHIES is a list of aggreagation relationships between geographical entities. It defines which geographical territories (e.g the state of California, the town of Aptos) are a part of whihc larger geographical territories (e.g. the United States of America, the county of Santa Cruz.) This is necessary for producing reports which are broken down along the geographical dimension.

Indexes
Index Type Tablespace Column
BIS_TERRITORY_HIERARCHIES_U1 UNIQUE APPS_TS_TX_IDX PARENT_TERRITORY_CODE
PARENT_TERRITORY_TYPE
CHILD_TERRITORY_CODE
CHILD_TERRITORY_TYPE
Columns
Name Datatype Length Mandatory Comments
PARENT_TERRITORY_CODE VARCHAR2 (30) Y Description
PARENT_TERRITORY_TYPE VARCHAR2 (30) Y Description
CHILD_TERRITORY_CODE VARCHAR2 (30) Y Description
CHILD_TERRITORY_TYPE VARCHAR2 (30) Y Description
START_DATE_ACTIVE DATE

Description
END_DATE_ACTIVE DATE

Description
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]

BIS.BIS_TERRITORY_HIERARCHIES does not reference any database object

BIS.BIS_TERRITORY_HIERARCHIES is referenced by following:

BIS
VIEW - BIS_TERRITORY_HIERARCHIES#

[top of page]

Table: BIS_USER_ATTRIBUTES

Description:

This table stores the parameters selected by user

Comments

This table stores the parameters selected by user

Indexes
Index Type Tablespace Column
BIS_USER_ATTRIBUTES_N1 NONUNIQUE APPS_TS_TX_IDX SCHEDULE_ID
ATTRIBUTE_NAME
BIS_USER_ATTRIBUTES_N2 NONUNIQUE APPS_TS_TX_IDX USER_ID
FUNCTION_NAME
SESSION_ID
SCHEDULE_ID
BIS_USER_ATTRIBUTES_N3 NONUNIQUE APPS_TS_TX_IDX USER_ID
ATTRIBUTE_NAME
BIS_USER_ATTRIBUTES_N4 NONUNIQUE APPS_TS_TX_IDX USER_ID
PAGE_ID
Columns
Name Datatype Length Mandatory Comments
USER_ID NUMBER

SSWA Userid
FUNCTION_NAME VARCHAR2 (480)
SSWA function name
SESSION_ID VARCHAR2 (80)
SSWA Session id
SESSION_VALUE VARCHAR2 (2000)
Parameters session value
SESSION_DESCRIPTION VARCHAR2 (2000)
Parameters attribute description
DEFAULT_VALUE VARCHAR2 (2000)
Parameters default value
DEFAULT_DESCRIPTION VARCHAR2 (2000)
Parameters default attribute description
ATTRIBUTE_NAME VARCHAR2 (80)
Parameters attribute name
DIMENSION VARCHAR2 (80)
Dimension Name
PERIOD_DATE DATE

Period Date
SCHEDULE_ID NUMBER

Report Schedule Id
OPERATOR VARCHAR2 (2000)
PAGE_ID NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

[top of page]

BIS.BIS_USER_ATTRIBUTES does not reference any database object

BIS.BIS_USER_ATTRIBUTES is referenced by following:

BIS
VIEW - BIS_USER_ATTRIBUTES#

[top of page]

Table: EDW_MTL_ILDM_LOCATOR_LSTG

Description:
Comments

Staging Table for the LOCATOR level of the ILDM (Inventory Locator Dimension)

Indexes
Index Type Tablespace Column
EDW_MTL_ILDM_LOCATOR_LSTG_N1 NONUNIQUE APPS_TS_INTERFACE COLLECTION_STATUS
Columns
Name Datatype Length Mandatory Comments
COLLECTION_STATUS VARCHAR2 (30)
Collection Status [EDW tracking attribute] of this row
CREATION_DATE DATE

Creation Date of Inventory Location record on OLTP
DESCRIPTION VARCHAR2 (500)
Description of Inventory Location
ENABLED_FLAG VARCHAR2 (20)
Indicates whether Locator is active
ERROR_CODE VARCHAR2 (2000)
No Longer Used
INSTANCE_CODE VARCHAR2 (40)
Instance from which this row was pushed
LAST_UPDATE_DATE DATE

Last Update Date of Inventory Location record on OLTP
LOCATOR_DP VARCHAR2 (240)
EDW-internal ID for Locator
LOCATOR_NAME VARCHAR2 (500)
Locator Name
LOCATOR_PK VARCHAR2 (320)
Primary Key for Location (unique across instances and source-types)
NAME VARCHAR2 (2000)
Locator Name
OPERATION_CODE VARCHAR2 (30)
EDW-internal Indicator for operation to perform
REQUEST_ID NUMBER

Standard Row WHO Column
ROW_ID VARCHAR2 (20)
EDW-internal key for processing row
STOCK_ROOM_FK VARCHAR2 (240)
Source System FK for SubInventory Level
STOCK_ROOM_FK_KEY NUMBER

EDW (Surrogate) key for the SubInventory Level
USER_ATTRIBUTE1 VARCHAR2 (240)
1st Flexfield from Inventory Location record on OLTP
USER_ATTRIBUTE2 VARCHAR2 (240)
2nd Flexfield from Inventory Location record on OLTP
USER_ATTRIBUTE3 VARCHAR2 (240)
3rd Flexfield from Inventory Location record on OLTP
USER_ATTRIBUTE4 VARCHAR2 (240)
4th Flexfield from Inventory Location record on OLTP
USER_ATTRIBUTE5 VARCHAR2 (240)
5th Flexfield from Inventory Location record on OLTP

[top of page]

OPI.EDW_MTL_ILDM_LOCATOR_LSTG does not reference any database object

OPI.EDW_MTL_ILDM_LOCATOR_LSTG is referenced by following:

OPI
VIEW - EDW_MTL_ILDM_LOCATOR_LSTG#

[top of page]

Table: EDW_MTL_ILDM_LOCATOR_LTC

Description:
Comments

Level Table for the LOCATOR level of the ILDM (Inventory Locator Dimension)

Indexes
Index Type Tablespace Column
EDW_MTL_ILDM_LOCATOR_LTC_U UNIQUE APPS_TS_SUMMARY LOCATOR_PK
EDW_MTL_ILDM_LOCATOR_LTC_UKEY UNIQUE APPS_TS_SUMMARY LOCATOR_PK_KEY
Columns
Name Datatype Length Mandatory Comments
CREATION_DATE DATE
Y Creation Date of Inventory Location record on OLTP
DESCRIPTION VARCHAR2 (240)
Description of Inventory Location
ENABLED_FLAG VARCHAR2 (20)
Indicates whether Locator is active
INSTANCE_CODE VARCHAR2 (40)
Instance from which this row was pushed
LAST_UPDATE_DATE DATE
Y Last Update Date of Inventory Location record on OLTP
LOCATOR_DP VARCHAR2 (240)
EDW-internal ID for Locator
LOCATOR_NAME VARCHAR2 (240)
Locator Name
LOCATOR_PK VARCHAR2 (320)
Primary Key for Location (unique across instances and source-types)
LOCATOR_PK_KEY NUMBER

EDW-assigned surrogate for Locator
NAME VARCHAR2 (2000)
Locator Name
STOCK_ROOM_FK VARCHAR2 (240)
Source System FK for SubInventory Level
STOCK_ROOM_FK_KEY NUMBER

EDW (Surrogate) key for the SubInventory Level
USER_ATTRIBUTE1 VARCHAR2 (240)
1st Flexfield from Inventory Location record on OLTP
USER_ATTRIBUTE2 VARCHAR2 (240)
2nd Flexfield from Inventory Location record on OLTP
USER_ATTRIBUTE3 VARCHAR2 (240)
3rd Flexfield from Inventory Location record on OLTP
USER_ATTRIBUTE4 VARCHAR2 (240)
4th Flexfield from Inventory Location record on OLTP
USER_ATTRIBUTE5 VARCHAR2 (240)
5th Flexfield from Inventory Location record on OLTP

[top of page]

OPI.EDW_MTL_ILDM_LOCATOR_LTC does not reference any database object

OPI.EDW_MTL_ILDM_LOCATOR_LTC is referenced by following:

OPI
VIEW - EDW_MTL_ILDM_LOCATOR_LTC#

[top of page]

Table: EDW_MTL_ILDM_PLANT_LSTG

Description:
Comments
Indexes
Index Type Tablespace Column
EDW_MTL_ILDM_PLANT_LSTG_N1 NONUNIQUE APPS_TS_INTERFACE COLLECTION_STATUS
Columns
Name Datatype Length Mandatory Comments
COLLECTION_STATUS VARCHAR2 (30)
CREATION_DATE DATE

DESCRIPTION VARCHAR2 (500)
ERROR_CODE VARCHAR2 (2000)
INSTANCE_CODE VARCHAR2 (40)
LAST_UPDATE_DATE DATE

NAME VARCHAR2 (2000)
OPERATING_UNIT_FK VARCHAR2 (500)
OPERATING_UNIT_FK_KEY NUMBER

OPERATION_CODE VARCHAR2 (30)
OPM_ORGANIZATION_FK VARCHAR2 (200)
OPM_ORGANIZATION_FK_KEY NUMBER

ORGANIZATION_CODE VARCHAR2 (40)
ORGANIZATION_NAME VARCHAR2 (500)
PLANT_DP VARCHAR2 (240)
PLANT_PK VARCHAR2 (120)
REQUEST_ID NUMBER

ROW_ID NUMBER

USER_ATTRIBUTE1 VARCHAR2 (240)
USER_ATTRIBUTE2 VARCHAR2 (240)
USER_ATTRIBUTE3 VARCHAR2 (240)
USER_ATTRIBUTE4 VARCHAR2 (240)
USER_ATTRIBUTE5 VARCHAR2 (240)

[top of page]

OPI.EDW_MTL_ILDM_PLANT_LSTG does not reference any database object

OPI.EDW_MTL_ILDM_PLANT_LSTG is referenced by following:

OPI
VIEW - EDW_MTL_ILDM_PLANT_LSTG#

[top of page]

Table: EDW_MTL_ILDM_PLANT_LTC

Description:
Comments

Level Table for the Inventory Org level of the ILDM (Inventory Locator Dimension)

Indexes
Index Type Tablespace Column
EDW_MTL_ILDM_PLANT_LTC_U UNIQUE APPS_TS_SUMMARY PLANT_PK
EDW_MTL_ILDM_PLANT_LTC_UKEY UNIQUE APPS_TS_SUMMARY PLANT_PK_KEY
Columns
Name Datatype Length Mandatory Comments
CREATION_DATE DATE
Y Creation Date of Inventory Organization record on OLTP
DESCRIPTION VARCHAR2 (240)
Description of Inventory Organization
INSTANCE_CODE VARCHAR2 (40)
Instance from which this row was pushed
LAST_UPDATE_DATE DATE
Y Last Update Date of Inventory Organization record on OLTP
NAME VARCHAR2 (2000)
Name of Inventory Organization
OPERATING_UNIT_FK_KEY NUMBER

EDW-Assigned Surrogate Foreign Key to Operating Unit Level
OPM_ORGANIZATION_FK_KEY NUMBER

EDW-Assigned Surrogate Foreign Key to Inventory Org Group Level
ORGANIZATION_CODE VARCHAR2 (40)
Organization Code of Inventory Organization
ORGANIZATION_NAME VARCHAR2 (240)
Organization Name of Inventory Organization
PLANT_DP VARCHAR2 (240)
EDW-Internal Key for Inventory Organization
PLANT_PK VARCHAR2 (120)
Primary Key for Inventory Organization (include Instance)
PLANT_PK_KEY NUMBER

EDW-Assigned Surrogate Primary Key for Inventory Organization
USER_ATTRIBUTE1 VARCHAR2 (240)
1st Flexfield from Inventory Organization record on OLTP
USER_ATTRIBUTE2 VARCHAR2 (240)
2nd Flexfield from Inventory Organization record on OLTP
USER_ATTRIBUTE3 VARCHAR2 (240)
3rd Flexfield from Inventory Organization record on OLTP
USER_ATTRIBUTE4 VARCHAR2 (240)
4th Flexfield from Inventory Organization record on OLTP
USER_ATTRIBUTE5 VARCHAR2 (240)
5th Flexfield from Inventory Organization record on OLTP

[top of page]

OPI.EDW_MTL_ILDM_PLANT_LTC does not reference any database object

OPI.EDW_MTL_ILDM_PLANT_LTC is referenced by following:

OPI
VIEW - EDW_MTL_ILDM_PLANT_LTC#

[top of page]

Table: EDW_MTL_ILDM_SUB_INV_LSTG

Description:
Comments

Staging Table for the SUB_INVI (Sub Inventory) level of the ILDM (Inventory Locator Dimension)

Indexes
Index Type Tablespace Column
EDW_MTL_ILDM_SUB_INV_LSTG_N1 NONUNIQUE APPS_TS_INTERFACE COLLECTION_STATUS
Columns
Name Datatype Length Mandatory Comments
COLLECTION_STATUS VARCHAR2 (30)
Collection Status [EDW tracking attribute] of this row
CREATION_DATE DATE

Creation Date of SubInventory record on OLTP
DESCRIPTION VARCHAR2 (500)
Description of SubInventory in OLTP
ERROR_CODE VARCHAR2 (2000)
No Longer Used
INSTANCE_CODE VARCHAR2 (40)
Instance from which this row was pushed
LAST_UPDATE_DATE DATE

Last Update Date of Inventory Location record on OLTP
NAME VARCHAR2 (2000)
SubInventory Name
OPERATION_CODE VARCHAR2 (30)
EDW-internal Indicator for operation to perform
PLANT_FK VARCHAR2 (120)
Foreign Key to Inventory Organization Level
PLANT_FK_KEY NUMBER

EDW-internal Foreign Key to Inventory Organization Level
REQUEST_ID NUMBER

Standard Row WHO Column
ROW_ID VARCHAR2 (20)
EDW-internal ID for Organization Group
STOCK_ROOM VARCHAR2 (80)
SubInventory Name
STOCK_ROOM_DP VARCHAR2 (240)
EDW-internal ID for SubInventory
STOCK_ROOM_PK VARCHAR2 (240)
Primary Key for SubInventory (Includes Instance)
USER_ATTRIBUTE1 VARCHAR2 (240)
1st Flexfield from SubInventory record on OLTP
USER_ATTRIBUTE2 VARCHAR2 (240)
2nd Flexfield from SubInventory record on OLTP
USER_ATTRIBUTE3 VARCHAR2 (240)
3rd Flexfield from SubInventory record on OLTP
USER_ATTRIBUTE4 VARCHAR2 (240)
4th Flexfield from SubInventory record on OLTP
USER_ATTRIBUTE5 VARCHAR2 (240)
5th Flexfield from SubInventory record on OLTP

[top of page]

OPI.EDW_MTL_ILDM_SUB_INV_LSTG does not reference any database object

OPI.EDW_MTL_ILDM_SUB_INV_LSTG is referenced by following:

OPI
VIEW - EDW_MTL_ILDM_SUB_INV_LSTG#

[top of page]

Table: EDW_MTL_ILDM_SUB_INV_LTC

Description:
Comments

Level Table for the SUB_INV (Sub Inventory) level of the ILDM (Inventory Locator Dimension)

Indexes
Index Type Tablespace Column
EDW_MTL_ILDM_SUB_INV_LTC_U UNIQUE APPS_TS_SUMMARY STOCK_ROOM_PK
EDW_MTL_ILDM_SUB_INV_LTC_UKEY UNIQUE APPS_TS_SUMMARY STOCK_ROOM_PK_KEY
Columns
Name Datatype Length Mandatory Comments
CREATION_DATE DATE
Y Creation Date of SubInventory record on OLTP
DESCRIPTION VARCHAR2 (240)
Description of SubInventory in OLTP
INSTANCE_CODE VARCHAR2 (40)
Instance from which this row was pushed
LAST_UPDATE_DATE DATE
Y Last Update Date of Inventory Location record on OLTP
NAME VARCHAR2 (2000)
SubInventory Name
PLANT_FK_KEY NUMBER

EDW-internal Foreign Key to Inventory Organization Level
STOCK_ROOM VARCHAR2 (80)
SubInventory Name
STOCK_ROOM_DP VARCHAR2 (240)
EDW-internal ID for SubInventory
STOCK_ROOM_PK VARCHAR2 (240)
Primary Key for SubInventory (Includes Instance)
STOCK_ROOM_PK_KEY NUMBER

EDW-internal Surrogate Primary Key for SubInventory
USER_ATTRIBUTE1 VARCHAR2 (240)
1st Flexfield from SubInventory record on OLTP
USER_ATTRIBUTE2 VARCHAR2 (240)
2nd Flexfield from SubInventory record on OLTP
USER_ATTRIBUTE3 VARCHAR2 (240)
3rd Flexfield from SubInventory record on OLTP
USER_ATTRIBUTE4 VARCHAR2 (240)
4th Flexfield from SubInventory record on OLTP
USER_ATTRIBUTE5 VARCHAR2 (240)
5th Flexfield from SubInventory record on OLTP

[top of page]

OPI.EDW_MTL_ILDM_SUB_INV_LTC does not reference any database object

OPI.EDW_MTL_ILDM_SUB_INV_LTC is referenced by following:

OPI
VIEW - EDW_MTL_ILDM_SUB_INV_LTC#

[top of page]

Table: EDW_MTL_INVENTORY_LOC_M

Description:
Primary Key: EDW_MTL_ILDM_LOCATOR_UK
  1. INVL_LOCATOR_PK_KEY
Primary Key: EDW_MTL_INVENTORY_LOC_M_U
  1. INVL_LOCATOR_PK
Comments

Dimension Table for the Inventory Locator Dimension

Indexes
Index Type Tablespace Column
EDW_MTL_INVENTORY_LOC_M_P NONUNIQUE APPS_TS_SUMMARY INVL_LOCATOR_PK_KEY
EDW_MTL_INVENTORY_LOC_M_U NONUNIQUE APPS_TS_SUMMARY INVL_LOCATOR_PK
Columns
Name Datatype Length Mandatory Comments
ALL_NAME VARCHAR2 (80)
Name of the All Level
ALL_PK VARCHAR2 (40)
Primary Key of the All Level
ALL_PK_KEY NUMBER

EDW-Internal Surrogate key to the All Level
CREATION_DATE DATE
Y Creation Date
INVL_NAME VARCHAR2 (2000)
Locator Name
INVL_DESCRIPTION VARCHAR2 (240)
Description of Inventory Location
INVL_ENABLED_FLAG VARCHAR2 (20)
Indicates whether Locator is active
INVL_INSTANCE_CODE VARCHAR2 (40)
Instance from which this Locator was pushed
INVL_LOCATOR_DP VARCHAR2 (240)
EDW-internal ID for Locator
INVL_LOCATOR_NAME VARCHAR2 (240)
Locator Name
INVL_LOCATOR_PK VARCHAR2 (320)
Primary Key for Location (unique across instances and source-types)
INVL_LOCATOR_PK_KEY NUMBER
Y EDW-assigned surrogate for Locator
INVL_USER_ATTRIBUTE1 VARCHAR2 (240)
1st Flexfield from Inventory Location record on OLTP
INVL_USER_ATTRIBUTE2 VARCHAR2 (240)
2nd Flexfield from Inventory Location record on OLTP
INVL_USER_ATTRIBUTE3 VARCHAR2 (240)
3rd Flexfield from Inventory Location record on OLTP
INVL_USER_ATTRIBUTE4 VARCHAR2 (240)
4th Flexfield from Inventory Location record on OLTP
INVL_USER_ATTRIBUTE5 VARCHAR2 (240)
5th Flexfield from Inventory Location record on OLTP
LAST_UPDATE_DATE DATE
Y Last Update Date
OU_BUSINESS_GROUP VARCHAR2 (120)
Business Group attribute of Operating Unit Level
OU_DATE_FROM DATE

Beginning Effective Date for Operating Unit
OU_DATE_TO DATE

Ending Effective Date for Operating Unit
OU_INSTANCE_CODE VARCHAR2 (40)
Instance from which this Operating Unit was pushed
OU_INT_EXT_FLAG VARCHAR2 (120)
Flag indicates if Operating Unit is Internal or External
OU_NAME VARCHAR2 (320)
Operating Unit Name
OU_OPERATING_UNIT_DP VARCHAR2 (240)
EDW-internal ID for Operating Unit
OU_OPERATING_UNIT_PK VARCHAR2 (240)
Primary Key of Operating Unit
OU_OPERATING_UNIT_PK_KEY NUMBER

EDW-internal Surrogate Key for Operating Unit
OU_ORG_CODE VARCHAR2 (40)
Operating Unit Code
OU_ORG_TYPE VARCHAR2 (120)
Organization Type of Operating Unit
OU_PRIMARY_CST_MTHD VARCHAR2 (120)
Cost Method for Operating Unit
OU_USER_ATTRIBUTE1 VARCHAR2 (240)
1st Flexfield from Operating Unit record on OLTP
OU_USER_ATTRIBUTE2 VARCHAR2 (240)
2nd Flexfield from Operating Unit record on OLTP
OU_USER_ATTRIBUTE3 VARCHAR2 (240)
3rd Flexfield from Operating Unit record on OLTP
OU_USER_ATTRIBUTE4 VARCHAR2 (240)
4th Flexfield from Operating Unit record on OLTP
OU_USER_ATTRIBUTE5 VARCHAR2 (240)
5th Flexfield from Operating Unit record on OLTP
PCMP_DESCRIPTION VARCHAR2 (240)
Description of Inventory Organization Parent Group
PCMP_INSTANCE_CODE VARCHAR2 (40)
Instance from which this Parent Group was pushed
PCMP_NAME VARCHAR2 (320)
Name of Inventory Organization Parent Group
PCMP_OPM_COMPANY_PK VARCHAR2 (120)
Inventory Org Parent Group Primary Key (Includes Instance)
PCMP_OPM_COMPANY_CODE VARCHAR2 (40)
Organization Code of the Inventory Organization Parent Group
PCMP_OPM_COMPANY_DP VARCHAR2 (240)
EDW-internal ID for Parent Group
PCMP_OPM_COMPANY_NAME VARCHAR2 (120)
Name of Inventory Organization Parent Group
PCMP_OPM_COMPANY_PK_KEY NUMBER

Primary Key of Parent Group, unique across instances and system types
PCMP_USER_ATTRIBUTE1 VARCHAR2 (240)
1st Flexfield from Inventory Org Parent Group record on OLTP
PCMP_USER_ATTRIBUTE2 VARCHAR2 (240)
2nd Flexfield from Inventory Org Parent Group record on OLTP
PCMP_USER_ATTRIBUTE3 VARCHAR2 (240)
3rd Flexfield from Inventory Org Parent Group record on OLTP
PCMP_USER_ATTRIBUTE4 VARCHAR2 (240)
4th Flexfield from Inventory Org Parent Group record on OLTP
PCMP_USER_ATTRIBUTE5 VARCHAR2 (240)
5th Flexfield from Inventory Org Parent Group record on OLTP
PLNT_NAME VARCHAR2 (2000)
Name of Inventory Organization
PLNT_ORGANIZATION_NAME VARCHAR2 (240)
Name of Inventory Organization
PLNT_DESCRIPTION VARCHAR2 (240)
Description of Inventory Organization
PLNT_INSTANCE_CODE VARCHAR2 (40)
Instance from which this Inventory Organization was pushed
PLNT_ORGANIZATION_CODE VARCHAR2 (40)
Organization Code of the Inventory Organization
PLNT_PLANT_DP VARCHAR2 (240)
EDW-internal ID for Inventory Organization
PLNT_PLANT_PK VARCHAR2 (120)
Primary Key of Inventory Organization, unique across instances and system types
PLNT_PLANT_PK_KEY NUMBER

EDW-internal Surrogate Key for Inventory Organization
PLNT_USER_ATTRIBUTE1 VARCHAR2 (240)
1st Flexfield from Inventory Organization record on OLTP
PLNT_USER_ATTRIBUTE2 VARCHAR2 (240)
2nd Flexfield from Inventory Organization record on OLTP
PLNT_USER_ATTRIBUTE3 VARCHAR2 (240)
3rd Flexfield from Inventory Organization record on OLTP
PLNT_USER_ATTRIBUTE4 VARCHAR2 (240)
4th Flexfield from Inventory Organization record on OLTP
PLNT_USER_ATTRIBUTE5 VARCHAR2 (240)
5th Flexfield from Inventory Organization record on OLTP
PORG_DESCRIPTION VARCHAR2 (240)
Description of Inventory Organization Group
PORG_INSTANCE_CODE VARCHAR2 (40)
Instance from which this Inventory Organization Group was pushed
PORG_NAME VARCHAR2 (320)
Name of Inventory Organization Group
PORG_OPM_ORGANIZATION_CODE VARCHAR2 (80)
Organization Code of Inventory Organization Group
PORG_OPM_ORGANIZATION_DP VARCHAR2 (240)
EDW-internal ID for Inventory Organization Group
PORG_OPM_ORGANIZATION_NAME VARCHAR2 (240)
Name of the Inventory Organization Group
PORG_OPM_ORGANIZATION_PK VARCHAR2 (120)
Primary Key of Inventory Organization Group, unique across instances and system types
PORG_OPM_ORGANIZATION_PK_KEY NUMBER

EDW-internal ID for Inventory Organization Group
PORG_USER_ATTRIBUTE1 VARCHAR2 (240)
1st Flexfield from Inventory Organization Group record on OLTP
PORG_USER_ATTRIBUTE2 VARCHAR2 (240)
2nd Flexfield from Inventory Organization Group record on OLTP
PORG_USER_ATTRIBUTE3 VARCHAR2 (240)
3rd Flexfield from Inventory Organization Group record on OLTP
PORG_USER_ATTRIBUTE4 VARCHAR2 (240)
4th Flexfield from Inventory Organization Group record on OLTP
PORG_USER_ATTRIBUTE5 VARCHAR2 (240)
5th Flexfield from Inventory Organization Group record on OLTP
SUBI_NAME VARCHAR2 (2000)
Name of SubInventory
SUBI_DESCRIPTION VARCHAR2 (240)
Description of SubInventory
SUBI_INSTANCE_CODE VARCHAR2 (40)
Instance from which this SubInventory was pushed
SUBI_STOCK_ROOM VARCHAR2 (80)
SubInventory Name
SUBI_STOCK_ROOM_DP VARCHAR2 (240)
EDW-internal ID for SubInventory
SUBI_STOCK_ROOM_PK VARCHAR2 (240)
Primary Key of SubInventory, unique across instances and system types
SUBI_STOCK_ROOM_PK_KEY NUMBER

EDW-internal ID for SubInventory
SUBI_USER_ATTRIBUTE1 VARCHAR2 (240)
1st Flexfield from SubInventory record on OLTP
SUBI_USER_ATTRIBUTE2 VARCHAR2 (240)
2nd Flexfield from SubInventory record on OLTP
SUBI_USER_ATTRIBUTE3 VARCHAR2 (240)
3rd Flexfield from SubInventory record on OLTP
SUBI_USER_ATTRIBUTE4 VARCHAR2 (240)
4th Flexfield from SubInventory record on OLTP
SUBI_USER_ATTRIBUTE5 VARCHAR2 (240)
5th Flexfield from SubInventory record on OLTP

[top of page]

OPI.EDW_MTL_INVENTORY_LOC_M does not reference any database object

OPI.EDW_MTL_INVENTORY_LOC_M is referenced by following:

OPI
VIEW - EDW_MTL_INVENTORY_LOC_M#

[top of page]

View: BIS_BUCKET_CUSTOMIZATIONS_VL

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

View contains customized data for buckets.

Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Y Id
BUCKET_ID NUMBER
Y Bucket Id
USER_ID NUMBER

User Id
RESPONSIBILITY_ID NUMBER

Responsibility Id
ORG_ID NUMBER

Org Id
APPLICATION_ID NUMBER

Application Id
SITE_ID NUMBER

Site Id
PAGE_ID NUMBER

Page Id
FUNCTION_ID NUMBER

Function Id
RANGE1_LOW NUMBER

Range1 Low
RANGE1_HIGH NUMBER

Range1 High
RANGE2_LOW NUMBER

Range2 Low
RANGE2_HIGH NUMBER

Range2 High
RANGE3_LOW NUMBER

Range3 Low
RANGE3_HIGH NUMBER

Range3 High
RANGE4_LOW NUMBER

Range4 Low
RANGE4_HIGH NUMBER

Range4 High
RANGE5_LOW NUMBER

Range5 Low
RANGE5_HIGH NUMBER

Range5 High
RANGE6_LOW NUMBER

Range6 Low
RANGE6_HIGH NUMBER

Range6 High
RANGE7_LOW NUMBER

Range7 Low
RANGE7_HIGH NUMBER

Range7 High
RANGE8_LOW NUMBER

Range8 Low
RANGE8_HIGH NUMBER

Range8 High
RANGE9_LOW NUMBER

Range9 Low
RANGE9_HIGH NUMBER

Range9 High
RANGE10_LOW NUMBER

Range10 Low
RANGE10_HIGH NUMBER

Range10 High
CREATION_DATE DATE
Y Creation Date
CREATED_BY NUMBER
Y Created By
LAST_UPDATE_DATE DATE
Y Last Update Date
LAST_UPDATED_BY NUMBER
Y Last Update By
LAST_UPDATE_LOGIN NUMBER

Last Update Login
RANGE1_NAME VARCHAR2 (80)
Range1 Name
RANGE2_NAME VARCHAR2 (80)
Range2 Name
RANGE3_NAME VARCHAR2 (80)
Range3 Name
RANGE4_NAME VARCHAR2 (80)
Range4 Name
RANGE5_NAME VARCHAR2 (80)
Range5 Name
RANGE6_NAME VARCHAR2 (80)
Range6 Name
RANGE7_NAME VARCHAR2 (80)
Range7 Name
RANGE8_NAME VARCHAR2 (80)
Range8 Name
RANGE9_NAME VARCHAR2 (80)
Range9 Name
RANGE10_NAME VARCHAR2 (80)
Range10 Name
CUSTOMIZED VARCHAR2 (1)
Customized Flag
SHORT_NAME VARCHAR2 (30) Y Short name of bucket
TYPE VARCHAR2 (30) Y Type of Bucket
UPDATABLE VARCHAR2 (1)
UPDATABLE(T/F)
EXPANDABLE VARCHAR2 (1)
EXPANDABLE(T/F)
DISCONTINUOUS VARCHAR2 (1)
DISCONTINUOUS(T/F)
OVERLAPPING VARCHAR2 (1)
OVERLAPPING(T/F)
UOM VARCHAR2 (10)
Unit of Measure
NAME VARCHAR2 (80) Y Bucket Name
DESCRIPTION VARCHAR2 (240)
Bucket Description

[top of page]

APPS.BIS_BUCKET_CUSTOMIZATIONS_VL references the following:

APPS
SYNONYM - BIS_BUCKET
SYNONYM - BIS_BUCKET_CUSTOMIZATIONS
SYNONYM - BIS_BUCKET_CUSTOMIZATIONS_TL
SYNONYM - BIS_BUCKET_TL

APPS.BIS_BUCKET_CUSTOMIZATIONS_VL is not referenced by any database object

[top of page]

View: BIS_DIMENSIONS_VL

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
DIMENSION_ID NUMBER
Y
DIM_GRP_ID NUMBER

SHORT_NAME VARCHAR2 (30) Y
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created 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_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
HIDE_IN_DESIGN VARCHAR2 (1)
NAME VARCHAR2 (255) Y
DESCRIPTION VARCHAR2 (1024)

APPLICATION_ID NUMBER

Application Id

[top of page]

APPS.BIS_DIMENSIONS_VL references the following:

APPS
SYNONYM - BIS_DIMENSIONS
SYNONYM - BIS_DIMENSIONS_TL
APPS.BIS_DIMENSIONS_VL is referenced by following:

APPS
VIEW - BIS_FLEX_MAPPINGS_V

[top of page]

View: BIS_FLEX_FIELDS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER

APPLICATION_NAME VARCHAR2 (240)
FLEX_FIELD_CODE VARCHAR2 (40)
FLEX_FIELD_NAME VARCHAR2 (60)
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
FLEX_FIELD_TYPE CHAR (1)

[top of page]

APPS.BIS_FLEX_FIELDS_V references the following:

APPS
SYNONYM - FND_ID_FLEXS
- FND_DESCRIPTIVE_FLEXS_VL
- FND_APPLICATION_VL
APPS.BIS_FLEX_FIELDS_V is referenced by following:

APPS
VIEW - BIS_FLEX_MAPPINGS_V

[top of page]

View: BIS_FLEX_MAPPINGS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
SEG_MAPPING_LINE_ID NUMBER (10) Y
SEGMENT_NAME VARCHAR2 (30) Y
APPLICATION_ID NUMBER (10) Y
APPLICATION_NAME VARCHAR2 (240)
ID_FLEX_CODE VARCHAR2 (40) Y
FLEX_FIELD_NAME VARCHAR2 (60)
FLEX_FIELD_TYPE CHAR (1)
STRUCTURE_NUM NUMBER (15)
STRUCTURE_NAME VARCHAR2 (30)
APPLICATION_COLUMN_NAME VARCHAR2 (30) Y
VALUE_SET_ID NUMBER (10) Y
INSTANCE_CODE VARCHAR2 (30)
DIMENSION_ID NUMBER (10) Y
DIMENSION_NAME VARCHAR2 (255)
LEVEL_ID NUMBER (10) Y
LEVEL_SHORT_NAME VARCHAR2 (30)
LEVEL_NAME VARCHAR2 (255)
WH_DIMENSION_NAME VARCHAR2 (30)
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).
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).
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.

[top of page]

APPS.BIS_FLEX_MAPPINGS_V references the following:

APPS
VIEW - BIS_DIMENSIONS_VL
VIEW - BIS_FLEX_FIELDS_V
SYNONYM - BIS_FLEX_SEG_MAPPING_LINES
- BIS_LEVELS_VL

APPS.BIS_FLEX_MAPPINGS_V is not referenced by any database object

[top of page]

View: BIS_LEVELS_VL

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
LEVEL_ID NUMBER
Y
SHORT_NAME VARCHAR2 (30) Y
DIMENSION_ID NUMBER
Y
LEVEL_VALUES_VIEW_NAME VARCHAR2 (30)
WHERE_CLAUSE VARCHAR2 (2000)
CREATION_DATE DATE
Y Standard who column - date when this row was created.
CREATED_BY NUMBER
Y Standard who column - user who created 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_UPDATED_BY NUMBER
Y Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
NAME VARCHAR2 (255) Y
DESCRIPTION VARCHAR2 (1024)
SOURCE VARCHAR2 (30) Y
COMPARISON_LABEL_CODE VARCHAR2 (30)
Comparison Label Code
ATTRIBUTE_CODE VARCHAR2 (30)
Attribute Code
APPLICATION_ID NUMBER

Application Id
DEFAULT_SEARCH VARCHAR2 (480)
LONG_LOV VARCHAR2 (1)
MASTER_LEVEL VARCHAR2 (30)
ENABLED VARCHAR2 (1)
VIEW_OBJECT_NAME VARCHAR2 (255)
DEFAULT_VALUES_API VARCHAR2 (255)
DRILL_TO_FORM_FUNCTION VARCHAR2 (480)
Drill To Form Function
HIDE_IN_DESIGN VARCHAR2 (1)

[top of page]

APPS.BIS_LEVELS_VL references the following:

APPS
SYNONYM - BIS_LEVELS
SYNONYM - BIS_LEVELS_TL

APPS.BIS_LEVELS_VL is not referenced by any database object

[top of page]

View: BIS_ORGANIZATIONS_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

BIS inventory organization view with security informaiton.

Columns
Name Datatype Length Mandatory Comments
ID VARCHAR2 (40)
Organization ID.
VALUE VARCHAR2 (240) Y Organization Name.
RESPONSIBILITY_ID NUMBER

Responsibility ID.
EAM_ENABLED_FLAG VARCHAR2 (1)
Enterprise Asset Management Enabled Flag: Y = Yes, N = No.

[top of page]

APPS.BIS_ORGANIZATIONS_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - MTL_PARAMETERS
SYNONYM - ORG_ACCESS

APPS.BIS_ORGANIZATIONS_V is not referenced by any database object

[top of page]

View: BIS_TERRITORIES_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

BIS_TERRITORIES_V

Columns
Name Datatype Length Mandatory Comments
TERRITORY_CODE VARCHAR2 (30)
comment
NAME VARCHAR2 (80)
comment
DESCRIPTION VARCHAR2 (240)
comment
TYPE VARCHAR2 (30)
comment

[top of page]

APPS.BIS_TERRITORIES_V references the following:

APPS
PACKAGE - FND_GLOBAL
- FND_TERRITORIES_VL
- FND_LOOKUPS
APPS.BIS_TERRITORIES_V is referenced by following:

APPS
VIEW - BIS_TERRITORY_HIERARCHIES_V

[top of page]

View: BIS_TERRITORY_HIERARCHIES_V

Comments
View Type

A public view which may be useful for custom reporting or other data requirements.

BIS_TERRITORY_HIERARCHIES_V

Columns
Name Datatype Length Mandatory Comments
PARENT_TERRITORY_CODE VARCHAR2 (30) Y comment
PARENT_TERRITORY_TYPE VARCHAR2 (30) Y comment
PARENT_TERRITORY_NAME VARCHAR2 (80)
comment
CHILD_TERRITORY_CODE VARCHAR2 (30) Y comment
CHILD_TERRITORY_TYPE VARCHAR2 (30) Y comment
CHILD_TERRITORY_NAME VARCHAR2 (80)
comment
START_DATE DATE

comment
END_DATE DATE

comment
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]

APPS.BIS_TERRITORY_HIERARCHIES_V references the following:

APPS
VIEW - BIS_TERRITORIES_V
SYNONYM - BIS_TERRITORY_HIERARCHIES
PACKAGE - FND_GLOBAL

APPS.BIS_TERRITORY_HIERARCHIES_V is not referenced by any database object

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