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

TABLE - BSC.BSC_APPS_USERS
TABLE - BSC.BSC_BIS_MEASURES_DATA
TABLE - BSC.BSC_COLOR_RANGES
TABLE - BSC.BSC_COLOR_TYPE_PROPS
TABLE - BSC.BSC_CURRENT_SESSIONS
TABLE - BSC.BSC_DB_CALCULATIONS
TABLE - BSC.BSC_DB_CALENDAR
TABLE - BSC.BSC_DB_LOADER_CONTROL
TABLE - BSC.BSC_DB_MEASURE_COLS_TL
TABLE - BSC.BSC_DB_MEASURE_GROUPS_TL
TABLE - BSC.BSC_DB_PROCESS_CONTROL
TABLE - BSC.BSC_DB_RESERVED_WORDS
TABLE - BSC.BSC_DB_TABLES
TABLE - BSC.BSC_DB_TABLES_COLS
TABLE - BSC.BSC_DB_TABLES_DISPLAY
TABLE - BSC.BSC_DB_TABLES_RELS
TABLE - BSC.BSC_DB_TABLES_RELS_DISPLAY
TABLE - BSC.BSC_DB_VALIDATION
TABLE - BSC.BSC_DB_WEEK_MAPS
TABLE - BSC.BSC_EDW_CALENDAR_TYPE_TL
TABLE - BSC.BSC_EDW_PERIODS_TL
TABLE - BSC.BSC_INSTALL_LOGS
TABLE - BSC.BSC_KPIS_B
TABLE - BSC.BSC_KPIS_TL
TABLE - BSC.BSC_KPI_ANALYSIS_GROUPS
TABLE - BSC.BSC_KPI_ANALYSIS_MEASURES_B
TABLE - BSC.BSC_KPI_ANALYSIS_MEASURES_TL
TABLE - BSC.BSC_KPI_ANALYSIS_OPTIONS_B
TABLE - BSC.BSC_KPI_ANALYSIS_OPTIONS_TL
TABLE - BSC.BSC_KPI_ANALYSIS_OPT_USER
TABLE - BSC.BSC_KPI_CALCULATIONS
TABLE - BSC.BSC_KPI_CALCULATIONS_USER
TABLE - BSC.BSC_KPI_CAUSE_EFFECT_RELS
TABLE - BSC.BSC_KPI_COMMENTS
TABLE - BSC.BSC_KPI_DATA_TABLES
TABLE - BSC.BSC_KPI_DEFAULTS_B
TABLE - BSC.BSC_KPI_DEFAULTS_TL
TABLE - BSC.BSC_KPI_DIM_GROUPS
TABLE - BSC.BSC_KPI_DIM_LEVELS_B
TABLE - BSC.BSC_KPI_DIM_LEVELS_TL
TABLE - BSC.BSC_KPI_DIM_LEVELS_USER
TABLE - BSC.BSC_KPI_DIM_LEVEL_PROPERTIES
TABLE - BSC.BSC_KPI_DIM_SETS_TL
TABLE - BSC.BSC_KPI_GRAPHS
TABLE - BSC.BSC_KPI_MEASURE_PROPS
TABLE - BSC.BSC_KPI_MEASURE_WEIGHTS
TABLE - BSC.BSC_KPI_MM_CONTROLS
TABLE - BSC.BSC_KPI_PERIODICITIES
TABLE - BSC.BSC_KPI_PERIODICITIES_USER
TABLE - BSC.BSC_KPI_PROPERTIES
TABLE - BSC.BSC_KPI_SERIES_COLORS
TABLE - BSC.BSC_KPI_SHELL_CMDS_TL
TABLE - BSC.BSC_KPI_SHELL_CMDS_USER
TABLE - BSC.BSC_KPI_SUBTITLES_TL
TABLE - BSC.BSC_KPI_TREE_NODES_B
TABLE - BSC.BSC_KPI_TREE_NODES_TL
TABLE - BSC.BSC_MESSAGE_LOGS
TABLE - BSC.BSC_MIG_SRC_SYS_DETAILS
TABLE - BSC.BSC_OBJECT_LOCKS
TABLE - BSC.BSC_OBJECT_LOCK_USERS
TABLE - BSC.BSC_OLAP_OBJECT
TABLE - BSC.BSC_OLAP_OBJECT_RELATION
TABLE - BSC.BSC_REPORTING_CALENDAR
TABLE - BSC.BSC_RESPONSIBILITY
TABLE - BSC.BSC_RESPONSIBILITY_TL
TABLE - BSC.BSC_RPT_KEYS
TABLE - BSC.BSC_SYS_BENCHMARKS_B
TABLE - BSC.BSC_SYS_BENCHMARKS_TL
TABLE - BSC.BSC_SYS_BM_GROUPS
TABLE - BSC.BSC_SYS_CALCULATIONS
TABLE - BSC.BSC_SYS_CALENDARS_B
TABLE - BSC.BSC_SYS_CALENDARS_TL
TABLE - BSC.BSC_SYS_COLORS_B
TABLE - BSC.BSC_SYS_COLORS_TL
TABLE - BSC.BSC_SYS_COM_DIM_LEVELS
TABLE - BSC.BSC_SYS_DATASETS_B
TABLE - BSC.BSC_SYS_DATASETS_TL
TABLE - BSC.BSC_SYS_DATASET_CALC
TABLE - BSC.BSC_SYS_DIM_GROUPS_TL
TABLE - BSC.BSC_SYS_DIM_LEVELS_B
TABLE - BSC.BSC_SYS_DIM_LEVELS_BY_GROUP
TABLE - BSC.BSC_SYS_DIM_LEVELS_TL
TABLE - BSC.BSC_SYS_DIM_LEVEL_COLS
TABLE - BSC.BSC_SYS_DIM_LEVEL_RELS
TABLE - BSC.BSC_SYS_FILES
TABLE - BSC.BSC_SYS_FILTERS
TABLE - BSC.BSC_SYS_FILTERS_VIEWS
TABLE - BSC.BSC_SYS_FORMATS
TABLE - BSC.BSC_SYS_IMAGES
TABLE - BSC.BSC_SYS_IMAGES_MAP_TL
TABLE - BSC.BSC_SYS_INIT
TABLE - BSC.BSC_SYS_KPI_COLORS
TABLE - BSC.BSC_SYS_LABELS_B
TABLE - BSC.BSC_SYS_LABELS_TL
TABLE - BSC.BSC_SYS_LINES
TABLE - BSC.BSC_SYS_MEASURES
TABLE - BSC.BSC_SYS_MM_CONTROLS_TL
TABLE - BSC.BSC_SYS_OBJECTIVE_COLORS
TABLE - BSC.BSC_SYS_PERIODICITIES
TABLE - BSC.BSC_SYS_PERIODICITIES_TL
TABLE - BSC.BSC_SYS_PERIODS
TABLE - BSC.BSC_SYS_PERIODS_TL
TABLE - BSC.BSC_SYS_SERIES_COLORS
TABLE - BSC.BSC_SYS_USER_OPTIONS
TABLE - BSC.BSC_TABS_B
TABLE - BSC.BSC_TABS_TL
TABLE - BSC.BSC_TAB_CSF_B
TABLE - BSC.BSC_TAB_CSF_TL
TABLE - BSC.BSC_TAB_INDICATORS
TABLE - BSC.BSC_TAB_IND_GROUPS_B
TABLE - BSC.BSC_TAB_IND_GROUPS_TL
TABLE - BSC.BSC_TAB_VIEWS_B
TABLE - BSC.BSC_TAB_VIEWS_TL
TABLE - BSC.BSC_TAB_VIEW_KPI_TL
TABLE - BSC.BSC_TAB_VIEW_LABELS_B
TABLE - BSC.BSC_TAB_VIEW_LABELS_TL
TABLE - BSC.BSC_TMP_BIG_IN_COND
TABLE - BSC.BSC_TMP_OPT_UI_KPIS
TABLE - BSC.BSC_TMP_OPT_UI_LEVELS
TABLE - BSC.BSC_UI_COLOR_SCHEMES
TABLE - BSC.BSC_UI_COLOR_USER
TABLE - BSC.BSC_UPGRADE_TASK
TABLE - BSC.BSC_USERS
TABLE - BSC.BSC_USER_INFO
TABLE - BSC.BSC_USER_KPIGRAPH_PLUGS
TABLE - BSC.BSC_USER_KPILIST_KPIS
TABLE - BSC.BSC_USER_KPILIST_PLUGS
TABLE - BSC.BSC_USER_KPI_ACCESS
TABLE - BSC.BSC_USER_LIST_ACCESS
TABLE - BSC.BSC_USER_PARAMETERS_B
TABLE - BSC.BSC_USER_PARAMETERS_TL
TABLE - BSC.BSC_USER_RESPONSIBILITY
TABLE - BSC.BSC_USER_TAB_ACCESS
VIEW - APPS.BSC_APPS_USERS_V
VIEW - APPS.BSC_BIS_DIM_LEVELS_V
VIEW - APPS.BSC_DB_BASIC_DIM_SETS_V
VIEW - APPS.BSC_DB_COLOR_AO_DEFAULTS_V
VIEW - APPS.BSC_DB_COLOR_KPI_DEFAULTS_V
VIEW - APPS.BSC_DB_COLOR_KPI_V
VIEW - APPS.BSC_DB_COLOR_MEASURES_V
VIEW - APPS.BSC_DB_DATASET_DIM_SETS_V
VIEW - APPS.BSC_DB_MEASURE_BY_DIM_SET_V
VIEW - APPS.BSC_DB_MEASURE_COLS_VL
VIEW - APPS.BSC_DB_MEASURE_GROUPS_VL
VIEW - APPS.BSC_EDW_CALENDAR_TYPE_VL
VIEW - APPS.BSC_KPIS_VL
VIEW - APPS.BSC_KPI_ANALYSIS_MEASURES_VL
VIEW - APPS.BSC_KPI_ANALYSIS_OPTIONS_VL
VIEW - APPS.BSC_KPI_DATA_TABLES_V
VIEW - APPS.BSC_KPI_DEFAULTS_VL
VIEW - APPS.BSC_KPI_DIM_LEVELS_VL
VIEW - APPS.BSC_KPI_DIM_SETS_VL
VIEW - APPS.BSC_KPI_SHELL_CMDS_VL
VIEW - APPS.BSC_KPI_SUBTITLES_VL
VIEW - APPS.BSC_KPI_TREE_NODES_VL
VIEW - APPS.BSC_LOOKUPS
VIEW - APPS.BSC_MESSAGES
VIEW - APPS.BSC_OAF_ANALYSYS_OPT_COMB_V
VIEW - APPS.BSC_OAF_DIM_LEVELS_V
VIEW - APPS.BSC_OPTS_PMF_MEAS_V
VIEW - APPS.BSC_PMF_MEAS_V
VIEW - APPS.BSC_RESPONSIBILITY_VL
VIEW - APPS.BSC_SYS_BENCHMARKS_VL
VIEW - APPS.BSC_SYS_CALENDARS_VL
VIEW - APPS.BSC_SYS_COLORS_VL
VIEW - APPS.BSC_SYS_DATASETS_VL
VIEW - APPS.BSC_SYS_DIM_GROUPS_VL
VIEW - APPS.BSC_SYS_DIM_LEVELS_VL
VIEW - APPS.BSC_SYS_DIM_LEVEL_RELS_V
VIEW - APPS.BSC_SYS_IMAGES_MAP_VL
VIEW - APPS.BSC_SYS_LABELS_VL
VIEW - APPS.BSC_SYS_MM_CONTROLS_VL
VIEW - APPS.BSC_SYS_PERIODICITIES_VL
VIEW - APPS.BSC_SYS_PERIODS_VL
VIEW - APPS.BSC_TABS_VL
VIEW - APPS.BSC_TAB_CSF_VL
VIEW - APPS.BSC_TAB_IND_GROUPS_VL
VIEW - APPS.BSC_TAB_IND_V
VIEW - APPS.BSC_TAB_VIEWS_VL
VIEW - APPS.BSC_TAB_VIEW_KPI_VL
VIEW - APPS.BSC_TAB_VIEW_LABELS_VL
VIEW - APPS.BSC_USER_PARAMETERS_VL
VIEW - APPS.BSC_USER_RESPONSIBILITY_V

Table: BSC_APPS_USERS

Description: BSC Users
Primary Key: BSC_APPS_USERS_PK
  1. USER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_APPS_USERS.USER_ID BSC_USERS

[top of page]

BSC.BSC_APPS_USERS does not reference any database object

BSC.BSC_APPS_USERS is referenced by following:

APPS
SYNONYM - BSC_APPS_USERS

[top of page]

Table: BSC_BIS_MEASURES_DATA

Description: BSC/PMF measure Actual and Target

[top of page]

BSC.BSC_BIS_MEASURES_DATA does not reference any database object

BSC.BSC_BIS_MEASURES_DATA is referenced by following:

APPS
SYNONYM - BSC_BIS_MEASURES_DATA

[top of page]

Table: BSC_COLOR_RANGES

Description: Table to store the color tresholds/ranges

[top of page]

BSC.BSC_COLOR_RANGES does not reference any database object

BSC.BSC_COLOR_RANGES is referenced by following:

APPS
SYNONYM - BSC_COLOR_RANGES

[top of page]

Table: BSC_COLOR_TYPE_PROPS

Description: This table stores the Color Ranges for the KPI Measures and Objectives. We kept this separate so as to allow multiple threshold ranges for the same KPI Measure (or Objective) for different color types. For Simulation Objective, KPI_MEASURE_

[top of page]

BSC.BSC_COLOR_TYPE_PROPS does not reference any database object

BSC.BSC_COLOR_TYPE_PROPS is referenced by following:

APPS
SYNONYM - BSC_COLOR_TYPE_PROPS

[top of page]

Table: BSC_CURRENT_SESSIONS

Description: Current BSC sessions

[top of page]

BSC.BSC_CURRENT_SESSIONS does not reference any database object

BSC.BSC_CURRENT_SESSIONS is referenced by following:

APPS
SYNONYM - BSC_CURRENT_SESSIONS

[top of page]

Table: BSC_DB_CALCULATIONS

Description: Calculation configuration by table
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_DB_CALCULATIONS.TABLE_NAME BSC_DB_TABLES

[top of page]

BSC.BSC_DB_CALCULATIONS does not reference any database object

BSC.BSC_DB_CALCULATIONS is referenced by following:

APPS
SYNONYM - BSC_DB_CALCULATIONS

[top of page]

Table: BSC_DB_CALENDAR

Description: Calendar information

[top of page]

BSC.BSC_DB_CALENDAR does not reference any database object

BSC.BSC_DB_CALENDAR is referenced by following:

APPS
SYNONYM - BSC_DB_CALENDAR

[top of page]

Table: BSC_DB_LOADER_CONTROL

Description: Loader control information
Primary Key: BSC_DB_LOADER_CONTROL_PK
  1. INPUT_TABLE_NAME
  2. PROCESS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_DB_LOADER_CONTROL.INPUT_TABLE_NAME BSC_DB_TABLES

[top of page]

BSC.BSC_DB_LOADER_CONTROL does not reference any database object

BSC.BSC_DB_LOADER_CONTROL is referenced by following:

APPS
SYNONYM - BSC_DB_LOADER_CONTROL

[top of page]

Table: BSC_DB_MEASURE_COLS_TL

Description: Measure columns information
Primary Key: BSC_DB_MEASURE_COLS_TL_PK
  1. MEASURE_COL
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_DB_MEASURE_COLS_TL.MEASURE_GROUP_ID BSC_DB_MEASURE_GROUPS_TL

[top of page]

BSC.BSC_DB_MEASURE_COLS_TL does not reference any database object

BSC.BSC_DB_MEASURE_COLS_TL is referenced by following:

APPS
SYNONYM - BSC_DB_MEASURE_COLS_TL

[top of page]

Table: BSC_DB_MEASURE_GROUPS_TL

Description: Measure groups information
Primary Key: BSC_DB_MEASURE_GROUPS_TL_PK
  1. MEASURE_GROUP_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_DB_MEASURE_COLS_TL.MEASURE_GROUP_ID BSC_DB_MEASURE_GROUPS_TL

[top of page]

BSC.BSC_DB_MEASURE_GROUPS_TL does not reference any database object

BSC.BSC_DB_MEASURE_GROUPS_TL is referenced by following:

APPS
SYNONYM - BSC_DB_MEASURE_GROUPS_TL

[top of page]

Table: BSC_DB_PROCESS_CONTROL

Description: Process control information
Primary Key: BSC_DB_PROCESS_CONTROL_PK
  1. PROCESS_ID

[top of page]

BSC.BSC_DB_PROCESS_CONTROL does not reference any database object

