View: MSD_DP_PARAMETERS_CS_V

Product:	MSD - Demand Planning
Description:	this view provied Demand Plans Input Parameters.
Implementation/DBA Data:	APPS.MSD_DP_PARAMETERS_CS_V

View Text

SELECT MPR.ROWID
, MPR.DEMAND_PLAN_ID
, MDP.DEMAND_PLAN_NAME
, MPR.PARAMETER_ID
, MPR.PARAMETER_NAME
, MPR.PARAMETER_TYPE
, CSD.DESCRIPTION
, MPR.START_DATE
, MPR.END_DATE
, MPR.INPUT_SCENARIO_ID
, MDSV2.SCENARIO_NAME
, MPR.INPUT_DEMAND_PLAN_ID
, MDP2.DEMAND_PLAN_NAME
, MPR.FORECAST_DATE_USED
, MCID.DESCRIPTION
, MSD_CS_DFN_UTL.GET_PLANNING_SERVER_CLMN(CSD.CS_DEFINITION_ID
, MPR.FORECAST_DATE_USED)
, MPR.QUANTITY_USED
, MCID2.DESCRIPTION
, MSD_CS_DFN_UTL.GET_PLANNING_SERVER_CLMN(CSD.CS_DEFINITION_ID
, MPR.QUANTITY_USED)
, MPR.AMOUNT_USED
, MCID3.DESCRIPTION
, MSD_CS_DFN_UTL.GET_PLANNING_SERVER_CLMN(CSD.CS_DEFINITION_ID
, MPR.AMOUNT_USED)
, MPR.FORECAST_USED
, FLV7.MEANING
, MPR.FACT_TYPE
, FLV8.MEANING
, MPR.REVISION
, MPR.VIEW_NAME
, MPR.ALLO_AGG_BASIS_STREAM_ID
, MPR.NUMBER_OF_PERIOD
, CSD.CS_DEFINITION_ID
, CSD.MULTIPLE_STREAM_FLAG
, CSD.MEASUREMENT_TYPE
, CSD.SYSTEM_FLAG
, MPR.LAST_UPDATE_DATE
, MPR.LAST_UPDATED_BY
, MPR.CREATION_DATE
, MPR.CREATED_BY
, MPR.LAST_UPDATE_LOGIN
, MPR.REQUEST_ID
, MPR.PROGRAM_APPLICATION_ID
, MPR.PROGRAM_ID
, MPR.PROGRAM_UPDATE_DATE
, MPR.EXCLUDE_FROM_ROLLING_CYCLE
, MPR.SCN_BUILD_REFRESH_NUM
FROM MSD_CS_DEFINITIONS_VL CSD
, MSD_CS_CLMN_IDENTIFIERS_VL MCID
, MSD_CS_CLMN_IDENTIFIERS_VL MCID2
, MSD_CS_CLMN_IDENTIFIERS_VL MCID3
, FND_LOOKUP_VALUES_VL FLV7
, FND_LOOKUP_VALUES_VL FLV8
, MSD_DEMAND_PLANS MDP
, MSD_DP_SCENARIOS MDSV2
, MSD_DEMAND_PLANS MDP2
, MSD_DP_PARAMETERS MPR
WHERE MDP.DEMAND_PLAN_ID = MPR.DEMAND_PLAN_ID
AND CSD.NAME = MPR.PARAMETER_TYPE
AND MCID.COLUMN_IDENTIFIER (+) = MPR.FORECAST_DATE_USED
AND MCID2.COLUMN_IDENTIFIER (+) = MPR.QUANTITY_USED
AND MCID3.COLUMN_IDENTIFIER (+) = MPR.AMOUNT_USED
AND FLV7.LOOKUP_CODE (+) = MPR.FORECAST_USED
AND FLV7.LOOKUP_TYPE (+) = 'MSD_FORECAST_TYPE'
AND FLV8.LOOKUP_CODE (+) = MPR.FACT_TYPE
AND FLV8.LOOKUP_TYPE (+) = 'MSD_FACT_TYPE'
AND MDSV2.DEMAND_PLAN_ID (+) = MPR.INPUT_DEMAND_PLAN_ID
AND MDSV2.SCENARIO_ID (+) = MPR.INPUT_SCENARIO_ID
AND MDP2.DEMAND_PLAN_ID (+) = MDSV2.DEMAND_PLAN_ID

Columns