[Home] [Help]
435: , mt.continuous_move_sequence
436: , mt.out_of_scope
437: , null
438: , 1
439: , wsh_trips_interface_s.nextval
440: , mt.status_code
441: , fvt.inventory_item_id
442: , fvt.organization_id
443: , mt.carrier_id
499: , mt.continuous_move_sequence
500: , mt.out_of_scope
501: , null
502: , 1
503: , wsh_trips_interface_s.nextval
504: , mt.status_code
505: , fvt.inventory_item_id
506: , fvt.organization_id
507: , mt.carrier_id
730: , mt.continuous_move_id
731: , mt.continuous_move_sequence
732: , mt.out_of_scope
733: , null
734: , wsh_trips_interface_s.nextval
735: , mt.status_code
736: , fvt.inventory_item_id
737: , fvt.organization_id
738: , mt.carrier_id
825: , mt.trip_start_date
826: , mt.continuous_move_id
827: , mt.continuous_move_sequence
828: , mt.out_of_scope
829: --, wsh_trips_interface_s.nextval bug # 3509717 moving to update section below
830: , null
831: , mt.status_code
832: , fvt.inventory_item_id
833: , fvt.organization_id
860: end if;
861: --assign same group_id and set planned_flag of trip which are related to current trip thru delivery
862: update mst_release_temp_gt mrt
863: Set mrt.group_id = p_group_id
864: , trip_id_iface = wsh_trips_interface_s.nextval -- bug # 3509717 moved here from insert section
865: , mrt.planned_flag = decode(p_planned_flag,-1111,-1111,
866: decode(mrt.out_of_scope,1,mrt.planned_flag
867: ,decode(p_planned_flag,1,decode(nvl(mrt.planned_flag,0),3,2,mrt.planned_flag),mrt.planned_flag)))
868: where mrt.release_id = p_release_id
3502: , mt.continuous_move_sequence
3503: , mt.out_of_scope
3504: , null
3505: , 1
3506: , wsh_trips_interface_s.nextval
3507: , mt.status_code
3508: , fvt.inventory_item_id
3509: , fvt.organization_id
3510: , mt.carrier_id
3577: , mt.continuous_move_sequence
3578: , mt.out_of_scope
3579: , null
3580: , 1
3581: , wsh_trips_interface_s.nextval
3582: , mt.status_code
3583: , fvt.inventory_item_id
3584: , fvt.organization_id
3585: , mt.carrier_id