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

TABLE - MSD.MSD_APP_INSTANCE_ORGS
TABLE - MSD.MSD_AUDIT_SQL_STATEMENTS
TABLE - MSD.MSD_BACKUP_LEVEL_VALUES
TABLE - MSD.MSD_BOM_COMPONENTS
TABLE - MSD.MSD_BOOKING_DATA
TABLE - MSD.MSD_COMMENTS
TABLE - MSD.MSD_CS_CLMN_DIM_DTLS
TABLE - MSD.MSD_CS_CLMN_IDENTIFIERS
TABLE - MSD.MSD_CS_CLMN_IDENTIFIERS_TL
TABLE - MSD.MSD_CS_DATA
TABLE - MSD.MSD_CS_DATA_HEADERS
TABLE - MSD.MSD_CS_DEFINITIONS
TABLE - MSD.MSD_CS_DEFINITIONS_TL
TABLE - MSD.MSD_CS_DEFN_COLUMN_DTLS
TABLE - MSD.MSD_CS_DEFN_DIM_DTLS
TABLE - MSD.MSD_CURRENCY_CONVERSIONS
TABLE - MSD.MSD_DELETED_LEVEL_VALUES
TABLE - MSD.MSD_DEMAND_PLANS
TABLE - MSD.MSD_DEM_ITEMS_GTT
TABLE - MSD.MSD_DEM_LOCATIONS_GTT
TABLE - MSD.MSD_DEM_PRICE_LISTS_GTT
TABLE - MSD.MSD_DEM_UOM_CONVERSIONS_GTT
TABLE - MSD.MSD_DP_CALENDARS
TABLE - MSD.MSD_DP_DIMENSIONS
TABLE - MSD.MSD_DP_EVENTS
TABLE - MSD.MSD_DP_EXPRESS_SETUP
TABLE - MSD.MSD_DP_HIERARCHIES
TABLE - MSD.MSD_DP_PARAMETERS
TABLE - MSD.MSD_DP_PLANNING_PERCENTAGES
TABLE - MSD.MSD_DP_PRICE_LISTS
TABLE - MSD.MSD_DP_SCENARIOS
TABLE - MSD.MSD_DP_SCENARIO_ENTRIES
TABLE - MSD.MSD_DP_SCENARIO_EVENTS
TABLE - MSD.MSD_DP_SCENARIO_OUTPUT_LEVELS
TABLE - MSD.MSD_DP_SCENARIO_REVISIONS
TABLE - MSD.MSD_EVENTS
TABLE - MSD.MSD_EVENT_DETAILS
TABLE - MSD.MSD_EVENT_PRODUCTS
TABLE - MSD.MSD_EVT_PRODUCT_DETAILS
TABLE - MSD.MSD_EVT_PROD_RELATIONSHIPS
TABLE - MSD.MSD_HIERARCHIES
TABLE - MSD.MSD_HIERARCHY_LEVELS
TABLE - MSD.MSD_ITEM_LIST_PRICE
TABLE - MSD.MSD_LEVELS
TABLE - MSD.MSD_LEVEL_ASSOCIATIONS
TABLE - MSD.MSD_LEVEL_VALUES
TABLE - MSD.MSD_LOCAL_ID_SETUP
TABLE - MSD.MSD_MFG_FORECAST
TABLE - MSD.MSD_ODPTIME
TABLE - MSD.MSD_ORG_CALENDARS
TABLE - MSD.MSD_PRICE_LIST
TABLE - MSD.MSD_REASON_CODES
TABLE - MSD.MSD_SALES_FORECAST
TABLE - MSD.MSD_SALES_OPPORTUNITY_DATA
TABLE - MSD.MSD_SCN_ENTRY_COMMENTS
TABLE - MSD.MSD_SETUP_PARAMETERS
TABLE - MSD.MSD_SHIPMENT_DATA
TABLE - MSD.MSD_ST_BOOKING_DATA
TABLE - MSD.MSD_ST_CS_DATA
TABLE - MSD.MSD_ST_CURRENCY_CONVERSIONS
TABLE - MSD.MSD_ST_EVENTS
TABLE - MSD.MSD_ST_EVENT_PRODUCTS
TABLE - MSD.MSD_ST_EVT_PRODUCT_DETAILS
TABLE - MSD.MSD_ST_EVT_PROD_RELATIONSHIPS
TABLE - MSD.MSD_ST_ITEM_LIST_PRICE
TABLE - MSD.MSD_ST_LEVEL_ASSOCIATIONS
TABLE - MSD.MSD_ST_LEVEL_VALUES
TABLE - MSD.MSD_ST_MFG_FORECAST
TABLE - MSD.MSD_ST_ORG_CALENDARS
TABLE - MSD.MSD_ST_PRICE_LIST
TABLE - MSD.MSD_ST_SALES_FORECAST
TABLE - MSD.MSD_ST_SALES_OPPORTUNITY_DATA
TABLE - MSD.MSD_ST_SETUP_PARAMETERS
TABLE - MSD.MSD_ST_SHIPMENT_DATA
TABLE - MSD.MSD_ST_TIME
TABLE - MSD.MSD_ST_UOM_CONVERSIONS
TABLE - MSD.MSD_TIME
TABLE - MSD.MSD_UOM_CONVERSIONS
VIEW - APPS.MSD_ASCP_PLANS_HEADER_V
VIEW - APPS.MSD_AUDIT_SQL_STATEMENTS_V
VIEW - APPS.MSD_BACKLOG_CS_V
VIEW - APPS.MSD_BOM_COMPONENTS_V
VIEW - APPS.MSD_BOOKING_DATA_CS_V
VIEW - APPS.MSD_BOOKING_DATA_ORIG_CS_V
VIEW - APPS.MSD_BOOKING_DATA_V
VIEW - APPS.MSD_CATEGORY_SETS_V
VIEW - APPS.MSD_CONSTRAINED_FORECAST_V
VIEW - APPS.MSD_CS_CLMN_DIM_DTLS_V
VIEW - APPS.MSD_CS_CLMN_IDENTIFIERS_VL
VIEW - APPS.MSD_CS_DATA_HEADERS_V
VIEW - APPS.MSD_CS_DATA_HEADERS_V1
VIEW - APPS.MSD_CS_DATA_V
VIEW - APPS.MSD_CS_DATA_V1
VIEW - APPS.MSD_CS_DEFINITIONS_V1
VIEW - APPS.MSD_CS_DEFINITIONS_VL
VIEW - APPS.MSD_CS_DEFN_COLUMN_DTLS_V
VIEW - APPS.MSD_CS_DEFN_DIM_DTLS_V
VIEW - APPS.MSD_CS_PLANNING_BOOKING_V
VIEW - APPS.MSD_CURRENCY_CONVERSIONS_V
VIEW - APPS.MSD_CUST_ORDER_FCST_CS_V
VIEW - APPS.MSD_CUST_SALES_FCST_CS_V
VIEW - APPS.MSD_DELETED_LEVEL_VALUES_V
VIEW - APPS.MSD_DEMAND_PLANS_V
VIEW - APPS.MSD_DP_ASCP_SCENARIOS_V
VIEW - APPS.MSD_DP_ASCP_SCN_ENTRIES_V
VIEW - APPS.MSD_DP_CALENDARS_V
VIEW - APPS.MSD_DP_DEFAULT_SCENARIO_V
VIEW - APPS.MSD_DP_DIMENSIONS_V
VIEW - APPS.MSD_DP_EVENTS_V
VIEW - APPS.MSD_DP_HIERARCHIES_V
VIEW - APPS.MSD_DP_PARAMETERS_CS_V
VIEW - APPS.MSD_DP_PLANNING_PERCENTAGES_V
VIEW - APPS.MSD_DP_PRICE_LISTS_V
VIEW - APPS.MSD_DP_SCENARIOS_CS_V
VIEW - APPS.MSD_DP_SCENARIOS_V
VIEW - APPS.MSD_DP_SCENARIO_ALL_EVENTS_V
VIEW - APPS.MSD_DP_SCENARIO_EVENTS_V
VIEW - APPS.MSD_DP_SCE_SCENARIOS_V
VIEW - APPS.MSD_DP_SCE_SCN_ENTRIES_V
VIEW - APPS.MSD_DP_SCN_LOV_V
VIEW - APPS.MSD_DP_SCN_OUTPUT_LEVELS_V
VIEW - APPS.MSD_DP_SCN_REVISIONS_V
VIEW - APPS.MSD_DP_USERS_V
VIEW - APPS.MSD_EVENTS_V
VIEW - APPS.MSD_EVENT_PRODUCTS_V
VIEW - APPS.MSD_EVENT_PRODUCTS_V1
VIEW - APPS.MSD_EVT_PRODUCT_DETAILS_V
VIEW - APPS.MSD_EVT_PRODUCT_DETAILS_V1
VIEW - APPS.MSD_HIERARCHIES_V
VIEW - APPS.MSD_HIERARCHY_LEVELS_V
VIEW - APPS.MSD_ITEM_MASTER_V
VIEW - APPS.MSD_LEGAL_ENTITIES_V
VIEW - APPS.MSD_LEVELS_V
VIEW - APPS.MSD_LEVEL_ASSOCIATIONS_V1
VIEW - APPS.MSD_LEVEL_VALUES_V
VIEW - APPS.MSD_LEVEL_VALUES_V1
VIEW - APPS.MSD_MFG_FCST_CS_V
VIEW - APPS.MSD_MFG_FCST_V
VIEW - APPS.MSD_NPI_CANNED_PRODUCTS_V
VIEW - APPS.MSD_NPI_RELATED_PRODUCTS_V
VIEW - APPS.MSD_NPI_RELATED_PRODUCTS_V1
VIEW - APPS.MSD_NPI_RELATED_PROD_DETAILS_V
VIEW - APPS.MSD_NPI_RELATED_PROD_DTLS_V1
VIEW - APPS.MSD_OBJECTS_V
VIEW - APPS.MSD_OPPORTUNITY_DATA_CS_V
VIEW - APPS.MSD_OPPORTUNITY_DATA_V
VIEW - APPS.MSD_ORGANIZATION_DEFINITIONS
VIEW - APPS.MSD_ORG_CALENDAR_CS_V
VIEW - APPS.MSD_PRICE_LIST_V
VIEW - APPS.MSD_SALES_FCST_BESTCASE_CS_V
VIEW - APPS.MSD_SALES_FCST_PIPELINE_CS_V
VIEW - APPS.MSD_SALES_FCST_REALISTIC_CS_V
VIEW - APPS.MSD_SALES_FCST_WGTPLINE_CS_V
VIEW - APPS.MSD_SALES_FCST_WORSTCASE_CS_V
VIEW - APPS.MSD_SCN_ENTRY_COMMENTS_V
VIEW - APPS.MSD_SHIPMENT_DATA_CS_V
VIEW - APPS.MSD_SHIPMENT_DATA_ORIG_CS_V
VIEW - APPS.MSD_SHIPMENT_DATA_V
VIEW - APPS.MSD_SR_AREA_ALL_V
VIEW - APPS.MSD_SR_BACKLOG_V
VIEW - APPS.MSD_SR_BG_ALL_V
VIEW - APPS.MSD_SR_BOOKING_DATA_V
VIEW - APPS.MSD_SR_CAT_ALL_V
VIEW - APPS.MSD_SR_CLASS_ALL_V
VIEW - APPS.MSD_SR_COUNTRY_AREA_V
VIEW - APPS.MSD_SR_CURRENCY_CONVERSIONS_V
VIEW - APPS.MSD_SR_CUS_CLASS_V
VIEW - APPS.MSD_SR_CUS_GROUP_V
VIEW - APPS.MSD_SR_FISCAL_TIME_V
VIEW - APPS.MSD_SR_GROUP_ALL_V
VIEW - APPS.MSD_SR_GRP1_GRP2_V
VIEW - APPS.MSD_SR_GRP2_GRP3_V
VIEW - APPS.MSD_SR_GRP3_GRP4_V
VIEW - APPS.MSD_SR_GRP4_ALL_V
VIEW - APPS.MSD_SR_ITEM_LIST_PRICE_V
VIEW - APPS.MSD_SR_IT_ALL_V
VIEW - APPS.MSD_SR_LE_BG_V
VIEW - APPS.MSD_SR_LOC_CUS_V
VIEW - APPS.MSD_SR_LOC_REG_V
VIEW - APPS.MSD_SR_MFG_FCST_V
VIEW - APPS.MSD_SR_MFG_TIME_V
VIEW - APPS.MSD_SR_MGR1_MGR2_V
VIEW - APPS.MSD_SR_MGR2_MGR3_V
VIEW - APPS.MSD_SR_MGR3_MGR4_V
VIEW - APPS.MSD_SR_MGR4_ALL_V
VIEW - APPS.MSD_SR_OPPORTUNITY_V
VIEW - APPS.MSD_SR_ORG_OU_V
VIEW - APPS.MSD_SR_OU_LE_V
VIEW - APPS.MSD_SR_PF_ALL_V
VIEW - APPS.MSD_SR_PRD_CAT_V
VIEW - APPS.MSD_SR_PRD_IT_V
VIEW - APPS.MSD_SR_PRD_PF_V
VIEW - APPS.MSD_SR_PRICE_LIST_V
VIEW - APPS.MSD_SR_REG_COUNTRY_V
VIEW - APPS.MSD_SR_REP_GRP1_V
VIEW - APPS.MSD_SR_REP_MGR1_V
VIEW - APPS.MSD_SR_SALES_FCST_V
VIEW - APPS.MSD_SR_SC_ALL_V
VIEW - APPS.MSD_SR_SHIPMENT_DATA_V
VIEW - APPS.MSD_SR_UOM_CONVERSIONS_V
VIEW - APPS.MSD_ST_CS_DATA_V
VIEW - APPS.MSD_SUPPLY_PLANS_V
VIEW - APPS.MSD_TIME_V
VIEW - APPS.MSD_UOM_CONVERSIONS_V

