DBA Data[Home] [Help]

APPS.WSH_AUTO_MANIFEST dependencies on WSH_CARRIERS

Line 323: wsh_carriers wc

319: FROM wsh_delivery_details wdd,
320: wsh_delivery_assignments_v wda,
321: wsh_new_deliveries wnd,
322: mtl_parameters mtl,
323: wsh_carriers wc
324: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
325: AND wda.delivery_id = wnd.delivery_id
326: AND wda.delivery_detail_id = wdd.delivery_detail_id
327: AND ((p_src_header_num_from IS NOT NULL

Line 410: FROM wsh_carriers, hz_parties

406: ;
407:
408: CURSOR get_carrier_name(pc_carrier_id NUMBER) IS
409: SELECT party_name
410: FROM wsh_carriers, hz_parties
411: WHERE carrier_id =party_id (+)
412: AND carrier_id= pc_carrier_id;
413:
414: CURSOR get_customer_name(pc_customer_id NUMBER) IS