APPS.WSH_TRIP_VALIDATIONS dependencies on WSH_NEW_DELIVERIES

Line 52: wsh_new_deliveries dl

48: SELECT dl.delivery_id
49: FROM wsh_trips t,
50: wsh_trip_stops st,
51: wsh_delivery_legs dg,
52: wsh_new_deliveries dl
53: WHERE t.trip_id = p_trip_id AND
54: st.trip_id = t.trip_id AND
55: dg.pick_up_stop_id = st.stop_id AND
56: dl.delivery_id = dg.delivery_id;

Line 387: wsh_new_deliveries dl

383: SELECT 1 from dual
384: WHERE exists ( select 1
385: FROM wsh_trip_stops ds,
386: wsh_delivery_legs dg,
387: wsh_new_deliveries dl
388: WHERE ds.trip_id = p_trip_id
389: AND dg.drop_off_stop_id = p_stop_id
390: AND dg.delivery_id = dl.delivery_id
391: AND dl.status_code IN ('CO','OP','PA'));

Line 972: wsh_new_deliveries dl,

968: CURSOR group_by_carrier_set IS
969: SELECT count(*)
970: FROM wsh_trip_stops t,
971: wsh_delivery_legs dg,
972: wsh_new_deliveries dl,
973: wsh_shipping_parameters wsp
974: WHERE t.stop_id = p_trip_id AND
975: dg.pick_up_stop_id = t.stop_id AND
976: dl.delivery_id = dg.delivery_id AND

Line 1231: FROM wsh_new_deliveries wnd,

1227:
1228: -- bug 1550824: find delivery not confirmed, in transit or closed.
1229: CURSOR deliveries_still_open(p_stop_id NUMBER) IS
1230: SELECT wnd.delivery_id
1231: FROM wsh_new_deliveries wnd,
1232: wsh_delivery_legs wdl
1233: WHERE wdl.pick_up_stop_id = p_stop_id
1234: AND wnd.delivery_id = wdl.delivery_id
1235: AND wnd.status_code IN ('OP', 'PA')

Line 2135: NVL(wnd.tms_interface_flag,WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) tms_interface_flag, -- OTM R12, glog proj

2131: /*J inbound logistics new column jckwok*/
2132: NVL(shipment_direction,'O') shipment_direction,
2133: wnd.delivery_type, --MDC
2134: NVL(wnd.ignore_for_planning, 'N') ignore_for_planning, -- OTM R12, glog proj
2135: NVL(wnd.tms_interface_flag,WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) tms_interface_flag, -- OTM R12, glog proj
2136: wsp.otm_enabled -- OTM R12, glog proj
2137: FROM wsh_new_deliveries wnd,
2138: wsh_delivery_legs wdl,
2139: wsh_trip_stops wts1,

Line 2137: FROM wsh_new_deliveries wnd,

2133: wnd.delivery_type, --MDC
2134: NVL(wnd.ignore_for_planning, 'N') ignore_for_planning, -- OTM R12, glog proj
2135: NVL(wnd.tms_interface_flag,WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) tms_interface_flag, -- OTM R12, glog proj
2136: wsp.otm_enabled -- OTM R12, glog proj
2137: FROM wsh_new_deliveries wnd,
2138: wsh_delivery_legs wdl,
2139: wsh_trip_stops wts1,
2140: wsh_trip_stops wts2,
2141: wsh_trips wt,

Line 4726: wsh_new_deliveries wnd,

4722: CURSOR trip_csr (p_trip_id NUMBER, p_stop_id NUMBER)
4723: IS
4724: SELECT 1
4725: FROM wsh_delivery_legs wdl,
4726: wsh_new_deliveries wnd,
4727: wsh_trip_stops wts
4728: WHERE wts.trip_id = p_trip_id
4729: AND wdl.delivery_id = wnd.delivery_id
4730: AND NVL(wnd.shipment_direction,'O') IN ( 'O','IO' )

Line 4836: wsh_new_deliveries wnd,

4832: CURSOR trip_csr (p_trip_id NUMBER, p_stop_id NUMBER)
4833: IS
4834: SELECT 1
4835: FROM wsh_delivery_legs wdl,
4836: wsh_new_deliveries wnd,
4837: wsh_trip_stops wts
4838: WHERE wts.trip_id = p_trip_id
4839: AND wdl.delivery_id = wnd.delivery_id
4840: AND NVL(wnd.shipment_direction,'O') NOT IN ( 'O','IO' )

Line 6026: WSH_NEW_DELIVERIES_PVT.get_name(l_del_to_unassign(i)));

6022: END IF;
6023:
6024: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_UNASSIGN_TRIP');
6025: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',
6026: WSH_NEW_DELIVERIES_PVT.get_name(l_del_to_unassign(i)));
6027: FND_MESSAGE.SET_TOKEN('TRIP_NAME',
6028: WSH_TRIPS_PVT.get_name(p_trip_id));
6029: l_num_warn := l_num_warn + 1;
6030: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);