Table: MSD_APP_INSTANCE_ORGS

Description: This table resides in Source Instance. It hold the list of organizations for which data must be brought in to the planning Server. ODP source view restrict data using this table.
Primary Key: MSD_APP_INSTANCE_ORGS
  1. INSTANCE_ID
  2. ORGANIZATION_ID

[top of page]

MSD.MSD_APP_INSTANCE_ORGS does not reference any database object

MSD.MSD_APP_INSTANCE_ORGS is referenced by following:

MSD
VIEW - MSD_APP_INSTANCE_ORGS#

[top of page]

Table: MSD_AUDIT_SQL_STATEMENTS

Description: This table forms the basis for the Audit Statements architecture. Each row can be interpreted as a valid sql query. A concurrent program picks up selective queries from this table (based on FUNCTION and APPLICATION_CODE), runs them, and l
Primary Key: MSD_AUDIT_SQL_STATEMENTS_UK
  1. STATEMENT_ID

[top of page]

MSD.MSD_AUDIT_SQL_STATEMENTS does not reference any database object

MSD.MSD_AUDIT_SQL_STATEMENTS is referenced by following:

MSD
VIEW - MSD_AUDIT_SQL_STATEMENTS#

[top of page]

Table: MSD_BACKUP_LEVEL_VALUES

Description: This table stores level value pks during a level value collection. After a level is collected (in msd_level_values) it's pks are reverted to those from msd_backup_level_values.
Primary Key: MSD_BACKUP_LEVEL_VALUES_PK
  1. SR_LEVEL_PK
  2. INSTANCE
  3. LEVEL_ID

[top of page]

MSD.MSD_BACKUP_LEVEL_VALUES does not reference any database object

MSD.MSD_BACKUP_LEVEL_VALUES is referenced by following:

MSD
VIEW - MSD_BACKUP_LEVEL_VALUES#

[top of page]

Table: MSD_BOM_COMPONENTS

Description: Contains Model to Component Relationships

[top of page]

MSD.MSD_BOM_COMPONENTS does not reference any database object

MSD.MSD_BOM_COMPONENTS is referenced by following:

MSD
VIEW - MSD_BOM_COMPONENTS#

[top of page]

Table: MSD_BOOKING_DATA

Description: Fact Table that stores the Booking Data.

[top of page]

MSD.MSD_BOOKING_DATA does not reference any database object

MSD.MSD_BOOKING_DATA is referenced by following:

MSD
VIEW - MSD_BOOKING_DATA#

[top of page]

Table: MSD_COMMENTS

Description: This table stores comments for a particular scenario revision
Primary Key: MSD_COMMENTS_UK1
  1. COMMENT_ID
  2. DEMAND_PLAN_ID
  3. REVISION
  4. SCENARIO_ID

[top of page]

MSD.MSD_COMMENTS does not reference any database object

MSD.MSD_COMMENTS is referenced by following:

MSD
VIEW - MSD_COMMENTS#

[top of page]

Table: MSD_CS_CLMN_DIM_DTLS

Description: This table has Data Streams Column Dimension specific details.
Primary Key: MSD_CS_CLMN_DIM_DTLS_PK
  1. CS_CLMN_DIM_DTLS_ID
Primary Key: MSD_CS_CLMN_DIM_DTLS_U1
  1. CS_DEFN_DIM_DTLS_ID
  2. CS_COLUMN_DTLS_ID

[top of page]

MSD.MSD_CS_CLMN_DIM_DTLS does not reference any database object

MSD.MSD_CS_CLMN_DIM_DTLS is referenced by following:

MSD
VIEW - MSD_CS_CLMN_DIM_DTLS#

[top of page]

Table: MSD_CS_CLMN_IDENTIFIERS

Description: This table has Column identifiers for Custom Data Stream.
Primary Key: MSD_CS_CLMN_IDENTIFIERS_PK
  1. COLUMN_IDENTIFIER

[top of page]

MSD.MSD_CS_CLMN_IDENTIFIERS does not reference any database object

MSD.MSD_CS_CLMN_IDENTIFIERS is referenced by following:

MSD
VIEW - MSD_CS_CLMN_IDENTIFIERS#

[top of page]

Table: MSD_CS_CLMN_IDENTIFIERS_TL

Description: This table holds translatable data for MSD_CS_CLMN_IDENTIFIERS.
Primary Key: MSD_CS_CLMN_IDENTIFIERS_TL_PK
  1. COLUMN_IDENTIFIER
  2. LANGUAGE

[top of page]

MSD.MSD_CS_CLMN_IDENTIFIERS_TL does not reference any database object

MSD.MSD_CS_CLMN_IDENTIFIERS_TL is referenced by following:

MSD
VIEW - MSD_CS_CLMN_IDENTIFIERS_TL#

[top of page]

Table: MSD_CS_DATA

Description: This table is fact table for Custom Data Stream.
Primary Key: MSD_CS_DATA_PK
  1. CS_DATA_ID

[top of page]

MSD.MSD_CS_DATA does not reference any database object

MSD.MSD_CS_DATA is referenced by following:

MSD
VIEW - MSD_CS_DATA#

[top of page]

Table: MSD_CS_DATA_HEADERS

Description: Stores Custom Stream Fact Headers
Primary Key: MSD_CS_DATA_HEADERS_PK
  1. CS_DATA_HEADER_ID

[top of page]

MSD.MSD_CS_DATA_HEADERS does not reference any database object

MSD.MSD_CS_DATA_HEADERS is referenced by following:

MSD
VIEW - MSD_CS_DATA_HEADERS#

[top of page]

Table: MSD_CS_DEFINITIONS

Description: This table stores Custom Stream Definitions
Primary Key: MSD_CS_DEFINITIONS_PK
  1. CS_DEFINITION_ID
Primary Key: MSD_CS_DEFINITIONS_UK
  1. NAME

[top of page]

MSD.MSD_CS_DEFINITIONS does not reference any database object

MSD.MSD_CS_DEFINITIONS is referenced by following:

MSD
VIEW - MSD_CS_DEFINITIONS#

[top of page]

Table: MSD_CS_DEFINITIONS_TL

Description: This table holds translatable data for MSD_CS_DEFINITIONS.
Primary Key: MSD_CS_DEFINITIONS_TL_PK
  1. CS_DEFINITION_ID
  2. LANGUAGE

[top of page]

MSD.MSD_CS_DEFINITIONS_TL does not reference any database object

MSD.MSD_CS_DEFINITIONS_TL is referenced by following:

MSD
VIEW - MSD_CS_DEFINITIONS_TL#

[top of page]

Table: MSD_CS_DEFN_COLUMN_DTLS

Description: This table has Data Stream's Column mappings.
Primary Key: MSD_CS_DEFN_COLUMN_DTLS_PK
  1. CS_COLUMN_DTLS_ID

[top of page]

MSD.MSD_CS_DEFN_COLUMN_DTLS does not reference any database object

MSD.MSD_CS_DEFN_COLUMN_DTLS is referenced by following:

MSD
VIEW - MSD_CS_DEFN_COLUMN_DTLS#

[top of page]

Table: MSD_CS_DEFN_DIM_DTLS

Description: This table has Data Stream's Dimension details.
Primary Key: MSD_CS_DEFN_DIM_DTLS_PK
  1. CS_DEFN_DIM_DTLS_ID

[top of page]

MSD.MSD_CS_DEFN_DIM_DTLS does not reference any database object

MSD.MSD_CS_DEFN_DIM_DTLS is referenced by following:

MSD
VIEW - MSD_CS_DEFN_DIM_DTLS#

[top of page]

Table: MSD_CURRENCY_CONVERSIONS

Description: Fact table that stores the Currency Conversion information.

[top of page]

MSD.MSD_CURRENCY_CONVERSIONS does not reference any database object

MSD.MSD_CURRENCY_CONVERSIONS is referenced by following:

MSD
VIEW - MSD_CURRENCY_CONVERSIONS#

[top of page]

Table: MSD_DELETED_LEVEL_VALUES

Description: This table stores all the deleted level values Information including the system generated primary key and the level value attributes. This is not stripped by the Demand Plan Id.

[top of page]

MSD.MSD_DELETED_LEVEL_VALUES does not reference any database object

MSD.MSD_DELETED_LEVEL_VALUES is referenced by following:

MSD
VIEW - MSD_DELETED_LEVEL_VALUES#

[top of page]

Table: MSD_DEMAND_PLANS

Description: Demand Plan definition.
Primary Key: MSD_DEMAND_PLANS_PK
  1. DEMAND_PLAN_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
MSD_DP_CALENDARS.DEMAND_PLAN_ID MSD_DEMAND_PLANS
MSD_DP_DIMENSIONS.DEMAND_PLAN_ID MSD_DEMAND_PLANS
MSD_DP_EXPRESS_SETUP.DEMAND_PLAN_ID MSD_DEMAND_PLANS
MSD_DP_PARAMETERS.DEMAND_PLAN_ID MSD_DEMAND_PLANS
MSD_DP_SCENARIOS.DEMAND_PLAN_ID MSD_DEMAND_PLANS

[top of page]

MSD.MSD_DEMAND_PLANS does not reference any database object

MSD.MSD_DEMAND_PLANS is referenced by following:

MSD
VIEW - MSD_DEMAND_PLANS#

[top of page]

Table: MSD_DEM_ITEMS_GTT

Description:

[top of page]

MSD.MSD_DEM_ITEMS_GTT does not reference any database object

MSD.MSD_DEM_ITEMS_GTT is referenced by following:

APPS
SYNONYM - MSD_DEM_ITEMS_GTT

[top of page]

Table: MSD_DEM_LOCATIONS_GTT

Description:

[top of page]

MSD.MSD_DEM_LOCATIONS_GTT does not reference any database object

MSD.MSD_DEM_LOCATIONS_GTT is referenced by following:

APPS
SYNONYM - MSD_DEM_LOCATIONS_GTT

[top of page]

Table: MSD_DEM_PRICE_LISTS_GTT

Description:

[top of page]

MSD.MSD_DEM_PRICE_LISTS_GTT does not reference any database object

MSD.MSD_DEM_PRICE_LISTS_GTT is referenced by following:

APPS
SYNONYM - MSD_DEM_PRICE_LISTS_GTT

[top of page]

Table: MSD_DEM_UOM_CONVERSIONS_GTT

Description:

[top of page]

MSD.MSD_DEM_UOM_CONVERSIONS_GTT does not reference any database object

MSD.MSD_DEM_UOM_CONVERSIONS_GTT is referenced by following:

APPS
SYNONYM - MSD_DEM_UOM_CONVERSIONS_GTT

[top of page]

Table: MSD_DP_CALENDARS

Description: This table stores Demand Plan related Calendars.
Primary Key: MSD_DP_CALENDARS_PK
  1. CALENDAR_CODE
  2. CALENDAR_TYPE
  3. DEMAND_PLAN_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
MSD_DP_CALENDARS.DEMAND_PLAN_ID MSD_DEMAND_PLANS

[top of page]

MSD.MSD_DP_CALENDARS does not reference any database object

MSD.MSD_DP_CALENDARS is referenced by following:

MSD
VIEW - MSD_DP_CALENDARS#

[top of page]

Table: MSD_DP_DIMENSIONS

Description: This table stores the associations between the Demand Plan User Defined Dimensions and the Real Dimensions.
Primary Key: MSD_DP_DIMENSIONS_PK
  1. DEMAND_PLAN_ID
  2. DIMENSION_CODE
  3. DP_DIMENSION_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
MSD_DP_DIMENSIONS.DEMAND_PLAN_ID MSD_DEMAND_PLANS

[top of page]

MSD.MSD_DP_DIMENSIONS does not reference any database object

MSD.MSD_DP_DIMENSIONS is referenced by following:

MSD
VIEW - MSD_DP_DIMENSIONS#

[top of page]

Table: MSD_DP_EVENTS

Description: This table stores Demand Plan related Events.
Primary Key: MSD_DP_EVENTS_PK
  1. DP_EVENT_ID

[top of page]

MSD.MSD_DP_EVENTS does not reference any database object

MSD.MSD_DP_EVENTS is referenced by following:

MSD
VIEW - MSD_DP_EVENTS#

[top of page]

Table: MSD_DP_EXPRESS_SETUP

Description: This table stores the Express related Setup information for a Demand Plan.
Primary Key: MSD_DP_EXPRESS_SETUP_PK
  1. DEMAND_PLAN_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
MSD_DP_EXPRESS_SETUP.DEMAND_PLAN_ID MSD_DEMAND_PLANS

[top of page]

MSD.MSD_DP_EXPRESS_SETUP does not reference any database object

MSD.MSD_DP_EXPRESS_SETUP is referenced by following:

MSD
VIEW - MSD_DP_EXPRESS_SETUP#

[top of page]

Table: MSD_DP_HIERARCHIES

Description: This table stores the various hierarchies that are associated to the Demand Plan.
Primary Key: MSD_DP_HIERARCHIES_PK
  1. DEMAND_PLAN_ID
  2. HIERARCHY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
MSD_DP_HIERARCHIES.HIERARCHY_ID %

[top of page]

MSD.MSD_DP_HIERARCHIES does not reference any database object

MSD.MSD_DP_HIERARCHIES is referenced by following:

MSD
VIEW - MSD_DP_HIERARCHIES#

