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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: MSD.MSD_DP_PARAMETERS

Object Details

Object Name:	MSD_DP_PARAMETERS
Object Type:	TABLE
Owner:	MSD
FND Design Data:	MSD.MSD_DP_PARAMETERS
Subobject Name:
Status:	VALID

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 create the scenarios that are to be download the information into PS.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSD_DP_PARAMETERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PARAMETER_ID
MSD_DP_PARAMETERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DEMAND_PLAN_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DEMAND_PLAN_ID	NUMBER		Yes	Demand Plan Unique ID. This is part of the primary key.
PARAMETER_ID	NUMBER		Yes	Parameter Unique ID. This is generated out of MSD_DP_PARAMETERS_S sequence. This is part of the Primary Key.
PARAMETER_TYPE	VARCHAR2	(30)	Yes	Paramater Type. This is based on MSD_DATA_ELEMENT lookup, the possible values are : 1. Booking History, 2. Shipment History, 3. Opportunity History, 4. Input Scenario, 5. Input Manufacturing Forecast, 6. Input Sales Forecast, 7. Output Scenario, and 8. Supply Plan.
PARAMETER_NAME	VARCHAR2	(320)		Parameter Name. This field is required for Input or Output Scenario, Manufacturing Forecast, or Sales Forecast.
START_DATE	DATE			The Start Date from which the Input Data is to be read. For output Parameter it is the actual Data from which the forecast is to be generated, usually this value will be defaulted from the Horizon_Start_Date of the Scenario that is to be generated. If this null, then we would use the Horizon_Start_Date defined for the scenarios in the MSD_SCENARIOS.
END_DATE	DATE			The End Date till which the Input Data is to be read. If this is null, we will read it till the end of the history. For Output Parameters this is the date till which the Output Parameter is to bedate till which the Output Parameter is to be generated. If this null the forecast will be generated till the Horizon_End_Date specified in thetill the Horizon_End_Date specified in the MSD_SCENARIOS.
OUTPUT_SCENARIO_ID	NUMBER			The Output Scenario that is to be generated. This is a FK to MSD_SCENARIOS for the same demand plan.
INPUT_SCENARIO_ID	NUMBER			The Input Scenario ID that is to be used, if the Input Parameter Type is 4 - Input Scenario ID.
INPUT_DEMAND_PLAN_ID	NUMBER			The Input Demand Plan ID that is to be used, if the parameter type id is 4 - Input Scenario.
FORECAST_DATE_USED	VARCHAR2	(30)		The date used for generating the forecast. This is based on MSD_DATE_USED. The possible values are : 1. Booked Date, 2. Shipped Date, 3.Requested Date, 4.Scheduled Date, and 5.Promised Date.
FORECAST_BASED_ON	VARCHAR2	(30)		This is the data on which the forecast is generated. The possible values are : 1. Booking History, and 2. Shipment History.
QUANTITY_USED	VARCHAR2	(30)		This is the forecast quantity used for the Input Manufacturing Forecast. This is based on the MSD_MFG_FCST_QTY_USED lookup. The possible values are : 1. Original Quantity, and 2. Current Quantity.
AMOUNT_USED	VARCHAR2	(30)		This is the amount used in for input sales forecast. This is based on the MSD_SALES_FCST_AMOUNT_USED lookup. The possible values are : 1. Forecast Amount, 2.Upside Amount, and 3. Quota Amount.
FORECAST_USED	VARCHAR2	(1)		Forecast Used. This field is required for Input Scenarios. This based on the MSD_FORECAST_TYPE lookup. The possible values are : 1. Overridden Forecast, and 2. Baseline Forecast.
PERIOD_TYPE	VARCHAR2	(1)		This is the Level in the time dimension at which the Fact data is passed from the PS to the ODP for the Input Parameters.
FACT_TYPE	VARCHAR2	(1)		Fact Type. This is based on MSD_FACT_TYPE lookup. The possible values for this are : 1. Fully Recalculable, 2. Partially Recalculable, and 3. Chaotic. This is required for any Forecast that is passed in as input parameter, mainly for Manufacturing Forecast.
VIEW_NAME	VARCHAR2	(240)		This is the view name for the input parameters that is used to do the filtering on top of the history and forecast information stored in the fact section of Demand Planning Server.
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER		Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER			Standard who column
REQUEST_ID	NUMBER			Enhanced who column
PROGRAM_APPLICATION_ID	NUMBER			Enhanced who column
PROGRAM_ID	NUMBER			Enhanced who column
PROGRAM_UPDATE_DATE	DATE			Enhanced who column
REVISION	VARCHAR2	(40)		Revision of the scenario being brought-in
ALLO_AGG_BASIS_STREAM_ID	NUMBER	(15)		Input Parameter on that basis of which this stream will be Allocated/Aggregated.
NUMBER_OF_PERIOD	NUMBER	(15)		Number of Period.
EXCLUDE_FROM_ROLLING_CYCLE	VARCHAR2	(30)		This is the flag for parameter to exclude from rolling cycle.Possible values are 1 (Exclude) and 2 or Null (Include).
SCN_BUILD_REFRESH_NUM	NUMBER	(15)		Scenario Build Refresh Number
ROUNDING_FLAG	VARCHAR2	(30)		Rounding Flag
DELETEABLE_FLAG	VARCHAR2	(15)		Indicates whether the record is deleteable or not
ENABLE_NONSEED_FLAG	VARCHAR2	(15)		Indicates whether the fields for this record need to be disabled for non seeded records also
CAPACITY_USAGE_RATIO	VARCHAR2	(80)		Identifies the Designator to be used by DPE to identify the Capacity Usage Object
SUPPLY_PLAN_FLAG	VARCHAR2	(15)		Identifies whether the stream is ASCP plan specific or not.
PRICE_LIST_NAME	VARCHAR2	(240)		Name of the price list attached to the Input Parameter
ASCP_STREAM_FLAG	VARCHAR2	(30)		Specifies if this is an ASCP stream
EQUATION	VARCHAR2	(2000)		Equation for calculated type of streams in EOL
STREAM_TYPE	VARCHAR2	(30)		Specifies the type of the stream. Possible values - NULL, CALCULATED, ARCHIVED, ARCHIVED_WO_TIM
CALCULATED_ORDER	NUMBER			Calculation order for calculated type of streams
POST_CALCULATION	VARCHAR2	(1000)		List of calculated streams to be recalcuated when this stream is recalculated
ARCHIVED_FOR_PARAMETER	VARCHAR2	(300)		Base stream if this is a archived type of parameter
DEPENDENT_DEMAND_DESC	VARCHAR2	(240)		Description for Dependant demand. Added for EOL

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DEMAND_PLAN_ID
,      PARAMETER_ID
,      PARAMETER_TYPE
,      PARAMETER_NAME
,      START_DATE
,      END_DATE
,      OUTPUT_SCENARIO_ID
,      INPUT_SCENARIO_ID
,      INPUT_DEMAND_PLAN_ID
,      FORECAST_DATE_USED
,      FORECAST_BASED_ON
,      QUANTITY_USED
,      AMOUNT_USED
,      FORECAST_USED
,      PERIOD_TYPE
,      FACT_TYPE
,      VIEW_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REVISION
,      ALLO_AGG_BASIS_STREAM_ID
,      NUMBER_OF_PERIOD
,      EXCLUDE_FROM_ROLLING_CYCLE
,      SCN_BUILD_REFRESH_NUM
,      ROUNDING_FLAG
,      DELETEABLE_FLAG
,      ENABLE_NONSEED_FLAG
,      CAPACITY_USAGE_RATIO
,      SUPPLY_PLAN_FLAG
,      PRICE_LIST_NAME
,      ASCP_STREAM_FLAG
,      EQUATION
,      STREAM_TYPE
,      CALCULATED_ORDER
,      POST_CALCULATION
,      ARCHIVED_FOR_PARAMETER
,      DEPENDENT_DEMAND_DESC
FROM MSD.MSD_DP_PARAMETERS;

Dependencies

[top of page]

MSD.MSD_DP_PARAMETERS does not reference any database object

MSD.MSD_DP_PARAMETERS is referenced by following:

APPS: MSD_DP_PARAMETERS