APPS.WSH_INTERFACE dependencies on WSH_NEW_DELIVERIES

Line 432: wsh_new_deliveries nd

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

Line 1245: FROM wsh_new_deliveries

1241: -- if delivery line is assigned to delivery and delivery is planned,
1242: -- log exception for it
1243: SELECT planned_flag
1244: INTO l_planned_flag
1245: FROM wsh_new_deliveries
1246: WHERE delivery_id = l_assign_rec.delivery_id;
1247:
1248: IF (NVL(l_planned_flag, 'N') IN ('Y','F')) THEN
1249: -- hwahdani BUG#:1565518

Line 2309: FROM wsh_new_deliveries wnd

2305: -- Do not Lock the Delivery if source_code is 'INV'
2306: IF (l_dummy_id IS NOT NULL) THEN
2307: SELECT wnd.status_code
2308: INTO l_del_status_code
2309: FROM wsh_new_deliveries wnd
2310: WHERE wnd.delivery_id = l_dummy_id;
2311: ELSE
2312: l_del_status_code := 'OP';
2313: END IF;

Line 2323: FROM wsh_new_deliveries wnd

2319: END IF;
2320: IF (l_dummy_id IS NOT NULL) THEN
2321: SELECT wnd.status_code
2322: INTO l_del_status_code
2323: FROM wsh_new_deliveries wnd
2324: WHERE wnd.delivery_id = l_dummy_id
2325: FOR UPDATE NOWAIT;
2326: ELSE
2327: l_del_status_code := 'OP';