Product: | MSD - Demand Planning |
---|---|
Description: | This view specifies the Input Parameters for a demand plan. This is a subset of the MSD_DP_PARAMETERS_V. This view has only the columns required for the input parameters for a demand plan. For the description of the columns of this API, ple |
Implementation/DBA Data: | Not implemented in this database |
SELECT MPRV.ROW_ID
, MPRV.DEMAND_PLAN_ID
, MPRV.DEMAND_PLAN_NAME
, MPRV.PARAMETER_ID
, MPRV.PARAMETER_NAME
, MPRV.PARAMETER_TYPE_ID
, MPRV.PARAMETER_TYPE
, MPRV.PERIOD_TYPE_ID
, MPRV.PERIOD_TYPE
, MPRV.START_DATE
, MPRV.END_DATE
, MPRV.INPUT_SCENARIO_ID
, MPRV.INPUT_SCENARIO_NAME
, MPRV.INPUT_DEMAND_PLAN_ID
, MPRV.INPUT_DEMAND_PLAN_NAME
, MPRV.FORECAST_DATE_USED_ID
, MPRV.FORECAST_DATE_USED
, MPRV.QUANTITY_USED_ID
, MPRV.QUANTITY_USED
, MPRV.AMOUNT_USED_ID
, MPRV.AMOUNT_USED
, MPRV.FORECAST_USED_ID
, MPRV.FORECAST_USED
, MPRV.FACT_TYPE_ID
, MPRV.FACT_TYPE
, MPRV.VIEW_NAME
, MPRV.LAST_UPDATE_DATE
, MPRV.LAST_UPDATED_BY
, MPRV.CREATION_DATE
, MPRV.CREATED_BY
, MPRV.LAST_UPDATE_LOGIN
, MPRV.REQUEST_ID
, MPRV.PROGRAM_APPLICATION_ID
, MPRV.PROGRAM_ID
, MPRV.PROGRAM_UPDATE_DATE
FROM MSD_DP_PARAMETERS_V MPRV
WHERE MPRV.PARAMETER_TYPE_ID IN ('1'
, '2'
, '3'
, '4'
, '5'
, '6')