268: p_demand_plan_id
269: ,msd_dp_parameters_s.nextval
270: ,par.PARAMETER_TYPE
271: ,mds.supply_plan_name
272: ,msd_common_utilities.get_bucket_start_date(sysdate,-23,6,'GREGORIAN')
273: ,msd_common_utilities.get_bucket_start_date(sysdate,24,6,'GREGORIAN')
274: ,par.OUTPUT_SCENARIO_ID
275: ,mds.SCENARIO_ID
276: ,mds.DEMAND_PLAN_ID
269: ,msd_dp_parameters_s.nextval
270: ,par.PARAMETER_TYPE
271: ,mds.supply_plan_name
272: ,msd_common_utilities.get_bucket_start_date(sysdate,-23,6,'GREGORIAN')
273: ,msd_common_utilities.get_bucket_start_date(sysdate,24,6,'GREGORIAN')
274: ,par.OUTPUT_SCENARIO_ID
275: ,mds.SCENARIO_ID
276: ,mds.DEMAND_PLAN_ID
277: ,nvl(mdsr.REVISION,-1)
356: p_demand_plan_id
357: ,msd_dp_parameters_s.nextval
358: ,par.PARAMETER_TYPE
359: ,mds.supply_plan_name
360: ,msd_common_utilities.get_bucket_start_date(sysdate,-23,6,'GREGORIAN')
361: ,msd_common_utilities.get_bucket_start_date(sysdate,24,6,'GREGORIAN')
362: ,par.OUTPUT_SCENARIO_ID
363: ,mds.SCENARIO_ID
364: ,mds.DEMAND_PLAN_ID
357: ,msd_dp_parameters_s.nextval
358: ,par.PARAMETER_TYPE
359: ,mds.supply_plan_name
360: ,msd_common_utilities.get_bucket_start_date(sysdate,-23,6,'GREGORIAN')
361: ,msd_common_utilities.get_bucket_start_date(sysdate,24,6,'GREGORIAN')
362: ,par.OUTPUT_SCENARIO_ID
363: ,mds.SCENARIO_ID
364: ,mds.DEMAND_PLAN_ID
365: ,nvl(mdsr.REVISION,-1)
470: p_demand_plan_id
471: ,msd_dp_parameters_s.nextval
472: ,par.PARAMETER_TYPE
473: ,mds.supply_plan_name
474: ,msd_common_utilities.get_bucket_start_date(sysdate,-23,6,'GREGORIAN')
475: ,msd_common_utilities.get_bucket_start_date(sysdate,24,6,'GREGORIAN')
476: ,par.OUTPUT_SCENARIO_ID
477: ,mds.SCENARIO_ID
478: ,mds.DEMAND_PLAN_ID
471: ,msd_dp_parameters_s.nextval
472: ,par.PARAMETER_TYPE
473: ,mds.supply_plan_name
474: ,msd_common_utilities.get_bucket_start_date(sysdate,-23,6,'GREGORIAN')
475: ,msd_common_utilities.get_bucket_start_date(sysdate,24,6,'GREGORIAN')
476: ,par.OUTPUT_SCENARIO_ID
477: ,mds.SCENARIO_ID
478: ,mds.DEMAND_PLAN_ID
479: ,decode(nvl(mdsr.revision,-1), nvl(mdp2.revision,-1) , -1 , mdsr.revision)