BSC.BSC_DB_PROCESS_CONTROL is referenced by following:

APPS
SYNONYM - BSC_DB_PROCESS_CONTROL

[top of page]

Table: BSC_DB_RESERVED_WORDS

Description: Reserved words
Primary Key: BSC_DB_RESERVED_WORDS_PK
  1. TYPE
  2. WORD

[top of page]

BSC.BSC_DB_RESERVED_WORDS does not reference any database object

BSC.BSC_DB_RESERVED_WORDS is referenced by following:

APPS
SYNONYM - BSC_DB_RESERVED_WORDS

[top of page]

Table: BSC_DB_TABLES

Description: Data tables information
Primary Key: BSC_DB_TABLES_PK
  1. TABLE_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_DB_TABLES.PERIODICITY_ID BSC_SYS_PERIODICITIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_DB_CALCULATIONS.TABLE_NAME BSC_DB_TABLES
BSC_DB_LOADER_CONTROL.INPUT_TABLE_NAME BSC_DB_TABLES
BSC_DB_TABLES_COLS.TABLE_NAME BSC_DB_TABLES
BSC_DB_TABLES_RELS.TABLE_NAME BSC_DB_TABLES
BSC_DB_TABLES_RELS.SOURCE_TABLE_NAME BSC_DB_TABLES
BSC_KPI_DATA_TABLES.TABLE_NAME BSC_DB_TABLES

[top of page]

BSC.BSC_DB_TABLES does not reference any database object

BSC.BSC_DB_TABLES is referenced by following:

APPS
SYNONYM - BSC_DB_TABLES

[top of page]

Table: BSC_DB_TABLES_COLS

Description: Data table columns information
Primary Key: BSC_DB_TABLES_COLS_PK
  1. COLUMN_NAME
  2. TABLE_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_DB_TABLES_COLS.TABLE_NAME BSC_DB_TABLES
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_DB_VALIDATION.INPUT_TABLE_NAME
BSC_DB_VALIDATION.COLUMN_NAME
BSC_DB_TABLES_COLS

[top of page]

BSC.BSC_DB_TABLES_COLS does not reference any database object

BSC.BSC_DB_TABLES_COLS is referenced by following:

APPS
SYNONYM - BSC_DB_TABLES_COLS

[top of page]

Table: BSC_DB_TABLES_DISPLAY

Description: BSC_DB_TABLES_DISPLAY Stores information about data tables, to improve performance and used in UI.

[top of page]

BSC.BSC_DB_TABLES_DISPLAY does not reference any database object

BSC.BSC_DB_TABLES_DISPLAY is referenced by following:

APPS
SYNONYM - BSC_DB_TABLES_DISPLAY

[top of page]

Table: BSC_DB_TABLES_RELS

Description: Table relationships information
Primary Key: BSC_DB_TABLES_RELS_PK
  1. SOURCE_TABLE_NAME
  2. TABLE_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_DB_TABLES_RELS.TABLE_NAME BSC_DB_TABLES
BSC_DB_TABLES_RELS.SOURCE_TABLE_NAME BSC_DB_TABLES

[top of page]

BSC.BSC_DB_TABLES_RELS does not reference any database object

BSC.BSC_DB_TABLES_RELS is referenced by following:

APPS
SYNONYM - BSC_DB_TABLES_RELS

[top of page]

Table: BSC_DB_TABLES_RELS_DISPLAY

Description: BSC_DB_TABLES_RELS_DISPLAY stores information about Relationship between data tables, to improve performance and used in UI.

[top of page]

BSC.BSC_DB_TABLES_RELS_DISPLAY does not reference any database object

BSC.BSC_DB_TABLES_RELS_DISPLAY is referenced by following:

APPS
SYNONYM - BSC_DB_TABLES_RELS_DISPLAY

[top of page]

Table: BSC_DB_VALIDATION

Description: Log of the input table validation error
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_DB_VALIDATION.INPUT_TABLE_NAME
BSC_DB_VALIDATION.COLUMN_NAME
BSC_DB_TABLES_COLS

[top of page]

BSC.BSC_DB_VALIDATION does not reference any database object

BSC.BSC_DB_VALIDATION is referenced by following:

APPS
SYNONYM - BSC_DB_VALIDATION

[top of page]

Table: BSC_DB_WEEK_MAPS

Description: Mapping information between week 4 and week 54

[top of page]

BSC.BSC_DB_WEEK_MAPS does not reference any database object

BSC.BSC_DB_WEEK_MAPS is referenced by following:

APPS
SYNONYM - BSC_DB_WEEK_MAPS

[top of page]

Table: BSC_EDW_CALENDAR_TYPE_TL

Description: EDW translated calendar type information
Primary Key: BSC_EDW_CALENDAR_TYPE_TL_PK
  1. EDW_CALENDAR_TYPE_ID
  2. LANGUAGE

[top of page]

BSC.BSC_EDW_CALENDAR_TYPE_TL does not reference any database object

BSC.BSC_EDW_CALENDAR_TYPE_TL is referenced by following:

APPS
SYNONYM - BSC_EDW_CALENDAR_TYPE_TL

[top of page]

Table: BSC_EDW_PERIODS_TL

Description: EDW period by periodicity information
Primary Key: BSC_EDW_PERIODS_TL_PK
  1. LANGUAGE
  2. PERIOD_ID
  3. YEAR
  4. PERIODICITY_ID

[top of page]

BSC.BSC_EDW_PERIODS_TL does not reference any database object

BSC.BSC_EDW_PERIODS_TL is referenced by following:

APPS
SYNONYM - BSC_EDW_PERIODS_TL

[top of page]

Table: BSC_INSTALL_LOGS

Description: Install log for personal Mode

[top of page]

BSC.BSC_INSTALL_LOGS does not reference any database object

BSC.BSC_INSTALL_LOGS is referenced by following:

APPS
SYNONYM - BSC_INSTALL_LOGS

[top of page]

Table: BSC_KPIS_B

Description: Key performance indicator information
Primary Key: BSC_KPIS_B_PK
  1. INDICATOR
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPIS_B.PERIODICITY_ID BSC_SYS_PERIODICITIES
BSC_KPIS_B.SOURCE_INDICATOR BSC_KPIS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPIS_B.SOURCE_INDICATOR BSC_KPIS_B
BSC_KPIS_TL.INDICATOR BSC_KPIS_B
BSC_KPI_ANALYSIS_GROUPS.INDICATOR BSC_KPIS_B
BSC_KPI_ANALYSIS_MEASURES_B.INDICATOR BSC_KPIS_B
BSC_KPI_CALCULATIONS.INDICATOR BSC_KPIS_B
BSC_KPI_CAUSE_EFFECT_RELS.CAUSE_INDICATOR BSC_KPIS_B
BSC_KPI_CAUSE_EFFECT_RELS.EFFECT_INDICATOR BSC_KPIS_B
BSC_KPI_COMMENTS.INDICATOR BSC_KPIS_B
BSC_KPI_DIM_SETS_TL.INDICATOR BSC_KPIS_B
BSC_KPI_MM_CONTROLS.INDICATOR BSC_KPIS_B
BSC_KPI_PERIODICITIES.INDICATOR BSC_KPIS_B
BSC_KPI_PROPERTIES.INDICATOR BSC_KPIS_B
BSC_KPI_SHELL_CMDS_TL.INDICATOR BSC_KPIS_B
BSC_KPI_SUBTITLES_TL.INDICATOR BSC_KPIS_B
BSC_KPI_TREE_NODES_B.INDICATOR BSC_KPIS_B
BSC_TAB_INDICATORS.INDICATOR BSC_KPIS_B

[top of page]

BSC.BSC_KPIS_B does not reference any database object

BSC.BSC_KPIS_B is referenced by following:

APPS
SYNONYM - BSC_KPIS_B

[top of page]

Table: BSC_KPIS_TL

Description: Translated Key performance indicator information
Primary Key: BSC_KPIS_TL_PK
  1. INDICATOR
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPIS_TL.INDICATOR BSC_KPIS_B

[top of page]

BSC.BSC_KPIS_TL does not reference any database object

BSC.BSC_KPIS_TL is referenced by following:

APPS
SYNONYM - BSC_KPIS_TL

[top of page]

Table: BSC_KPI_ANALYSIS_GROUPS

Description: Analysis groups information
Primary Key: BSC_KPI_ANALYSIS_GROUPS_PK
  1. ANALYSIS_GROUP_ID
  2. INDICATOR
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_ANALYSIS_GROUPS.INDICATOR BSC_KPIS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPI_ANALYSIS_OPTIONS_B.INDICATOR
BSC_KPI_ANALYSIS_OPTIONS_B.ANALYSIS_GROUP_ID
BSC_KPI_ANALYSIS_GROUPS

[top of page]

BSC.BSC_KPI_ANALYSIS_GROUPS does not reference any database object

BSC.BSC_KPI_ANALYSIS_GROUPS is referenced by following:

APPS
SYNONYM - BSC_KPI_ANALYSIS_GROUPS

[top of page]

Table: BSC_KPI_ANALYSIS_MEASURES_B

Description: Analysis measures information
Primary Key: BSC_KPI_ANALYSIS_MEASURES_B_PK
  1. ANALYSIS_OPTION0
  2. ANALYSIS_OPTION1
  3. INDICATOR
  4. SERIES_ID
  5. ANALYSIS_OPTION2
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_ANALYSIS_MEASURES_B.INDICATOR BSC_KPIS_B
BSC_KPI_ANALYSIS_MEASURES_B.DATASET_ID BSC_SYS_DATASETS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPI_ANALYSIS_MEASURES_TL.ANALYSIS_OPTION2
BSC_KPI_ANALYSIS_MEASURES_TL.ANALYSIS_OPTION0
BSC_KPI_ANALYSIS_MEASURES_TL.SERIES_ID
BSC_KPI_ANALYSIS_MEASURES_TL.ANALYSIS_OPTION1
BSC_KPI_ANALYSIS_MEASURES_TL.INDICATOR
BSC_KPI_ANALYSIS_MEASURES_B
BSC_KPI_SERIES_COLORS.ANALYSIS_OPTION2
BSC_KPI_SERIES_COLORS.ANALYSIS_OPTION0
BSC_KPI_SERIES_COLORS.SERIES_ID
BSC_KPI_SERIES_COLORS.ANALYSIS_OPTION1
BSC_KPI_SERIES_COLORS.INDICATOR
BSC_KPI_ANALYSIS_MEASURES_B

[top of page]

BSC.BSC_KPI_ANALYSIS_MEASURES_B does not reference any database object

BSC.BSC_KPI_ANALYSIS_MEASURES_B is referenced by following:

APPS
SYNONYM - BSC_KPI_ANALYSIS_MEASURES_B

[top of page]

Table: BSC_KPI_ANALYSIS_MEASURES_TL

Description: Translated analysis measures information
Primary Key: BSC_KPI_ANALYSIS_MEASURESTL_PK
  1. ANALYSIS_OPTION0
  2. ANALYSIS_OPTION1
  3. INDICATOR
  4. SERIES_ID
  5. LANGUAGE
  6. ANALYSIS_OPTION2
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_ANALYSIS_MEASURES_TL.ANALYSIS_OPTION2
BSC_KPI_ANALYSIS_MEASURES_TL.ANALYSIS_OPTION0
BSC_KPI_ANALYSIS_MEASURES_TL.SERIES_ID
BSC_KPI_ANALYSIS_MEASURES_TL.ANALYSIS_OPTION1
BSC_KPI_ANALYSIS_MEASURES_TL.INDICATOR
BSC_KPI_ANALYSIS_MEASURES_B

[top of page]

BSC.BSC_KPI_ANALYSIS_MEASURES_TL does not reference any database object

BSC.BSC_KPI_ANALYSIS_MEASURES_TL is referenced by following:

APPS
SYNONYM - BSC_KPI_ANALYSIS_MEASURES_TL

[top of page]

Table: BSC_KPI_ANALYSIS_OPTIONS_B

Description: Analysis options information
Primary Key: BSC_KPI_ANALYSIS_OPTIONS_B_PK
  1. ANALYSIS_GROUP_ID
  2. OPTION_ID
  3. INDICATOR
  4. GRANDPARENT_OPTION_ID
  5. PARENT_OPTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_ANALYSIS_OPTIONS_B.INDICATOR
BSC_KPI_ANALYSIS_OPTIONS_B.ANALYSIS_GROUP_ID
BSC_KPI_ANALYSIS_GROUPS
BSC_KPI_ANALYSIS_OPTIONS_B.DIM_SET_ID
BSC_KPI_ANALYSIS_OPTIONS_B.INDICATOR
BSC_KPI_DIM_SETS_TL
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPI_ANALYSIS_OPTIONS_TL.OPTION_ID
BSC_KPI_ANALYSIS_OPTIONS_TL.PARENT_OPTION_ID
BSC_KPI_ANALYSIS_OPTIONS_TL.GRANDPARENT_OPTION_ID
BSC_KPI_ANALYSIS_OPTIONS_TL.INDICATOR
BSC_KPI_ANALYSIS_OPTIONS_TL.ANALYSIS_GROUP_ID
BSC_KPI_ANALYSIS_OPTIONS_B
BSC_KPI_ANALYSIS_OPT_USER.OPTION_ID
BSC_KPI_ANALYSIS_OPT_USER.PARENT_OPTION_ID
BSC_KPI_ANALYSIS_OPT_USER.GRANDPARENT_OPTION_ID
BSC_KPI_ANALYSIS_OPT_USER.INDICATOR
BSC_KPI_ANALYSIS_OPT_USER.ANALYSIS_GROUP_ID
BSC_KPI_ANALYSIS_OPTIONS_B

[top of page]

BSC.BSC_KPI_ANALYSIS_OPTIONS_B does not reference any database object

BSC.BSC_KPI_ANALYSIS_OPTIONS_B is referenced by following:

APPS
SYNONYM - BSC_KPI_ANALYSIS_OPTIONS_B

[top of page]

Table: BSC_KPI_ANALYSIS_OPTIONS_TL

Description: Translated analysis options information
Primary Key: BSC_KPI_ANALYSIS_OPTIONS_TL_PK
  1. ANALYSIS_GROUP_ID
  2. INDICATOR
  3. GRANDPARENT_OPTION_ID
  4. LANGUAGE
  5. PARENT_OPTION_ID
  6. OPTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_ANALYSIS_OPTIONS_TL.OPTION_ID
BSC_KPI_ANALYSIS_OPTIONS_TL.PARENT_OPTION_ID
BSC_KPI_ANALYSIS_OPTIONS_TL.GRANDPARENT_OPTION_ID
BSC_KPI_ANALYSIS_OPTIONS_TL.INDICATOR
BSC_KPI_ANALYSIS_OPTIONS_TL.ANALYSIS_GROUP_ID
BSC_KPI_ANALYSIS_OPTIONS_B

[top of page]

BSC.BSC_KPI_ANALYSIS_OPTIONS_TL does not reference any database object

BSC.BSC_KPI_ANALYSIS_OPTIONS_TL is referenced by following:

APPS
SYNONYM - BSC_KPI_ANALYSIS_OPTIONS_TL

[top of page]

Table: BSC_KPI_ANALYSIS_OPT_USER

Description: Analysis options information by user
Primary Key: BSC_KPI_ANALYSIS_OPT_USER_PK
  1. ANALYSIS_GROUP_ID
  2. OPTION_ID
  3. PARENT_OPTION_ID
  4. INDICATOR
  5. GRANDPARENT_OPTION_ID
  6. USER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_ANALYSIS_OPT_USER.USER_ID BSC_USERS
BSC_KPI_ANALYSIS_OPT_USER.OPTION_ID
BSC_KPI_ANALYSIS_OPT_USER.PARENT_OPTION_ID
BSC_KPI_ANALYSIS_OPT_USER.GRANDPARENT_OPTION_ID
BSC_KPI_ANALYSIS_OPT_USER.INDICATOR
BSC_KPI_ANALYSIS_OPT_USER.ANALYSIS_GROUP_ID
BSC_KPI_ANALYSIS_OPTIONS_B

[top of page]

BSC.BSC_KPI_ANALYSIS_OPT_USER does not reference any database object

BSC.BSC_KPI_ANALYSIS_OPT_USER is referenced by following:

APPS
SYNONYM - BSC_KPI_ANALYSIS_OPT_USER

[top of page]

Table: BSC_KPI_CALCULATIONS

Description: Calculations information
Primary Key: BSC_KPI_CALCULATIONS_PK
  1. CALCULATION_ID
  2. INDICATOR
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_CALCULATIONS.INDICATOR BSC_KPIS_B
BSC_KPI_CALCULATIONS.CALCULATION_ID BSC_SYS_CALCULATIONS
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPI_CALCULATIONS_USER.INDICATOR
BSC_KPI_CALCULATIONS_USER.CALCULATION_ID
BSC_KPI_CALCULATIONS

[top of page]

BSC.BSC_KPI_CALCULATIONS does not reference any database object

BSC.BSC_KPI_CALCULATIONS is referenced by following:

APPS
SYNONYM - BSC_KPI_CALCULATIONS

[top of page]

Table: BSC_KPI_CALCULATIONS_USER

Description: Calculations information by user
Primary Key: BSC_KPI_CALCULATIONS_USER_PK
  1. CALCULATION_ID
  2. USER_ID
  3. INDICATOR
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_CALCULATIONS_USER.USER_ID BSC_USERS
BSC_KPI_CALCULATIONS_USER.INDICATOR
BSC_KPI_CALCULATIONS_USER.CALCULATION_ID
BSC_KPI_CALCULATIONS

[top of page]

BSC.BSC_KPI_CALCULATIONS_USER does not reference any database object

BSC.BSC_KPI_CALCULATIONS_USER is referenced by following:

APPS
SYNONYM - BSC_KPI_CALCULATIONS_USER

[top of page]

Table: BSC_KPI_CAUSE_EFFECT_RELS

Description: Indicator cause & effect relationships
Primary Key: BSC_KPI_CAUSE_EFFECT_RELS_PK
  1. CAUSE_INDICATOR
  2. EFFECT_INDICATOR
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_CAUSE_EFFECT_RELS.CAUSE_INDICATOR BSC_KPIS_B
BSC_KPI_CAUSE_EFFECT_RELS.EFFECT_INDICATOR BSC_KPIS_B

[top of page]

BSC.BSC_KPI_CAUSE_EFFECT_RELS does not reference any database object

BSC.BSC_KPI_CAUSE_EFFECT_RELS is referenced by following:

APPS
SYNONYM - BSC_KPI_CAUSE_EFFECT_RELS

[top of page]

Table: BSC_KPI_COMMENTS

Description: Indicator comments
Primary Key: BSC_KPI_COMMENTS_PK
  1. CREATED_BY
  2. CREATION_DATE
  3. INDICATOR
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_COMMENTS.INDICATOR BSC_KPIS_B
BSC_KPI_COMMENTS.PERIODICITY_ID
BSC_KPI_COMMENTS.PERIOD_ID
BSC_KPI_COMMENTS.YEAR
BSC_SYS_PERIODS_TL

[top of page]

BSC.BSC_KPI_COMMENTS does not reference any database object

BSC.BSC_KPI_COMMENTS is referenced by following:

APPS
SYNONYM - BSC_KPI_COMMENTS

[top of page]

Table: BSC_KPI_DATA_TABLES

Description: Data table information
Primary Key: BSC_KPI_DATA_TABLES_PK
  1. DIM_SET_ID
  2. PERIODICITY_ID
  3. LEVEL_COMB
  4. INDICATOR
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_DATA_TABLES.INDICATOR
BSC_KPI_DATA_TABLES.PERIODICITY_ID
BSC_KPI_PERIODICITIES
BSC_KPI_DATA_TABLES.TABLE_NAME BSC_DB_TABLES
BSC_KPI_DATA_TABLES.DIM_SET_ID
BSC_KPI_DATA_TABLES.INDICATOR
BSC_KPI_DIM_SETS_TL

[top of page]

BSC.BSC_KPI_DATA_TABLES does not reference any database object

BSC.BSC_KPI_DATA_TABLES is referenced by following:

APPS
SYNONYM - BSC_KPI_DATA_TABLES

[top of page]

Table: BSC_KPI_DEFAULTS_B

Description: Indicator data for information box
Primary Key: BSC_KPI_DEFAULTS_B_PK
  1. INDICATOR
  2. TAB_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_DEFAULTS_B.TAB_ID
BSC_KPI_DEFAULTS_B.INDICATOR
BSC_TAB_INDICATORS
BSC_KPI_DEFAULTS_B.DIM_SET_ID
BSC_KPI_DEFAULTS_B.INDICATOR
BSC_KPI_DIM_SETS_TL
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPI_DEFAULTS_TL.INDICATOR
BSC_KPI_DEFAULTS_TL.TAB_ID
BSC_KPI_DEFAULTS_B

[top of page]

BSC.BSC_KPI_DEFAULTS_B does not reference any database object

BSC.BSC_KPI_DEFAULTS_B is referenced by following:

APPS
SYNONYM - BSC_KPI_DEFAULTS_B

[top of page]

Table: BSC_KPI_DEFAULTS_TL

Description: Indicator translated data for information box
Primary Key: BSC_KPI_DEFAULTS_TL_PK
  1. INDICATOR
  2. TAB_ID
  3. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_DEFAULTS_TL.INDICATOR
BSC_KPI_DEFAULTS_TL.TAB_ID
BSC_KPI_DEFAULTS_B

[top of page]

BSC.BSC_KPI_DEFAULTS_TL does not reference any database object

BSC.BSC_KPI_DEFAULTS_TL is referenced by following:

APPS
SYNONYM - BSC_KPI_DEFAULTS_TL

[top of page]

Table: BSC_KPI_DIM_GROUPS

Description: Dimension groups information
Primary Key: BSC_KPI_DIM_GROUPS_PK
  1. DIM_GROUP_ID
  2. DIM_SET_ID
  3. INDICATOR
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_DIM_GROUPS.DIM_SET_ID
BSC_KPI_DIM_GROUPS.INDICATOR
BSC_KPI_DIM_SETS_TL
BSC_KPI_DIM_GROUPS.DIM_GROUP_ID BSC_SYS_DIM_GROUPS_TL

[top of page]

BSC.BSC_KPI_DIM_GROUPS does not reference any database object

BSC.BSC_KPI_DIM_GROUPS is referenced by following:

APPS
SYNONYM - BSC_KPI_DIM_GROUPS

[top of page]

Table: BSC_KPI_DIM_LEVELS_B

Description: Dimension levels information
Primary Key: BSC_KPI_DIM_LEVELS_B_PK
  1. DIM_LEVEL_INDEX
  2. DIM_SET_ID
  3. INDICATOR
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_DIM_LEVELS_B.DIM_SET_ID
BSC_KPI_DIM_LEVELS_B.INDICATOR
BSC_KPI_DIM_SETS_TL
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPI_DIM_LEVELS_TL.DIM_LEVEL_INDEX
BSC_KPI_DIM_LEVELS_TL.INDICATOR
BSC_KPI_DIM_LEVELS_TL.DIM_SET_ID
BSC_KPI_DIM_LEVELS_B
BSC_KPI_DIM_LEVELS_USER.DIM_LEVEL_INDEX
BSC_KPI_DIM_LEVELS_USER.INDICATOR
BSC_KPI_DIM_LEVELS_USER.DIM_SET_ID
BSC_KPI_DIM_LEVELS_B

[top of page]

BSC.BSC_KPI_DIM_LEVELS_B does not reference any database object

BSC.BSC_KPI_DIM_LEVELS_B is referenced by following:

APPS
SYNONYM - BSC_KPI_DIM_LEVELS_B

[top of page]

Table: BSC_KPI_DIM_LEVELS_TL

Description: Translated dimension levels information
Primary Key: BSC_KPI_DIM_LEVELS_TL_PK
  1. DIM_LEVEL_INDEX
  2. DIM_SET_ID
  3. LANGUAGE
  4. INDICATOR
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_DIM_LEVELS_TL.DIM_LEVEL_INDEX
BSC_KPI_DIM_LEVELS_TL.INDICATOR
BSC_KPI_DIM_LEVELS_TL.DIM_SET_ID
BSC_KPI_DIM_LEVELS_B

[top of page]

BSC.BSC_KPI_DIM_LEVELS_TL does not reference any database object

BSC.BSC_KPI_DIM_LEVELS_TL is referenced by following:

APPS
SYNONYM - BSC_KPI_DIM_LEVELS_TL

[top of page]

Table: BSC_KPI_DIM_LEVELS_USER

Description: Dimension levels information by user
Primary Key: BSC_KPI_DIM_LEVELS_USER_PK
  1. DIM_LEVEL_INDEX
  2. DIM_SET_ID
  3. INDICATOR
  4. USER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_DIM_LEVELS_USER.USER_ID BSC_USERS
BSC_KPI_DIM_LEVELS_USER.DIM_LEVEL_INDEX
BSC_KPI_DIM_LEVELS_USER.INDICATOR
BSC_KPI_DIM_LEVELS_USER.DIM_SET_ID
BSC_KPI_DIM_LEVELS_B

[top of page]

BSC.BSC_KPI_DIM_LEVELS_USER does not reference any database object

BSC.BSC_KPI_DIM_LEVELS_USER is referenced by following:

APPS
SYNONYM - BSC_KPI_DIM_LEVELS_USER

[top of page]

Table: BSC_KPI_DIM_LEVEL_PROPERTIES

Description: Dimension levels properties
Primary Key: BSC_KPI_DIM_LEVEL_PROPERTI_PK
  1. DIM_LEVEL_ID
  2. INDICATOR
  3. DIM_SET_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_DIM_LEVEL_PROPERTIES.DIM_SET_ID
BSC_KPI_DIM_LEVEL_PROPERTIES.INDICATOR
BSC_KPI_DIM_SETS_TL
BSC_KPI_DIM_LEVEL_PROPERTIES.DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B

[top of page]

BSC.BSC_KPI_DIM_LEVEL_PROPERTIES does not reference any database object

BSC.BSC_KPI_DIM_LEVEL_PROPERTIES is referenced by following:

APPS
SYNONYM - BSC_KPI_DIM_LEVEL_PROPERTIES

[top of page]

Table: BSC_KPI_DIM_SETS_TL

Description: Dimension sets information
Primary Key: BSC_KPI_DIM_SETS_TL_PK
  1. DIM_SET_ID
  2. INDICATOR
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_DIM_SETS_TL.INDICATOR BSC_KPIS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPI_ANALYSIS_OPTIONS_B.DIM_SET_ID
BSC_KPI_ANALYSIS_OPTIONS_B.INDICATOR
BSC_KPI_DIM_SETS_TL
BSC_KPI_DATA_TABLES.DIM_SET_ID
BSC_KPI_DATA_TABLES.INDICATOR
BSC_KPI_DIM_SETS_TL
BSC_KPI_DEFAULTS_B.DIM_SET_ID
BSC_KPI_DEFAULTS_B.INDICATOR
BSC_KPI_DIM_SETS_TL
BSC_KPI_DIM_GROUPS.DIM_SET_ID
BSC_KPI_DIM_GROUPS.INDICATOR
BSC_KPI_DIM_SETS_TL
BSC_KPI_DIM_LEVELS_B.DIM_SET_ID
BSC_KPI_DIM_LEVELS_B.INDICATOR
BSC_KPI_DIM_SETS_TL
BSC_KPI_DIM_LEVEL_PROPERTIES.DIM_SET_ID
BSC_KPI_DIM_LEVEL_PROPERTIES.INDICATOR
BSC_KPI_DIM_SETS_TL

[top of page]

BSC.BSC_KPI_DIM_SETS_TL does not reference any database object

BSC.BSC_KPI_DIM_SETS_TL is referenced by following:

APPS
SYNONYM - BSC_KPI_DIM_SETS_TL

[top of page]

Table: BSC_KPI_GRAPHS

Description: Indicator graph files for portlet
Primary Key: BSC_KPI_GRAPHS_PK
  1. RESPONSIBILITY_ID
  2. INDICATOR

[top of page]

BSC.BSC_KPI_GRAPHS does not reference any database object

BSC.BSC_KPI_GRAPHS is referenced by following:

APPS
SYNONYM - BSC_KPI_GRAPHS

[top of page]

Table: BSC_KPI_MEASURE_PROPS

Description: Table to store KPI Measure Properties

[top of page]

BSC.BSC_KPI_MEASURE_PROPS does not reference any database object

BSC.BSC_KPI_MEASURE_PROPS is referenced by following:

APPS
SYNONYM - BSC_KPI_MEASURE_PROPS

[top of page]

Table: BSC_KPI_MEASURE_WEIGHTS

Description: Table to store weights of the KPI Measure. Same KPI can have more than one weight if this KPI belongs to more than one Weighted Average KPI; or, there can be possible multiple weights for a KPI for different dimension object combination in

[top of page]

BSC.BSC_KPI_MEASURE_WEIGHTS does not reference any database object

BSC.BSC_KPI_MEASURE_WEIGHTS is referenced by following:

APPS
SYNONYM - BSC_KPI_MEASURE_WEIGHTS

[top of page]

Table: BSC_KPI_MM_CONTROLS

Description: Multimedia control remote information
Primary Key: BSC_KPI_MM_CONTROLS_PK
  1. BUTTON_ID
  2. INDICATOR
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_MM_CONTROLS.INDICATOR BSC_KPIS_B
BSC_KPI_MM_CONTROLS.BUTTON_ID BSC_SYS_MM_CONTROLS_TL

[top of page]

BSC.BSC_KPI_MM_CONTROLS does not reference any database object

BSC.BSC_KPI_MM_CONTROLS is referenced by following:

APPS
SYNONYM - BSC_KPI_MM_CONTROLS

[top of page]

Table: BSC_KPI_PERIODICITIES

Description: Indicator periodicity information
Primary Key: BSC_KPI_PERIODICITIES_PK
  1. INDICATOR
  2. PERIODICITY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_PERIODICITIES.INDICATOR BSC_KPIS_B
BSC_KPI_PERIODICITIES.PERIODICITY_ID BSC_SYS_PERIODICITIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPI_DATA_TABLES.INDICATOR
BSC_KPI_DATA_TABLES.PERIODICITY_ID
BSC_KPI_PERIODICITIES
BSC_KPI_PERIODICITIES_USER.INDICATOR
BSC_KPI_PERIODICITIES_USER.PERIODICITY_ID
BSC_KPI_PERIODICITIES

[top of page]

BSC.BSC_KPI_PERIODICITIES does not reference any database object

BSC.BSC_KPI_PERIODICITIES is referenced by following:

APPS
SYNONYM - BSC_KPI_PERIODICITIES

[top of page]

Table: BSC_KPI_PERIODICITIES_USER

Description: Indicator periodicity information by user
Primary Key: BSC_KPI_PERIODICITIES_USER_PK
  1. INDICATOR
  2. PERIODICITY_ID
  3. USER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_PERIODICITIES_USER.USER_ID BSC_USERS
BSC_KPI_PERIODICITIES_USER.INDICATOR
BSC_KPI_PERIODICITIES_USER.PERIODICITY_ID
BSC_KPI_PERIODICITIES

[top of page]

BSC.BSC_KPI_PERIODICITIES_USER does not reference any database object

BSC.BSC_KPI_PERIODICITIES_USER is referenced by following:

APPS
SYNONYM - BSC_KPI_PERIODICITIES_USER

[top of page]

Table: BSC_KPI_PROPERTIES

Description: Indicator properties information
Primary Key: BSC_KPI_PROPERTIES_PK
  1. INDICATOR
  2. PROPERTY_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_PROPERTIES.INDICATOR BSC_KPIS_B

[top of page]

BSC.BSC_KPI_PROPERTIES does not reference any database object

BSC.BSC_KPI_PROPERTIES is referenced by following:

APPS
SYNONYM - BSC_KPI_PROPERTIES

[top of page]

Table: BSC_KPI_SERIES_COLORS

Description: Series and benchmark color by dataseries
Primary Key: BSC_KPI_SERIES_COLORS_PK
  1. ANALYSIS_OPTION0
  2. ANALYSIS_OPTION1
  3. BM_ID
  4. INDICATOR
  5. SERIES_ID
  6. ANALYSIS_OPTION2
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_SERIES_COLORS.ANALYSIS_OPTION2
BSC_KPI_SERIES_COLORS.ANALYSIS_OPTION0
BSC_KPI_SERIES_COLORS.SERIES_ID
BSC_KPI_SERIES_COLORS.ANALYSIS_OPTION1
BSC_KPI_SERIES_COLORS.INDICATOR
BSC_KPI_ANALYSIS_MEASURES_B
BSC_KPI_SERIES_COLORS.BM_ID BSC_SYS_BENCHMARKS_B

[top of page]

BSC.BSC_KPI_SERIES_COLORS does not reference any database object

BSC.BSC_KPI_SERIES_COLORS is referenced by following:

APPS
SYNONYM - BSC_KPI_SERIES_COLORS

[top of page]

Table: BSC_KPI_SHELL_CMDS_TL

Description: Links command information
Primary Key: BSC_KPI_SHELL_CMDS_TL_PK
  1. INDICATOR
  2. SHELL_CMD_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_SHELL_CMDS_TL.INDICATOR BSC_KPIS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPI_SHELL_CMDS_USER.INDICATOR
BSC_KPI_SHELL_CMDS_USER.SHELL_CMD_ID
BSC_KPI_SHELL_CMDS_TL

[top of page]

BSC.BSC_KPI_SHELL_CMDS_TL does not reference any database object

BSC.BSC_KPI_SHELL_CMDS_TL is referenced by following:

APPS
SYNONYM - BSC_KPI_SHELL_CMDS_TL

[top of page]

Table: BSC_KPI_SHELL_CMDS_USER

Description: Links command information by user
Primary Key: BSC_KPI_SHELL_CMDS_USER_PK
  1. INDICATOR
  2. SHELL_CMD_ID
  3. USER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_SHELL_CMDS_USER.USER_ID BSC_USERS
BSC_KPI_SHELL_CMDS_USER.INDICATOR
BSC_KPI_SHELL_CMDS_USER.SHELL_CMD_ID
BSC_KPI_SHELL_CMDS_TL

[top of page]

BSC.BSC_KPI_SHELL_CMDS_USER does not reference any database object

BSC.BSC_KPI_SHELL_CMDS_USER is referenced by following:

APPS
SYNONYM - BSC_KPI_SHELL_CMDS_USER

[top of page]

Table: BSC_KPI_SUBTITLES_TL

Description: Indicator sub titles information
Primary Key: BSC_KPI_SUBTITLES_TL_PK
  1. ANALYSIS_OPTION0
  2. ANALYSIS_OPTION1
  3. CALC_COMB
  4. LANGUAGE
  5. INDICATOR
  6. ANALYSIS_OPTION2
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_SUBTITLES_TL.INDICATOR BSC_KPIS_B

[top of page]

BSC.BSC_KPI_SUBTITLES_TL does not reference any database object

BSC.BSC_KPI_SUBTITLES_TL is referenced by following:

APPS
SYNONYM - BSC_KPI_SUBTITLES_TL

[top of page]

Table: BSC_KPI_TREE_NODES_B

Description: Simulation tree nodes information
Primary Key: BSC_KPI_TREE_NODES_B_PK
  1. INDICATOR
  2. NODE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_TREE_NODES_B.INDICATOR BSC_KPIS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPI_TREE_NODES_TL.INDICATOR
BSC_KPI_TREE_NODES_TL.NODE_ID
BSC_KPI_TREE_NODES_B

[top of page]

BSC.BSC_KPI_TREE_NODES_B does not reference any database object

BSC.BSC_KPI_TREE_NODES_B is referenced by following:

APPS
SYNONYM - BSC_KPI_TREE_NODES_B

[top of page]

Table: BSC_KPI_TREE_NODES_TL

Description: Translated simulation tree nodes information
Primary Key: BSC_KPI_TREE_NODES_TL_PK
  1. INDICATOR
  2. LANGUAGE
  3. NODE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_TREE_NODES_TL.INDICATOR
BSC_KPI_TREE_NODES_TL.NODE_ID
BSC_KPI_TREE_NODES_B

[top of page]

BSC.BSC_KPI_TREE_NODES_TL does not reference any database object

BSC.BSC_KPI_TREE_NODES_TL is referenced by following:

APPS
SYNONYM - BSC_KPI_TREE_NODES_TL

[top of page]

Table: BSC_MESSAGE_LOGS

Description: Errors/log messages information

[top of page]

BSC.BSC_MESSAGE_LOGS does not reference any database object

BSC.BSC_MESSAGE_LOGS is referenced by following:

APPS
SYNONYM - BSC_MESSAGE_LOGS

[top of page]

Table: BSC_MIG_SRC_SYS_DETAILS

Description:

[top of page]

BSC.BSC_MIG_SRC_SYS_DETAILS does not reference any database object

BSC.BSC_MIG_SRC_SYS_DETAILS is referenced by following:

APPS
SYNONYM - BSC_MIG_SRC_SYS_DETAILS

[top of page]

Table: BSC_OBJECT_LOCKS

Description:

[top of page]

BSC.BSC_OBJECT_LOCKS does not reference any database object

BSC.BSC_OBJECT_LOCKS is referenced by following:

APPS
SYNONYM - BSC_OBJECT_LOCKS

[top of page]

Table: BSC_OBJECT_LOCK_USERS

Description:

[top of page]

BSC.BSC_OBJECT_LOCK_USERS does not reference any database object

BSC.BSC_OBJECT_LOCK_USERS is referenced by following:

APPS
SYNONYM - BSC_OBJECT_LOCK_USERS

[top of page]

Table: BSC_OLAP_OBJECT

Description:

[top of page]

BSC.BSC_OLAP_OBJECT does not reference any database object

BSC.BSC_OLAP_OBJECT is referenced by following:

APPS
SYNONYM - BSC_OLAP_OBJECT

[top of page]

Table: BSC_OLAP_OBJECT_RELATION

Description:

[top of page]

BSC.BSC_OLAP_OBJECT_RELATION does not reference any database object

BSC.BSC_OLAP_OBJECT_RELATION is referenced by following:

APPS
SYNONYM - BSC_OLAP_OBJECT_RELATION

[top of page]

Table: BSC_REPORTING_CALENDAR

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

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

[top of page]

BSC.BSC_REPORTING_CALENDAR does not reference any database object

BSC.BSC_REPORTING_CALENDAR is referenced by following:

APPS
SYNONYM - BSC_REPORTING_CALENDAR

[top of page]

Table: BSC_RESPONSIBILITY

Description: Responsibilities information
Primary Key: BSC_RESPONSIBILITY_PK
  1. RESPONSIBILITY_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_RESPONSIBILITY_TL.RESPONSIBILITY_ID BSC_RESPONSIBILITY
BSC_USER_RESPONSIBILITY.RESPONSIBILITY_ID BSC_RESPONSIBILITY
BSC_USER_TAB_ACCESS.RESPONSIBILITY_ID BSC_RESPONSIBILITY

[top of page]

BSC.BSC_RESPONSIBILITY does not reference any database object

BSC.BSC_RESPONSIBILITY is referenced by following:

APPS
SYNONYM - BSC_RESPONSIBILITY

[top of page]

Table: BSC_RESPONSIBILITY_TL

Description: Translated BSC responsibilities information.
Primary Key: BSC_RESPONSIBILITY_TL_PK
  1. APPLICATION_ID
  2. LANGUAGE
  3. RESPONSIBILITY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_RESPONSIBILITY_TL.RESPONSIBILITY_ID BSC_RESPONSIBILITY

[top of page]

BSC.BSC_RESPONSIBILITY_TL does not reference any database object

BSC.BSC_RESPONSIBILITY_TL is referenced by following:

APPS
SYNONYM - BSC_RESPONSIBILITY_TL

[top of page]

Table: BSC_RPT_KEYS

Description:

[top of page]

BSC.BSC_RPT_KEYS does not reference any database object

BSC.BSC_RPT_KEYS is referenced by following:

APPS
SYNONYM - BSC_RPT_KEYS

[top of page]

Table: BSC_SYS_BENCHMARKS_B

Description: Benchmarks information
Primary Key: BSC_SYS_BENCHMARKS_B_PK
  1. BM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_SYS_BENCHMARKS_B.PERIODICITY_ID BSC_SYS_PERIODICITIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPI_SERIES_COLORS.BM_ID BSC_SYS_BENCHMARKS_B
BSC_SYS_BENCHMARKS_TL.BM_ID BSC_SYS_BENCHMARKS_B
BSC_SYS_BM_GROUPS.BM_ID BSC_SYS_BENCHMARKS_B

[top of page]

BSC.BSC_SYS_BENCHMARKS_B does not reference any database object

BSC.BSC_SYS_BENCHMARKS_B is referenced by following:

APPS
SYNONYM - BSC_SYS_BENCHMARKS_B

[top of page]

Table: BSC_SYS_BENCHMARKS_TL

Description: Translated benchmarks information
Primary Key: BSC_SYS_BENCHMARKS_TL_PK
  1. BM_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_SYS_BENCHMARKS_TL.BM_ID BSC_SYS_BENCHMARKS_B

[top of page]

BSC.BSC_SYS_BENCHMARKS_TL does not reference any database object

BSC.BSC_SYS_BENCHMARKS_TL is referenced by following:

APPS
SYNONYM - BSC_SYS_BENCHMARKS_TL

[top of page]

Table: BSC_SYS_BM_GROUPS

Description: Benchmark groups information
Primary Key: BSC_SYS_BM_GROUPS_PK
  1. BM_GROUP_ID
  2. BM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_SYS_BM_GROUPS.BM_ID BSC_SYS_BENCHMARKS_B

[top of page]

BSC.BSC_SYS_BM_GROUPS does not reference any database object

BSC.BSC_SYS_BM_GROUPS is referenced by following:

APPS
SYNONYM - BSC_SYS_BM_GROUPS

[top of page]

Table: BSC_SYS_CALCULATIONS

Description: System calculations
Primary Key: BSC_SYS_CALCULATIONS_PK
  1. CALCULATION_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPI_CALCULATIONS.CALCULATION_ID BSC_SYS_CALCULATIONS
BSC_SYS_DATASET_CALC.DISABLED_CALC_ID BSC_SYS_CALCULATIONS

[top of page]

BSC.BSC_SYS_CALCULATIONS does not reference any database object

BSC.BSC_SYS_CALCULATIONS is referenced by following:

APPS
SYNONYM - BSC_SYS_CALCULATIONS

[top of page]

Table: BSC_SYS_CALENDARS_B

Description: Calendar information
Primary Key: BSC_SYS_CALENDARS_B_PK
  1. CALENDAR_ID

[top of page]

BSC.BSC_SYS_CALENDARS_B does not reference any database object

BSC.BSC_SYS_CALENDARS_B is referenced by following:

APPS
SYNONYM - BSC_SYS_CALENDARS_B

[top of page]

Table: BSC_SYS_CALENDARS_TL

Description: Translated calendar information
Primary Key: BSC_SYS_CALENDARS_TL_PK
  1. CALENDAR_ID
  2. LANGUAGE

[top of page]

BSC.BSC_SYS_CALENDARS_TL does not reference any database object

BSC.BSC_SYS_CALENDARS_TL is referenced by following:

APPS
SYNONYM - BSC_SYS_CALENDARS_TL

[top of page]

Table: BSC_SYS_COLORS_B

Description: Table to store all colors and related properties, mainly used for the Performance Bands.

[top of page]

BSC.BSC_SYS_COLORS_B does not reference any database object

BSC.BSC_SYS_COLORS_B is referenced by following:

APPS
SYNONYM - BSC_SYS_COLORS_B

[top of page]

Table: BSC_SYS_COLORS_TL

Description: Translation table for colors

[top of page]

BSC.BSC_SYS_COLORS_TL does not reference any database object

BSC.BSC_SYS_COLORS_TL is referenced by following:

APPS
SYNONYM - BSC_SYS_COLORS_TL

[top of page]

Table: BSC_SYS_COM_DIM_LEVELS

Description: Common dimension levels information
Primary Key: BSC_SYS_COM_DIM_LEVELS_PK
  1. DIM_LEVEL_INDEX
  2. TAB_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_SYS_COM_DIM_LEVELS.TAB_ID BSC_TABS_B
BSC_SYS_COM_DIM_LEVELS.DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B
BSC_SYS_COM_DIM_LEVELS.PARENT_DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B

[top of page]

BSC.BSC_SYS_COM_DIM_LEVELS does not reference any database object

BSC.BSC_SYS_COM_DIM_LEVELS is referenced by following:

APPS
SYNONYM - BSC_SYS_COM_DIM_LEVELS

[top of page]

Table: BSC_SYS_DATASETS_B

Description: Datasets information
Primary Key: BSC_SYS_DATASETS_B_PK
  1. DATASET_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_SYS_DATASETS_B.MEASURE_ID1 BSC_SYS_MEASURES
BSC_SYS_DATASETS_B.MEASURE_ID2 BSC_SYS_MEASURES
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPI_ANALYSIS_MEASURES_B.DATASET_ID BSC_SYS_DATASETS_B
BSC_SYS_DATASETS_TL.DATASET_ID BSC_SYS_DATASETS_B
BSC_SYS_DATASET_CALC.DATASET_ID BSC_SYS_DATASETS_B

[top of page]

BSC.BSC_SYS_DATASETS_B does not reference any database object

BSC.BSC_SYS_DATASETS_B is referenced by following:

APPS
SYNONYM - BSC_SYS_DATASETS_B

[top of page]

Table: BSC_SYS_DATASETS_TL

Description: Translated datasets information
Primary Key: BSC_SYS_DATASETS_TL_PK
  1. DATASET_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_SYS_DATASETS_TL.DATASET_ID BSC_SYS_DATASETS_B

[top of page]

BSC.BSC_SYS_DATASETS_TL does not reference any database object

BSC.BSC_SYS_DATASETS_TL is referenced by following:

APPS
SYNONYM - BSC_SYS_DATASETS_TL

[top of page]

Table: BSC_SYS_DATASET_CALC

Description: Disabled calculations information per dataset
Primary Key: BSC_SYS_DATASET_CALC_PK
  1. DATASET_ID
  2. DISABLED_CALC_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_SYS_DATASET_CALC.DATASET_ID BSC_SYS_DATASETS_B
BSC_SYS_DATASET_CALC.DISABLED_CALC_ID BSC_SYS_CALCULATIONS

[top of page]

BSC.BSC_SYS_DATASET_CALC does not reference any database object

BSC.BSC_SYS_DATASET_CALC is referenced by following:

APPS
SYNONYM - BSC_SYS_DATASET_CALC

[top of page]

Table: BSC_SYS_DIM_GROUPS_TL

Description: Translated dimension groups information
Primary Key: BSC_SYS_DIM_GROUPS_TL_PK
  1. DIM_GROUP_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPI_DIM_GROUPS.DIM_GROUP_ID BSC_SYS_DIM_GROUPS_TL
BSC_SYS_DIM_LEVELS_BY_GROUP.DIM_GROUP_ID BSC_SYS_DIM_GROUPS_TL

[top of page]

BSC.BSC_SYS_DIM_GROUPS_TL does not reference any database object

BSC.BSC_SYS_DIM_GROUPS_TL is referenced by following:

APPS
SYNONYM - BSC_SYS_DIM_GROUPS_TL

[top of page]

Table: BSC_SYS_DIM_LEVELS_B

Description: Dimension levels information
Primary Key: BSC_SYS_DIM_LEVELS_B_PK
  1. DIM_LEVEL_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPI_DIM_LEVEL_PROPERTIES.DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B
BSC_SYS_COM_DIM_LEVELS.DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B
BSC_SYS_COM_DIM_LEVELS.PARENT_DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B
BSC_SYS_DIM_LEVELS_TL.DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B
BSC_SYS_DIM_LEVELS_BY_GROUP.DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B
BSC_SYS_DIM_LEVEL_COLS.DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B
BSC_SYS_DIM_LEVEL_RELS.DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B
BSC_SYS_DIM_LEVEL_RELS.PARENT_DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B
BSC_SYS_FILTERS.DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B
BSC_SYS_FILTERS_VIEWS.DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B

[top of page]

BSC.BSC_SYS_DIM_LEVELS_B does not reference any database object

BSC.BSC_SYS_DIM_LEVELS_B is referenced by following:

APPS
SYNONYM - BSC_SYS_DIM_LEVELS_B

[top of page]

Table: BSC_SYS_DIM_LEVELS_BY_GROUP

Description: Dimension levels by dimension group
Primary Key: BSC_SYS_DIM_LEVELS_BY_GROUP_PK
  1. DIM_LEVEL_ID
  2. DIM_GROUP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_SYS_DIM_LEVELS_BY_GROUP.DIM_GROUP_ID BSC_SYS_DIM_GROUPS_TL
BSC_SYS_DIM_LEVELS_BY_GROUP.DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B

[top of page]

BSC.BSC_SYS_DIM_LEVELS_BY_GROUP does not reference any database object

BSC.BSC_SYS_DIM_LEVELS_BY_GROUP is referenced by following:

APPS
SYNONYM - BSC_SYS_DIM_LEVELS_BY_GROUP

[top of page]

Table: BSC_SYS_DIM_LEVELS_TL

Description: Translated dimension levels information
Primary Key: BSC_SYS_DIM_LEVELS_TL_PK
  1. DIM_LEVEL_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_SYS_DIM_LEVELS_TL.DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B

[top of page]

BSC.BSC_SYS_DIM_LEVELS_TL does not reference any database object

BSC.BSC_SYS_DIM_LEVELS_TL is referenced by following:

APPS
SYNONYM - BSC_SYS_DIM_LEVELS_TL

[top of page]

