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: MSD.MSD_DP_PARAMETERS#

Object Details

Object Name:	MSD_DP_PARAMETERS#
Object Type:	VIEW
Owner:	MSD
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
DEMAND_PLAN_ID	NUMBER		Yes
PARAMETER_ID	NUMBER		Yes
PARAMETER_TYPE	VARCHAR2	(30)	Yes
PARAMETER_NAME	VARCHAR2	(320)
START_DATE	DATE
END_DATE	DATE
OUTPUT_SCENARIO_ID	NUMBER
INPUT_SCENARIO_ID	NUMBER
INPUT_DEMAND_PLAN_ID	NUMBER
FORECAST_DATE_USED	VARCHAR2	(30)
FORECAST_BASED_ON	VARCHAR2	(30)
QUANTITY_USED	VARCHAR2	(30)
AMOUNT_USED	VARCHAR2	(30)
FORECAST_USED	VARCHAR2	(1)
PERIOD_TYPE	VARCHAR2	(1)
FACT_TYPE	VARCHAR2	(1)
VIEW_NAME	VARCHAR2	(240)
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
LAST_UPDATE_LOGIN	NUMBER
REQUEST_ID	NUMBER
PROGRAM_APPLICATION_ID	NUMBER
PROGRAM_ID	NUMBER
PROGRAM_UPDATE_DATE	DATE
REVISION	VARCHAR2	(40)
ALLO_AGG_BASIS_STREAM_ID	NUMBER	(15)
NUMBER_OF_PERIOD	NUMBER	(15)
EXCLUDE_FROM_ROLLING_CYCLE	VARCHAR2	(30)
SCN_BUILD_REFRESH_NUM	NUMBER	(15)
ROUNDING_FLAG	VARCHAR2	(30)
DELETEABLE_FLAG	VARCHAR2	(15)
ENABLE_NONSEED_FLAG	VARCHAR2	(15)
CAPACITY_USAGE_RATIO	VARCHAR2	(80)
SUPPLY_PLAN_FLAG	VARCHAR2	(15)
PRICE_LIST_NAME	VARCHAR2	(240)
ASCP_STREAM_FLAG	VARCHAR2	(30)
EQUATION	VARCHAR2	(2000)
STREAM_TYPE	VARCHAR2	(30)
CALCULATED_ORDER	NUMBER
POST_CALCULATION	VARCHAR2	(1000)
ARCHIVED_FOR_PARAMETER	VARCHAR2	(300)
DEPENDENT_DEMAND_DESC	VARCHAR2	(240)
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

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
,      ZD_EDITION_NAME
FROM MSD.MSD_DP_PARAMETERS#;

Dependencies

[top of page]

MSD.MSD_DP_PARAMETERS# references the following:

MSD: MSD_DP_PARAMETERS

MSD.MSD_DP_PARAMETERS# is referenced by following:

APPS: MSD_DP_PARAMETERS; MSD_DP_PARAMETERS+