[top of page]

Table: MSD_DP_PARAMETERS

Description: This table stores the Parameters (both Input as well as Output) to be used by a Demand Plan. This will be used by Oracle Express to load the Data from the PS (all Input Parameters) and the Output Parameters will be used by Oracle Express to
Primary Key: MSD_DP_PARAMETERS_PK
  1. PARAMETER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
MSD_DP_PARAMETERS.DEMAND_PLAN_ID MSD_DEMAND_PLANS

[top of page]

MSD.MSD_DP_PARAMETERS does not reference any database object

MSD.MSD_DP_PARAMETERS is referenced by following:

MSD
VIEW - MSD_DP_PARAMETERS#

[top of page]

Table: MSD_DP_PLANNING_PERCENTAGES

Description: Planning Percentages Data Published by DPE

[top of page]

MSD.MSD_DP_PLANNING_PERCENTAGES does not reference any database object

MSD.MSD_DP_PLANNING_PERCENTAGES is referenced by following:

MSD
VIEW - MSD_DP_PLANNING_PERCENTAGES#

[top of page]

Table: MSD_DP_PRICE_LISTS

Description: This table stores Deman Plan's Price Lists.
Primary Key: MSD_DP_PRICE_LISTS_PK
  1. DP_PRICE_LIST_ID

[top of page]

MSD.MSD_DP_PRICE_LISTS does not reference any database object

MSD.MSD_DP_PRICE_LISTS is referenced by following:

MSD
VIEW - MSD_DP_PRICE_LISTS#

[top of page]

Table: MSD_DP_SCENARIOS

Description: This table specifies the Scenarios to be generated from a particular Demand Plan. [To actually generate this scenario from Oracle Express, an instance of this scenario needs to be created in the Demand Plan Parameters table].
Primary Key: MSD_DP_SCENARIOS_PK
  1. SCENARIO_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
MSD_DP_SCENARIOS.DEMAND_PLAN_ID MSD_DEMAND_PLANS

[top of page]

MSD.MSD_DP_SCENARIOS does not reference any database object

MSD.MSD_DP_SCENARIOS is referenced by following:

MSD
VIEW - MSD_DP_SCENARIOS#

[top of page]

Table: MSD_DP_SCENARIO_ENTRIES

Description: This fact table has all the detail scenario entry information.
Foreign Keys from this table:
Foreign Key Column Foreign Table
MSD_DP_SCENARIO_ENTRIES.PRODUCT_LVL_PK MSD_LEVEL_VALUES
MSD_DP_SCENARIO_ENTRIES.GEOGRAPHY_LVL_PK MSD_LEVEL_VALUES
MSD_DP_SCENARIO_ENTRIES.ORGANIZATION_LVL_PK MSD_LEVEL_VALUES
MSD_DP_SCENARIO_ENTRIES.SALESCHANNEL_LVL_PK MSD_LEVEL_VALUES
MSD_DP_SCENARIO_ENTRIES.SALES_REP_LVL_PK MSD_LEVEL_VALUES
MSD_DP_SCENARIO_ENTRIES.USER_DEFINED1_LVL_PK MSD_LEVEL_VALUES
MSD_DP_SCENARIO_ENTRIES.USER_DEFINED2_LVL_PK MSD_LEVEL_VALUES

[top of page]

MSD.MSD_DP_SCENARIO_ENTRIES does not reference any database object

MSD.MSD_DP_SCENARIO_ENTRIES is referenced by following:

MSD
VIEW - MSD_DP_SCENARIO_ENTRIES#

[top of page]

Table: MSD_DP_SCENARIO_EVENTS

Description: This tables stores the associations between a scenario and the events associated with this scenario.
Primary Key: MSD_DP_SCN_EVENTS_PK
  1. DEMAND_PLAN_ID
  2. EVENT_ID
  3. SCENARIO_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
MSD_DP_SCENARIO_EVENTS.EVENT_ID MSD_EVENTS

[top of page]

MSD.MSD_DP_SCENARIO_EVENTS does not reference any database object

MSD.MSD_DP_SCENARIO_EVENTS is referenced by following:

MSD
VIEW - MSD_DP_SCENARIO_EVENTS#

[top of page]

Table: MSD_DP_SCENARIO_OUTPUT_LEVELS

Description: This table specifies the levels in the various dimensions except for the time dimension at which the Scenario needs to be generated from the Oracle Express component.
Primary Key: MSD_DP_SCN_OUTPUT_LVLS_PK
  1. DEMAND_PLAN_ID
  2. SCENARIO_ID
  3. LEVEL_ID

[top of page]

MSD.MSD_DP_SCENARIO_OUTPUT_LEVELS does not reference any database object

MSD.MSD_DP_SCENARIO_OUTPUT_LEVELS is referenced by following:

MSD
VIEW - MSD_DP_SCENARIO_OUTPUT_LEVELS#

[top of page]

Table: MSD_DP_SCENARIO_REVISIONS

Description: Header Table for Scenario Entries Table
Primary Key: MSD_DP_SCENARIO_REVISIONS_UK1
  1. SCENARIO_ID
  2. DEMAND_PLAN_ID
  3. REVISION

[top of page]

MSD.MSD_DP_SCENARIO_REVISIONS does not reference any database object

MSD.MSD_DP_SCENARIO_REVISIONS is referenced by following:

MSD
VIEW - MSD_DP_SCENARIO_REVISIONS#

[top of page]

Table: MSD_EVENTS

Description: This table stores the Marketing Events. This defines the types of Events and is the header to the MSD_EVENT_PRODUCTS table.
Primary Key: MSD_EVENTS_PK
  1. EVENT_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
MSD_DP_SCENARIO_EVENTS.EVENT_ID MSD_EVENTS
MSD_EVENT_PRODUCTS.EVENT_ID MSD_EVENTS

[top of page]

MSD.MSD_EVENTS does not reference any database object

MSD.MSD_EVENTS is referenced by following:

MSD
VIEW - MSD_EVENTS#

[top of page]

Table: MSD_EVENT_DETAILS

Description:

[top of page]

MSD.MSD_EVENT_DETAILS does not reference any database object

MSD.MSD_EVENT_DETAILS is referenced by following:

MSD
VIEW - MSD_EVENT_DETAILS#

[top of page]

Table: MSD_EVENT_PRODUCTS

Description: This table is a child to MSD_EVENTS. This stores the information about the various products.
Primary Key: MSD_EVENT_PRODUCTS_PK
  1. EVENT_ID
  2. SEQ_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
MSD_EVENT_PRODUCTS.EVENT_ID MSD_EVENTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
MSD_EVT_PRODUCT_DETAILS.EVENT_ID
MSD_EVT_PRODUCT_DETAILS.SEQ_ID
MSD_EVENT_PRODUCTS
MSD_EVT_PROD_RELATIONSHIPS.EVENT_ID
MSD_EVT_PROD_RELATIONSHIPS.SEQ_ID
MSD_EVENT_PRODUCTS

[top of page]

MSD.MSD_EVENT_PRODUCTS does not reference any database object

MSD.MSD_EVENT_PRODUCTS is referenced by following:

MSD
VIEW - MSD_EVENT_PRODUCTS#

[top of page]

Table: MSD_EVT_PRODUCT_DETAILS

Description: This table is a child to the MSD_EVENT_PRODUCTS. This stores all the detail events information.
Primary Key: MSD_EVT_PRODUCT_DETAILS_PK
  1. EVENT_ID
  2. DETAIL_ID
  3. SEQ_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
MSD_EVT_PRODUCT_DETAILS.EVENT_ID
MSD_EVT_PRODUCT_DETAILS.SEQ_ID
MSD_EVENT_PRODUCTS
MSD_EVT_PRODUCT_DETAILS.SEQ_ID
MSD_EVT_PRODUCT_DETAILS.EVENT_ID
MSD_EVT_PRODUCT_DETAILS.RELATION_ID
%

[top of page]

MSD.MSD_EVT_PRODUCT_DETAILS does not reference any database object

MSD.MSD_EVT_PRODUCT_DETAILS is referenced by following:

MSD
VIEW - MSD_EVT_PRODUCT_DETAILS#

[top of page]

Table: MSD_EVT_PROD_RELATIONSHIPS

Description: This table is a child to the MSD_EVENT_PRODUCTS and holds the relationship information for New Product Introductions.
Primary Key: MSD_EVT_PROD_REL_PK
  1. RELATION_ID
  2. SEQ_ID
  3. EVENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
MSD_EVT_PROD_RELATIONSHIPS.EVENT_ID
MSD_EVT_PROD_RELATIONSHIPS.SEQ_ID
MSD_EVENT_PRODUCTS

[top of page]

MSD.MSD_EVT_PROD_RELATIONSHIPS does not reference any database object

MSD.MSD_EVT_PROD_RELATIONSHIPS is referenced by following:

MSD
VIEW - MSD_EVT_PROD_RELATIONSHIPS#

[top of page]

Table: MSD_HIERARCHIES

Description: This table provides the Hierachies, their corresponding State (Valid or Not) and the Dimension to which it belongs.
Primary Key: MSD_HIERARCHIES_PK
  1. HIERARCHY_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
MSD_HIERARCHY_LEVELS.HIERARCHY_ID MSD_HIERARCHIES

[top of page]

MSD.MSD_HIERARCHIES does not reference any database object

MSD.MSD_HIERARCHIES is referenced by following:

MSD
VIEW - MSD_HIERARCHIES#

[top of page]

Table: MSD_HIERARCHY_LEVELS

Description: This table provides the Level Associations within a Hierarchy for a Real Dimension.
Primary Key: MSD_HIERARCHY_LEVELS_PK
  1. HIERARCHY_ID
  2. LEVEL_ID
  3. PARENT_LEVEL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
MSD_HIERARCHY_LEVELS.LEVEL_ID %
MSD_HIERARCHY_LEVELS.HIERARCHY_ID MSD_HIERARCHIES
MSD_HIERARCHY_LEVELS.PARENT_LEVEL_ID %

[top of page]

MSD.MSD_HIERARCHY_LEVELS does not reference any database object

MSD.MSD_HIERARCHY_LEVELS is referenced by following:

MSD
VIEW - MSD_HIERARCHY_LEVELS#

[top of page]

Table: MSD_ITEM_LIST_PRICE

Description: This is a fact table that stores the list price, Base UOM and the average discount for each of the Product that is used in the Demand Planning.

[top of page]

MSD.MSD_ITEM_LIST_PRICE does not reference any database object

MSD.MSD_ITEM_LIST_PRICE is referenced by following:

MSD
VIEW - MSD_ITEM_LIST_PRICE#

[top of page]

Table: MSD_LEVELS

Description: This tableI provides the Levels, their Owning Dimension. It also specifies the Level Type. The possible values for Level Type are :
Primary Key: MSD_LEVELS_PK
  1. LEVEL_ID

[top of page]

MSD.MSD_LEVELS does not reference any database object

MSD.MSD_LEVELS is referenced by following:

MSD
VIEW - MSD_LEVELS#

[top of page]

Table: MSD_LEVEL_ASSOCIATIONS

Description: This table maintains association information between levels.

[top of page]

MSD.MSD_LEVEL_ASSOCIATIONS does not reference any database object

MSD.MSD_LEVEL_ASSOCIATIONS is referenced by following:

MSD
VIEW - MSD_LEVEL_ASSOCIATIONS#

[top of page]

Table: MSD_LEVEL_VALUES

Description: This table stores all the level values Information including the system generated primary key and the level value attributes. This is not stripped by the Demand Plan Id.
Primary Key: MSD_LEVEL_VALUES_PK
  1. LEVEL_PK
Foreign Keys from this table:
Foreign Key Column Foreign Table
MSD_LEVEL_VALUES.LEVEL_ID %
Foreign Keys to this table:
Foreign Key Column Foreign Table
MSD_DP_SCENARIO_ENTRIES.PRODUCT_LVL_PK MSD_LEVEL_VALUES
MSD_DP_SCENARIO_ENTRIES.GEOGRAPHY_LVL_PK MSD_LEVEL_VALUES
MSD_DP_SCENARIO_ENTRIES.ORGANIZATION_LVL_PK MSD_LEVEL_VALUES
MSD_DP_SCENARIO_ENTRIES.SALESCHANNEL_LVL_PK MSD_LEVEL_VALUES
MSD_DP_SCENARIO_ENTRIES.SALES_REP_LVL_PK MSD_LEVEL_VALUES
MSD_DP_SCENARIO_ENTRIES.USER_DEFINED1_LVL_PK MSD_LEVEL_VALUES
MSD_DP_SCENARIO_ENTRIES.USER_DEFINED2_LVL_PK MSD_LEVEL_VALUES
MSD_SHIPMENT_DATA.SR_ITEM_PK MSD_LEVEL_VALUES

[top of page]

MSD.MSD_LEVEL_VALUES does not reference any database object

MSD.MSD_LEVEL_VALUES is referenced by following:

MSD
VIEW - MSD_LEVEL_VALUES#

[top of page]

Table: MSD_LOCAL_ID_SETUP

Description: This table is used by Legacy Collection to generate Local ID.

[top of page]

MSD.MSD_LOCAL_ID_SETUP does not reference any database object

MSD.MSD_LOCAL_ID_SETUP is referenced by following:

MSD
VIEW - MSD_LOCAL_ID_SETUP#

[top of page]

Table: MSD_MFG_FORECAST

Description: This table stores the fact data for Manufacturing Forecast.

[top of page]

MSD.MSD_MFG_FORECAST does not reference any database object

MSD.MSD_MFG_FORECAST is referenced by following:

