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: NVL(mcp.otm_enabled,wsp.otm_enabled) otm_enabled, -- OTM R12, glog proj-- LSP PROJECT : checking OTM enabled flag on client parameters.
2137: mcp.client_id -- LSP PROJECT
2138: FROM wsh_new_deliveries wnd,
2139: wsh_delivery_legs wdl,

Line 2138: FROM wsh_new_deliveries wnd,

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: NVL(mcp.otm_enabled,wsp.otm_enabled) otm_enabled, -- OTM R12, glog proj-- LSP PROJECT : checking OTM enabled flag on client parameters.
2137: mcp.client_id -- LSP PROJECT
2138: FROM wsh_new_deliveries wnd,
2139: wsh_delivery_legs wdl,
2140: wsh_trip_stops wts1,
2141: wsh_trip_stops wts2,
2142: wsh_trips wt,

Line 4729: wsh_new_deliveries wnd,

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

Line 4839: wsh_new_deliveries wnd,

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

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

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