DBA Data[Home] [Help]

APPS.WSH_AUTO_MANIFEST dependencies on WSH_CARRIERS

Line 238: wsh_carriers wc

234: FROM wsh_delivery_details wdd,
235: wsh_delivery_assignments_v wda,
236: wsh_new_deliveries wnd,
237: mtl_parameters mtl,
238: wsh_carriers wc
239: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
240: AND wda.delivery_id = wnd.delivery_id
241: AND wda.delivery_detail_id = wdd.delivery_detail_id
242: AND ((p_src_header_num_from IS NOT NULL

Line 307: FROM wsh_carriers, hz_parties

303: OR ( wnd.initial_pickup_date <= p_scheduled_to_date));
304:
305: CURSOR get_carrier_name(pc_carrier_id NUMBER) IS
306: SELECT party_name
307: FROM wsh_carriers, hz_parties
308: WHERE carrier_id =party_id (+)
309: AND carrier_id= pc_carrier_id;
310:
311: CURSOR get_customer_name(pc_customer_id NUMBER) IS