Table: BSC_SYS_DIM_LEVEL_COLS

Description: Dimension levels table structure
Primary Key: BSC_SYS_DIM_LEVEL_COLS_PK
  1. COLUMN_NAME
  2. DIM_LEVEL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_SYS_DIM_LEVEL_COLS.DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B

[top of page]

BSC.BSC_SYS_DIM_LEVEL_COLS does not reference any database object

BSC.BSC_SYS_DIM_LEVEL_COLS is referenced by following:

APPS
SYNONYM - BSC_SYS_DIM_LEVEL_COLS

[top of page]

Table: BSC_SYS_DIM_LEVEL_RELS

Description: Dimension levels relationships
Primary Key: BSC_SYS_DIM_LEVEL_RELS_PK
  1. DIM_LEVEL_ID
  2. PARENT_DIM_LEVEL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_SYS_DIM_LEVEL_RELS.DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B
BSC_SYS_DIM_LEVEL_RELS.PARENT_DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B

[top of page]

BSC.BSC_SYS_DIM_LEVEL_RELS does not reference any database object

BSC.BSC_SYS_DIM_LEVEL_RELS is referenced by following:

APPS
SYNONYM - BSC_SYS_DIM_LEVEL_RELS

[top of page]

Table: BSC_SYS_FILES

Description: Files information
Primary Key: BSC_SYS_FILES_PK
  1. FILE_INDEX
  2. FILE_TYPE
  3. INDICATOR

[top of page]

BSC.BSC_SYS_FILES does not reference any database object

BSC.BSC_SYS_FILES is referenced by following:

APPS
SYNONYM - BSC_SYS_FILES

[top of page]

Table: BSC_SYS_FILTERS

Description: Filter information
Primary Key: BSC_SYS_FILTERS_PK
  1. DIM_LEVEL_ID
  2. SOURCE_CODE
  3. SOURCE_TYPE
  4. DIM_LEVEL_VALUE
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_SYS_FILTERS.DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B

[top of page]

BSC.BSC_SYS_FILTERS does not reference any database object

BSC.BSC_SYS_FILTERS is referenced by following:

APPS
SYNONYM - BSC_SYS_FILTERS

[top of page]

Table: BSC_SYS_FILTERS_VIEWS

Description: Filter views information
Primary Key: BSC_SYS_FILTERS_VIEWS_PK
  1. DIM_LEVEL_ID
  2. SOURCE_TYPE
  3. SOURCE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_SYS_FILTERS_VIEWS.DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B

[top of page]

BSC.BSC_SYS_FILTERS_VIEWS does not reference any database object

BSC.BSC_SYS_FILTERS_VIEWS is referenced by following:

APPS
SYNONYM - BSC_SYS_FILTERS_VIEWS

[top of page]

Table: BSC_SYS_FORMATS

Description: Number format
Primary Key: BSC_SYS_FORMATS_PK
  1. FORMAT_ID

[top of page]

BSC.BSC_SYS_FORMATS does not reference any database object

BSC.BSC_SYS_FORMATS is referenced by following:

APPS
SYNONYM - BSC_SYS_FORMATS

[top of page]

Table: BSC_SYS_IMAGES

Description: Images files information
Primary Key: BSC_SYS_IMAGES_PK
  1. IMAGE_ID

[top of page]

BSC.BSC_SYS_IMAGES does not reference any database object

BSC.BSC_SYS_IMAGES is referenced by following:

APPS
SYNONYM - BSC_SYS_IMAGES

[top of page]

Table: BSC_SYS_IMAGES_MAP_TL

Description: Image map information
Primary Key: BSC_SYS_IMAGES_MAP_TL_PK
  1. SOURCE_TYPE
  2. LANGUAGE
  3. TYPE
  4. SOURCE_CODE

[top of page]

BSC.BSC_SYS_IMAGES_MAP_TL does not reference any database object

BSC.BSC_SYS_IMAGES_MAP_TL is referenced by following:

APPS
SYNONYM - BSC_SYS_IMAGES_MAP_TL

[top of page]

Table: BSC_SYS_INIT

Description: System Properties
Primary Key: BSC_SYS_INIT_PK
  1. PROPERTY_CODE

[top of page]

BSC.BSC_SYS_INIT does not reference any database object

BSC.BSC_SYS_INIT is referenced by following:

APPS
SYNONYM - BSC_SYS_INIT

[top of page]

Table: BSC_SYS_KPI_COLORS

Description: Kpi color by tab
Primary Key: BSC_SYS_KPI_COLORS_PK
  1. DIM_LEVEL3
  2. DIM_LEVEL7
  3. DIM_LEVEL2
  4. DIM_LEVEL1
  5. TAB_ID
  6. PERIOD_ID
  7. INDICATOR
  8. DIM_LEVEL8
  9. DIM_LEVEL6
  10. DIM_LEVEL4
  11. DIM_LEVEL5
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_SYS_KPI_COLORS.TAB_ID
BSC_SYS_KPI_COLORS.INDICATOR
BSC_TAB_INDICATORS

[top of page]

BSC.BSC_SYS_KPI_COLORS does not reference any database object

BSC.BSC_SYS_KPI_COLORS is referenced by following:

APPS
SYNONYM - BSC_SYS_KPI_COLORS

[top of page]

Table: BSC_SYS_LABELS_B

Description: Labels information
Primary Key: BSC_SYS_LABELS_B_PK
  1. LABEL_ID
  2. SOURCE_TYPE
  3. SOURCE_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_SYS_LABELS_TL.SOURCE_CODE
BSC_SYS_LABELS_TL.SOURCE_TYPE
BSC_SYS_LABELS_TL.LABEL_ID
BSC_SYS_LABELS_B

[top of page]

BSC.BSC_SYS_LABELS_B does not reference any database object

BSC.BSC_SYS_LABELS_B is referenced by following:

APPS
SYNONYM - BSC_SYS_LABELS_B

[top of page]

Table: BSC_SYS_LABELS_TL

Description: Translated label information
Primary Key: BSC_SYS_LABELS_TL_PK
  1. LABEL_ID
  2. LANGUAGE
  3. SOURCE_CODE
  4. SOURCE_TYPE
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_SYS_LABELS_TL.SOURCE_CODE
BSC_SYS_LABELS_TL.SOURCE_TYPE
BSC_SYS_LABELS_TL.LABEL_ID
BSC_SYS_LABELS_B

[top of page]

BSC.BSC_SYS_LABELS_TL does not reference any database object

BSC.BSC_SYS_LABELS_TL is referenced by following:

APPS
SYNONYM - BSC_SYS_LABELS_TL

[top of page]

Table: BSC_SYS_LINES

Description: Lines information
Primary Key: BSC_SYS_LINES_PK
  1. LINE_ID
  2. LINE_TYPE
  3. SOURCE_CODE
  4. SOURCE_TYPE

[top of page]

BSC.BSC_SYS_LINES does not reference any database object

BSC.BSC_SYS_LINES is referenced by following:

APPS
SYNONYM - BSC_SYS_LINES

[top of page]

Table: BSC_SYS_MEASURES

Description: Measure information
Primary Key: BSC_SYS_MEASURES_PK
  1. MEASURE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_SYS_DATASETS_B.MEASURE_ID1 BSC_SYS_MEASURES
BSC_SYS_DATASETS_B.MEASURE_ID2 BSC_SYS_MEASURES

[top of page]

BSC.BSC_SYS_MEASURES does not reference any database object

BSC.BSC_SYS_MEASURES is referenced by following:

APPS
SYNONYM - BSC_SYS_MEASURES

[top of page]

Table: BSC_SYS_MM_CONTROLS_TL

Description: Translated multimedia remote control information
Primary Key: BSC_SYS_MM_CONTROLS_TL_PK
  1. BUTTON_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPI_MM_CONTROLS.BUTTON_ID BSC_SYS_MM_CONTROLS_TL

[top of page]

BSC.BSC_SYS_MM_CONTROLS_TL does not reference any database object

BSC.BSC_SYS_MM_CONTROLS_TL is referenced by following:

APPS
SYNONYM - BSC_SYS_MM_CONTROLS_TL

[top of page]

Table: BSC_SYS_OBJECTIVE_COLORS

Description: Table to store the color of the Objectives

[top of page]

BSC.BSC_SYS_OBJECTIVE_COLORS does not reference any database object

BSC.BSC_SYS_OBJECTIVE_COLORS is referenced by following:

APPS
SYNONYM - BSC_SYS_OBJECTIVE_COLORS

[top of page]

Table: BSC_SYS_PERIODICITIES

Description: Periodicity information
Primary Key: BSC_SYS_PERIODICITIES_PK
  1. PERIODICITY_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_DB_TABLES.PERIODICITY_ID BSC_SYS_PERIODICITIES
BSC_KPIS_B.PERIODICITY_ID BSC_SYS_PERIODICITIES
BSC_KPI_PERIODICITIES.PERIODICITY_ID BSC_SYS_PERIODICITIES
BSC_SYS_BENCHMARKS_B.PERIODICITY_ID BSC_SYS_PERIODICITIES

[top of page]

BSC.BSC_SYS_PERIODICITIES does not reference any database object

BSC.BSC_SYS_PERIODICITIES is referenced by following:

APPS
SYNONYM - BSC_SYS_PERIODICITIES

[top of page]

Table: BSC_SYS_PERIODICITIES_TL

Description: translated periodicity information
Primary Key: BSC_SYS_PERIODICITIES_TL_PK
  1. PERIODICITY_ID
  2. LANGUAGE

[top of page]

BSC.BSC_SYS_PERIODICITIES_TL does not reference any database object

BSC.BSC_SYS_PERIODICITIES_TL is referenced by following:

APPS
SYNONYM - BSC_SYS_PERIODICITIES_TL

[top of page]

Table: BSC_SYS_PERIODS

Description: Periods information
Primary Key: BSC_SYS_PERIODS_PK
  1. PERIODICITY_ID
  2. PERIOD_ID
  3. YEAR

[top of page]

BSC.BSC_SYS_PERIODS does not reference any database object

BSC.BSC_SYS_PERIODS is referenced by following:

APPS
SYNONYM - BSC_SYS_PERIODS

[top of page]

Table: BSC_SYS_PERIODS_TL

Description: Translated Period information
Primary Key: BSC_SYS_PERIODS_TL_PK
  1. YEAR
  2. PERIODICITY_ID
  3. PERIOD_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPI_COMMENTS.PERIODICITY_ID
BSC_KPI_COMMENTS.PERIOD_ID
BSC_KPI_COMMENTS.YEAR
BSC_SYS_PERIODS_TL

[top of page]

BSC.BSC_SYS_PERIODS_TL does not reference any database object

BSC.BSC_SYS_PERIODS_TL is referenced by following:

APPS
SYNONYM - BSC_SYS_PERIODS_TL

[top of page]

Table: BSC_SYS_SERIES_COLORS

Description: Series colors information
Primary Key: BSC_SYS_SERIES_COLORS_PK
  1. SERIES_ID

[top of page]

BSC.BSC_SYS_SERIES_COLORS does not reference any database object

BSC.BSC_SYS_SERIES_COLORS is referenced by following:

APPS
SYNONYM - BSC_SYS_SERIES_COLORS

[top of page]

Table: BSC_SYS_USER_OPTIONS

Description: User options information
Primary Key: BSC_SYS_USER_OPTIONS_PK
  1. SOURCE_CODE
  2. USER_OPT_ID
  3. SOURCE_TYPE

[top of page]

BSC.BSC_SYS_USER_OPTIONS does not reference any database object

BSC.BSC_SYS_USER_OPTIONS is referenced by following:

APPS
SYNONYM - BSC_SYS_USER_OPTIONS

[top of page]

Table: BSC_TABS_B

Description: Tabs information
Primary Key: BSC_TABS_B_PK
  1. TAB_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_SYS_COM_DIM_LEVELS.TAB_ID BSC_TABS_B
BSC_TABS_TL.TAB_ID BSC_TABS_B
BSC_TAB_CSF_B.TAB_ID BSC_TABS_B
BSC_TAB_VIEWS_B.TAB_ID BSC_TABS_B
BSC_USER_LIST_ACCESS.TAB_ID BSC_TABS_B
BSC_USER_TAB_ACCESS.TAB_ID BSC_TABS_B

[top of page]

BSC.BSC_TABS_B does not reference any database object

BSC.BSC_TABS_B is referenced by following:

APPS
SYNONYM - BSC_TABS_B

[top of page]

Table: BSC_TABS_TL

Description: Translated tabs information
Primary Key: BSC_TABS_TL_PK
  1. LANGUAGE
  2. TAB_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_TABS_TL.TAB_ID BSC_TABS_B

[top of page]

BSC.BSC_TABS_TL does not reference any database object

BSC.BSC_TABS_TL is referenced by following:

APPS
SYNONYM - BSC_TABS_TL

[top of page]

Table: BSC_TAB_CSF_B

Description: Critical success factor information
Primary Key: BSC_TAB_CSF_B_PK
  1. CSF_ID
  2. TAB_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_TAB_CSF_B.TAB_ID BSC_TABS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_TAB_CSF_TL.CSF_ID
BSC_TAB_CSF_TL.TAB_ID
BSC_TAB_CSF_B
BSC_TAB_IND_GROUPS_B.CSF_ID
BSC_TAB_IND_GROUPS_B.TAB_ID
BSC_TAB_CSF_B

[top of page]

BSC.BSC_TAB_CSF_B does not reference any database object

BSC.BSC_TAB_CSF_B is referenced by following:

APPS
SYNONYM - BSC_TAB_CSF_B

[top of page]

Table: BSC_TAB_CSF_TL

Description: Translated critical success factor information
Primary Key: BSC_TAB_CSF_TL_PK
  1. CSF_ID
  2. LANGUAGE
  3. TAB_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_TAB_CSF_TL.CSF_ID
BSC_TAB_CSF_TL.TAB_ID
BSC_TAB_CSF_B

[top of page]

BSC.BSC_TAB_CSF_TL does not reference any database object

BSC.BSC_TAB_CSF_TL is referenced by following:

APPS
SYNONYM - BSC_TAB_CSF_TL

[top of page]

Table: BSC_TAB_INDICATORS

Description: Indicator by tab information
Primary Key: BSC_TAB_INDICATORS_PK
  1. INDICATOR
  2. TAB_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_TAB_INDICATORS.INDICATOR BSC_KPIS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPI_DEFAULTS_B.TAB_ID
BSC_KPI_DEFAULTS_B.INDICATOR
BSC_TAB_INDICATORS
BSC_SYS_KPI_COLORS.TAB_ID
BSC_SYS_KPI_COLORS.INDICATOR
BSC_TAB_INDICATORS

[top of page]

BSC.BSC_TAB_INDICATORS does not reference any database object

BSC.BSC_TAB_INDICATORS is referenced by following:

APPS
SYNONYM - BSC_TAB_INDICATORS

[top of page]

Table: BSC_TAB_IND_GROUPS_B

Description: Indicator groups information
Primary Key: BSC_TAB_IND_GROUPS_B_PK
  1. CSF_ID
  2. IND_GROUP_ID
  3. TAB_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_TAB_IND_GROUPS_B.CSF_ID
BSC_TAB_IND_GROUPS_B.TAB_ID
BSC_TAB_CSF_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_TAB_IND_GROUPS_TL.CSF_ID
BSC_TAB_IND_GROUPS_TL.IND_GROUP_ID
BSC_TAB_IND_GROUPS_TL.TAB_ID
BSC_TAB_IND_GROUPS_B

[top of page]

BSC.BSC_TAB_IND_GROUPS_B does not reference any database object

BSC.BSC_TAB_IND_GROUPS_B is referenced by following:

APPS
SYNONYM - BSC_TAB_IND_GROUPS_B

[top of page]

Table: BSC_TAB_IND_GROUPS_TL

Description: Translated Indicator groups information
Primary Key: BSC_TAB_IND_GROUPS_TL_PK
  1. CSF_ID
  2. LANGUAGE
  3. TAB_ID
  4. IND_GROUP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_TAB_IND_GROUPS_TL.CSF_ID
BSC_TAB_IND_GROUPS_TL.IND_GROUP_ID
BSC_TAB_IND_GROUPS_TL.TAB_ID
BSC_TAB_IND_GROUPS_B

[top of page]

BSC.BSC_TAB_IND_GROUPS_TL does not reference any database object

BSC.BSC_TAB_IND_GROUPS_TL is referenced by following:

APPS
SYNONYM - BSC_TAB_IND_GROUPS_TL

[top of page]

Table: BSC_TAB_VIEWS_B

Description: Tab Views information
Primary Key: BSC_TAB_VIEWS_B_PK
  1. TAB_ID
  2. TAB_VIEW_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_TAB_VIEWS_B.TAB_ID BSC_TABS_B

