MSD Views (138)
MSD - Demand Planning — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| View | Description |
|---|---|
MSD_ASCP_PLANS_HEADER_V |
View to display ASCP Plan information |
MSD_AUDIT_SQL_STATEMENTS_V |
This view is used by the MSDAUDIT form for validation rules. |
MSD_BACKLOG_CS_V |
This view is used by express to download custom data stream |
MSD_BOM_COMPONENTS_V |
This view provides Planning BOMs and its attributes information for demand planning |
MSD_BOOKING_DATA_CS_V |
This view provides Booking Data to Express Upload process. Implemented with Custom Data Stream Module. |
MSD_BOOKING_DATA_ORIG_CS_V |
This view to support product substitution in booking data |
MSD_BOOKING_DATA_V |
This view provides the Booking Data in the planning server and is not restricted by a demand plan. If the Planning Server is used for only o |
MSD_CATEGORY_SETS_V |
This view for Demand Planning Category Sets |
MSD_CONSTRAINED_FORECAST_V |
Constrained Plan View |
MSD_CS_CLMN_DIM_DTLS_V |
This view is provides Data Stream's Dimension-Column specific details. |
MSD_CS_CLMN_IDENTIFIERS_VL |
This view for Custom Stream Column identifiers |
MSD_CS_DATA_HEADERS_V |
This view to display Custom Stream names |
MSD_CS_DATA_HEADERS_V1 |
This view used for accessing custom stream data |
MSD_CS_DATA_V |
This view is used by express to download custom data stream |
MSD_CS_DATA_V1 |
This view is for Audit report |
MSD_CS_DEFINITIONS_V1 |
This view provides Data Stream Definition and it's dimension properties. |
MSD_CS_DEFINITIONS_VL |
This view provides Data Stream Definition. It is used in "Define Data Stream UI". |
MSD_CS_DEFN_COLUMN_DTLS_V |
This view provides Data Stream's Column Details. |
MSD_CS_DEFN_DIM_DTLS_V |
This view provides Data Stream's Dimension Details. |
MSD_CS_PLANNING_BOOKING_V |
Standalone Patch for QA115 |
MSD_CURRENCY_CONVERSIONS_V |
This view specifies the Conversion Rate between two currencies. The fact table underlying this would be populated with the currency conversi |
MSD_CUST_ORDER_FCST_CS_V |
This view is used by express to download data which is received from SCE to DP |
MSD_CUST_SALES_FCST_CS_V |
This view is used by express to download data which is received from SCE to DP |
MSD_DELETED_LEVEL_VALUES_V |
This view specifies the deleted Level Value Associations for a level with its parent level value in a hierarchy along with the system genera |
MSD_DEMAND_PLANS_V |
This view provides the Demand Plan Definitions and its Express Setup Information. |
MSD_DP_ASCP_SCENARIOS_V |
This view provides the integration api with ASCP for Scenarios |
MSD_DP_ASCP_SCN_ENTRIES_V |
This view provides the integration api with ASCP for scenario entries |
MSD_DP_CALENDARS_V |
This view to display Demand Planning Calendars |
MSD_DP_DEFAULT_SCENARIO_V |
This view provides scenarios for ASCP unconstrained Plan |
MSD_DP_DIMENSIONS_V |
This view stores the associations between the Demand Plans User Defined Dimensions and the Real Dimensions. |
MSD_DP_EVENTS_V |
This view to display Demand Planning Events |
MSD_DP_HIERARCHIES_V |
This view stores the Demand Plan Hierarchies Association. |
MSD_DP_HIERS_HLP_V |
This view associates the demand plan to its dimensions. This is used for Demand Plan forms. The usage of this view for anyother purpose is d |
MSD_DP_INPUT_PRS_V |
This view specifies the Input Parameters for a demand plan. This is a subset of the MSD_DP_PARAMETERS_V. This view has only the columns requ |
MSD_DP_OUTPUT_PRS_V |
This view specifies the Output Parameters for a demand plan. This is a subset of the MSD_DP_PARAMETERS_V. This view has only the columns req |
MSD_DP_PARAMETERS_CS_V |
this view provied Demand Plans Input Parameters. |
MSD_DP_PARAMETERS_V |
This view 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 |
MSD_DP_PLANNING_PERCENTAGES_V |
Demand Plan Planning Percentages |
MSD_DP_PRICE_LISTS_V |
This view to display price list information |
MSD_DP_SCENARIOS_CS_V |
This table provides the Scenarios to be generated from a particular Demand Plan. |
MSD_DP_SCENARIOS_V |
This table provides the Scenarios to be generated from a particular Demand Plan. |
MSD_DP_SCENARIO_ALL_EVENTS_V |
This view provides all the Events - i.e., Promotion, Cannibalization, Product Phase Out, New Product Introduction, and Miscellaneous Events |
MSD_DP_SCENARIO_EVENTS_V |
This view provides all the Events except for New Product Introduction Event - i.e., Promotion, Cannibalization, Product Phase Out, and Misc |
MSD_DP_SCENARIO_INTROS_V |
|
MSD_DP_SCE_SCENARIOS_V |
This view provides the integration api with ASCP for Scenarios |
MSD_DP_SCE_SCN_ENTRIES_V |
This view provides the integration api with ASCP for scenario entries |
MSD_DP_SCN_INTRO_EVENTS_V |
|
MSD_DP_SCN_LOV_V |
This view to display DP scenarios |
MSD_DP_SCN_OUTPUT_LEVELS_V |
This view provides the Levels at which the output Scenario for a demand plan is to be generated. This stores the level values for all the di |
MSD_DP_SCN_REVISIONS_V |
This view to show scenario revisions |
MSD_DP_USERS_V |
This view Specifies the various Users who have access to the Demand Plan. |
MSD_EVENTS_V |
This API defines the types of Events and is the header to the MSD_EVENT_PRODUCTS_V API. This is based on top of the MSD_EVENTS table. |
MSD_EVENT_DETAILS_V |
|
MSD_EVENT_PRODUCTS_V |
This API is a child to the MSD_EVENTS_V API. This API holds information about all the products for which the promotion is run and the star |
MSD_EVENT_PRODUCTS_V1 |
This API is a child to the MSD_EVENTS_V API. This API holds information about all the products for which the promotion is run and the star |
MSD_EVT_PRODUCT_DETAILS_V |
This API is a child to the MSD_EVENTS_PRODUCTS_V API. This API holds time frame for which this product promotion is run and the correspondi |
MSD_EVT_PRODUCT_DETAILS_V1 |
This API is a child to the MSD_EVENTS_PRODUCTS_V API. This API holds time frame for which this product promotion is run and the correspondi |
MSD_HIERARCHIES_V |
This view provides the Hierachies, their corresponding State (Valid or Not) and the Dimension to which it belongs. |
MSD_HIERARCHY_LEVELS_V |
This view provides the Level Associations within a Hierarchy in the Real Dimension realm. |
MSD_INTRODUCTION_PLANS_V |
|
MSD_INTRO_EVENTS_V |
|
MSD_ITEM_LIST_PRICE_V |
|
MSD_ITEM_MASTER_V |
This view exposes item specific properties - forecast type, base uom, average discount, list price - to the demand planning engine. |
MSD_LEGAL_ENTITIES_V |
This view will provide legal entities information for Demand Planning |
MSD_LEVELS_V |
This view provides the Levels, their Owning Dimension. It also specifies the Level Type. |
MSD_LEVEL_ASSOCIATIONS_V1 |
This view specifies the Level Value Associations for a level with its parent level value in a hierarchy along with the system generated prim |
MSD_LEVEL_VALUES_SR_V |
This view exposes source primary keys for level values to DPE |
MSD_LEVEL_VALUES_V |
This view specifies the Level Value Associations for a level with its parent level value in a hierarchy along with the system generated prim |
MSD_LEVEL_VALUES_V1 |
This view specifies the Level Values along with the system generated primary keys for these level values. This view is used only for the Le |
MSD_MFG_FCST_CS_V |
This view specifies the Manufacturing Forecast. This is not stripped by the demand plan id. It has a forecast designator that could be used |
MSD_MFG_FCST_V |
This view specifies the Manufacturing Forecast. This is not stripped by the demand plan id. It has a forecast designator that could be used |
MSD_NPI_CANNED_PRODUCTS_V |
This API holds information about Cannibalized products. |
MSD_NPI_RELATED_PRODUCTS_V |
This API holds information on New Product Introduction Related Products. |
MSD_NPI_RELATED_PRODUCTS_V1 |
This API holds information on New Product Introduction Related Products. Used by the Events Form. |
MSD_NPI_RELATED_PROD_DETAILS_V |
This API holds DETAILS information for New Product Introductions. |
MSD_NPI_RELATED_PROD_DTLS_V1 |
This API holds DETAILS information for New Product Introductions. Used by the Events Form. |
MSD_OBJECTS_V |
This view to show all MSD Objects |
MSD_OPPORTUNITY_DATA_CS_V |
This view Specifies the Opportunity History. This view is based on Flexible data stream entity MSD_CS_DATA. |
MSD_OPPORTUNITY_DATA_V |
This view Specifies the Opportunity History. This is not stripped by demand plan id. The user can write a custom view to actually restrict t |
MSD_ORGANIZATION_DEFINITIONS |
This view show organization definitions |
MSD_ORG_CALENDAR_CS_V |
Working Day Allocation Stream Planning Server View |
MSD_PRICE_LIST_V |
This view to show price list information |
MSD_SALES_FCST_BESTCASE_CS_V |
This view is used by express to download data which is received from CRM Sales Online best case amount and releated dimensions data to DP |
MSD_SALES_FCST_PIPELINE_CS_V |
This view is used by express to download data which is received from CRM Sales Online pipeline amount and releated dimensions data to DP |
MSD_SALES_FCST_REALISTIC_CS_V |
This view is used by express to download data which is received from CRM Sales Online propable case amount and releated dimensions data to D |
MSD_SALES_FCST_V |
|
MSD_SALES_FCST_WGTPLINE_CS_V |
This view is used by express to download data which is received from CRM Sales Online weighted pipeline amount and releated dimensions data |
MSD_SALES_FCST_WORSTCASE_CS_V |
This view is used by express to download data which is received from CRM Sales Online worst case amount and releated dimensions data to DP |
MSD_SCN_ENTRY_COMMENTS_V |
This view to display Scenario Entries comments |
MSD_SHIPMENT_DATA_CS_V |
This view provides the shipment Data in the planning server and is not restricted by a demand plan. If the Planning Server is used for only |
MSD_SHIPMENT_DATA_ORIG_CS_V |
This view to support product substitution in shipment data |
MSD_SHIPMENT_DATA_V |
This view provides the shipment Data in the planning server and is not restricted by a demand plan. If the Planning Server is used for only |
MSD_SR_AREA_ALL_V |
This is the Source View that associates the Area level to Top level in the Geography Dimension. This view would be applied to an Oracle Appl |
MSD_SR_BACKLOG_V |
This is the Source View for Booking Data. This view would be applied to an Oracle Applications 11i instance from which the Backlog informat |
MSD_SR_BG_ALL_V |
This is the Source View that associates the Business Group level to Top level in the Organization Dimension. This view would be applied to |
MSD_SR_BOOKING_DATA_V |
This is the Source View for Booking Data. This view would be applied to an Oracle Applications 11i instance from which the Booking informati |
MSD_SR_CAT_ALL_V |
This is the Source View that associates the Product Category level to Top level in the Product Dimension. This view would be applied to an |
MSD_SR_CLASS_ALL_V |
This is the Source View that associates the Customer Class level to Top level in the Geography Dimension. This view would be applied to an O |
MSD_SR_COUNTRY_AREA_V |
This is the Source View that associates the Country level to Area level in the Geography Dimension. This view would be applied to an Oracle |
MSD_SR_CURRENCY_CONVERSIONS_V |
This is the Source View for Currency Conversions. This view would be applied to an Oracle Applications 11i instance from which the Currency |
MSD_SR_CUS_CLASS_V |
This is the Source View that associates the Customer level to Customer Class level in the Geography Dimension. This view would be applied to |
MSD_SR_CUS_GROUP_V |
This is the Source View that associates the Customer level to Customer Group level in the Geography Dimension. This view would be applied to |
MSD_SR_FISCAL_TIME_V |
This is the Source View for Fiscal Calendar. This view would be applied to an Oracle Applications 11i instance from which the Fiscal Calenda |
MSD_SR_GROUP_ALL_V |
This is the Source View that associates the Customer Group level to Top level in the Geography Dimension. This view would be applied to an |
MSD_SR_GRP1_GRP2_V |
This is the Source View that associates the First level Sales Group to Second level Sales Group in the Sales Representative Dimension. This |
MSD_SR_GRP2_GRP3_V |
This is the Source View that associates the Second level Sales Group to Third level Sales Group in the Sales Representative Dimension. This |
MSD_SR_GRP3_GRP4_V |
This is the Source View that associates theThird level Sales Group to Fourth level Sales Group in the Sales Representative Dimension. This v |
MSD_SR_GRP4_ALL_V |
This is the Source View that associates the Fourth level Sales Group to Top level in the Sales Representative Dimension. This view would be |
MSD_SR_ITEM_LIST_PRICE_V |
This is the Source View for Item List Price. This view would be applied to an Oracle Applications 11i instance from which the Item List Pric |
MSD_SR_IT_ALL_V |
This is the Source View that associates the Interest Type level to Top level in the Product Dimension. This view would be applied to an Ora |
MSD_SR_LE_BG_V |
This is the Source View that associates the Legal Entity level to Business Group level in the Organization Dimension. This view would be ap |
MSD_SR_LOC_CUS_V |
This is the Source View that associates the Location level to Customer level in the Geography Dimension. This view would be applied to an Or |
MSD_SR_LOC_REG_V |
This is the Source View that associates the Location level to Region level in the Geography Dimension. This view would be applied to an Orac |
MSD_SR_MFG_FCST_V |
This is the Source View for Manufacturing Forecast. This view would be applied to an Oracle Applications 11i instance from which the Manufac |
MSD_SR_MFG_TIME_V |
This is the Source View for Manufacturing Calendar. This view would be applied to an Oracle Applications 11i instance from which the Manufac |
MSD_SR_MGR1_MGR2_V |
This is the Source View that associates the First level Sales Manager to Second level Sales Manager in the Sales Representative Dimension. T |
MSD_SR_MGR2_MGR3_V |
This is the Source View that associates the Second level Sales Manager to Third level Sales Manager in the Sales Representative Dimension. T |
MSD_SR_MGR3_MGR4_V |
This is the Source View that associates the Third level Sales Manager to Fourth level Sales Manager in the Sales Representative Dimension. T |
MSD_SR_MGR4_ALL_V |
This is the Source View that associates the Fourth level Sales Manager to Top Level in the Sales Representative Dimension. This view would b |
MSD_SR_OPPORTUNITY_V |
This is the Source View for Sales Opportunity. This view would be applied to an Oracle Applications 11i instance from which the Sales Opport |
MSD_SR_ORG_OU_V |
This is the Source View that associates the Organization level to Operating Unit level in the Organization Dimension. This view would be app |
MSD_SR_OU_LE_V |
This is the Source View that associates the Operating Unit level to Legal Entity level in the Organization Dimension. This view would be app |
MSD_SR_PF_ALL_V |
This is the Source View that associates the Product Family to Top level in the Product Dimension. This view would be applied to an Oracle Ap |
MSD_SR_PRD_CAT_V |
This is the Source View that associates the Product level to Product Category level in the Product Dimension. This view would be applied t |
MSD_SR_PRD_IT_V |
This is the Source View that associates the Product level to Interest Type level in the Product Dimension. This view would be applied to an |
MSD_SR_PRD_PF_V |
This is the Source View that associates the Product level to Product Family level in the Product Dimension. This view would be applied to a |
MSD_SR_PRICE_LIST_V |
This source view gathers the price list information defined. |
MSD_SR_REG_COUNTRY_V |
This is the Source View that associates the Region level to Country level in the Geography Dimension. This view would be applied to an Orac |
MSD_SR_REP_GRP1_V |
This is the Source View that associates the Sales Representative Level to First level Sales Group in the Sales Representative Dimension. Thi |
MSD_SR_REP_MGR1_V |
This is the Source View that associates the Sales Representative Level to First level Sales Manager in the Sales Representative Dimension. T |
MSD_SR_SALES_FCST_V |
This is the Source View for Sales Forecast. This view would be applied to an Oracle Applications 11i instance from which the Sales Forecast |
MSD_SR_SC_ALL_V |
This is the Source View that associates the Sales Channel level to the Top level in the Sales Channel Dimension. This view would be applied |
MSD_SR_SHIPMENT_DATA_V |
This is the Source View for Shipment. This view would be applied to an Oracle Applications 11i instance from which the Shipment information |
MSD_SR_UOM_CONVERSIONS_V |
This is the Source View for UOM Conversions. This view would be applied to an Oracle Applications 11i instance from which the UOM Conversion |
MSD_ST_CS_DATA_V |
This view provides data stream staged data. |
MSD_SUPPLY_PLANS_V |
Supply Plan View |
MSD_TIME_V |
This view gives the definition for the time hierarchies for all the time hierarchies - Gregorian, Manufacturing and fiscal hierarchies. |
MSD_UOM_CONVERSIONS_V |
This API specifies the Conversion Rate between two UOM's. |