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.

[Home] [Help]

View: MSD_DP_OUTPUT_PRS_V

Product:	MSD - Demand Planning
Description:	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 required for the output parameters for a demand plan. For the description of the columns of this API, p
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT DEMAND_PLAN_ID
, DEMAND_PLAN_NAME
, NULL
, NULL
, NULL
, NULL
, HISTORY_START_DATE
, HISTORY_END_DATE
, SCENARIO_ID
, SCENARIO_NAME
, OUTPUT_PERIOD_TYPE_ID
, OUTPUT_PERIOD_TYPE
, HORIZON_START_DATE
, HORIZON_END_DATE
, FORECAST_DATE_USED_ID
, FORECAST_DATE_USED
, FORECAST_BASED_ON_ID
, FORECAST_BASED_ON
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM MSD_DP_SCENARIOS_V

Columns

Name
DEMAND_PLAN_ID
DEMAND_PLAN_NAME
PARAMETER_ID
PARAMETER_NAME
PARAMETER_TYPE_ID
PARAMETER_TYPE
START_DATE
END_DATE
OUTPUT_SCENARIO_ID
OUTPUT_SCENARIO_NAME
OUTPUT_SCN_OUTPUT_PERIOD_ID
OUTPUT_SCN_OUTPUT_PERIOD_TYPE
OUTPUT_SCN_HORIZON_START_DATE
OUTPUT_SCN_HORIZON_END_DATE
FORECAST_DATE_USED_ID
FORECAST_DATE_USED
FORECAST_BASED_ON_ID
FORECAST_BASED_ON
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE