DBA Data[Home] [Help]

APPS.MSD_COMMON_UTILITIES_LB dependencies on MSD_DP_SCENARIO_REVISIONS

Line 392: UPDATE MSD_DP_SCENARIO_REVISIONS SET plan_start_date = x_demand_plan_rec.plan_start_date

388: prev_liab_pub_plan_start_date = x_demand_plan_rec.plan_start_date
389: WHERE demand_plan_id = p_demand_plan_id ;
390: */
391:
392: UPDATE MSD_DP_SCENARIO_REVISIONS SET plan_start_date = x_demand_plan_rec.plan_start_date
393: WHERE demand_plan_id = p_demand_plan_id and revision = p_senario_rev_num
394: and scenario_id = x_demand_plan_rec.scenario_id ;
395: /*
396: fnd_file.put_line(fnd_file.log , 'LIABILITY POST PROCESS' );

Line 435: MSD_DP_SCENARIO_REVISIONS

431: select
432: max(revision),
433: plan_start_date
434: from
435: MSD_DP_SCENARIO_REVISIONS
436: where
437: demand_plan_id = p_demand_plan_id
438: and scenario_id = p_scenario_id
439: group by