2498: END IF;
2499:
2500: update mrp_org_transfer_release motr
2501: set earliest_ship_date = (select max(ms.new_schedule_date)
2502: from msc_supplies ms, msc_single_lvl_peg mslp
2503: where ms.plan_id=l_arg_plan_id
2504: and ms.transaction_id = mslp.child_id
2505: and ms.plan_id= mslp.plan_id
2506: and mslp.parent_id = motr.transaction_id
2719: END IF;
2720:
2721: /* update mrp_org_transfer_release motr
2722: set earliest_ship_date = (select max(ms.new_schedule_date)
2723: from msc_part_supplies ms, msc_single_lvl_peg mslp
2724: where ms.plan_id=l_arg_plan_id
2725: and ms.transaction_id = mslp.child_id
2726: and ms.plan_id= mslp.plan_id
2727: and mslp.parent_id = motr.transaction_id