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:

[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:

[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:

[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:

[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

[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:

[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:

[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

[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:

[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:

[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.

[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:

[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

[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.

[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:

[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

[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

[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.

[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.

[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

[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:

[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:

[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

[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:

[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:

[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:

[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:

[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:

[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:

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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