APPS.WSH_INTERFACE dependencies on WSH_NEW_DELIVERIES

Line 422: wsh_new_deliveries nd

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
426: and nd.delivery_id = da.delivery_id

Line 1235: FROM wsh_new_deliveries

1231: -- if delivery line is assigned to delivery and delivery is planned,
1232: -- log exception for it
1233: SELECT planned_flag
1234: INTO l_planned_flag
1235: FROM wsh_new_deliveries
1236: WHERE delivery_id = l_assign_rec.delivery_id;
1237:
1238: IF (NVL(l_planned_flag, 'N') IN ('Y','F')) THEN
1239: -- hwahdani BUG#:1565518

Line 2377: FROM wsh_new_deliveries wnd

2373: -- Do not Lock the Delivery if source_code is 'INV'
2374: IF (l_dummy_id IS NOT NULL) THEN
2375: SELECT wnd.status_code
2376: INTO l_del_status_code
2377: FROM wsh_new_deliveries wnd
2378: WHERE wnd.delivery_id = l_dummy_id;
2379: ELSE
2380: l_del_status_code := 'OP';
2381: END IF;

Line 2391: FROM wsh_new_deliveries wnd

2387: END IF;
2388: IF (l_dummy_id IS NOT NULL) THEN
2389: SELECT wnd.status_code
2390: INTO l_del_status_code
2391: FROM wsh_new_deliveries wnd
2392: WHERE wnd.delivery_id = l_dummy_id
2393: FOR UPDATE NOWAIT;
2394: ELSE
2395: l_del_status_code := 'OP';