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]

VIEW: APPS.MSD_DP_PARAMETERS_CS_V

Object Details

Object Name:	MSD_DP_PARAMETERS_CS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MSD.MSD_DP_PARAMETERS_CS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

this view provied Demand Plans Input Parameters.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Unique Row ID.
DEMAND_PLAN_ID	NUMBER		Yes	Demand Plan Id.
DEMAND_PLAN_NAME	VARCHAR2	(30)	Yes	Demand Plan Name.
PARAMETER_ID	NUMBER		Yes	Primary Key.
PARAMETER_NAME	VARCHAR2	(320)		Parameter Name.
PARAMETER_TYPE_ID	VARCHAR2	(30)	Yes	Parameter Type ID. This identifies the type Input Parameter.
PARAMETER_TYPE	VARCHAR2	(252)		Parameter Type Description.
START_DATE	DATE			The Start Date from which the Input Data is read.
END_DATE	DATE			The End Date from which the Input Data is read.
INPUT_SCENARIO_ID	NUMBER			The Input Scenario ID that is to be used for Parameter Type of "Input Scenario".
INPUT_SCENARIO_NAME	VARCHAR2	(45)		Input Scenario Name.
INPUT_DEMAND_PLAN_ID	NUMBER			Input Scenario Demand Plan ID.
INPUT_DEMAND_PLAN_NAME	VARCHAR2	(30)		Input Demand Plan Name.
FORECAST_DATE_USED_ID	VARCHAR2	(30)		The date column used for generating the forecast.
FORECAST_DATE_USED	VARCHAR2	(100)		Forecast Date Used Description.
DATE_PLANNING_VIEW_CLMN	VARCHAR2	(4000)		The column name that the Planning Server uses to store Date info.
QUANTITY_USED_ID	VARCHAR2	(30)		Column Identifier of type Quantity
QUANTITY_USED	VARCHAR2	(100)		How to Measure Quantity.
QUANTITY_PLANNING_VIEW_CLMN	VARCHAR2	(4000)		The column name that the Planning Server uses to store Quantity info.
AMOUNT_USED_ID	VARCHAR2	(30)		Column Identifier of type Amount
AMOUNT_USED	VARCHAR2	(100)		How to Measure Amount.
AMOUNT_PLANNING_VIEW_CLMN	VARCHAR2	(4000)		The column name that the Planning Server uses to store Amount info.
FORECAST_USED_ID	VARCHAR2	(1)		Forecast Used ID.
FORECAST_USED	VARCHAR2	(80)		Forecast Used.
FACT_TYPE_ID	VARCHAR2	(1)		Forecast Type ID
FACT_TYPE	VARCHAR2	(80)		Forecast Type
REVISION	VARCHAR2	(40)		Revision
VIEW_NAME	VARCHAR2	(240)		View Name
ALLO_AGG_BASIS_STREAM_ID	NUMBER	(15)		How Allocation/Aggregation will be based.
NUMBER_OF_PERIOD	NUMBER	(15)		Number of Periods
CS_DEFINITION_ID	NUMBER	(15)	Yes	Which Custom Stream Definition used.
MULTIPLE_STREAM_FLAG	VARCHAR2	(30)		Does this Custom Stream contain subsets
MEASUREMENT_TYPE	VARCHAR2	(30)		How measures this Custom Stream
SYSTEM_FLAG	VARCHAR2	(30)	Yes	flag for internal or custom defined stream.
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			Concurrent Who Column
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Who Column
PROGRAM_ID	NUMBER			Concurrent Who Column
PROGRAM_UPDATE_DATE	DATE			Concurrent Who Column
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
CS_CLASSIFICATION	VARCHAR2	(30)	Yes	Custom Stream Classification
STRICT_FLAG	VARCHAR2	(30)	Yes	Strict Flag
AGGREGATION_ALLOWED_FLAG	VARCHAR2	(30)		Aggregation Allowed Flag
ALLOCATION_ALLOWED_FLAG	VARCHAR2	(30)		Allocation Allowed Flag
STREAM_EDITABLE_FLAG	VARCHAR2	(30)		Stream Editable Flag
PLANNING_SERVER_VIEW_NAME	VARCHAR2	(30)		Planning Server View
CS_TYPE	VARCHAR2	(30)	Yes	Custom Stream Type
LOWEST_LEVEL_FLAG	VARCHAR2	(30)		Lowest Level Flag
COMPOSITE_GROUP_CODE	NUMBER			Composite Group Code
DEPENDENT_DATA_FLAG	VARCHAR2	(30)		Dependent Data Flag
DEPENDENT_DEMAND_CODE	VARCHAR2	(30)		Dependent Demand Code
CAPACITY_USAGE_RATIO	VARCHAR2	(80)		Identifies the Designator to be used by DPE to identiy the Capacity Usage Object
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
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
STREAM_TYPE	VARCHAR2	(30)		Specifies the type of the stream. Possible values - NULL, CALCULATED, ARCHIVED, ARCHIVED_WO_TIM
EQUATION	VARCHAR2	(2000)		Equation for calculated type of streams in EOL
POST_CALCULATION	VARCHAR2	(1000)		List of calculated streams to be recalcuated when this stream is recalculated
CALCULATED_ORDER	NUMBER			Calculation order for calculated type of streams
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 ROW_ID
,      DEMAND_PLAN_ID
,      DEMAND_PLAN_NAME
,      PARAMETER_ID
,      PARAMETER_NAME
,      PARAMETER_TYPE_ID
,      PARAMETER_TYPE
,      START_DATE
,      END_DATE
,      INPUT_SCENARIO_ID
,      INPUT_SCENARIO_NAME
,      INPUT_DEMAND_PLAN_ID
,      INPUT_DEMAND_PLAN_NAME
,      FORECAST_DATE_USED_ID
,      FORECAST_DATE_USED
,      DATE_PLANNING_VIEW_CLMN
,      QUANTITY_USED_ID
,      QUANTITY_USED
,      QUANTITY_PLANNING_VIEW_CLMN
,      AMOUNT_USED_ID
,      AMOUNT_USED
,      AMOUNT_PLANNING_VIEW_CLMN
,      FORECAST_USED_ID
,      FORECAST_USED
,      FACT_TYPE_ID
,      FACT_TYPE
,      REVISION
,      VIEW_NAME
,      ALLO_AGG_BASIS_STREAM_ID
,      NUMBER_OF_PERIOD
,      CS_DEFINITION_ID
,      MULTIPLE_STREAM_FLAG
,      MEASUREMENT_TYPE
,      SYSTEM_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      EXCLUDE_FROM_ROLLING_CYCLE
,      SCN_BUILD_REFRESH_NUM
,      ROUNDING_FLAG
,      CS_CLASSIFICATION
,      STRICT_FLAG
,      AGGREGATION_ALLOWED_FLAG
,      ALLOCATION_ALLOWED_FLAG
,      STREAM_EDITABLE_FLAG
,      PLANNING_SERVER_VIEW_NAME
,      CS_TYPE
,      LOWEST_LEVEL_FLAG
,      COMPOSITE_GROUP_CODE
,      DEPENDENT_DATA_FLAG
,      DEPENDENT_DEMAND_CODE
,      CAPACITY_USAGE_RATIO
,      DELETEABLE_FLAG
,      ENABLE_NONSEED_FLAG
,      SUPPLY_PLAN_FLAG
,      PRICE_LIST_NAME
,      ASCP_STREAM_FLAG
,      STREAM_TYPE
,      EQUATION
,      POST_CALCULATION
,      CALCULATED_ORDER
,      DEPENDENT_DEMAND_DESC
FROM APPS.MSD_DP_PARAMETERS_CS_V;

Dependencies

[top of page]

APPS.MSD_DP_PARAMETERS_CS_V references the following:

APPS: FND_LOOKUP_VALUES_VL; MSD_CS_CLMN_IDENTIFIERS_VL; MSD_CS_DEFINITIONS_VL; MSD_CS_DFN_UTL - show dependent code; MSD_DEMAND_PLANS; MSD_DP_PARAMETERS; MSD_DP_SCENARIOS

APPS.MSD_DP_PARAMETERS_CS_V is referenced by following:

APPS: MSD_LIABILITY - show dependent code; MSD_VALIDATE_DEMAND_PLAN - show dependent code