[top of page]

BSC.BSC_TAB_VIEWS_B does not reference any database object

BSC.BSC_TAB_VIEWS_B is referenced by following:

APPS
SYNONYM - BSC_TAB_VIEWS_B

[top of page]

Table: BSC_TAB_VIEWS_TL

Description: Translated Tab Views information
Primary Key: BSC_TAB_VIEWS_TL_PK
  1. TAB_ID
  2. TAB_VIEW_ID
  3. LANGUAGE

[top of page]

BSC.BSC_TAB_VIEWS_TL does not reference any database object

BSC.BSC_TAB_VIEWS_TL is referenced by following:

APPS
SYNONYM - BSC_TAB_VIEWS_TL

[top of page]

Table: BSC_TAB_VIEW_KPI_TL

Description: Translated Indicator by Tab View information
Primary Key: BSC_TAB_VIEW_KPI_TL_PK
  1. TAB_ID
  2. TAB_VIEW_ID
  3. LANGUAGE
  4. INDICATOR

[top of page]

BSC.BSC_TAB_VIEW_KPI_TL does not reference any database object

BSC.BSC_TAB_VIEW_KPI_TL is referenced by following:

APPS
SYNONYM - BSC_TAB_VIEW_KPI_TL

[top of page]

Table: BSC_TAB_VIEW_LABELS_B

Description: Tab View information
Primary Key: BSC_TAB_VIEW_LABELS_B_PK
  1. TAB_ID
  2. TAB_VIEW_ID
  3. LABEL_ID

[top of page]

BSC.BSC_TAB_VIEW_LABELS_B does not reference any database object

BSC.BSC_TAB_VIEW_LABELS_B is referenced by following:

APPS
SYNONYM - BSC_TAB_VIEW_LABELS_B

[top of page]

Table: BSC_TAB_VIEW_LABELS_TL

Description: Translated Labels by Tab View information
Primary Key: BSC_TAB_VIEW_LABELS_TL_PK
  1. TAB_ID
  2. TAB_VIEW_ID
  3. LABEL_ID
  4. LANGUAGE

[top of page]

BSC.BSC_TAB_VIEW_LABELS_TL does not reference any database object

BSC.BSC_TAB_VIEW_LABELS_TL is referenced by following:

APPS
SYNONYM - BSC_TAB_VIEW_LABELS_TL

[top of page]

Table: BSC_TMP_BIG_IN_COND

Description: Temporary table used to store information about temporary variables

[top of page]

BSC.BSC_TMP_BIG_IN_COND does not reference any database object

BSC.BSC_TMP_BIG_IN_COND is referenced by following:

APPS
SYNONYM - BSC_TMP_BIG_IN_COND

[top of page]

Table: BSC_TMP_OPT_UI_KPIS

Description: Temporary table used to store KPI information, to improve performance

[top of page]

BSC.BSC_TMP_OPT_UI_KPIS does not reference any database object

BSC.BSC_TMP_OPT_UI_KPIS is referenced by following:

APPS
SYNONYM - BSC_TMP_OPT_UI_KPIS

[top of page]

Table: BSC_TMP_OPT_UI_LEVELS

Description: Temporary table used to store Dimension Sets, to improve performance

[top of page]

BSC.BSC_TMP_OPT_UI_LEVELS does not reference any database object

BSC.BSC_TMP_OPT_UI_LEVELS is referenced by following:

APPS
SYNONYM - BSC_TMP_OPT_UI_LEVELS

[top of page]

Table: BSC_UI_COLOR_SCHEMES

Description: Scheme information
Primary Key: BSC_UI_COLOR_SCHEMES_PK
  1. SCHEME_CODE

[top of page]

BSC.BSC_UI_COLOR_SCHEMES does not reference any database object

BSC.BSC_UI_COLOR_SCHEMES is referenced by following:

APPS
SYNONYM - BSC_UI_COLOR_SCHEMES

[top of page]

Table: BSC_UI_COLOR_USER

Description: Customized scheme information
Primary Key: BSC_UI_COLOR_USER_PK
  1. USER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_UI_COLOR_USER.USER_ID BSC_USERS

[top of page]

BSC.BSC_UI_COLOR_USER does not reference any database object

BSC.BSC_UI_COLOR_USER is referenced by following:

APPS
SYNONYM - BSC_UI_COLOR_USER

[top of page]

Table: BSC_UPGRADE_TASK

Description: Migration process task information

[top of page]

BSC.BSC_UPGRADE_TASK does not reference any database object

BSC.BSC_UPGRADE_TASK is referenced by following:

APPS
SYNONYM - BSC_UPGRADE_TASK

[top of page]

Table: BSC_USERS

Description: User information
Primary Key: BSC_USERS_PK
  1. USER_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_APPS_USERS.USER_ID BSC_USERS
BSC_KPI_ANALYSIS_OPT_USER.USER_ID BSC_USERS
BSC_KPI_CALCULATIONS_USER.USER_ID BSC_USERS
BSC_KPI_DIM_LEVELS_USER.USER_ID BSC_USERS
BSC_KPI_PERIODICITIES_USER.USER_ID BSC_USERS
BSC_KPI_SHELL_CMDS_USER.USER_ID BSC_USERS
BSC_UI_COLOR_USER.USER_ID BSC_USERS
BSC_USER_INFO.USER_ID BSC_USERS
BSC_USER_RESPONSIBILITY.USER_ID BSC_USERS

[top of page]

BSC.BSC_USERS does not reference any database object

BSC.BSC_USERS is referenced by following:

APPS
SYNONYM - BSC_USERS

[top of page]

Table: BSC_USER_INFO

Description: Connection information
Primary Key: BSC_USER_INFO_PK
  1. SID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_USER_INFO.USER_ID BSC_USERS

[top of page]

BSC.BSC_USER_INFO does not reference any database object

BSC.BSC_USER_INFO is referenced by following:

APPS
SYNONYM - BSC_USER_INFO

[top of page]

Table: BSC_USER_KPIGRAPH_PLUGS

Description: Portlet information by user
Primary Key: BSC_USER_KPIGRAPH_PLUGS_PK
  1. USER_ID
  2. PLUG_ID

[top of page]

BSC.BSC_USER_KPIGRAPH_PLUGS does not reference any database object

BSC.BSC_USER_KPIGRAPH_PLUGS is referenced by following:

APPS
SYNONYM - BSC_USER_KPIGRAPH_PLUGS

[top of page]

Table: BSC_USER_KPILIST_KPIS

Description: Portlet information by user
Primary Key: BSC_USER_KPILIST_KPIS_PK
  1. PLUG_ID
  2. PARAM_LIST_ID

[top of page]

BSC.BSC_USER_KPILIST_KPIS does not reference any database object

BSC.BSC_USER_KPILIST_KPIS is referenced by following:

APPS
SYNONYM - BSC_USER_KPILIST_KPIS

[top of page]

Table: BSC_USER_KPILIST_PLUGS

Description: Portlet information by user
Primary Key: BSC_USER_KPILIST_PLUGS_PK
  1. PLUG_ID

[top of page]

BSC.BSC_USER_KPILIST_PLUGS does not reference any database object

BSC.BSC_USER_KPILIST_PLUGS is referenced by following:

APPS
SYNONYM - BSC_USER_KPILIST_PLUGS

[top of page]

Table: BSC_USER_KPI_ACCESS

Description: Indicator permissions
Primary Key: BSC_USER_KPI_ACCESS_PK
  1. INDICATOR
  2. RESPONSIBILITY_ID

[top of page]

BSC.BSC_USER_KPI_ACCESS does not reference any database object

BSC.BSC_USER_KPI_ACCESS is referenced by following:

APPS
SYNONYM - BSC_USER_KPI_ACCESS

[top of page]

Table: BSC_USER_LIST_ACCESS

Description: List button permissions
Primary Key: BSC_USER_LIST_ACCESS_PK
  1. DIM_LEVEL_INDEX
  2. RESPONSIBILITY_ID
  3. TAB_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_USER_LIST_ACCESS.TAB_ID BSC_TABS_B

[top of page]

BSC.BSC_USER_LIST_ACCESS does not reference any database object

BSC.BSC_USER_LIST_ACCESS is referenced by following:

APPS
SYNONYM - BSC_USER_LIST_ACCESS

[top of page]

Table: BSC_USER_PARAMETERS_B

Description: Indicator data for information box
Primary Key: BSC_USER_PARAMETERS_B_PK
  1. PARAM_LIST_ID

[top of page]

BSC.BSC_USER_PARAMETERS_B does not reference any database object

BSC.BSC_USER_PARAMETERS_B is referenced by following:

APPS
SYNONYM - BSC_USER_PARAMETERS_B

[top of page]

Table: BSC_USER_PARAMETERS_TL

Description: Indicator data for information box
Primary Key: BSC_USER_PARAMETERS_TL_PK
  1. LANGUAGE
  2. PARAM_LIST_ID

[top of page]

BSC.BSC_USER_PARAMETERS_TL does not reference any database object

BSC.BSC_USER_PARAMETERS_TL is referenced by following:

APPS
SYNONYM - BSC_USER_PARAMETERS_TL

[top of page]

Table: BSC_USER_RESPONSIBILITY

Description: Responsibility associated to user
Primary Key: BSC_USER_RESPONSIBILITY_PK
  1. RESPONSIBILITY_ID
  2. USER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_USER_RESPONSIBILITY.RESPONSIBILITY_ID BSC_RESPONSIBILITY
BSC_USER_RESPONSIBILITY.USER_ID BSC_USERS

[top of page]

BSC.BSC_USER_RESPONSIBILITY does not reference any database object

BSC.BSC_USER_RESPONSIBILITY is referenced by following:

APPS
SYNONYM - BSC_USER_RESPONSIBILITY

[top of page]

Table: BSC_USER_TAB_ACCESS

Description: Tab permissions
Primary Key: BSC_USER_TAB_ACCESS_PK
  1. RESPONSIBILITY_ID
  2. TAB_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_USER_TAB_ACCESS.RESPONSIBILITY_ID BSC_RESPONSIBILITY
BSC_USER_TAB_ACCESS.TAB_ID BSC_TABS_B

[top of page]

BSC.BSC_USER_TAB_ACCESS does not reference any database object

BSC.BSC_USER_TAB_ACCESS is referenced by following:

APPS
SYNONYM - BSC_USER_TAB_ACCESS

[top of page]

View: BSC_APPS_USERS_V

[top of page]

APPS.BSC_APPS_USERS_V references the following:

APPS
PACKAGE - BSC_APPS
SYNONYM - FND_USER
APPS.BSC_APPS_USERS_V is referenced by following:

APPS
PACKAGE BODY - BSC_BIS_LOCKS_PUB
PACKAGE BODY - BSC_LOCKS_PUB
PACKAGE BODY - BSC_LOCKS_PVT

[top of page]

View: BSC_BIS_DIM_LEVELS_V

[top of page]

APPS.BSC_BIS_DIM_LEVELS_V references the following:

APPS
VIEW - BIS_LEVELS_VL
SYNONYM - BSC_SYS_DIM_LEVELS_B
APPS.BSC_BIS_DIM_LEVELS_V is referenced by following:

APPS
VIEW - BSC_OAF_DIM_LEVELS_V

[top of page]

View: BSC_DB_BASIC_DIM_SETS_V

[top of page]

APPS.BSC_DB_BASIC_DIM_SETS_V references the following:

APPS
SYNONYM - BSC_KPI_ANALYSIS_GROUPS
SYNONYM - BSC_KPI_ANALYSIS_MEASURES_B
SYNONYM - BSC_KPI_ANALYSIS_OPTIONS_B
APPS.BSC_DB_BASIC_DIM_SETS_V is referenced by following:

APPS
PACKAGE BODY - BSC_COPY_INDICATOR_PUB
VIEW - BSC_DB_DATASET_DIM_SETS_V

[top of page]

View: BSC_DB_COLOR_AO_DEFAULTS_V

[top of page]

APPS.BSC_DB_COLOR_AO_DEFAULTS_V references the following:

APPS
SYNONYM - BSC_KPI_ANALYSIS_GROUPS
APPS.BSC_DB_COLOR_AO_DEFAULTS_V is referenced by following:

APPS
PACKAGE BODY - BSC_ANALYSIS_OPTION_PVT
PACKAGE BODY - BSC_BIS_KPI_MEAS_PUB
PACKAGE BODY - BSC_BIS_WRAPPER_PVT
PACKAGE BODY - BSC_COLOR_CALC_UTIL
VIEW - BSC_DB_COLOR_KPI_DEFAULTS_V
PACKAGE BODY - BSC_DESIGNER_PVT
PACKAGE BODY - BSC_KPI_COLOR_PROPERTIES_PUB
PACKAGE BODY - BSC_KPI_PUB
PACKAGE BODY - BSC_KPI_SERIES_PUB
PACKAGE BODY - BSC_OAF_VIEWS_PVT
PACKAGE BODY - BSC_OBJ_ANALYSIS_OPTIONS_PUB

[top of page]

View: BSC_DB_COLOR_KPI_DEFAULTS_V

[top of page]

APPS.BSC_DB_COLOR_KPI_DEFAULTS_V references the following:

APPS
VIEW - BSC_DB_COLOR_AO_DEFAULTS_V
VIEW - BSC_DB_DATASET_DIM_SETS_V
APPS.BSC_DB_COLOR_KPI_DEFAULTS_V is referenced by following:

APPS
PACKAGE BODY - BSC_BIS_MEASURE_PUB
VIEW - BSC_DB_COLOR_KPI_V
VIEW - BSC_DB_COLOR_MEASURES_V

[top of page]

View: BSC_DB_COLOR_KPI_V

[top of page]

APPS.BSC_DB_COLOR_KPI_V references the following:

APPS
VIEW - BSC_DB_COLOR_KPI_DEFAULTS_V
SYNONYM - BSC_KPIS_B
SYNONYM - BSC_KPI_CALCULATIONS
VIEW - BSC_KPI_DIM_LEVELS_VL
SYNONYM - BSC_TAB_INDICATORS
APPS.BSC_DB_COLOR_KPI_V is referenced by following:

APPS
PACKAGE BODY - BSC_DESIGNER_PVT
PACKAGE BODY - BSC_MO_HELPER_PKG

[top of page]

View: BSC_DB_COLOR_MEASURES_V

[top of page]

APPS.BSC_DB_COLOR_MEASURES_V references the following:

APPS
PACKAGE - BSC_APPS
VIEW - BSC_DB_COLOR_KPI_DEFAULTS_V
SYNONYM - BSC_KPIS_B
SYNONYM - BSC_KPI_PROPERTIES
SYNONYM - BSC_KPI_TREE_NODES_B
SYNONYM - BSC_SYS_DATASETS_B
SYNONYM - BSC_SYS_MEASURES
SYNONYM - BSC_TAB_INDICATORS
APPS.BSC_DB_COLOR_MEASURES_V is referenced by following:

APPS
PACKAGE BODY - BSC_UPDATE_COLOR

[top of page]

View: BSC_DB_DATASET_DIM_SETS_V

[top of page]

APPS.BSC_DB_DATASET_DIM_SETS_V references the following:

APPS
VIEW - BSC_DB_BASIC_DIM_SETS_V
VIEW - BSC_KPI_ANALYSIS_MEASURES_VL
APPS.BSC_DB_DATASET_DIM_SETS_V is referenced by following:

APPS
PACKAGE BODY - BSC_BIS_DIMENSION_PUB
PACKAGE BODY - BSC_BIS_KPI_MEAS_PUB
PACKAGE BODY - BSC_BIS_WRAPPER_PVT
PACKAGE BODY - BSC_COLOR_CALC_UTIL
PACKAGE BODY - BSC_DBGEN_BSC_READER
VIEW - BSC_DB_COLOR_KPI_DEFAULTS_V
VIEW - BSC_DB_MEASURE_BY_DIM_SET_V
PACKAGE BODY - BSC_KPI_SERIES_PUB
PACKAGE BODY - BSC_LOCKS_PVT
PACKAGE BODY - BSC_METADATA_DESC
PACKAGE BODY - BSC_MO_INDICATOR_PKG
PACKAGE BODY - BSC_OBJ_ANALYSIS_OPTIONS_PUB
PACKAGE BODY - BSC_UPDATE_UTIL

[top of page]

View: BSC_DB_MEASURE_BY_DIM_SET_V

[top of page]

APPS.BSC_DB_MEASURE_BY_DIM_SET_V references the following:

APPS
VIEW - BSC_DB_DATASET_DIM_SETS_V
VIEW - BSC_SYS_DATASETS_VL
APPS.BSC_DB_MEASURE_BY_DIM_SET_V is referenced by following:

