Product: | MSD - Demand Planning |
---|---|
Description: | This view stores the Parameters (both Input as well as Output) to be used by a Demand Plan. This will be used by Oracle Express to load the Data from the PS (all Input Parameters) and the Output parameters will be used by Oracle Express to |
Implementation/DBA Data: | Not implemented in this database |
SELECT MPR.ROWID
, MPR.DEMAND_PLAN_ID
, MDP.DEMAND_PLAN_NAME
, MPR.PARAMETER_ID
, MPR.PARAMETER_NAME
, MPR.PARAMETER_TYPE
, FLV1.MEANING
, MPR.PERIOD_TYPE
, FLV2.MEANING
, MPR.START_DATE
, MPR.END_DATE
, MPR.OUTPUT_SCENARIO_ID
, MDSV1.SCENARIO_NAME
, MDSV1.OUTPUT_PERIOD_TYPE
, FLV9.MEANING
, MDSV1.HORIZON_START_DATE
, MDSV1.HORIZON_END_DATE
, MPR.INPUT_SCENARIO_ID
, MDSV2.SCENARIO_NAME
, MPR.INPUT_DEMAND_PLAN_ID
, MDP2.DEMAND_PLAN_NAME
, MPR.FORECAST_DATE_USED
, FLV3.MEANING
, MPR.FORECAST_BASED_ON
, FLV4.MEANING
, MPR.QUANTITY_USED
, FLV5.MEANING
, MPR.AMOUNT_USED
, FLV6.MEANING
, MPR.FORECAST_USED
, FLV7.MEANING
, MPR.FACT_TYPE
, FLV8.MEANING
, MPR.REVISION
, MPR.VIEW_NAME
, 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 FND_LOOKUP_VALUES_VL FLV1
, FND_LOOKUP_VALUES_VL FLV2
, FND_LOOKUP_VALUES_VL FLV3
, FND_LOOKUP_VALUES_VL FLV4
, FND_LOOKUP_VALUES_VL FLV5
, FND_LOOKUP_VALUES_VL FLV6
, FND_LOOKUP_VALUES_VL FLV7
, FND_LOOKUP_VALUES_VL FLV8
, FND_LOOKUP_VALUES_VL FLV9
, MSD_DEMAND_PLANS MDP
, MSD_DP_SCENARIOS MDSV1
, MSD_DP_SCENARIOS MDSV2
, MSD_DEMAND_PLANS MDP2
, MSD_DP_PARAMETERS MPR
WHERE MDP.DEMAND_PLAN_ID = MPR.DEMAND_PLAN_ID
AND FLV1.LOOKUP_CODE = MPR.PARAMETER_TYPE
AND FLV1.LOOKUP_TYPE = 'MSD_DATA_ELEMENT'
AND FLV2.LOOKUP_CODE = MPR.PARAMETER_TYPE
AND FLV2.LOOKUP_TYPE = 'MSD_PERIOD_TYPE'
AND FLV3.LOOKUP_CODE (+) = MPR.FORECAST_DATE_USED
AND FLV3.LOOKUP_TYPE (+) = 'MSD_DATE_USED'
AND FLV4.LOOKUP_CODE (+) = MPR.FORECAST_BASED_ON
AND FLV4.LOOKUP_TYPE (+) = 'MSD_DATA_ELEMENT'
AND FLV5.LOOKUP_CODE (+) = MPR.QUANTITY_USED
AND FLV5.LOOKUP_TYPE (+) = 'MSD_MFG_FCST_QTY_USED'
AND FLV6.LOOKUP_CODE (+) = MPR.AMOUNT_USED
AND FLV6.LOOKUP_TYPE (+) = 'MSD_SALES_FCST_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 FLV9.LOOKUP_CODE (+) = MDSV1.OUTPUT_PERIOD_TYPE
AND FLV9.LOOKUP_TYPE (+) = 'MSD_PERIOD_TYPE'
AND MDSV1.DEMAND_PLAN_ID (+) = MPR.DEMAND_PLAN_ID
AND MDSV1.SCENARIO_ID (+) = MPR.OUTPUT_SCENARIO_ID
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