eTRM uses javascript that opens and focuses a separate window to display reports.
Your browser does not appear to support javascript. This should not prevent you from using
eTRM but it does mean the window focus feature will not work. Please check the contents of
other windows on your desktop if you click on a link that does not appear to do anything.
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®,
OracleDevConnect SM, Oracle® Discoverer,
Oracle® Expert, Oracle Financials®, OracleGOLD SM,
OracleIncident SM, OracleJSP,
OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURY SM,
OracleMetaLink SM, Oraclemetals SM, OracleMobile, Oracle Names®,
Oracle NetSolutions®, Oracle® One, Oracle Open Gateways®,
Oracle OpenWorld®, OraclePLATINUM SM,
Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®,
Oracle Quality®, Oracle Secure Network Services®, OracleSILVER SM,
Oracle® SQL/Services, Oracle® SQL*TutorSM,
OracleSTERLING SM, 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_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
INSTANCE_ID
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:
APPS
SYNONYM - 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
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:
APPS
SYNONYM - 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
SR_LEVEL_PK
INSTANCE
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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - MSD_BOOKING_DATA
[top of page]
Table: MSD_COMMENTS
Description: This table stores comments for a particular scenario revision
Primary Key: MSD_COMMENTS_UK1
COMMENT_ID
DEMAND_PLAN_ID
REVISION
SCENARIO_ID
[top of page]
MSD.MSD_COMMENTS does not reference any database object
MSD.MSD_COMMENTS is referenced by following:
APPS
SYNONYM - 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
CS_CLMN_DIM_DTLS_ID
Primary Key: MSD_CS_CLMN_DIM_DTLS_U1
CS_DEFN_DIM_DTLS_ID
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:
APPS
SYNONYM - 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
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:
APPS
SYNONYM - 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
COLUMN_IDENTIFIER
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:
APPS
SYNONYM - 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
CS_DATA_ID
[top of page]
MSD.MSD_CS_DATA does not reference any database object
MSD.MSD_CS_DATA is referenced by following:
APPS
SYNONYM - MSD_CS_DATA
[top of page]
Table: MSD_CS_DATA_HEADERS
Description: Stores Custom Stream Fact Headers
Primary Key: MSD_CS_DATA_HEADERS_PK
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:
APPS
SYNONYM - MSD_CS_DATA_HEADERS
[top of page]
Table: MSD_CS_DEFINITIONS
Description: This table stores Custom Stream Definitions
Primary Key: MSD_CS_DEFINITIONS_PK
CS_DEFINITION_ID
Primary Key: MSD_CS_DEFINITIONS_UK
NAME
[top of page]
MSD.MSD_CS_DEFINITIONS does not reference any database object
MSD.MSD_CS_DEFINITIONS is referenced by following:
APPS
SYNONYM - 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
CS_DEFINITION_ID
LANGUAGE
[top of page]
MSD.MSD_CS_DEFINITIONS_TL does not reference any database object
MSD.MSD_CS_DEFINITIONS_TL is referenced by following:
APPS
SYNONYM - 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
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:
APPS
SYNONYM - 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
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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - MSD_DELETED_LEVEL_VALUES
[top of page]
Table: MSD_DEMAND_PLANS
Description: Demand Plan definition.
Primary Key: MSD_DEMAND_PLANS_PK
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:
APPS
SYNONYM - MSD_DEMAND_PLANS
MATERIALIZED VIEW - MSD_DEM_SCN_ENTRIES_MV
[top of page]
Table: MSD_DEM_ITEMS_GTT
[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
[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
[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
[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
CALENDAR_CODE
CALENDAR_TYPE
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:
APPS
SYNONYM - 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
DEMAND_PLAN_ID
DIMENSION_CODE
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:
APPS
SYNONYM - MSD_DP_DIMENSIONS
PACKAGE BODY - MSD_VALIDATE_DEMAND_PLAN
[top of page]
Table: MSD_DP_EVENTS
Description: This table stores Demand Plan related Events.
Primary Key: MSD_DP_EVENTS_PK
DP_EVENT_ID
[top of page]
MSD.MSD_DP_EVENTS does not reference any database object
MSD.MSD_DP_EVENTS is referenced by following:
APPS
SYNONYM - 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
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:
APPS
SYNONYM - 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
DEMAND_PLAN_ID
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:
APPS
SYNONYM - 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
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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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
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:
APPS
SYNONYM - 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
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:
APPS
MATERIALIZED VIEW - MSD_DEM_SCN_ENTRIES_MV
SYNONYM - 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:
APPS
MATERIALIZED VIEW - MSD_DEM_SCN_ENTRIES_MV
SYNONYM - 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
DEMAND_PLAN_ID
EVENT_ID
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:
APPS
SYNONYM - 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
DEMAND_PLAN_ID
SCENARIO_ID
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:
APPS
SYNONYM - 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
SCENARIO_ID
DEMAND_PLAN_ID
REVISION
[top of page]
MSD.MSD_DP_SCENARIO_REVISIONS does not reference any database object
MSD.MSD_DP_SCENARIO_REVISIONS is referenced by following:
APPS
MATERIALIZED VIEW - MSD_DEM_SCN_ENTRIES_MV
SYNONYM - 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
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:
APPS
SYNONYM - MSD_EVENTS
[top of page]
Table: MSD_EVENT_DETAILS
[top of page]
MSD.MSD_EVENT_DETAILS does not reference any database object
MSD.MSD_EVENT_DETAILS is referenced by following:
APPS
SYNONYM - 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
EVENT_ID
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:
APPS
SYNONYM - 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
EVENT_ID
DETAIL_ID
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:
APPS
SYNONYM - 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
RELATION_ID
SEQ_ID
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:
APPS
SYNONYM - 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
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:
APPS
SYNONYM - 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
HIERARCHY_ID
LEVEL_ID
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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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
LEVEL_ID
[top of page]
MSD.MSD_LEVELS does not reference any database object
MSD.MSD_LEVELS is referenced by following:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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
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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - MSD_MFG_FORECAST
[top of page]
Table: MSD_ODPTIME
[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
INSTANCE
SR_ORG_PK
CALENDAR_TYPE
CALENDAR_CODE
[top of page]
MSD.MSD_ORG_CALENDARS does not reference any database object
MSD.MSD_ORG_CALENDARS is referenced by following:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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
DEMAND_PLAN_ID
REASON_CODE
REVISION
SCENARIO_ID
[top of page]
MSD.MSD_REASON_CODES does not reference any database object
MSD.MSD_REASON_CODES is referenced by following:
APPS
SYNONYM - MSD_REASON_CODES
[top of page]
Table: MSD_SALES_FORECAST
[top of page]
MSD.MSD_SALES_FORECAST does not reference any database object
MSD.MSD_SALES_FORECAST is referenced by following:
APPS
SYNONYM - MSD_SALES_FORECAST
[top of page]
Table: MSD_SALES_OPPORTUNITY_DATA
[top of page]
MSD.MSD_SALES_OPPORTUNITY_DATA does not reference any database object
MSD.MSD_SALES_OPPORTUNITY_DATA is referenced by following:
APPS
SYNONYM - 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
COMMENT_ID
DEMAND_PLAN_ID
REVISION
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:
APPS
SYNONYM - 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
INSTANCE_ID
PARAMETER_NAME
[top of page]
MSD.MSD_SETUP_PARAMETERS does not reference any database object
MSD.MSD_SETUP_PARAMETERS is referenced by following:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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
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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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:
APPS
SYNONYM - 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 referenced by following:
APPS
PACKAGE BODY - MSD_COMPOSITE_GROUPING
[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 referenced by following:
APPS
PACKAGE BODY - MSD_CS_CLMN_DIM_LOAD_DATA
[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 referenced by following:
APPS
PACKAGE BODY - MSD_CS_COLLECTION
[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 referenced by following:
APPS
PACKAGE BODY - MSD_CS_COLLECTION
[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
PACKAGE BODY - MSD_VALIDATE_DEMAND_PLAN
[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 BODY - MSD_CS_COLLECTION
PACKAGE - MSD_CS_DFN_UTL
PACKAGE BODY - MSD_CS_DFN_UTL
PACKAGE BODY - MSD_STRIPE_DEMAND_PLAN
PACKAGE BODY - MSD_VALIDATE_DEMAND_PLAN
[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
PACKAGE BODY - MSDWF
VIEW - MSD_DP_USERS_V
PACKAGE BODY - MSD_SOP
PACKAGE BODY - MSD_WF
PACKAGE BODY - ODP
[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 referenced by following:
APPS
PACKAGE BODY - MSC_DEMANTRA_PKG
VIEW - MSC_FORECAST_RULES_V
PACKAGE BODY - MSC_GET_NAME
PACKAGE BODY - MSC_PHUB_PKG
PACKAGE BODY - MSC_PHUB_UTIL
VIEW - MSC_PLAN_SCHEDULES_V
VIEW - MSC_PLAN_SCHED_V
PACKAGE BODY - MSC_SCN_UTILS
PACKAGE BODY - MSC_WS_APS_DATA_SERVICES
PACKAGE BODY - MSC_WS_ASCP
PACKAGE BODY - MSC_WS_COMMON
PACKAGE BODY - MSC_WS_DRP
PACKAGE BODY - MSC_WS_IO
PACKAGE BODY - MSC_WS_SRP
PACKAGE BODY - MSD_ASCP_FLOW
[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
MATERIALIZED VIEW - MSD_DEM_SCN_ENTRIES_MV
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
PACKAGE BODY - MSD_VALIDATE_DEMAND_PLAN
[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 referenced by following:
APPS
PACKAGE BODY - MSD_VALIDATE_DEMAND_PLAN
[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 referenced by following:
APPS
PACKAGE BODY - MSD_COLLECT_LEVEL_VALUES
PACKAGE BODY - MSD_VALIDATE_DEMAND_PLAN
[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 referenced by following:
APPS
PACKAGE BODY - MSD_LIABILITY
PACKAGE BODY - MSD_VALIDATE_DEMAND_PLAN
[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
PACKAGE BODY - MSD_APPLY_TEMPLATE_DEMAND_PLAN
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_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
SYNONYM - MSD_DP_SCENARIOS
SYNONYM - MSD_DP_SCENARIO_ENTRIES
APPS.MSD_DP_SCE_SCN_ENTRIES_V is referenced by following:
APPS
PACKAGE BODY - MSD_SCE_PUBLISH_FORECAST_PKG
[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
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
PACKAGE BODY - MSC_GET_NAME
PACKAGE BODY - MSC_WS_ASCP
[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 referenced by following:
APPS
PACKAGE BODY - ODP
[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
PACKAGE BODY - MSD_VALIDATE_DEMAND_PLAN
[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 referenced by following:
APPS
PACKAGE BODY - MSD_VALIDATE_DEMAND_PLAN
[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 referenced by following:
APPS
PACKAGE BODY - MSD_COLLECT_LEVEL_VALUES
PACKAGE BODY - MSD_VALIDATE_DEMAND_PLAN
[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_LE_BG_V
VIEW - MSD_SR_ORG_LE_V
VIEW - MSD_SR_OU_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
PACKAGE BODY - MSD_CS_DFN_UTL
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 referenced by following:
APPS
PACKAGE BODY - MSD_COMPOSITE_GROUPING
[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 referenced by following:
APPS
PACKAGE BODY - MSD_VALIDATE_DEMAND_PLAN
[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
VIEW - GL_SETS_OF_BOOKS
VIEW - HR_ALL_ORGANIZATION_UNITS_VL
SYNONYM - HR_ORGANIZATION_INFORMATION
SYNONYM - MTL_PARAMETERS
APPS.MSD_ORGANIZATION_DEFINITIONS is referenced by following:
APPS
PACKAGE BODY - MSDWF
VIEW - MSD_SR_BG_ALL_V
VIEW - MSD_SR_LE_BG_V
VIEW - MSD_SR_ORG_LE_V
VIEW - MSD_SR_ORG_OU_V
VIEW - MSD_SR_OU_BG_V
VIEW - MSD_SR_OU_LE_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 referenced by following:
APPS
PACKAGE BODY - MSD_VALIDATE_DEMAND_PLAN
[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 referenced by following:
APPS
PACKAGE BODY - MSD_COMPOSITE_GROUPING
[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
SYNONYM - 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
VIEW - MSD_ORGANIZATION_DEFINITIONS
PACKAGE - MSD_SR_UTIL
PUBLIC
SYNONYM - DUAL
- 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
SYNONYM - 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 referenced by following:
APPS
VIEW - MSD_SR_GRP4_ALL_V
[top of page]
View: MSD_SR_GRP4_ALL_V
[top of page]
APPS.MSD_SR_GRP4_ALL_V references the following:
APPS
VIEW - MSD_SR_GRP3_GRP4_V
PACKAGE - MSD_SR_UTIL
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
VIEW - MSD_LEGAL_ENTITIES_V
VIEW - MSD_ORGANIZATION_DEFINITIONS
PACKAGE - MSD_SR_UTIL
PUBLIC
SYNONYM - DUAL
- DUAL
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_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
VIEW - MSD_ORGANIZATION_DEFINITIONS
PACKAGE - MSD_SR_UTIL
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
VIEW - MSD_LEGAL_ENTITIES_V
VIEW - MSD_ORGANIZATION_DEFINITIONS
PACKAGE - MSD_SR_UTIL
PUBLIC
SYNONYM - DUAL
- 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
VIEW - QP_LIST_HEADERS_VL
SYNONYM - QP_LIST_LINES
VIEW - QP_PRICE_REQ_SOURCES_V
SYNONYM - QP_PRICING_ATTRIBUTES
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
SYNONYM - SO_LOOKUPS
PUBLIC
SYNONYM - DUAL
- DUAL
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
SYNONYM - 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]