[Home] [Help]
417: dd.shipped_quantity
418: from wsh_delivery_Details dd,
419: wsh_trip_stops s,
420: wsh_delivery_legs dl,
421: wsh_delivery_assignments_v da,
422: wsh_new_deliveries nd
423: -- wsh_delivery_line_status_v ds
424: where s.stop_id = dl.pick_up_stop_id
425: and dl.delivery_id = nd.delivery_id
1071: CURSOR c_assignment(c_detail_id NUMBER) IS
1072: SELECT delivery_assignment_id,
1073: parent_delivery_detail_id,
1074: delivery_id
1075: FROM wsh_delivery_assignments_v
1076: WHERE delivery_detail_id = c_detail_id;
1077: l_assign_rec c_assignment%ROWTYPE;
1078:
1079: -- HW OPMCONV - Added Qty2
2120: --
2121: <
2122: FOR l_counter IN p_changed_attributes.FIRST .. p_changed_attributes.LAST LOOP
2123:
2124: -- lock records in WSH_DELIVERY_DETAILS and wsh_delivery_assignments_v (if not Pick Confirm)
2125: -- unless we are importing source lines.
2126: -- We also look up delivery's status (if not Pick Confirm)
2127: IF p_changed_attributes(l_counter).action_flag <> 'I' THEN
2128:
2354: l_ship_set_id,
2355: l_source_header_id,
2356: l_dummy_id
2357: FROM wsh_delivery_details wdd,
2358: wsh_delivery_assignments_v wda
2359: WHERE wdd.delivery_detail_id = p_delivery_detail_id
2360: AND wdd.delivery_detail_id = wda.delivery_detail_id
2361: AND wdd.container_flag = 'N'
2362: FOR UPDATE NOWAIT;
2793: wda.delivery_id,
2794: wda.parent_delivery_detail_id,
2795: wdd.released_status
2796: FROM wsh_delivery_details wdd,
2797: wsh_delivery_assignments_v wda
2798: WHERE wdd.delivery_detail_id = v_delivery_detail_id
2799: AND wdd.delivery_detail_id = wda.delivery_detail_id;
2800: -- cannot add wda.delivery_id is not null because this is a generic
2801: -- API and not specific for FTE
2814: wda.delivery_id,
2815: wda.parent_delivery_detail_id,
2816: wdd.released_status
2817: FROM wsh_delivery_details wdd,
2818: wsh_delivery_assignments_v wda
2819: WHERE wdd.source_line_id = v_source_line_id
2820: AND wdd.delivery_detail_id = wda.delivery_detail_id
2821: AND nvl(wdd.line_direction, 'O') IN ('O', 'IO');
2822: i NUMBER;