[Home] [Help]
427: dd.shipped_quantity
428: from wsh_delivery_Details dd,
429: wsh_trip_stops s,
430: wsh_delivery_legs dl,
431: wsh_delivery_assignments_v da,
432: wsh_new_deliveries nd
433: -- wsh_delivery_line_status_v ds
434: where s.stop_id = dl.pick_up_stop_id
435: and dl.delivery_id = nd.delivery_id
1081: CURSOR c_assignment(c_detail_id NUMBER) IS
1082: SELECT delivery_assignment_id,
1083: parent_delivery_detail_id,
1084: delivery_id
1085: FROM wsh_delivery_assignments_v
1086: WHERE delivery_detail_id = c_detail_id;
1087: l_assign_rec c_assignment%ROWTYPE;
1088:
1089: -- HW OPMCONV - Added Qty2
2109: --
2110: <
2111: FOR l_counter IN p_changed_attributes.FIRST .. p_changed_attributes.LAST LOOP
2112:
2113: -- lock records in WSH_DELIVERY_DETAILS and wsh_delivery_assignments_v (if not Pick Confirm)
2114: -- unless we are importing source lines.
2115: -- We also look up delivery's status (if not Pick Confirm)
2116: IF p_changed_attributes(l_counter).action_flag <> 'I' THEN
2117:
2286: l_ship_set_id,
2287: l_source_header_id,
2288: l_dummy_id
2289: FROM wsh_delivery_details wdd,
2290: wsh_delivery_assignments_v wda
2291: WHERE wdd.delivery_detail_id = p_delivery_detail_id
2292: AND wdd.delivery_detail_id = wda.delivery_detail_id
2293: AND wdd.container_flag = 'N'
2294: FOR UPDATE NOWAIT;
2706: wda.delivery_id,
2707: wda.parent_delivery_detail_id,
2708: wdd.released_status
2709: FROM wsh_delivery_details wdd,
2710: wsh_delivery_assignments_v wda
2711: WHERE wdd.delivery_detail_id = v_delivery_detail_id
2712: AND wdd.delivery_detail_id = wda.delivery_detail_id;
2713: -- cannot add wda.delivery_id is not null because this is a generic
2714: -- API and not specific for FTE
2727: wda.delivery_id,
2728: wda.parent_delivery_detail_id,
2729: wdd.released_status
2730: FROM wsh_delivery_details wdd,
2731: wsh_delivery_assignments_v wda
2732: WHERE wdd.source_line_id = v_source_line_id
2733: AND wdd.delivery_detail_id = wda.delivery_detail_id
2734: AND nvl(wdd.line_direction, 'O') IN ('O', 'IO');
2735: i NUMBER;