APPS
PACKAGE BODY - BSC_DBGEN_BSC_READER
PACKAGE BODY - BSC_MO_INDICATOR_PKG

[top of page]

View: BSC_DB_MEASURE_COLS_VL

[top of page]

APPS.BSC_DB_MEASURE_COLS_VL references the following:

APPS
SYNONYM - BSC_DB_MEASURE_COLS_TL
APPS.BSC_DB_MEASURE_COLS_VL is referenced by following:

APPS
PACKAGE BODY - BSC_BIA_WRAPPER
PACKAGE BODY - BSC_BIS_CUSTOM_KPI_UTIL_PUB
PACKAGE BODY - BSC_BIS_MEASURE_PUB
PACKAGE BODY - BSC_CALCULATIONS_PUB
PACKAGE BODY - BSC_DATASETS_PVT
PACKAGE BODY - BSC_DBGEN_BSC_READER
PACKAGE BODY - BSC_MO_HELPER_PKG
PACKAGE BODY - BSC_MO_INPUT_TABLE_PKG
PACKAGE BODY - BSC_MO_UI_PKG
PACKAGE BODY - BSC_UPDATE_CALC
PACKAGE BODY - BSC_UPDATE_UTIL
PACKAGE BODY - BSC_UPGRADES

[top of page]

View: BSC_DB_MEASURE_GROUPS_VL

[top of page]

APPS.BSC_DB_MEASURE_GROUPS_VL references the following:

APPS
SYNONYM - BSC_DB_MEASURE_GROUPS_TL
APPS.BSC_DB_MEASURE_GROUPS_VL is referenced by following:

APPS
PACKAGE BODY - BSC_BIS_KPI_CRUD_PUB
PACKAGE BODY - BSC_BIS_MEASURE_PUB

[top of page]

View: BSC_EDW_CALENDAR_TYPE_VL

[top of page]

APPS.BSC_EDW_CALENDAR_TYPE_VL references the following:

APPS
SYNONYM - BSC_EDW_CALENDAR_TYPE_TL
APPS.BSC_EDW_CALENDAR_TYPE_VL is referenced by following:

APPS
PACKAGE BODY - BSC_UPDATE_UTIL

[top of page]

View: BSC_KPIS_VL

[top of page]

APPS.BSC_KPIS_VL references the following:

APPS
SYNONYM - BSC_KPIS_B
SYNONYM - BSC_KPIS_TL
SYNONYM - BSC_SYS_CALENDARS_B
APPS.BSC_KPIS_VL is referenced by following:

APPS
PACKAGE BODY - BSC_ANALYSIS_OPTION_PUB
PACKAGE BODY - BSC_ANALYSIS_OPTION_PVT
PACKAGE BODY - BSC_BIS_DIMENSION_PUB
PACKAGE BODY - BSC_BIS_DIM_OBJ_PUB
PACKAGE BODY - BSC_BIS_DIM_REL_PUB
PACKAGE BODY - BSC_BIS_KPI_CRUD_PUB
PACKAGE BODY - BSC_BIS_KPI_MEAS_PUB
PACKAGE BODY - BSC_BIS_MEASURE_PUB
PACKAGE BODY - BSC_BSC_ADAPTER
PACKAGE BODY - BSC_CALENDAR_PUB
PACKAGE BODY - BSC_COPY_INDICATOR_PUB
PACKAGE BODY - BSC_DATASETS_PVT
PACKAGE BODY - BSC_DBGEN_BSC_READER
PACKAGE BODY - BSC_DBGEN_METADATA_READER
PACKAGE BODY - BSC_DBGEN_UTILS
PACKAGE BODY - BSC_DEFAULT_KEY_ITEM_PUB
PACKAGE BODY - BSC_DESIGNER_PVT
PACKAGE BODY - BSC_KPI_PVT
PACKAGE BODY - BSC_METADATA_DESC
PACKAGE BODY - BSC_METADATA_OPTIMIZER_PKG
PACKAGE - BSC_METADATA_OPTIMIZER_PKG
PACKAGE - BSC_MIGREATION_UI
PACKAGE BODY - BSC_MO_DOC_PKG
PACKAGE BODY - BSC_MO_HELPER_PKG
PACKAGE BODY - BSC_MO_INDICATOR_PKG
PACKAGE BODY - BSC_MO_UI_PKG
PACKAGE BODY - BSC_OBJECTIVE_METADATA_SETUP
PACKAGE BODY - BSC_PERIODICITIES_PUB
PACKAGE BODY - BSC_PMF_UI_WRAPPER
PACKAGE BODY - BSC_SIMULATION_VIEW_PUB
PACKAGE BODY - BSC_SIMULATION_VIEW_PVT
VIEW - BSC_TAB_IND_V
PACKAGE BODY - BSC_UPDATE
PACKAGE BODY - BSC_UPDATE_INC
PACKAGE BODY - BSC_UPDATE_LOCK
PACKAGE BODY - BSC_UPDATE_UTIL
PACKAGE BODY - BSC_UTILITY

[top of page]

View: BSC_KPI_ANALYSIS_MEASURES_VL

[top of page]

APPS.BSC_KPI_ANALYSIS_MEASURES_VL references the following:

APPS
SYNONYM - BSC_KPI_ANALYSIS_MEASURES_B
SYNONYM - BSC_KPI_ANALYSIS_MEASURES_TL
APPS.BSC_KPI_ANALYSIS_MEASURES_VL is referenced by following:

APPS
PACKAGE BODY - BSC_ANALYSIS_OPTION_PUB
PACKAGE BODY - BSC_ANALYSIS_OPTION_PVT
PACKAGE BODY - BSC_BIS_KPI_CRUD_PUB
PACKAGE BODY - BSC_BIS_KPI_MEAS_PUB
PACKAGE BODY - BSC_BIS_MEASURE_PUB
PACKAGE BODY - BSC_DATASETS_PVT
VIEW - BSC_DB_DATASET_DIM_SETS_V
PACKAGE BODY - BSC_KPI_COLOR_PROPERTIES_PUB
PACKAGE BODY - BSC_METADATA_DESC
PACKAGE BODY - BSC_OAF_VIEWS_PVT

[top of page]

View: BSC_KPI_ANALYSIS_OPTIONS_VL

[top of page]

APPS.BSC_KPI_ANALYSIS_OPTIONS_VL references the following:

APPS
SYNONYM - BSC_KPI_ANALYSIS_OPTIONS_B
SYNONYM - BSC_KPI_ANALYSIS_OPTIONS_TL
APPS.BSC_KPI_ANALYSIS_OPTIONS_VL is referenced by following:

APPS
PACKAGE BODY - BSC_ANALYSIS_OPTION_PVT
PACKAGE BODY - BSC_BIS_KPI_MEAS_PUB
PACKAGE BODY - BSC_BIS_MEASURE_PUB
PACKAGE BODY - BSC_DESIGNER_PVT
PACKAGE BODY - BSC_KPI_SERIES_PUB
PACKAGE BODY - BSC_METADATA_DESC
PACKAGE BODY - BSC_OAF_VIEWS_PVT
PACKAGE BODY - BSC_OBJ_ANALYSIS_OPTIONS_PUB
VIEW - BSC_PMF_MEAS_V
PACKAGE BODY - BSC_PMF_UI_API_PUB

[top of page]

View: BSC_KPI_DATA_TABLES_V

[top of page]

APPS.BSC_KPI_DATA_TABLES_V references the following:

APPS
SYNONYM - BSC_KPIS_B
SYNONYM - BSC_KPI_DATA_TABLES
APPS.BSC_KPI_DATA_TABLES_V is referenced by following:

APPS
PACKAGE BODY - BSC_BSC_ADAPTER
PACKAGE BODY - BSC_MO_LOADER_CONFIG_PKG

[top of page]

View: BSC_KPI_DEFAULTS_VL

[top of page]

APPS.BSC_KPI_DEFAULTS_VL references the following:

APPS
SYNONYM - BSC_KPI_DEFAULTS_B
SYNONYM - BSC_KPI_DEFAULTS_TL
SYNONYM - BSC_SYS_CALENDARS_B
SYNONYM - BSC_SYS_PERIODICITIES
APPS.BSC_KPI_DEFAULTS_VL is referenced by following:

APPS
PACKAGE BODY - BSC_DESIGNER_PVT

[top of page]

View: BSC_KPI_DIM_LEVELS_VL

[top of page]

APPS.BSC_KPI_DIM_LEVELS_VL references the following:

APPS
SYNONYM - BSC_KPI_DIM_LEVELS_B
SYNONYM - BSC_KPI_DIM_LEVELS_TL
SYNONYM - BSC_SYS_DIM_LEVELS_B
APPS.BSC_KPI_DIM_LEVELS_VL is referenced by following:

APPS
PACKAGE BODY - BIS_PMF_GET_DIMLEVELS_PVT
PACKAGE BODY - BSC_BIS_DIMENSION_PUB
PACKAGE BODY - BSC_BIS_DIM_OBJ_PUB
PACKAGE BODY - BSC_BIS_DIM_REL_PUB
PACKAGE BODY - BSC_BIS_KPI_CRUD_PUB
PACKAGE BODY - BSC_BIS_KPI_MEAS_PUB
PACKAGE BODY - BSC_COMMON_DIM_LEVELS_PUB
VIEW - BSC_DB_COLOR_KPI_V
PACKAGE BODY - BSC_DEFAULT_KEY_ITEM_PUB
PACKAGE BODY - BSC_DESIGNER_PVT
PACKAGE BODY - BSC_DIMENSION_SETS_PUB
PACKAGE BODY - BSC_DIM_LEVEL_FILTERS_PUB
PACKAGE BODY - BSC_KPI_DIM_SETS_PKG
PACKAGE BODY - BSC_METADATA_DESC
PACKAGE BODY - BSC_MO_UI_PKG
PACKAGE BODY - BSC_UPDATE_UTIL
PACKAGE BODY - BSC_UTILITY

[top of page]

View: BSC_KPI_DIM_SETS_VL

[top of page]

APPS.BSC_KPI_DIM_SETS_VL references the following:

APPS
SYNONYM - BSC_KPI_DIM_SETS_TL
APPS.BSC_KPI_DIM_SETS_VL is referenced by following:

APPS
PACKAGE BODY - BSC_BIS_KPI_MEAS_PUB
PACKAGE BODY - BSC_COMMON_DIM_LEVELS_PUB
PACKAGE BODY - BSC_COPY_INDICATOR_PUB
PACKAGE - BSC_DEFAULT_KEY_ITEM_PUB
PACKAGE BODY - BSC_DEFAULT_KEY_ITEM_PUB
PACKAGE BODY - BSC_KPI_DIM_SETS_PKG
PACKAGE BODY - BSC_METADATA_DESC

[top of page]

View: BSC_KPI_SHELL_CMDS_VL

[top of page]

APPS.BSC_KPI_SHELL_CMDS_VL references the following:

APPS
SYNONYM - BSC_KPI_SHELL_CMDS_TL

APPS.BSC_KPI_SHELL_CMDS_VL is not referenced by any database object

[top of page]

View: BSC_KPI_SUBTITLES_VL

[top of page]

APPS.BSC_KPI_SUBTITLES_VL references the following:

APPS
SYNONYM - BSC_KPI_SUBTITLES_TL

APPS.BSC_KPI_SUBTITLES_VL is not referenced by any database object

[top of page]

View: BSC_KPI_TREE_NODES_VL

[top of page]

APPS.BSC_KPI_TREE_NODES_VL references the following:

APPS
SYNONYM - BSC_KPI_TREE_NODES_B
SYNONYM - BSC_KPI_TREE_NODES_TL
APPS.BSC_KPI_TREE_NODES_VL is referenced by following:

APPS
PACKAGE BODY - BSC_SIMULATION_VIEW_PUB
PACKAGE BODY - BSC_SIMULATION_VIEW_PVT
PACKAGE - BSC_SIMULATION_VIEW_PVT

[top of page]

View: BSC_LOOKUPS

[top of page]

APPS.BSC_LOOKUPS references the following:

APPS
SYNONYM - FND_LOOKUP_VALUES
APPS.BSC_LOOKUPS is referenced by following:

APPS
PACKAGE BODY - BSC_APPS
PACKAGE BODY - BSC_BIS_KPI_MEAS_PUB
PACKAGE BODY - BSC_BIS_LOCKS_PVT
PACKAGE - BSC_LOCKS_PVT
PACKAGE BODY - BSC_LOCKS_PVT
PACKAGE BODY - BSC_METADATA_DESC
PACKAGE BODY - BSC_PERIODICITIES_PUB
PACKAGE BODY - BSC_PMA_DIAG_TEST
VIEW - BSC_SYS_PERIODICITIES_VL
VIEW - BSC_TAB_VIEWS_VL
PACKAGE BODY - BSC_TIME_DIM_TEST
PACKAGE BODY - BSC_UPDATE_UTIL
PACKAGE BODY - BSC_WEB_ADI_LOADER_PKG

[top of page]

View: BSC_MESSAGES

[top of page]

APPS.BSC_MESSAGES references the following:

APPS
SYNONYM - FND_NEW_MESSAGES
APPS.BSC_MESSAGES is referenced by following:

APPS
PACKAGE BODY - BSC_APPS
PACKAGE BODY - BSC_PERIODICITIES_PUB
PACKAGE BODY - BSC_UPDATE_UTIL

[top of page]

View: BSC_OAF_ANALYSYS_OPT_COMB_V

[top of page]

APPS.BSC_OAF_ANALYSYS_OPT_COMB_V references the following:

APPS
SYNONYM - BSC_KPIS_B
SYNONYM - BSC_KPI_ANALYSIS_MEASURES_B
SYNONYM - BSC_KPI_ANALYSIS_OPTIONS_B
PACKAGE - BSC_OAF_VIEWS_PVT
APPS.BSC_OAF_ANALYSYS_OPT_COMB_V is referenced by following:

APPS
PACKAGE - BSC_ANALYSIS_OPTION_PUB
PACKAGE BODY - BSC_ANALYSIS_OPTION_PUB
PACKAGE BODY - BSC_ANALYSIS_OPTION_PVT
PACKAGE - BSC_ANALYSIS_OPTION_PVT
PACKAGE BODY - BSC_BIS_KPI_CRUD_PUB
PACKAGE BODY - BSC_BIS_KPI_MEAS_PUB
PACKAGE BODY - BSC_BIS_MEASURE_PUB
PACKAGE BODY - BSC_COPY_INDICATOR_PUB
PACKAGE BODY - BSC_PMF_UI_WRAPPER

[top of page]

View: BSC_OAF_DIM_LEVELS_V

[top of page]

APPS.BSC_OAF_DIM_LEVELS_V references the following:

APPS
VIEW - BSC_BIS_DIM_LEVELS_V
PACKAGE - BSC_OAF_VIEWS_PVT

APPS.BSC_OAF_DIM_LEVELS_V is not referenced by any database object

[top of page]

View: BSC_OPTS_PMF_MEAS_V

[top of page]

APPS.BSC_OPTS_PMF_MEAS_V references the following:

APPS
SYNONYM - BIS_INDICATORS
SYNONYM - BIS_INDICATORS_TL
SYNONYM - BSC_KPI_ANALYSIS_OPTIONS_B
SYNONYM - BSC_KPI_ANALYSIS_OPTIONS_TL
SYNONYM - BSC_SYS_DATASETS_B
SYNONYM - BSC_SYS_MEASURES
PACKAGE - BSC_UTILITY

APPS.BSC_OPTS_PMF_MEAS_V is not referenced by any database object

[top of page]

View: BSC_PMF_MEAS_V

[top of page]

APPS.BSC_PMF_MEAS_V references the following:

APPS
VIEW - BIS_INDICATORS_VL
VIEW - BSC_KPI_ANALYSIS_OPTIONS_VL
SYNONYM - BSC_SYS_DATASETS_B
SYNONYM - BSC_SYS_MEASURES
PACKAGE - BSC_UTILITY

APPS.BSC_PMF_MEAS_V is not referenced by any database object

[top of page]

View: BSC_RESPONSIBILITY_VL

[top of page]

APPS.BSC_RESPONSIBILITY_VL references the following:

APPS
VIEW - FND_RESPONSIBILITY_VL
APPS.BSC_RESPONSIBILITY_VL is referenced by following:

APPS
PACKAGE BODY - BSC_METADATA_DESC
PACKAGE BODY - BSC_MIGREATION_UI
PACKAGE - BSC_MIGREATION_UI

[top of page]

View: BSC_SYS_BENCHMARKS_VL

[top of page]

APPS.BSC_SYS_BENCHMARKS_VL references the following:

APPS
SYNONYM - BSC_SYS_BENCHMARKS_B
SYNONYM - BSC_SYS_BENCHMARKS_TL

