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 303: FROM wsh_new_deliveries wnd,

299: SELECT Nvl(mcp.trading_partner_site_id, wnd.Initial_Pickup_Location_ID) Tranding_partner_site_id,
300: wnd.ultimate_dropoff_location_id, --Notification change heali
301: wnd.customer_id, --Notification change heali
302: wnd.client_id
303: FROM wsh_new_deliveries wnd,
304: mtl_client_parameters_v mcp
305: WHERE wnd.Name = l_name
306: AND wnd.client_id = mcp.client_id (+);
307: -- LSP PROJECT : end