APPS.WSH_EXTERNAL_INTERFACE_SV dependencies on WSH_CARRIERS

Line 56: wsh_carriers wc,

52: cursor valid_carrier_det_cur is
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(+)

Line 71: wsh_carriers wc

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
74: or wnd.carrier_id = wcs.carrier_id
75: )

Line 81: wsh_carriers wc

77:
78: cursor c_valid_carrier is
79: select distinct wc.manifesting_enabled_flag
80: from wsh_carrier_services wcs,
81: wsh_carriers wc
82: where wcs.carrier_id=p_carrier_id
83: and wcs.carrier_id = wc.carrier_id;
84:
85: cursor c_valid_smc is

Line 88: wsh_carriers wc

84:
85: cursor c_valid_smc is
86: select distinct wc.manifesting_enabled_flag
87: from wsh_carrier_services wcs,
88: wsh_carriers wc
89: where wcs.ship_method_code = p_ship_method_code
90: and wcs.carrier_id = wc.carrier_id;
91:
92: l_warehouse_type VARCHAR2 (3);