MSD
VIEW - MSD_MFG_FORECAST#

[top of page]

Table: MSD_ODPTIME

Description:

[top of page]

MSD.MSD_ODPTIME does not reference any database object

MSD.MSD_ODPTIME is referenced by following:

APPS
SYNONYM - MSD_ODPTIME

[top of page]

Table: MSD_ORG_CALENDARS

Description: This table stores Associations between Organizations and Calendars.
Primary Key: MSD_ORG_CALENDARS_UK1
  1. INSTANCE
  2. SR_ORG_PK
  3. CALENDAR_TYPE
  4. CALENDAR_CODE

[top of page]

MSD.MSD_ORG_CALENDARS does not reference any database object

MSD.MSD_ORG_CALENDARS is referenced by following:

MSD
VIEW - MSD_ORG_CALENDARS#

[top of page]

Table: MSD_PRICE_LIST

Description: This table has Price Lists.

[top of page]

MSD.MSD_PRICE_LIST does not reference any database object

MSD.MSD_PRICE_LIST is referenced by following:

MSD
VIEW - MSD_PRICE_LIST#

[top of page]

Table: MSD_REASON_CODES

Description: This table stores comment reason codes for scenario revisions.
Primary Key: MSD_REASON_CODES_UK1
  1. DEMAND_PLAN_ID
  2. REASON_CODE
  3. REVISION
  4. SCENARIO_ID

[top of page]

MSD.MSD_REASON_CODES does not reference any database object

MSD.MSD_REASON_CODES is referenced by following:

MSD
VIEW - MSD_REASON_CODES#

[top of page]

Table: MSD_SALES_FORECAST

Description:

[top of page]

MSD.MSD_SALES_FORECAST does not reference any database object

MSD.MSD_SALES_FORECAST is referenced by following:

MSD
VIEW - MSD_SALES_FORECAST#

[top of page]

Table: MSD_SALES_OPPORTUNITY_DATA

Description:

[top of page]

MSD.MSD_SALES_OPPORTUNITY_DATA does not reference any database object

MSD.MSD_SALES_OPPORTUNITY_DATA is referenced by following:

MSD
VIEW - MSD_SALES_OPPORTUNITY_DATA#

[top of page]

Table: MSD_SCN_ENTRY_COMMENTS

Description: This table stores the comments for scenario entries.
Primary Key: MSD_SCN_ENTRY_COMMENTS_UK1
  1. COMMENT_ID
  2. DEMAND_PLAN_ID
  3. REVISION
  4. SCENARIO_ID

[top of page]

MSD.MSD_SCN_ENTRY_COMMENTS does not reference any database object

MSD.MSD_SCN_ENTRY_COMMENTS is referenced by following:

MSD
VIEW - MSD_SCN_ENTRY_COMMENTS#

[top of page]

Table: MSD_SETUP_PARAMETERS

Description: This table stores Demand Planning application parameters setup information.
Primary Key: MSD_SETUP_PARAMETERS_PK
  1. INSTANCE_ID
  2. PARAMETER_NAME

[top of page]

MSD.MSD_SETUP_PARAMETERS does not reference any database object

MSD.MSD_SETUP_PARAMETERS is referenced by following:

MSD
VIEW - MSD_SETUP_PARAMETERS#

[top of page]

Table: MSD_SHIPMENT_DATA

Description: This is the fact table that stores the Shipment Information.
Foreign Keys from this table:
Foreign Key Column Foreign Table
MSD_SHIPMENT_DATA.SR_ITEM_PK MSD_LEVEL_VALUES

[top of page]

MSD.MSD_SHIPMENT_DATA does not reference any database object

MSD.MSD_SHIPMENT_DATA is referenced by following:

MSD
VIEW - MSD_SHIPMENT_DATA#

[top of page]

Table: MSD_ST_BOOKING_DATA

Description: Staging table that stores the booking data.

[top of page]

MSD.MSD_ST_BOOKING_DATA does not reference any database object

MSD.MSD_ST_BOOKING_DATA is referenced by following:

MSD
VIEW - MSD_ST_BOOKING_DATA#

[top of page]

Table: MSD_ST_CS_DATA

Description: This is staging table for Custom Stream Data.
Primary Key: MSD_ST_CS_DATA_PK
  1. CS_ST_DATA_ID

[top of page]

MSD.MSD_ST_CS_DATA does not reference any database object

MSD.MSD_ST_CS_DATA is referenced by following:

MSD
VIEW - MSD_ST_CS_DATA#

[top of page]

Table: MSD_ST_CURRENCY_CONVERSIONS

Description: Staging table that stores the currency conversion information.

[top of page]

MSD.MSD_ST_CURRENCY_CONVERSIONS does not reference any database object

MSD.MSD_ST_CURRENCY_CONVERSIONS is referenced by following:

MSD
VIEW - MSD_ST_CURRENCY_CONVERSIONS#

[top of page]

Table: MSD_ST_EVENTS

Description: Staging table for events

[top of page]

MSD.MSD_ST_EVENTS does not reference any database object

MSD.MSD_ST_EVENTS is referenced by following:

MSD
VIEW - MSD_ST_EVENTS#

[top of page]

Table: MSD_ST_EVENT_PRODUCTS

Description: Staging table for events

[top of page]

MSD.MSD_ST_EVENT_PRODUCTS does not reference any database object

MSD.MSD_ST_EVENT_PRODUCTS is referenced by following:

MSD
VIEW - MSD_ST_EVENT_PRODUCTS#

[top of page]

Table: MSD_ST_EVT_PRODUCT_DETAILS

Description: Staging table for events

[top of page]

MSD.MSD_ST_EVT_PRODUCT_DETAILS does not reference any database object

MSD.MSD_ST_EVT_PRODUCT_DETAILS is referenced by following:

MSD
VIEW - MSD_ST_EVT_PRODUCT_DETAILS#

[top of page]

Table: MSD_ST_EVT_PROD_RELATIONSHIPS

Description: Event product relationsships staging table

[top of page]

MSD.MSD_ST_EVT_PROD_RELATIONSHIPS does not reference any database object

MSD.MSD_ST_EVT_PROD_RELATIONSHIPS is referenced by following:

MSD
VIEW - MSD_ST_EVT_PROD_RELATIONSHIPS#

[top of page]

Table: MSD_ST_ITEM_LIST_PRICE

Description: Staging table that stores the item information like the base UOM, list price, and average discount.

[top of page]

MSD.MSD_ST_ITEM_LIST_PRICE does not reference any database object

MSD.MSD_ST_ITEM_LIST_PRICE is referenced by following:

MSD
VIEW - MSD_ST_ITEM_LIST_PRICE#

[top of page]

Table: MSD_ST_LEVEL_ASSOCIATIONS

Description: Staging table that specifies the value level associations for a level with its parent level in a hierarchy. This is not stripped by Demand Plan Id.

[top of page]

MSD.MSD_ST_LEVEL_ASSOCIATIONS does not reference any database object

MSD.MSD_ST_LEVEL_ASSOCIATIONS is referenced by following:

MSD
VIEW - MSD_ST_LEVEL_ASSOCIATIONS#

[top of page]

Table: MSD_ST_LEVEL_VALUES

Description: Staging table that stores all the level information; the attributes and the value. This is not stripped by the Demand Plan Id.

[top of page]

MSD.MSD_ST_LEVEL_VALUES does not reference any database object

MSD.MSD_ST_LEVEL_VALUES is referenced by following:

MSD
VIEW - MSD_ST_LEVEL_VALUES#

[top of page]

Table: MSD_ST_MFG_FORECAST

Description: Staging table that stores the data for manufacturing forecast.

[top of page]

MSD.MSD_ST_MFG_FORECAST does not reference any database object

MSD.MSD_ST_MFG_FORECAST is referenced by following:

MSD
VIEW - MSD_ST_MFG_FORECAST#

[top of page]

Table: MSD_ST_ORG_CALENDARS

Description: This staging table stores Associations between Organizations and Calendars.

[top of page]

MSD.MSD_ST_ORG_CALENDARS does not reference any database object

MSD.MSD_ST_ORG_CALENDARS is referenced by following:

MSD
VIEW - MSD_ST_ORG_CALENDARS#

[top of page]

Table: MSD_ST_PRICE_LIST

Description: Staging table for price list data

[top of page]

MSD.MSD_ST_PRICE_LIST does not reference any database object

MSD.MSD_ST_PRICE_LIST is referenced by following:

MSD
VIEW - MSD_ST_PRICE_LIST#

[top of page]

Table: MSD_ST_SALES_FORECAST

Description: Staging table that stores the sales forecast data.

[top of page]

MSD.MSD_ST_SALES_FORECAST does not reference any database object

MSD.MSD_ST_SALES_FORECAST is referenced by following:

MSD
VIEW - MSD_ST_SALES_FORECAST#

[top of page]

Table: MSD_ST_SALES_OPPORTUNITY_DATA

Description: Staging table that stores the sales opportunity data.

[top of page]

MSD.MSD_ST_SALES_OPPORTUNITY_DATA does not reference any database object

MSD.MSD_ST_SALES_OPPORTUNITY_DATA is referenced by following:

MSD
VIEW - MSD_ST_SALES_OPPORTUNITY_DATA#

[top of page]

Table: MSD_ST_SETUP_PARAMETERS

Description: This table is used by Legacy Collection for Staging Setup Parameters

[top of page]

MSD.MSD_ST_SETUP_PARAMETERS does not reference any database object

MSD.MSD_ST_SETUP_PARAMETERS is referenced by following:

MSD
VIEW - MSD_ST_SETUP_PARAMETERS#

[top of page]

Table: MSD_ST_SHIPMENT_DATA

Description: Staging table that stores the shipment information.

[top of page]

MSD.MSD_ST_SHIPMENT_DATA does not reference any database object

MSD.MSD_ST_SHIPMENT_DATA is referenced by following:

MSD
VIEW - MSD_ST_SHIPMENT_DATA#

[top of page]

Table: MSD_ST_TIME

Description: Staging table that stores the calender information.

[top of page]

MSD.MSD_ST_TIME does not reference any database object

MSD.MSD_ST_TIME is referenced by following:

MSD
VIEW - MSD_ST_TIME#

[top of page]

Table: MSD_ST_UOM_CONVERSIONS

Description: Staging table that stores the Unit of measurement conversion information.

[top of page]

MSD.MSD_ST_UOM_CONVERSIONS does not reference any database object

MSD.MSD_ST_UOM_CONVERSIONS is referenced by following:

MSD
VIEW - MSD_ST_UOM_CONVERSIONS#

[top of page]

Table: MSD_TIME

Description: This is the fact table that stores the Time Information.

[top of page]

MSD.MSD_TIME does not reference any database object

MSD.MSD_TIME is referenced by following:

MSD
VIEW - MSD_TIME#

[top of page]

Table: MSD_UOM_CONVERSIONS

Description: This is the fact table that stores the UOM conversions information.

[top of page]

MSD.MSD_UOM_CONVERSIONS does not reference any database object

MSD.MSD_UOM_CONVERSIONS is referenced by following:

MSD
VIEW - MSD_UOM_CONVERSIONS#

[top of page]

View: MSD_ASCP_PLANS_HEADER_V

[top of page]

APPS.MSD_ASCP_PLANS_HEADER_V references the following:

APPS
SYNONYM - MSC_PLANS

APPS.MSD_ASCP_PLANS_HEADER_V is not referenced by any database object

[top of page]

View: MSD_AUDIT_SQL_STATEMENTS_V

[top of page]

APPS.MSD_AUDIT_SQL_STATEMENTS_V references the following:

APPS
VIEW - FND_APPLICATION_VL
VIEW - FND_LOOKUP_VALUES_VL
SYNONYM - MSD_AUDIT_SQL_STATEMENTS

APPS.MSD_AUDIT_SQL_STATEMENTS_V is not referenced by any database object

[top of page]

View: MSD_BACKLOG_CS_V

[top of page]

APPS.MSD_BACKLOG_CS_V references the following:

APPS
SYNONYM - MSD_CS_DATA
SYNONYM - MSD_CS_DEFINITIONS

APPS.MSD_BACKLOG_CS_V is not referenced by any database object

[top of page]

View: MSD_BOM_COMPONENTS_V

[top of page]

APPS.MSD_BOM_COMPONENTS_V references the following:

APPS
PACKAGE - FND_PROFILE
SYNONYM - MSC_APPS_INSTANCES
SYNONYM - MSC_BOMS
SYNONYM - MSC_BOM_COMPONENTS
SYNONYM - MSC_SYSTEM_ITEMS
SYNONYM - MSD_BOM_COMPONENTS
PACKAGE - MSD_COMMON_UTILITIES
SYNONYM - MSD_LEVEL_VALUES
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.MSD_BOM_COMPONENTS_V is not referenced by any database object

[top of page]

View: MSD_BOOKING_DATA_CS_V

[top of page]

APPS.MSD_BOOKING_DATA_CS_V references the following:

APPS
SYNONYM - MSD_BOOKING_DATA
SYNONYM - MSD_LEVEL_VALUES
APPS.MSD_BOOKING_DATA_CS_V is referenced by following:

APPS
VIEW - MSD_CS_PLANNING_BOOKING_V

[top of page]

View: MSD_BOOKING_DATA_ORIG_CS_V

[top of page]

APPS.MSD_BOOKING_DATA_ORIG_CS_V references the following:

APPS
SYNONYM - MSD_BOOKING_DATA
SYNONYM - MSD_LEVEL_VALUES

APPS.MSD_BOOKING_DATA_ORIG_CS_V is not referenced by any database object

[top of page]

View: MSD_BOOKING_DATA_V

[top of page]

APPS.MSD_BOOKING_DATA_V references the following:

APPS
SYNONYM - MSD_BOOKING_DATA
SYNONYM - MSD_LEVEL_VALUES

APPS.MSD_BOOKING_DATA_V is not referenced by any database object

[top of page]

View: MSD_CATEGORY_SETS_V

[top of page]

APPS.MSD_CATEGORY_SETS_V references the following:

APPS
SYNONYM - MTL_CATEGORY_SETS

APPS.MSD_CATEGORY_SETS_V is not referenced by any database object

[top of page]

View: MSD_CONSTRAINED_FORECAST_V

[top of page]

APPS.MSD_CONSTRAINED_FORECAST_V references the following:

APPS
PACKAGE - FND_PROFILE
SYNONYM - MSC_DEMANDS
SYNONYM - MSC_PLANS
SYNONYM - MSC_SYSTEM_ITEMS
SYNONYM - MSC_TRADING_PARTNERS
PACKAGE - MSD_COMMON_UTILITIES
SYNONYM - MSD_CS_DATA
SYNONYM - MSD_CS_DEFINITIONS
SYNONYM - MSD_LEVEL_ASSOCIATIONS
SYNONYM - MSD_LEVEL_VALUES
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.MSD_CONSTRAINED_FORECAST_V is not referenced by any database object

[top of page]

View: MSD_CS_CLMN_DIM_DTLS_V

[top of page]

APPS.MSD_CS_CLMN_DIM_DTLS_V references the following:

APPS
VIEW - FND_LOOKUP_VALUES_VL
SYNONYM - MSD_CS_CLMN_DIM_DTLS
VIEW - MSD_CS_DEFN_COLUMN_DTLS_V
VIEW - MSD_CS_DEFN_DIM_DTLS_V
PACKAGE - MSD_CS_DFN_UTL

APPS.MSD_CS_CLMN_DIM_DTLS_V is not referenced by any database object

[top of page]

View: MSD_CS_CLMN_IDENTIFIERS_VL

[top of page]

APPS.MSD_CS_CLMN_IDENTIFIERS_VL references the following:

APPS
VIEW - FND_LOOKUP_VALUES_VL
SYNONYM - MSD_CS_CLMN_IDENTIFIERS
SYNONYM - MSD_CS_CLMN_IDENTIFIERS_TL
APPS.MSD_CS_CLMN_IDENTIFIERS_VL is referenced by following:

APPS
VIEW - MSD_CS_DEFN_COLUMN_DTLS_V
VIEW - MSD_DP_PARAMETERS_CS_V
VIEW - MSD_DP_SCENARIOS_VL

[top of page]

View: MSD_CS_DATA_HEADERS_V

[top of page]

APPS.MSD_CS_DATA_HEADERS_V references the following:

APPS
SYNONYM - MSD_CS_DATA_HEADERS
VIEW - MSD_CS_DEFINITIONS_VL

APPS.MSD_CS_DATA_HEADERS_V is not referenced by any database object

[top of page]

View: MSD_CS_DATA_HEADERS_V1

[top of page]

APPS.MSD_CS_DATA_HEADERS_V1 references the following:

APPS
SYNONYM - MSD_CS_DATA_HEADERS

APPS.MSD_CS_DATA_HEADERS_V1 is not referenced by any database object

[top of page]

View: MSD_CS_DATA_V

[top of page]

APPS.MSD_CS_DATA_V references the following:

APPS
SYNONYM - MSD_CS_DATA

APPS.MSD_CS_DATA_V is not referenced by any database object

[top of page]

View: MSD_CS_DATA_V1

[top of page]

APPS.MSD_CS_DATA_V1 references the following:

APPS
SYNONYM - MSD_CS_DATA

APPS.MSD_CS_DATA_V1 is not referenced by any database object

[top of page]

View: MSD_CS_DEFINITIONS_V1

[top of page]

APPS.MSD_CS_DEFINITIONS_V1 references the following:

APPS
VIEW - FND_LOOKUP_VALUES_VL
SYNONYM - MSD_CS_DEFINITIONS
SYNONYM - MSD_CS_DEFN_DIM_DTLS

APPS.MSD_CS_DEFINITIONS_V1 is not referenced by any database object

[top of page]

View: MSD_CS_DEFINITIONS_VL

[top of page]

APPS.MSD_CS_DEFINITIONS_VL references the following:

APPS
VIEW - FND_LOOKUP_VALUES_VL
SYNONYM - MSD_CS_DEFINITIONS
SYNONYM - MSD_CS_DEFINITIONS_TL
APPS.MSD_CS_DEFINITIONS_VL is referenced by following:

APPS
VIEW - MSD_CS_DATA_HEADERS_V
VIEW - MSD_DP_PARAMETERS_CS_V
VIEW - MSD_DP_SCENARIOS_VL

[top of page]

View: MSD_CS_DEFN_COLUMN_DTLS_V

[top of page]

APPS.MSD_CS_DEFN_COLUMN_DTLS_V references the following:

APPS
VIEW - FND_LOOKUP_VALUES_VL
VIEW - MSD_CS_CLMN_IDENTIFIERS_VL
SYNONYM - MSD_CS_DEFINITIONS
SYNONYM - MSD_CS_DEFN_COLUMN_DTLS
APPS.MSD_CS_DEFN_COLUMN_DTLS_V is referenced by following:

APPS
VIEW - MSD_CS_CLMN_DIM_DTLS_V
PACKAGE - MSD_CS_DFN_UTL

[top of page]

View: MSD_CS_DEFN_DIM_DTLS_V

[top of page]

APPS.MSD_CS_DEFN_DIM_DTLS_V references the following:

APPS
VIEW - FND_LOOKUP_VALUES_VL
SYNONYM - MSD_CS_DEFN_DIM_DTLS
PACKAGE - MSD_CS_DFN_UTL
APPS.MSD_CS_DEFN_DIM_DTLS_V is referenced by following:

APPS
VIEW - MSD_CS_CLMN_DIM_DTLS_V

[top of page]

View: MSD_CS_PLANNING_BOOKING_V

[top of page]

APPS.MSD_CS_PLANNING_BOOKING_V references the following:

APPS
VIEW - MSD_BOOKING_DATA_CS_V

APPS.MSD_CS_PLANNING_BOOKING_V is not referenced by any database object

[top of page]

View: MSD_CURRENCY_CONVERSIONS_V

[top of page]

APPS.MSD_CURRENCY_CONVERSIONS_V references the following:

APPS
SYNONYM - MSD_CURRENCY_CONVERSIONS

APPS.MSD_CURRENCY_CONVERSIONS_V is not referenced by any database object

[top of page]

View: MSD_CUST_ORDER_FCST_CS_V

[top of page]

APPS.MSD_CUST_ORDER_FCST_CS_V references the following:

APPS
SYNONYM - MSD_CS_DATA
SYNONYM - MSD_CS_DEFINITIONS

APPS.MSD_CUST_ORDER_FCST_CS_V is not referenced by any database object

[top of page]

View: MSD_CUST_SALES_FCST_CS_V

[top of page]

APPS.MSD_CUST_SALES_FCST_CS_V references the following:

APPS
SYNONYM - MSD_CS_DATA
SYNONYM - MSD_CS_DEFINITIONS

APPS.MSD_CUST_SALES_FCST_CS_V is not referenced by any database object

[top of page]

View: MSD_DELETED_LEVEL_VALUES_V

[top of page]

APPS.MSD_DELETED_LEVEL_VALUES_V references the following:

APPS
SYNONYM - MSD_DELETED_LEVEL_VALUES

APPS.MSD_DELETED_LEVEL_VALUES_V is not referenced by any database object

[top of page]

View: MSD_DEMAND_PLANS_V

[top of page]

APPS.MSD_DEMAND_PLANS_V references the following:

APPS
PACKAGE - FND_PROFILE
VIEW - MSD_DEMAND_PLANS_VL
APPS.MSD_DEMAND_PLANS_V is referenced by following:

APPS
VIEW - MSD_DP_USERS_V

[top of page]

View: MSD_DP_ASCP_SCENARIOS_V

[top of page]

APPS.MSD_DP_ASCP_SCENARIOS_V references the following:

APPS
PACKAGE - MSD_COMMON_UTILITIES
SYNONYM - MSD_DEMAND_PLANS
SYNONYM - MSD_DEM_TRANSFER_LIST
SYNONYM - MSD_DEM_TRANSFER_QUERY
PACKAGE - MSD_DEM_UPLOAD_FORECAST
SYNONYM - MSD_DP_SCENARIOS
SYNONYM - MSD_DP_SCENARIO_OUTPUT_LEVELS
SYNONYM - MSD_DP_SCENARIO_REVISIONS

APPS.MSD_DP_ASCP_SCENARIOS_V is not referenced by any database object

[top of page]

View: MSD_DP_ASCP_SCN_ENTRIES_V

[top of page]

APPS.MSD_DP_ASCP_SCN_ENTRIES_V references the following:

APPS
SYNONYM - MSC_APPS_INSTANCES
SYNONYM - MSC_SYSTEM_ITEMS
PACKAGE - MSD_COMMON_UTILITIES
SYNONYM - MSD_DEMAND_PLANS
SYNONYM - MSD_DP_SCENARIOS
SYNONYM - MSD_DP_SCENARIO_ENTRIES
SYNONYM - MSD_DP_SCENARIO_REVISIONS
SYNONYM - MSD_DP_SCN_ENTRIES_DENORM
APPS.MSD_DP_ASCP_SCN_ENTRIES_V is referenced by following:

APPS
VIEW - MSD_DEM_SCN_ENTRIES_V

[top of page]

View: MSD_DP_CALENDARS_V

[top of page]

APPS.MSD_DP_CALENDARS_V references the following:

APPS
SYNONYM - MSD_DP_CALENDARS

APPS.MSD_DP_CALENDARS_V is not referenced by any database object

[top of page]

View: MSD_DP_DEFAULT_SCENARIO_V

[top of page]

APPS.MSD_DP_DEFAULT_SCENARIO_V references the following:

APPS
SYNONYM - MSD_DEMAND_PLANS
SYNONYM - MSD_DP_SCENARIOS
SYNONYM - MSD_DP_SCENARIO_OUTPUT_LEVELS

APPS.MSD_DP_DEFAULT_SCENARIO_V is not referenced by any database object

[top of page]

View: MSD_DP_DIMENSIONS_V

[top of page]

APPS.MSD_DP_DIMENSIONS_V references the following:

APPS
VIEW - FND_LOOKUP_VALUES_VL
SYNONYM - MSD_DEMAND_PLANS
SYNONYM - MSD_DP_DIMENSIONS
APPS.MSD_DP_DIMENSIONS_V is referenced by following:

APPS
VIEW - MSD_DP_SCN_OUTPUT_LEVELS_V

[top of page]

View: MSD_DP_EVENTS_V

[top of page]

APPS.MSD_DP_EVENTS_V references the following:

APPS
SYNONYM - MSD_DP_EVENTS
VIEW - MSD_EVENTS_V

APPS.MSD_DP_EVENTS_V is not referenced by any database object

[top of page]

View: MSD_DP_HIERARCHIES_V

[top of page]

APPS.MSD_DP_HIERARCHIES_V references the following:

APPS
VIEW - FND_LOOKUP_VALUES_VL
VIEW - MFG_LOOKUPS
SYNONYM - MSD_DEMAND_PLANS
SYNONYM - MSD_DP_HIERARCHIES
SYNONYM - MSD_HIERARCHIES

APPS.MSD_DP_HIERARCHIES_V is not referenced by any database object

[top of page]

View: MSD_DP_PARAMETERS_CS_V

[top of page]

APPS.MSD_DP_PARAMETERS_CS_V references the following:

APPS
VIEW - FND_LOOKUP_VALUES_VL
VIEW - MSD_CS_CLMN_IDENTIFIERS_VL
VIEW - MSD_CS_DEFINITIONS_VL
PACKAGE - MSD_CS_DFN_UTL
SYNONYM - MSD_DEMAND_PLANS
SYNONYM - MSD_DP_PARAMETERS
SYNONYM - MSD_DP_SCENARIOS

APPS.MSD_DP_PARAMETERS_CS_V is not referenced by any database object

[top of page]

View: MSD_DP_PLANNING_PERCENTAGES_V

[top of page]

APPS.MSD_DP_PLANNING_PERCENTAGES_V references the following:

APPS
SYNONYM - MSC_APPS_INSTANCES
SYNONYM - MSC_BOMS
SYNONYM - MSC_BOM_COMPONENTS
SYNONYM - MSC_ITEM_ID_LID
SYNONYM - MSD_DEMAND_PLANS
SYNONYM - MSD_DP_PLANNING_PERCENTAGES
SYNONYM - MSD_DP_SCENARIOS

APPS.MSD_DP_PLANNING_PERCENTAGES_V is not referenced by any database object

[top of page]

View: MSD_DP_PRICE_LISTS_V

[top of page]

APPS.MSD_DP_PRICE_LISTS_V references the following:

APPS
SYNONYM - MSD_DP_PRICE_LISTS

APPS.MSD_DP_PRICE_LISTS_V is not referenced by any database object

[top of page]

View: MSD_DP_SCENARIOS_CS_V

[top of page]

APPS.MSD_DP_SCENARIOS_CS_V references the following:

APPS
SYNONYM - MSD_DP_SCENARIOS
VIEW - MSD_DP_SCENARIOS_VL
APPS.MSD_DP_SCENARIOS_CS_V is referenced by following:

APPS
VIEW - MSD_DP_SCENARIO_EVENTS_V
VIEW - MSD_DP_SCN_OUTPUT_LEVELS_V

[top of page]

View: MSD_DP_SCENARIOS_V

[top of page]

APPS.MSD_DP_SCENARIOS_V references the following:

APPS
VIEW - FND_LOOKUP_VALUES_VL
SYNONYM - MSD_DEMAND_PLANS
SYNONYM - MSD_DP_SCENARIOS

APPS.MSD_DP_SCENARIOS_V is not referenced by any database object

[top of page]

View: MSD_DP_SCENARIO_ALL_EVENTS_V

[top of page]

APPS.MSD_DP_SCENARIO_ALL_EVENTS_V references the following:

APPS
VIEW - MSD_DP_SCENARIO_EVENTS_V

APPS.MSD_DP_SCENARIO_ALL_EVENTS_V is not referenced by any database object

[top of page]

View: MSD_DP_SCENARIO_EVENTS_V

[top of page]

APPS.MSD_DP_SCENARIO_EVENTS_V references the following:

APPS
VIEW - MSD_DP_SCENARIOS_CS_V
SYNONYM - MSD_DP_SCENARIO_EVENTS
VIEW - MSD_EVENTS_V
APPS.MSD_DP_SCENARIO_EVENTS_V is referenced by following:

APPS
VIEW - MSD_DP_SCENARIO_ALL_EVENTS_V

[top of page]

View: MSD_DP_SCE_SCENARIOS_V

[top of page]

APPS.MSD_DP_SCE_SCENARIOS_V references the following:

APPS
SYNONYM - MSD_DEMAND_PLANS
SYNONYM - MSD_DEM_TRANSFER_LIST
SYNONYM - MSD_DEM_TRANSFER_QUERY
PACKAGE - MSD_DEM_UPLOAD_FORECAST
SYNONYM - MSD_DP_SCENARIOS
SYNONYM - MSD_DP_SCENARIO_OUTPUT_LEVELS
APPS.MSD_DP_SCE_SCENARIOS_V is referenced by following:

APPS
VIEW - MSD_DP_SCE_DEMANDPLAN_V

[top of page]

View: MSD_DP_SCE_SCN_ENTRIES_V

[top of page]

APPS.MSD_DP_SCE_SCN_ENTRIES_V references the following:

APPS
PACKAGE - MSD_DEM_COMMON_UTILITIES
SYNONYM - MSD_DP_SCENARIOS
SYNONYM - MSD_DP_SCENARIO_ENTRIES
SYNONYM - MSD_DP_SCN_ENTRIES_DENORM
VIEW - MSD_DP_SCN_OUTPUT_LEVELS_V

APPS.MSD_DP_SCE_SCN_ENTRIES_V is not referenced by any database object

[top of page]

View: MSD_DP_SCN_LOV_V

[top of page]

APPS.MSD_DP_SCN_LOV_V references the following:

APPS
VIEW - MSD_DP_SCN_REVISIONS_V

APPS.MSD_DP_SCN_LOV_V is not referenced by any database object

[top of page]

View: MSD_DP_SCN_OUTPUT_LEVELS_V

[top of page]

APPS.MSD_DP_SCN_OUTPUT_LEVELS_V references the following:

APPS
VIEW - FND_LOOKUP_VALUES_VL
SYNONYM - MSD_DEMAND_PLANS
PACKAGE - MSD_DEM_COMMON_UTILITIES
SYNONYM - MSD_DEM_GROUP_TABLES
SYNONYM - MSD_DEM_TRANSFER_LIST
SYNONYM - MSD_DEM_TRANSFER_QUERY
SYNONYM - MSD_DEM_TRANSFER_QUERY_LEVELS
VIEW - MSD_DP_DIMENSIONS_V
SYNONYM - MSD_DP_SCENARIOS
VIEW - MSD_DP_SCENARIOS_CS_V
SYNONYM - MSD_DP_SCENARIO_OUTPUT_LEVELS
SYNONYM - MSD_LEVELS
APPS.MSD_DP_SCN_OUTPUT_LEVELS_V is referenced by following:

APPS
VIEW - MSD_DP_SCE_SCN_ENTRIES_V

[top of page]

View: MSD_DP_SCN_REVISIONS_V

[top of page]

APPS.MSD_DP_SCN_REVISIONS_V references the following:

APPS
SYNONYM - MSD_DEMAND_PLANS
SYNONYM - MSD_DP_SCENARIOS
SYNONYM - MSD_DP_SCENARIO_REVISIONS
APPS.MSD_DP_SCN_REVISIONS_V is referenced by following:

APPS
VIEW - MSD_DP_SCN_LOV_V

[top of page]

View: MSD_DP_USERS_V

[top of page]

APPS.MSD_DP_USERS_V references the following:

APPS
SYNONYM - FND_APPLICATION
PACKAGE - FND_DATE
PACKAGE - FND_MESSAGE
PACKAGE - FND_PROFILE
VIEW - FND_RESPONSIBILITY_VL
SYNONYM - FND_USER
VIEW - FND_USER_RESP_GROUPS
SYNONYM - MSC_TRADING_PARTNERS
VIEW - MSD_DEMAND_PLANS_V

APPS.MSD_DP_USERS_V is not referenced by any database object

[top of page]

View: MSD_EVENTS_V

[top of page]

APPS.MSD_EVENTS_V references the following:

APPS
VIEW - FND_LOOKUP_VALUES_VL
SYNONYM - MSD_EVENTS
APPS.MSD_EVENTS_V is referenced by following:

APPS
VIEW - MSD_DP_EVENTS_V
VIEW - MSD_DP_SCENARIO_EVENTS_V

[top of page]

View: MSD_EVENT_PRODUCTS_V

[top of page]

APPS.MSD_EVENT_PRODUCTS_V references the following:

APPS
SYNONYM - MSD_EVENTS
SYNONYM - MSD_EVENT_PRODUCTS
SYNONYM - MSD_LEVELS
SYNONYM - MSD_LEVEL_VALUES

APPS.MSD_EVENT_PRODUCTS_V is not referenced by any database object

[top of page]

View: MSD_EVENT_PRODUCTS_V1

[top of page]

APPS.MSD_EVENT_PRODUCTS_V1 references the following:

APPS
PACKAGE - MSD_COMMON_UTILITIES
SYNONYM - MSD_EVENTS
SYNONYM - MSD_EVENT_PRODUCTS
SYNONYM - MSD_LEVELS

APPS.MSD_EVENT_PRODUCTS_V1 is not referenced by any database object

[top of page]

View: MSD_EVT_PRODUCT_DETAILS_V

[top of page]

APPS.MSD_EVT_PRODUCT_DETAILS_V references the following:

APPS
VIEW - FND_LOOKUP_VALUES_VL
PACKAGE - MSD_COMMON_UTILITIES
SYNONYM - MSD_EVENTS
SYNONYM - MSD_EVENT_PRODUCTS
SYNONYM - MSD_EVT_PRODUCT_DETAILS
SYNONYM - MSD_LEVEL_VALUES

APPS.MSD_EVT_PRODUCT_DETAILS_V is not referenced by any database object

[top of page]

View: MSD_EVT_PRODUCT_DETAILS_V1

[top of page]

APPS.MSD_EVT_PRODUCT_DETAILS_V1 references the following:

APPS
VIEW - FND_LOOKUP_VALUES_VL
PACKAGE - MSD_COMMON_UTILITIES
SYNONYM - MSD_EVENTS
SYNONYM - MSD_EVENT_PRODUCTS
SYNONYM - MSD_EVT_PRODUCT_DETAILS

APPS.MSD_EVT_PRODUCT_DETAILS_V1 is not referenced by any database object

[top of page]

View: MSD_HIERARCHIES_V

[top of page]

APPS.MSD_HIERARCHIES_V references the following:

APPS
VIEW - FND_LOOKUP_VALUES_VL
VIEW - MFG_LOOKUPS
SYNONYM - MSD_HIERARCHIES
APPS.MSD_HIERARCHIES_V is referenced by following:

APPS
VIEW - MSD_HIERARCHY_LEVELS_V

[top of page]

View: MSD_HIERARCHY_LEVELS_V

[top of page]

APPS.MSD_HIERARCHY_LEVELS_V references the following:

APPS
VIEW - MSD_HIERARCHIES_V
SYNONYM - MSD_HIERARCHY_LEVELS
VIEW - MSD_LEVELS_V

APPS.MSD_HIERARCHY_LEVELS_V is not referenced by any database object

[top of page]

View: MSD_ITEM_MASTER_V

[top of page]

APPS.MSD_ITEM_MASTER_V references the following:

APPS
VIEW - FND_COMMON_LOOKUPS
PACKAGE - FND_GLOBAL
PACKAGE - MSD_COMMON_UTILITIES
SYNONYM - MSD_ITEM_LIST_PRICE

APPS.MSD_ITEM_MASTER_V is not referenced by any database object

[top of page]

View: MSD_LEGAL_ENTITIES_V

[top of page]

APPS.MSD_LEGAL_ENTITIES_V references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - HR_ORGANIZATION_INFORMATION
APPS.MSD_LEGAL_ENTITIES_V is referenced by following:

APPS
VIEW - MSD_SR_LE_ALL_V
VIEW - MSD_SR_ORG_LE_V

[top of page]

View: MSD_LEVELS_V

[top of page]

APPS.MSD_LEVELS_V references the following:

APPS
VIEW - FND_LOOKUP_VALUES_VL
SYNONYM - MSD_LEVELS
APPS.MSD_LEVELS_V is referenced by following:

APPS
VIEW - MSD_HIERARCHY_LEVELS_V

[top of page]

View: MSD_LEVEL_ASSOCIATIONS_V1

[top of page]

APPS.MSD_LEVEL_ASSOCIATIONS_V1 references the following:

APPS
SYNONYM - MSC_APPS_INSTANCES
SYNONYM - MSD_LEVELS
SYNONYM - MSD_LEVEL_ASSOCIATIONS
SYNONYM - MSD_LEVEL_VALUES
PACKAGE - MSD_SR_UTIL

APPS.MSD_LEVEL_ASSOCIATIONS_V1 is not referenced by any database object

[top of page]

View: MSD_LEVEL_VALUES_V

[top of page]

APPS.MSD_LEVEL_VALUES_V references the following:

APPS
PACKAGE - MSD_COMMON_UTILITIES
SYNONYM - MSD_LEVELS
SYNONYM - MSD_LEVEL_ASSOCIATIONS
SYNONYM - MSD_LEVEL_VALUES
PACKAGE - MSD_SR_UTIL

APPS.MSD_LEVEL_VALUES_V is not referenced by any database object

[top of page]

View: MSD_LEVEL_VALUES_V1

[top of page]

APPS.MSD_LEVEL_VALUES_V1 references the following:

APPS
SYNONYM - MSC_APPS_INSTANCES
SYNONYM - MSD_LEVELS
SYNONYM - MSD_LEVEL_VALUES

APPS.MSD_LEVEL_VALUES_V1 is not referenced by any database object

[top of page]

View: MSD_MFG_FCST_CS_V

[top of page]

APPS.MSD_MFG_FCST_CS_V references the following:

APPS
SYNONYM - MSD_LEVEL_VALUES
SYNONYM - MSD_MFG_FORECAST

APPS.MSD_MFG_FCST_CS_V is not referenced by any database object

[top of page]

View: MSD_MFG_FCST_V

[top of page]

APPS.MSD_MFG_FCST_V references the following:

APPS
SYNONYM - MSD_LEVEL_VALUES
SYNONYM - MSD_MFG_FORECAST

APPS.MSD_MFG_FCST_V is not referenced by any database object

[top of page]

View: MSD_NPI_CANNED_PRODUCTS_V

[top of page]

APPS.MSD_NPI_CANNED_PRODUCTS_V references the following:

APPS
VIEW - FND_LOOKUP_VALUES_VL
PACKAGE - MSD_COMMON_UTILITIES
SYNONYM - MSD_EVT_PROD_RELATIONSHIPS
SYNONYM - MSD_LEVEL_VALUES

APPS.MSD_NPI_CANNED_PRODUCTS_V is not referenced by any database object

[top of page]

View: MSD_NPI_RELATED_PRODUCTS_V

[top of page]

APPS.MSD_NPI_RELATED_PRODUCTS_V references the following:

APPS
VIEW - FND_LOOKUP_VALUES_VL
PACKAGE - MSD_COMMON_UTILITIES
SYNONYM - MSD_EVT_PROD_RELATIONSHIPS
SYNONYM - MSD_LEVEL_VALUES

APPS.MSD_NPI_RELATED_PRODUCTS_V is not referenced by any database object

[top of page]

View: MSD_NPI_RELATED_PRODUCTS_V1

[top of page]

APPS.MSD_NPI_RELATED_PRODUCTS_V1 references the following:

APPS
VIEW - FND_LOOKUP_VALUES_VL
PACKAGE - MSD_COMMON_UTILITIES
SYNONYM - MSD_EVT_PROD_RELATIONSHIPS

APPS.MSD_NPI_RELATED_PRODUCTS_V1 is not referenced by any database object

[top of page]

View: MSD_NPI_RELATED_PROD_DETAILS_V

[top of page]

APPS.MSD_NPI_RELATED_PROD_DETAILS_V references the following:

APPS
VIEW - FND_LOOKUP_VALUES_VL
PACKAGE - MSD_COMMON_UTILITIES
SYNONYM - MSD_EVENTS
SYNONYM - MSD_EVENT_PRODUCTS
SYNONYM - MSD_EVT_PRODUCT_DETAILS
SYNONYM - MSD_EVT_PROD_RELATIONSHIPS
SYNONYM - MSD_LEVEL_VALUES

APPS.MSD_NPI_RELATED_PROD_DETAILS_V is not referenced by any database object

[top of page]

View: MSD_NPI_RELATED_PROD_DTLS_V1

[top of page]

APPS.MSD_NPI_RELATED_PROD_DTLS_V1 references the following:

APPS
VIEW - FND_LOOKUP_VALUES_VL
PACKAGE - MSD_COMMON_UTILITIES
SYNONYM - MSD_EVENTS
SYNONYM - MSD_EVENT_PRODUCTS
SYNONYM - MSD_EVT_PRODUCT_DETAILS
SYNONYM - MSD_EVT_PROD_RELATIONSHIPS

APPS.MSD_NPI_RELATED_PROD_DTLS_V1 is not referenced by any database object

[top of page]

View: MSD_OBJECTS_V

[top of page]

APPS.MSD_OBJECTS_V references the following:

APPS
VIEW - FND_LOOKUP_VALUES_VL
SYNONYM - MSD_DEMAND_PLANS
SYNONYM - MSD_HIERARCHIES
SYNONYM - MSD_LEVELS

APPS.MSD_OBJECTS_V is not referenced by any database object

[top of page]

View: MSD_OPPORTUNITY_DATA_CS_V

[top of page]

APPS.MSD_OPPORTUNITY_DATA_CS_V references the following:

APPS
SYNONYM - MSD_CS_DATA
SYNONYM - MSD_CS_DEFINITIONS

APPS.MSD_OPPORTUNITY_DATA_CS_V is not referenced by any database object

[top of page]

View: MSD_OPPORTUNITY_DATA_V

[top of page]

APPS.MSD_OPPORTUNITY_DATA_V references the following:

APPS
SYNONYM - MSD_CS_DATA
SYNONYM - MSD_CS_DEFINITIONS
SYNONYM - MSD_LEVEL_VALUES

APPS.MSD_OPPORTUNITY_DATA_V is not referenced by any database object

[top of page]

View: MSD_ORGANIZATION_DEFINITIONS

[top of page]

APPS.MSD_ORGANIZATION_DEFINITIONS references the following:

APPS
SYNONYM - FND_PRODUCT_GROUPS
SYNONYM - HR_ORGANIZATION_INFORMATION
SYNONYM - MTL_PARAMETERS
- GL_SETS_OF_BOOKS
- HR_ALL_ORGANIZATION_UNITS_VL
APPS.MSD_ORGANIZATION_DEFINITIONS is referenced by following:

APPS
VIEW - MSD_SR_ORG_LE_V
VIEW - MSD_SR_OU_BG_V

[top of page]

View: MSD_ORG_CALENDAR_CS_V

[top of page]

APPS.MSD_ORG_CALENDAR_CS_V references the following:

APPS
SYNONYM - MSD_LEVEL_VALUES
SYNONYM - MSD_ORG_CALENDARS
SYNONYM - MSD_TIME

APPS.MSD_ORG_CALENDAR_CS_V is not referenced by any database object

[top of page]

View: MSD_PRICE_LIST_V

[top of page]

APPS.MSD_PRICE_LIST_V references the following:

APPS
SYNONYM - MSD_LEVEL_VALUES
SYNONYM - MSD_PRICE_LIST

APPS.MSD_PRICE_LIST_V is not referenced by any database object

[top of page]

View: MSD_SALES_FCST_BESTCASE_CS_V

[top of page]

APPS.MSD_SALES_FCST_BESTCASE_CS_V references the following:

APPS
SYNONYM - MSD_CS_DATA
SYNONYM - MSD_CS_DEFINITIONS

APPS.MSD_SALES_FCST_BESTCASE_CS_V is not referenced by any database object

[top of page]

View: MSD_SALES_FCST_PIPELINE_CS_V

[top of page]

APPS.MSD_SALES_FCST_PIPELINE_CS_V references the following:

APPS
SYNONYM - MSD_CS_DATA
SYNONYM - MSD_CS_DEFINITIONS

APPS.MSD_SALES_FCST_PIPELINE_CS_V is not referenced by any database object

[top of page]

View: MSD_SALES_FCST_REALISTIC_CS_V

[top of page]

APPS.MSD_SALES_FCST_REALISTIC_CS_V references the following:

APPS
SYNONYM - MSD_CS_DATA
SYNONYM - MSD_CS_DEFINITIONS

APPS.MSD_SALES_FCST_REALISTIC_CS_V is not referenced by any database object

[top of page]

View: MSD_SALES_FCST_WGTPLINE_CS_V

[top of page]

APPS.MSD_SALES_FCST_WGTPLINE_CS_V references the following:

APPS
SYNONYM - MSD_CS_DATA
SYNONYM - MSD_CS_DEFINITIONS

APPS.MSD_SALES_FCST_WGTPLINE_CS_V is not referenced by any database object

[top of page]

View: MSD_SALES_FCST_WORSTCASE_CS_V

[top of page]

APPS.MSD_SALES_FCST_WORSTCASE_CS_V references the following:

APPS
SYNONYM - MSD_CS_DATA
SYNONYM - MSD_CS_DEFINITIONS

APPS.MSD_SALES_FCST_WORSTCASE_CS_V is not referenced by any database object

[top of page]

View: MSD_SCN_ENTRY_COMMENTS_V

[top of page]

APPS.MSD_SCN_ENTRY_COMMENTS_V references the following:

APPS
SYNONYM - MSD_COMMENTS
SYNONYM - MSD_REASON_CODES
SYNONYM - MSD_SCN_ENTRY_COMMENTS

APPS.MSD_SCN_ENTRY_COMMENTS_V is not referenced by any database object

[top of page]

View: MSD_SHIPMENT_DATA_CS_V

[top of page]

APPS.MSD_SHIPMENT_DATA_CS_V references the following:

APPS
SYNONYM - MSD_LEVEL_VALUES
SYNONYM - MSD_SHIPMENT_DATA

APPS.MSD_SHIPMENT_DATA_CS_V is not referenced by any database object

[top of page]

View: MSD_SHIPMENT_DATA_ORIG_CS_V

[top of page]

APPS.MSD_SHIPMENT_DATA_ORIG_CS_V references the following:

APPS
SYNONYM - MSD_LEVEL_VALUES
SYNONYM - MSD_SHIPMENT_DATA

APPS.MSD_SHIPMENT_DATA_ORIG_CS_V is not referenced by any database object

[top of page]

View: MSD_SHIPMENT_DATA_V

[top of page]

APPS.MSD_SHIPMENT_DATA_V references the following:

APPS
SYNONYM - MSD_LEVEL_VALUES
SYNONYM - MSD_SHIPMENT_DATA

APPS.MSD_SHIPMENT_DATA_V is not referenced by any database object

[top of page]

View: MSD_SR_AREA_ALL_V

[top of page]

APPS.MSD_SR_AREA_ALL_V references the following:

APPS
VIEW - FND_TERRITORIES_VL
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_CUST_SITE_USES_ALL
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_LOC_ASSIGNMENTS
SYNONYM - HZ_PARTY_SITES
SYNONYM - MSD_SETUP_PARAMETERS
PACKAGE - MSD_SR_UTIL
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.MSD_SR_AREA_ALL_V is not referenced by any database object

[top of page]

View: MSD_SR_BACKLOG_V

[top of page]

APPS.MSD_SR_BACKLOG_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_SITE_USES_ALL
SYNONYM - MSD_APP_INSTANCE_ORGS
SYNONYM - MSD_SETUP_PARAMETERS
PACKAGE - MSD_SR_UTIL
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - OE_ORDER_HEADERS_ALL
SYNONYM - OE_ORDER_LINES_ALL
SYNONYM - OE_TRANSACTION_TYPES_TL
SYNONYM - RA_SALESREPS_ALL
- SO_LOOKUPS

APPS.MSD_SR_BACKLOG_V is not referenced by any database object

[top of page]

View: MSD_SR_BG_ALL_V

[top of page]

APPS.MSD_SR_BG_ALL_V references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - MSD_APP_INSTANCE_ORGS
PACKAGE - MSD_SR_UTIL
PUBLIC
SYNONYM - DUAL
- MSD_ORGANIZATION_DEFINITIONS
- DUAL

APPS.MSD_SR_BG_ALL_V is not referenced by any database object

[top of page]

View: MSD_SR_BOOKING_DATA_V

[top of page]

APPS.MSD_SR_BOOKING_DATA_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - FND_PRODUCT_GROUPS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_SITE_USES_ALL
SYNONYM - MSD_APP_INSTANCE_ORGS
SYNONYM - MSD_SETUP_PARAMETERS
PACKAGE - MSD_SR_UTIL
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - OE_ORDER_HEADERS_ALL
SYNONYM - OE_ORDER_LINES_ALL
SYNONYM - RA_SALESREPS_ALL
- SO_LOOKUPS

APPS.MSD_SR_BOOKING_DATA_V is not referenced by any database object

[top of page]

View: MSD_SR_CAT_ALL_V

[top of page]

APPS.MSD_SR_CAT_ALL_V references the following:

APPS
SYNONYM - MSD_APP_INSTANCE_ORGS
SYNONYM - MSD_SETUP_PARAMETERS
PACKAGE - MSD_SR_UTIL
VIEW - MTL_CATEGORIES_B_KFV
SYNONYM - MTL_CATEGORIES_TL
SYNONYM - MTL_ITEM_CATEGORIES
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.MSD_SR_CAT_ALL_V is not referenced by any database object

[top of page]

View: MSD_SR_CLASS_ALL_V

[top of page]

APPS.MSD_SR_CLASS_ALL_V references the following:

APPS
VIEW - FND_LOOKUP_VALUES_VL
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - MSD_SETUP_PARAMETERS
PACKAGE - MSD_SR_UTIL
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.MSD_SR_CLASS_ALL_V is not referenced by any database object

[top of page]

View: MSD_SR_COUNTRY_AREA_V

[top of page]

APPS.MSD_SR_COUNTRY_AREA_V references the following:

APPS
VIEW - FND_TERRITORIES_VL
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_CUST_SITE_USES_ALL
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_LOC_ASSIGNMENTS
SYNONYM - HZ_PARTY_SITES
SYNONYM - MSD_SETUP_PARAMETERS
PACKAGE - MSD_SR_UTIL
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.MSD_SR_COUNTRY_AREA_V is not referenced by any database object

[top of page]

View: MSD_SR_CURRENCY_CONVERSIONS_V

[top of page]

APPS.MSD_SR_CURRENCY_CONVERSIONS_V references the following:

APPS
SYNONYM - GL_DAILY_RATES

APPS.MSD_SR_CURRENCY_CONVERSIONS_V is not referenced by any database object

[top of page]

View: MSD_SR_CUS_CLASS_V

[top of page]

APPS.MSD_SR_CUS_CLASS_V references the following:

APPS
VIEW - FND_LOOKUP_VALUES_VL
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_PARTIES
SYNONYM - MSD_SETUP_PARAMETERS
PACKAGE - MSD_SR_UTIL
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.MSD_SR_CUS_CLASS_V is not referenced by any database object

[top of page]

View: MSD_SR_CUS_GROUP_V

[top of page]

APPS.MSD_SR_CUS_GROUP_V references the following:

APPS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_PARTIES
SYNONYM - MSD_SETUP_PARAMETERS
PACKAGE - MSD_SR_UTIL
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.MSD_SR_CUS_GROUP_V is not referenced by any database object

[top of page]

View: MSD_SR_FISCAL_TIME_V

[top of page]

APPS.MSD_SR_FISCAL_TIME_V references the following:

APPS
SYNONYM - GL_PERIODS

APPS.MSD_SR_FISCAL_TIME_V is not referenced by any database object

[top of page]

View: MSD_SR_GROUP_ALL_V

[top of page]

APPS.MSD_SR_GROUP_ALL_V references the following:

APPS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - MSD_SETUP_PARAMETERS
PACKAGE - MSD_SR_UTIL
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.MSD_SR_GROUP_ALL_V is not referenced by any database object

[top of page]

View: MSD_SR_GRP1_GRP2_V

[top of page]

APPS.MSD_SR_GRP1_GRP2_V references the following:

APPS
PACKAGE - MSD_SR_UTIL
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.MSD_SR_GRP1_GRP2_V is not referenced by any database object

[top of page]

View: MSD_SR_GRP2_GRP3_V

[top of page]

APPS.MSD_SR_GRP2_GRP3_V references the following:

APPS
PACKAGE - MSD_SR_UTIL
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.MSD_SR_GRP2_GRP3_V is not referenced by any database object

[top of page]

View: MSD_SR_GRP3_GRP4_V

[top of page]

APPS.MSD_SR_GRP3_GRP4_V references the following:

APPS
PACKAGE - MSD_SR_UTIL
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.MSD_SR_GRP3_GRP4_V is not referenced by any database object

[top of page]

View: MSD_SR_GRP4_ALL_V

[top of page]

APPS.MSD_SR_GRP4_ALL_V references the following:

APPS
PACKAGE - MSD_SR_UTIL
- MSD_SR_GRP3_GRP4_V

APPS.MSD_SR_GRP4_ALL_V is not referenced by any database object

[top of page]

View: MSD_SR_ITEM_LIST_PRICE_V

[top of page]

APPS.MSD_SR_ITEM_LIST_PRICE_V references the following:

APPS
PACKAGE - MSD_SR_UTIL
SYNONYM - MTL_SYSTEM_ITEMS_KFV

APPS.MSD_SR_ITEM_LIST_PRICE_V is not referenced by any database object

[top of page]

View: MSD_SR_IT_ALL_V

[top of page]

APPS.MSD_SR_IT_ALL_V references the following:

APPS
SYNONYM - ENI_DENORM_HIERARCHIES
PACKAGE - MSD_SR_UTIL
VIEW - MTL_CATEGORIES_B_KFV
SYNONYM - MTL_CATEGORIES_TL
SYNONYM - MTL_DEFAULT_CATEGORY_SETS
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.MSD_SR_IT_ALL_V is not referenced by any database object

[top of page]

View: MSD_SR_LE_BG_V

[top of page]

APPS.MSD_SR_LE_BG_V references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - MSD_APP_INSTANCE_ORGS
PACKAGE - MSD_SR_UTIL
PUBLIC
SYNONYM - DUAL
- DUAL
- MSD_ORGANIZATION_DEFINITIONS
- MSD_LEGAL_ENTITIES_V

APPS.MSD_SR_LE_BG_V is not referenced by any database object

[top of page]

View: MSD_SR_LOC_CUS_V

[top of page]

APPS.MSD_SR_LOC_CUS_V references the following:

APPS
VIEW - FND_LOOKUP_VALUES_VL
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - HR_ORGANIZATION_INFORMATION
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_CUST_SITE_USES_ALL
SYNONYM - HZ_PARTIES
SYNONYM - MSD_SETUP_PARAMETERS
PACKAGE - MSD_SR_UTIL
SYNONYM - MTL_PARAMETERS
SYNONYM - PO_LOCATION_ASSOCIATIONS_ALL
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.MSD_SR_LOC_CUS_V is not referenced by any database object

[top of page]

View: MSD_SR_LOC_REG_V

[top of page]

APPS.MSD_SR_LOC_REG_V references the following:

APPS
VIEW - FND_LOOKUP_VALUES_VL
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - HR_ORGANIZATION_INFORMATION
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_CUST_SITE_USES_ALL
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_LOC_ASSIGNMENTS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
SYNONYM - MSD_SETUP_PARAMETERS
PACKAGE - MSD_SR_UTIL
SYNONYM - MTL_PARAMETERS
SYNONYM - PO_LOCATION_ASSOCIATIONS_ALL
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.MSD_SR_LOC_REG_V is not referenced by any database object

[top of page]

View: MSD_SR_MFG_FCST_V

[top of page]

APPS.MSD_SR_MFG_FCST_V references the following:

APPS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_SITE_USES_ALL
SYNONYM - MRP_FORECAST_DATES
SYNONYM - MRP_FORECAST_DESIGNATORS
SYNONYM - MSD_APP_INSTANCE_ORGS
SYNONYM - MSD_SETUP_PARAMETERS
PACKAGE - MSD_SR_UTIL
SYNONYM - MTL_SYSTEM_ITEMS

APPS.MSD_SR_MFG_FCST_V is not referenced by any database object

[top of page]

View: MSD_SR_MFG_TIME_V

[top of page]

APPS.MSD_SR_MFG_TIME_V references the following:

APPS
SYNONYM - BOM_CALENDAR_DATES
SYNONYM - BOM_CAL_WEEK_START_DATES
SYNONYM - BOM_PERIOD_START_DATES

APPS.MSD_SR_MFG_TIME_V is not referenced by any database object

[top of page]

View: MSD_SR_MGR1_MGR2_V

[top of page]

APPS.MSD_SR_MGR1_MGR2_V references the following:

APPS
PACKAGE - MSD_SR_UTIL
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.MSD_SR_MGR1_MGR2_V is not referenced by any database object

[top of page]

View: MSD_SR_MGR2_MGR3_V

[top of page]

APPS.MSD_SR_MGR2_MGR3_V references the following:

APPS
PACKAGE - MSD_SR_UTIL
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.MSD_SR_MGR2_MGR3_V is not referenced by any database object

[top of page]

View: MSD_SR_MGR3_MGR4_V

[top of page]

APPS.MSD_SR_MGR3_MGR4_V references the following:

APPS
PACKAGE - MSD_SR_UTIL
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.MSD_SR_MGR3_MGR4_V is not referenced by any database object

[top of page]

View: MSD_SR_MGR4_ALL_V

[top of page]

APPS.MSD_SR_MGR4_ALL_V references the following:

APPS
PACKAGE - MSD_SR_UTIL
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.MSD_SR_MGR4_ALL_V is not referenced by any database object

[top of page]

View: MSD_SR_OPPORTUNITY_V

[top of page]

APPS.MSD_SR_OPPORTUNITY_V references the following:

PUBLIC
SYNONYM - DUAL
- DUAL

APPS.MSD_SR_OPPORTUNITY_V is not referenced by any database object

[top of page]

View: MSD_SR_ORG_OU_V

[top of page]

APPS.MSD_SR_ORG_OU_V references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - MSD_APP_INSTANCE_ORGS
PACKAGE - MSD_SR_UTIL
- MSD_ORGANIZATION_DEFINITIONS

APPS.MSD_SR_ORG_OU_V is not referenced by any database object

[top of page]

View: MSD_SR_OU_LE_V

[top of page]

APPS.MSD_SR_OU_LE_V references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - MSD_APP_INSTANCE_ORGS
PACKAGE - MSD_SR_UTIL
PUBLIC
SYNONYM - DUAL
- MSD_ORGANIZATION_DEFINITIONS
- MSD_LEGAL_ENTITIES_V
- DUAL

APPS.MSD_SR_OU_LE_V is not referenced by any database object

[top of page]

View: MSD_SR_PF_ALL_V

[top of page]

APPS.MSD_SR_PF_ALL_V references the following:

APPS
VIEW - BOM_BILL_OF_MATERIALS
VIEW - BOM_BILL_OF_MATERIALS_V
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUP_VALUES_VL
SYNONYM - MSD_SETUP_PARAMETERS
PACKAGE - MSD_SR_UTIL
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - MTL_SYSTEM_ITEMS_TL
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.MSD_SR_PF_ALL_V is not referenced by any database object

[top of page]

View: MSD_SR_PRD_CAT_V

[top of page]

APPS.MSD_SR_PRD_CAT_V references the following:

APPS
SYNONYM - MSD_APP_INSTANCE_ORGS
SYNONYM - MSD_SETUP_PARAMETERS
PACKAGE - MSD_SR_UTIL
VIEW - MTL_CATEGORIES_B_KFV
SYNONYM - MTL_CATEGORY_SETS_B
SYNONYM - MTL_ITEM_CATEGORIES
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - MTL_SYSTEM_ITEMS_TL

APPS.MSD_SR_PRD_CAT_V is not referenced by any database object

[top of page]

View: MSD_SR_PRD_IT_V

[top of page]

APPS.MSD_SR_PRD_IT_V references the following:

APPS
SYNONYM - ENI_DENORM_HIERARCHIES
SYNONYM - MSD_APP_INSTANCE_ORGS
SYNONYM - MSD_SETUP_PARAMETERS
PACKAGE - MSD_SR_UTIL
VIEW - MTL_CATEGORIES_B_KFV
VIEW - MTL_CATEGORIES_VL
SYNONYM - MTL_DEFAULT_CATEGORY_SETS
VIEW - MTL_ITEM_CATEGORIES_V
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - MTL_SYSTEM_ITEMS_TL

APPS.MSD_SR_PRD_IT_V is not referenced by any database object

[top of page]

View: MSD_SR_PRD_PF_V

[top of page]

APPS.MSD_SR_PRD_PF_V references the following:

APPS
VIEW - BOM_BILL_OF_MATERIALS
VIEW - BOM_INVENTORY_COMPONENTS
PACKAGE - FND_GLOBAL
SYNONYM - MSD_APP_INSTANCE_ORGS
SYNONYM - MSD_SETUP_PARAMETERS
PACKAGE - MSD_SR_UTIL
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - MTL_SYSTEM_ITEMS_TL

APPS.MSD_SR_PRD_PF_V is not referenced by any database object

[top of page]

View: MSD_SR_PRICE_LIST_V

[top of page]

APPS.MSD_SR_PRICE_LIST_V references the following:

APPS
SYNONYM - MSD_APP_INSTANCE_ORGS
SYNONYM - MSD_SETUP_PARAMETERS
PACKAGE - MSD_SR_UTIL
SYNONYM - MTL_ITEM_CATEGORIES
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - QP_LIST_LINES
SYNONYM - QP_PRICING_ATTRIBUTES
- QP_PRICE_REQ_SOURCES_V
- QP_LIST_HEADERS_VL

APPS.MSD_SR_PRICE_LIST_V is not referenced by any database object

[top of page]

View: MSD_SR_REG_COUNTRY_V

[top of page]

APPS.MSD_SR_REG_COUNTRY_V references the following:

APPS
VIEW - FND_TERRITORIES_VL
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_CUST_SITE_USES_ALL
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_LOC_ASSIGNMENTS
SYNONYM - HZ_PARTY_SITES
SYNONYM - MSD_SETUP_PARAMETERS
PACKAGE - MSD_SR_UTIL
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.MSD_SR_REG_COUNTRY_V is not referenced by any database object

[top of page]

View: MSD_SR_REP_GRP1_V

[top of page]

APPS.MSD_SR_REP_GRP1_V references the following:

APPS
PACKAGE - MSD_SR_UTIL
SYNONYM - RA_SALESREPS_ALL
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.MSD_SR_REP_GRP1_V is not referenced by any database object

[top of page]

View: MSD_SR_REP_MGR1_V

[top of page]

APPS.MSD_SR_REP_MGR1_V references the following:

APPS
PACKAGE - MSD_SR_UTIL
SYNONYM - RA_SALESREPS_ALL
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.MSD_SR_REP_MGR1_V is not referenced by any database object

[top of page]

View: MSD_SR_SALES_FCST_V

[top of page]

APPS.MSD_SR_SALES_FCST_V references the following:

APPS
SYNONYM - AS_FORECAST_CATEGORIES
SYNONYM - AS_INTERNAL_FORECASTS
SYNONYM - AS_OPP_WORKSHEET_LINES
SYNONYM - AS_PROD_WORKSHEET_LINES
SYNONYM - ENI_DENORM_HIERARCHIES
SYNONYM - GL_PERIODS
SYNONYM - JTF_RS_GROUPS_B
SYNONYM - JTF_RS_GRP_RELATIONS
SYNONYM - MSD_SETUP_PARAMETERS
PACKAGE - MSD_SR_UTIL
SYNONYM - MTL_DEFAULT_CATEGORY_SETS

APPS.MSD_SR_SALES_FCST_V is not referenced by any database object

[top of page]

View: MSD_SR_SC_ALL_V

[top of page]

APPS.MSD_SR_SC_ALL_V references the following:

APPS
PACKAGE - FND_GLOBAL
PACKAGE - MSD_SR_UTIL
PUBLIC
SYNONYM - DUAL
- DUAL
- SO_LOOKUPS

APPS.MSD_SR_SC_ALL_V is not referenced by any database object

[top of page]

View: MSD_SR_SHIPMENT_DATA_V

[top of page]

APPS.MSD_SR_SHIPMENT_DATA_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - FND_PRODUCT_GROUPS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_SITE_USES_ALL
SYNONYM - MSD_APP_INSTANCE_ORGS
SYNONYM - MSD_SETUP_PARAMETERS
PACKAGE - MSD_SR_UTIL
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - OE_ORDER_HEADERS_ALL
SYNONYM - OE_ORDER_LINES_ALL
SYNONYM - RA_SALESREPS_ALL
- SO_LOOKUPS

APPS.MSD_SR_SHIPMENT_DATA_V is not referenced by any database object

[top of page]

View: MSD_SR_UOM_CONVERSIONS_V

[top of page]

APPS.MSD_SR_UOM_CONVERSIONS_V references the following:

APPS
PACKAGE - MSD_SR_UTIL
SYNONYM - MTL_UNITS_OF_MEASURE
SYNONYM - MTL_UOM_CLASS_CONVERSIONS
SYNONYM - MTL_UOM_CONVERSIONS

APPS.MSD_SR_UOM_CONVERSIONS_V is not referenced by any database object

[top of page]

View: MSD_ST_CS_DATA_V

[top of page]

APPS.MSD_ST_CS_DATA_V references the following:

APPS
SYNONYM - MSD_ST_CS_DATA

APPS.MSD_ST_CS_DATA_V is not referenced by any database object

[top of page]

View: MSD_SUPPLY_PLANS_V

[top of page]

APPS.MSD_SUPPLY_PLANS_V references the following:

APPS
PACKAGE - FND_PROFILE
SYNONYM - MSC_DEMANDS
SYNONYM - MSC_FULL_PEGGING
SYNONYM - MSC_PLANS
SYNONYM - MSC_SUPPLIES
SYNONYM - MSC_SYSTEM_ITEMS
PACKAGE - MSD_COMMON_UTILITIES
SYNONYM - MSD_CS_DATA
SYNONYM - MSD_CS_DEFINITIONS
SYNONYM - MSD_LEVEL_ASSOCIATIONS
SYNONYM - MSD_LEVEL_VALUES
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.MSD_SUPPLY_PLANS_V is not referenced by any database object

[top of page]

View: MSD_TIME_V

[top of page]

APPS.MSD_TIME_V references the following:

APPS
SYNONYM - MSD_TIME

APPS.MSD_TIME_V is not referenced by any database object

[top of page]

View: MSD_UOM_CONVERSIONS_V

[top of page]

APPS.MSD_UOM_CONVERSIONS_V references the following:

APPS
SYNONYM - MSD_LEVEL_VALUES
SYNONYM - MSD_UOM_CONVERSIONS

APPS.MSD_UOM_CONVERSIONS_V is not referenced by any database object

[top of page]



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