[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MSD_INPUT_SCENARIO_DS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Line of Business View for Input Scenario Stream. Used when Scope Tab of Demand Plan
Definition is used.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| DEMAND_PLAN_ID | NUMBER | Yes | Demand Plan Id | |
| STRIPE_DEMAND_PLAN_ID | NUMBER | Id for the Demand Plan that uses this Scenario in its Stripe | ||
| SCENARIO_ID | NUMBER | Yes | Scenario Id | |
| REVISION | VARCHAR2 | (40) | Yes | Revision |
| ORGANIZATION_LVL_PK | NUMBER | Yes | Organization Level Value Primary Key | |
| PRODUCT_LVL_PK | NUMBER | Product Level Value Primary Key | ||
| CUSTOMER_LVL_PK | NUMBER | Customer Level Value Primary Key | ||
| SALESCHANNEL_LVL_PK | NUMBER | Yes | Sales Channel Level Value Primary Key | |
| SALES_REP_LVL_PK | NUMBER | Yes | Sales Representative Primary Key | |
| GEOGRAPHY_LVL_PK | NUMBER | Yes | Geography Level Value Primary Key | |
| USER_DEFINED1_LVL_PK | NUMBER | Yes | User Defined 1 Level Value Primary Key | |
| USER_DEFINED2_LVL_PK | NUMBER | Yes | User Defined 2 Level Value Primary Key | |
| DEMAND_CLASS_LVL_PK | NUMBER | Yes | Demand Class Level Value Primary Key | |
| TIME_LVL_VAL_TO | DATE | Yes | Time Level Value To | |
| ORGANIZATION_LVL_ID | NUMBER | Organization Level Id | ||
| PRODUCT_LVL_ID | NUMBER | Product Level Id | ||
| CUSTOMER_LVL_ID | NUMBER | Customer Level Id | ||
| SALESCHANNEL_LVL_ID | NUMBER | Sales Channel Level Id | ||
| SALES_REP_LVL_ID | NUMBER | Sales Representative Level Id | ||
| GEOGRAPHY_LVL_ID | NUMBER | Geography Level Id | ||
| USER_DEFINED1_LVL_ID | NUMBER | User Defined 1 Level Id | ||
| USER_DEFINED2_LVL_ID | NUMBER | User Defined 2 Level Id | ||
| DEMAND_CLASS_LVL_ID | NUMBER | Demand Class Level Id | ||
| TIME_LVL_ID | NUMBER | Time Level Id | ||
| QUANTITY | NUMBER | Quantity | ||
| AMOUNT | NUMBER | Amount |
Cut, paste (and edit) the following text to query this object:
SELECT DEMAND_PLAN_ID
, STRIPE_DEMAND_PLAN_ID
, SCENARIO_ID
, REVISION
, ORGANIZATION_LVL_PK
, PRODUCT_LVL_PK
, CUSTOMER_LVL_PK
, SALESCHANNEL_LVL_PK
, SALES_REP_LVL_PK
, GEOGRAPHY_LVL_PK
, USER_DEFINED1_LVL_PK
, USER_DEFINED2_LVL_PK
, DEMAND_CLASS_LVL_PK
, TIME_LVL_VAL_TO
, ORGANIZATION_LVL_ID
, PRODUCT_LVL_ID
, CUSTOMER_LVL_ID
, SALESCHANNEL_LVL_ID
, SALES_REP_LVL_ID
, GEOGRAPHY_LVL_ID
, USER_DEFINED1_LVL_ID
, USER_DEFINED2_LVL_ID
, DEMAND_CLASS_LVL_ID
, TIME_LVL_ID
, QUANTITY
, AMOUNT
FROM APPS.MSD_INPUT_SCENARIO_DS_V;
APPS
MSD_DP_SCENARIO_ENTRIES
MSD_DP_SESSION
MSD_LEVEL_VALUES_DS
APPS.MSD_INPUT_SCENARIO_DS_V is not referenced by any database object
|
|
|
|