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.

VIEW: APPS.MSD_DP_PARAMETERS_CS_V

Source

View Text - Preformatted


SELECT mpr.ROWID, mpr.DEMAND_PLAN_ID, mdp.demand_plan_name, mpr.PARAMETER_ID, mpr.PARAMETER_NAME, mpr.PARAMETER_TYPE, decode(stream_type,'ARCHIVED_TIM',csd.description||' '||to_char(mpr.creation_date,'DD-MON-YYYY'),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, mpr.rounding_flag, csd.cs_classification, csd.strict_flag, csd.aggregation_allowed_flag, csd.allocation_allowed_flag, csd.stream_editable_flag, decode(mdp.build_stripe_level_pk, null, decode(mdp.build_stripe_stream_name, null, csd.planning_server_view_name, csd.planning_server_view_name_ds), csd.planning_server_view_name_ds), csd.cs_type, csd.lowest_level_flag, csd.composite_group_code, csd.dependent_data_flag, csd.dependent_demand_code, mpr.capacity_usage_ratio, mpr.deleteable_flag, mpr.enable_nonseed_flag, mpr.SUPPLY_PLAN_FLAG, mpr.PRICE_LIST_NAME, mpr.ASCP_STREAM_FLAG, mpr.STREAM_TYPE, mpr.EQUATION, mpr.POST_CALCULATION, mpr.CALCULATED_ORDER, mpr.DEPENDENT_DEMAND_DESC 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

View Text - HTML Formatted

SELECT MPR.ROWID
, MPR.DEMAND_PLAN_ID
, MDP.DEMAND_PLAN_NAME
, MPR.PARAMETER_ID
, MPR.PARAMETER_NAME
, MPR.PARAMETER_TYPE
, DECODE(STREAM_TYPE
, 'ARCHIVED_TIM'
, CSD.DESCRIPTION||' '||TO_CHAR(MPR.CREATION_DATE
, 'DD-MON-YYYY')
, 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
, MPR.ROUNDING_FLAG
, CSD.CS_CLASSIFICATION
, CSD.STRICT_FLAG
, CSD.AGGREGATION_ALLOWED_FLAG
, CSD.ALLOCATION_ALLOWED_FLAG
, CSD.STREAM_EDITABLE_FLAG
, DECODE(MDP.BUILD_STRIPE_LEVEL_PK
, NULL
, DECODE(MDP.BUILD_STRIPE_STREAM_NAME
, NULL
, CSD.PLANNING_SERVER_VIEW_NAME
, CSD.PLANNING_SERVER_VIEW_NAME_DS)
, CSD.PLANNING_SERVER_VIEW_NAME_DS)
, CSD.CS_TYPE
, CSD.LOWEST_LEVEL_FLAG
, CSD.COMPOSITE_GROUP_CODE
, CSD.DEPENDENT_DATA_FLAG
, CSD.DEPENDENT_DEMAND_CODE
, MPR.CAPACITY_USAGE_RATIO
, MPR.DELETEABLE_FLAG
, MPR.ENABLE_NONSEED_FLAG
, MPR.SUPPLY_PLAN_FLAG
, MPR.PRICE_LIST_NAME
, MPR.ASCP_STREAM_FLAG
, MPR.STREAM_TYPE
, MPR.EQUATION
, MPR.POST_CALCULATION
, MPR.CALCULATED_ORDER
, MPR.DEPENDENT_DEMAND_DESC
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