Product: | MSD - Demand Planning |
---|---|
Description: | This table provides the Scenarios to be generated from a particular Demand Plan. |
Implementation/DBA Data: | APPS.MSD_DP_SCENARIOS_CS_V |
SELECT MDS.ROWID
, MDS.DEMAND_PLAN_ID
, MDP.DEMAND_PLAN_NAME
, MDS.SCENARIO_ID
, MDS.SCENARIO_NAME
, MDS.DESCRIPTION
, MDS.OUTPUT_PERIOD_TYPE
, FLV1.MEANING
, MDS.HISTORY_START_DATE
, MDS.HISTORY_END_DATE
, MDS.PUBLISH_FLAG
, MDS.ENABLE_FLAG
, MDS.HORIZON_START_DATE
, MDS.HORIZON_END_DATE
, MDS.FORECAST_DATE_USED
, MCID.DESCRIPTION
, MDS.FORECAST_BASED_ON
, DECODE(CSD.DESCRIPTION
, NULL
, ''
, CSD.DESCRIPTION || ':' ) || MDS.PARAMETER_NAME
, MDS.PARAMETER_NAME
, MDS.PRICE_LIST_NAME
, MDS.LAST_UPDATE_DATE
, MDS.LAST_UPDATED_BY
, MDS.CREATION_DATE
, MDS.CREATED_BY
, MDS.LAST_UPDATE_LOGIN
, MDS.REQUEST_ID
, MDS.PROGRAM_APPLICATION_ID
, MDS.PROGRAM_ID
, MDS.PROGRAM_UPDATE_DATE
, MDS.ATTRIBUTE_CATEGORY
, MDS.ATTRIBUTE1
, MDS.ATTRIBUTE2
, MDS.ATTRIBUTE3
, MDS.ATTRIBUTE4
, MDS.ATTRIBUTE5
, MDS.ATTRIBUTE6
, MDS.ATTRIBUTE7
, MDS.ATTRIBUTE8
, MDS.ATTRIBUTE9
, MDS.ATTRIBUTE10
, MDS.ATTRIBUTE11
, MDS.ATTRIBUTE12
, MDS.ATTRIBUTE13
, MDS.ATTRIBUTE14
, MDS.ATTRIBUTE15
, MDS.ERROR_TYPE
, MDS.CONSUME_FLAG
FROM FND_LOOKUP_VALUES_VL FLV1
, MSD_CS_CLMN_IDENTIFIERS_VL MCID
, MSD_DEMAND_PLANS MDP
, MSD_DP_SCENARIOS MDS
, MSD_CS_DEFINITIONS CSD
WHERE MDP.DEMAND_PLAN_ID = MDS.DEMAND_PLAN_ID
AND FLV1.LOOKUP_CODE = MDS.OUTPUT_PERIOD_TYPE
AND FLV1.LOOKUP_TYPE = 'MSD_PERIOD_TYPE'
AND CSD.NAME(+) = MDS.FORECAST_BASED_ON
AND MCID.COLUMN_IDENTIFIER(+) = MDS.FORECAST_DATE_USED