APPS.WSH_EXTERNAL_INTERFACE_SV dependencies on WSH_NEW_DELIVERIES

Line 57: wsh_new_deliveries wnd,

53: select distinct wc.manifesting_enabled_flag
54: from wsh_delivery_details wdd,
55: wsh_carrier_services wcs,
56: wsh_carriers wc,
57: wsh_new_deliveries wnd,
58: wsh_delivery_assignments_v wda
59: where wdd.delivery_detail_id = p_delivery_detail_id
60: and wdd.delivery_detail_id = wda.delivery_detail_id(+)
61: and wda.delivery_id = wnd.delivery_id(+)

Line 69: from wsh_new_deliveries wnd,

65: and wcs.carrier_id = wc.carrier_id;
66:
67: cursor valid_carrier_del_cur is
68: select distinct wc.manifesting_enabled_flag
69: from wsh_new_deliveries wnd,
70: wsh_carrier_services wcs,
71: wsh_carriers wc
72: where wnd.delivery_id = p_delivery_id
73: and ( wnd.ship_method_code = wcs.ship_method_code

Line 286: FROM wsh_new_deliveries

282: IS
283: SELECT Initial_Pickup_Location_ID,
284: ultimate_dropoff_location_id, --Notification change heali
285: customer_id --Notification change heali
286: FROM wsh_new_deliveries
287: WHERE Organization_ID = l_trading_partner_id
288: AND Name = l_name;
289:
290: --Notification change heali