APPS.BSC_SYS_BENCHMARKS_VL is not referenced by any database object

[top of page]

View: BSC_SYS_CALENDARS_VL

[top of page]

APPS.BSC_SYS_CALENDARS_VL references the following:

APPS
SYNONYM - BSC_SYS_CALENDARS_B
SYNONYM - BSC_SYS_CALENDARS_TL
APPS.BSC_SYS_CALENDARS_VL is referenced by following:

APPS
PACKAGE BODY - BSC_BIS_LOCKS_PVT
PACKAGE BODY - BSC_CALENDAR_PUB
PACKAGE BODY - BSC_COPY_INDICATOR_PUB
PACKAGE BODY - BSC_METADATA_DESC
PACKAGE BODY - BSC_MO_DOC_PKG
PACKAGE BODY - BSC_MO_HELPER_PKG
PACKAGE BODY - BSC_PERIODICITIES_PUB
PACKAGE BODY - BSC_PERIODS_UTILITY_PKG
PACKAGE BODY - BSC_UPDATE_UTIL

[top of page]

View: BSC_SYS_COLORS_VL

[top of page]

APPS.BSC_SYS_COLORS_VL references the following:

APPS
SYNONYM - BSC_SYS_COLORS_B
SYNONYM - BSC_SYS_COLORS_TL
APPS.BSC_SYS_COLORS_VL is referenced by following:

APPS
PACKAGE BODY - BSC_COLOR_PVT

[top of page]

View: BSC_SYS_DATASETS_VL

[top of page]

APPS.BSC_SYS_DATASETS_VL references the following:

APPS
SYNONYM - BSC_SYS_DATASETS_B
SYNONYM - BSC_SYS_DATASETS_TL
APPS.BSC_SYS_DATASETS_VL is referenced by following:

APPS
VIEW - BIS_APP_NAMES_RPTS_V
VIEW - BIS_DISPLAY_MEASURES_V
PACKAGE BODY - BSC_ANALYSIS_OPTION_PUB
PACKAGE BODY - BSC_BIS_KPI_CRUD_PUB
PACKAGE BODY - BSC_BIS_KPI_MEAS_PUB
PACKAGE BODY - BSC_BIS_MEASURE_PUB
PACKAGE BODY - BSC_COLOR_UPGRADE
PACKAGE BODY - BSC_DATASETS_PUB
PACKAGE BODY - BSC_DATASETS_PVT
VIEW - BSC_DB_MEASURE_BY_DIM_SET_V
PACKAGE BODY - BSC_KPI_SERIES_PUB
PACKAGE BODY - BSC_METADATA_DESC
PACKAGE BODY - BSC_MO_UI_PKG
PACKAGE BODY - BSC_OBJ_ANALYSIS_OPTIONS_PUB
PACKAGE BODY - BSC_PMF_UI_WRAPPER
PACKAGE - BSC_SIMULATION_VIEW_PVT
PACKAGE BODY - BSC_SIMULATION_VIEW_PVT
PACKAGE BODY - BSC_UPGRADES
PACKAGE - BSC_UTILITY
PACKAGE BODY - BSC_UTILITY

[top of page]

View: BSC_SYS_DIM_GROUPS_VL

[top of page]

APPS.BSC_SYS_DIM_GROUPS_VL references the following:

APPS
SYNONYM - BSC_SYS_DIM_GROUPS_TL
APPS.BSC_SYS_DIM_GROUPS_VL is referenced by following:

APPS
PACKAGE BODY - BIS_DIMENSION_PVT
PACKAGE BODY - BIS_REPORT_PUB
PACKAGE BODY - BIS_UTIL
PACKAGE BODY - BSC_BIS_DIMENSION_PUB
PACKAGE BODY - BSC_BIS_DIM_OBJ_PUB
VIEW - BSC_BIS_DIM_VL
PACKAGE BODY - BSC_BIS_KPI_CRUD_PUB
PACKAGE BODY - BSC_BIS_KPI_MEAS_PUB
PACKAGE BODY - BSC_COPY_INDICATOR_PUB
PACKAGE BODY - BSC_DESIGNER_PVT
PACKAGE BODY - BSC_DIMENSION_GROUPS_PUB
PACKAGE BODY - BSC_DIMENSION_GROUPS_PVT
PACKAGE BODY - BSC_DIMENSION_LEVELS_PVT
PACKAGE BODY - BSC_DIMENSION_SETS_PUB
PACKAGE BODY - BSC_KPI_PUB
PACKAGE BODY - BSC_METADATA_DESC
PACKAGE BODY - BSC_MIGRATION
PACKAGE BODY - BSC_OBJ_ANALYSIS_OPTIONS_PUB
PACKAGE BODY - BSC_PMF_UI_API_PUB
PACKAGE BODY - BSC_SIMULATION_VIEW_PVT
PACKAGE BODY - BSC_UPGRADES
PACKAGE BODY - BSC_UTILITY

[top of page]

View: BSC_SYS_DIM_LEVELS_VL

[top of page]

APPS.BSC_SYS_DIM_LEVELS_VL references the following:

APPS
SYNONYM - BSC_SYS_DIM_LEVELS_B
SYNONYM - BSC_SYS_DIM_LEVELS_TL
APPS.BSC_SYS_DIM_LEVELS_VL is referenced by following:

APPS
PACKAGE BODY - BIS_DIMENSION_LEVEL_PUB
PACKAGE BODY - BIS_PMF_GET_DIMLEVELS_PVT
PACKAGE BODY - BIS_UTIL
PACKAGE BODY - BSC_BIS_DIMENSION_PUB
VIEW - BSC_BIS_DIM_OBJS_VL
VIEW - BSC_BIS_DIM_OBJ_BY_DIM_VL
PACKAGE BODY - BSC_BIS_DIM_OBJ_PUB
PACKAGE BODY - BSC_BIS_DIM_REL_PUB
PACKAGE BODY - BSC_BIS_KPI_MEAS_PUB
PACKAGE BODY - BSC_CALENDAR_PVT
PACKAGE BODY - BSC_COMMON_DIM_LEVELS_PUB
PACKAGE BODY - BSC_DBGEN_BSC_READER
PACKAGE - BSC_DEFAULT_KEY_ITEM_PUB
PACKAGE BODY - BSC_DEFAULT_KEY_ITEM_PUB
PACKAGE BODY - BSC_DIMENSION_GROUPS_PUB
PACKAGE BODY - BSC_DIMENSION_LEVELS_PVT
PACKAGE BODY - BSC_DIMENSION_SETS_PUB
PACKAGE BODY - BSC_DIM_LEVEL_FILTERS_PUB
VIEW - BSC_DIM_OBJ_CHD_RELS_VL
VIEW - BSC_DIM_OBJ_PAR_RELS_VL
PACKAGE BODY - BSC_INVALID_DIM_LVLS_RPT
PACKAGE BODY - BSC_METADATA_DESC
PACKAGE BODY - BSC_MIGRATION
PACKAGE BODY - BSC_MO_UI_PKG
PACKAGE BODY - BSC_OAF_VIEWS_PVT
PACKAGE BODY - BSC_PMF_UI_API_PUB
PACKAGE BODY - BSC_SEC_UTILITY
PACKAGE BODY - BSC_SIMULATION_VIEW_PVT
VIEW - BSC_SYS_DIM_LEVEL_RELS_V
PACKAGE BODY - BSC_UPGRADES
PACKAGE BODY - BSC_UTILITY

[top of page]

View: BSC_SYS_DIM_LEVEL_RELS_V

[top of page]

APPS.BSC_SYS_DIM_LEVEL_RELS_V references the following:

APPS
VIEW - BSC_SYS_DIM_LEVELS_VL
SYNONYM - BSC_SYS_DIM_LEVEL_RELS
APPS.BSC_SYS_DIM_LEVEL_RELS_V is referenced by following:

APPS
PACKAGE BODY - BSC_BIS_DIM_OBJ_PUB
PACKAGE BODY - BSC_BIS_KPI_MEAS_PUB
PACKAGE BODY - BSC_DIMENSION_LEVELS_PUB
PACKAGE BODY - BSC_PMF_UI_WRAPPER

[top of page]

View: BSC_SYS_IMAGES_MAP_VL

[top of page]

APPS.BSC_SYS_IMAGES_MAP_VL references the following:

APPS
SYNONYM - BSC_SYS_IMAGES_MAP_TL
APPS.BSC_SYS_IMAGES_MAP_VL is referenced by following:

APPS
PACKAGE BODY - BSC_CUSTOM_VIEW_UI_WRAPPER
PACKAGE BODY - BSC_PMF_UI_WRAPPER
PACKAGE BODY - BSC_PORTLET_UI_WRAPPER
PACKAGE BODY - BSC_SIMULATION_VIEW_PUB

[top of page]

View: BSC_SYS_LABELS_VL

[top of page]

APPS.BSC_SYS_LABELS_VL references the following:

APPS
SYNONYM - BSC_SYS_LABELS_B
SYNONYM - BSC_SYS_LABELS_TL

APPS.BSC_SYS_LABELS_VL is not referenced by any database object

[top of page]

View: BSC_SYS_MM_CONTROLS_VL

[top of page]

APPS.BSC_SYS_MM_CONTROLS_VL references the following:

APPS
SYNONYM - BSC_SYS_MM_CONTROLS_TL

APPS.BSC_SYS_MM_CONTROLS_VL is not referenced by any database object

[top of page]

View: BSC_SYS_PERIODICITIES_VL

[top of page]

APPS.BSC_SYS_PERIODICITIES_VL references the following:

APPS
VIEW - BSC_LOOKUPS
SYNONYM - BSC_SYS_CALENDARS_B
SYNONYM - BSC_SYS_PERIODICITIES
SYNONYM - BSC_SYS_PERIODICITIES_TL
APPS.BSC_SYS_PERIODICITIES_VL is referenced by following:

APPS
PACKAGE BODY - BSC_BIS_LOCKS_PVT
PACKAGE BODY - BSC_CALENDAR_PUB
PACKAGE BODY - BSC_CALENDAR_PVT
PACKAGE BODY - BSC_COPY_INDICATOR_PUB
PACKAGE BODY - BSC_DBGEN_BSC_READER
PACKAGE BODY - BSC_METADATA_DESC
PACKAGE BODY - BSC_MO_DOC_PKG
PACKAGE BODY - BSC_MO_HELPER_PKG
PACKAGE BODY - BSC_MO_UI_PKG
PACKAGE BODY - BSC_PERIODICITIES_PUB
PACKAGE BODY - BSC_PERIODICITIES_PVT
PACKAGE BODY - BSC_PERIODS_UTILITY_PKG
PACKAGE BODY - BSC_PMF_UI_WRAPPER
PACKAGE BODY - BSC_UPDATE

[top of page]

View: BSC_SYS_PERIODS_VL

[top of page]

APPS.BSC_SYS_PERIODS_VL references the following:

APPS
SYNONYM - BSC_SYS_CALENDARS_B
SYNONYM - BSC_SYS_PERIODICITIES
SYNONYM - BSC_SYS_PERIODS_TL
APPS.BSC_SYS_PERIODS_VL is referenced by following:

APPS
VIEW - BSC_P_BSC_PER_CAL1_PER2_V
VIEW - BSC_P_BSC_PER_CAL1_PER3_V
VIEW - BSC_P_BSC_PER_CAL1_PER4_V
VIEW - BSC_P_BSC_PER_CAL1_PER5_V
VIEW - BSC_P_BSC_PER_CAL1_PER7_V
VIEW - BSC_P_BSC_PER_CAL1_PER9_V

[top of page]

View: BSC_TABS_VL

[top of page]

APPS.BSC_TABS_VL references the following:

APPS
SYNONYM - BSC_TABS_B
SYNONYM - BSC_TABS_TL
APPS.BSC_TABS_VL is referenced by following:

APPS
PACKAGE BODY - BIS_PAGE_PUB
PACKAGE BODY - BSC_BIS_CUSTOM_KPI_UTIL_PUB
PACKAGE BODY - BSC_BIS_KPI_CRUD_PUB
PACKAGE BODY - BSC_BIS_KPI_MEAS_PUB
PACKAGE BODY - BSC_CUSTOM_VIEW_UI_WRAPPER
PACKAGE BODY - BSC_DEFAULT_KEY_ITEM_PUB
PACKAGE BODY - BSC_METADATA_DESC
PACKAGE BODY - BSC_OAF_VIEWS_PVT
PACKAGE - BSC_PMF_UI_WRAPPER
PACKAGE BODY - BSC_PMF_UI_WRAPPER
PACKAGE BODY - BSC_SCORECARD_PUB

[top of page]

View: BSC_TAB_CSF_VL

[top of page]

APPS.BSC_TAB_CSF_VL references the following:

APPS
SYNONYM - BSC_TAB_CSF_B
SYNONYM - BSC_TAB_CSF_TL

APPS.BSC_TAB_CSF_VL is not referenced by any database object

[top of page]

View: BSC_TAB_IND_GROUPS_VL

[top of page]

APPS.BSC_TAB_IND_GROUPS_VL references the following:

APPS
SYNONYM - BSC_TAB_IND_GROUPS_B
SYNONYM - BSC_TAB_IND_GROUPS_TL
APPS.BSC_TAB_IND_GROUPS_VL is referenced by following:

APPS
PACKAGE BODY - BSC_BIS_CUSTOM_KPI_UTIL_PUB
PACKAGE BODY - BSC_BIS_KPI_CRUD_PUB
PACKAGE BODY - BSC_COPY_INDICATOR_PUB
PACKAGE BODY - BSC_KPI_GROUP_PUB
PACKAGE BODY - BSC_METADATA_DESC

[top of page]

View: BSC_TAB_IND_V

[top of page]

APPS.BSC_TAB_IND_V references the following:

APPS
VIEW - BSC_KPIS_VL
SYNONYM - BSC_TAB_INDICATORS

APPS.BSC_TAB_IND_V is not referenced by any database object

[top of page]

View: BSC_TAB_VIEWS_VL

[top of page]

APPS.BSC_TAB_VIEWS_VL references the following:

APPS
VIEW - BSC_LOOKUPS
SYNONYM - BSC_TAB_VIEWS_B
SYNONYM - BSC_TAB_VIEWS_TL
APPS.BSC_TAB_VIEWS_VL is referenced by following:

APPS
PACKAGE BODY - BSC_CUSTOM_VIEW_UI_WRAPPER
PACKAGE BODY - BSC_PMF_UI_WRAPPER
VIEW - BSC_TAB_VIEW_LABELS_VL
PACKAGE BODY - BSC_UPGRADES_GENERIC

[top of page]

View: BSC_TAB_VIEW_KPI_VL

[top of page]

APPS.BSC_TAB_VIEW_KPI_VL references the following:

APPS
SYNONYM - BSC_TAB_VIEW_KPI_TL
APPS.BSC_TAB_VIEW_KPI_VL is referenced by following:

APPS
PACKAGE BODY - BSC_CUSTOM_VIEW_PVT
PACKAGE BODY - BSC_CUSTOM_VIEW_UI_WRAPPER

[top of page]

View: BSC_TAB_VIEW_LABELS_VL

[top of page]

APPS.BSC_TAB_VIEW_LABELS_VL references the following:

APPS
VIEW - BSC_TAB_VIEWS_VL
SYNONYM - BSC_TAB_VIEW_LABELS_B
SYNONYM - BSC_TAB_VIEW_LABELS_TL
VIEW - FND_MENUS_VL
APPS.BSC_TAB_VIEW_LABELS_VL is referenced by following:

APPS
PACKAGE BODY - BSC_CUSTOM_VIEW_UI_WRAPPER
PACKAGE BODY - BSC_LAUNCH_PAD_PUB
PACKAGE BODY - BSC_SIMULATION_VIEW_PUB
PACKAGE BODY - BSC_SIMULATION_VIEW_PVT

[top of page]

View: BSC_USER_PARAMETERS_VL

[top of page]

APPS.BSC_USER_PARAMETERS_VL references the following:

APPS
SYNONYM - BSC_USER_PARAMETERS_B
SYNONYM - BSC_USER_PARAMETERS_TL

APPS.BSC_USER_PARAMETERS_VL is not referenced by any database object

[top of page]

View: BSC_USER_RESPONSIBILITY_V

[top of page]

APPS.BSC_USER_RESPONSIBILITY_V references the following:

APPS
PACKAGE - FND_DATE
VIEW - FND_RESPONSIBILITY_VL
SYNONYM - FND_USER
VIEW - FND_USER_RESP_GROUPS
APPS.BSC_USER_RESPONSIBILITY_V is referenced by following:

APPS
PACKAGE BODY - BSC_PORTLET_GRAPH

[top of page]



Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract