APPS.FTE_FREIGHT_RATING_DLVY_GRP dependencies on WSH_CARRIERS

Line 170: wsh_carriers c

166: IS
167: SELECT count(a.delivery_id)
168: FROM wsh_new_deliveries a,
169: mtl_parameters b,
170: wsh_carriers c
171: WHERE a.organization_id = b.organization_id
172: AND a.carrier_id = c.carrier_id
173: AND c.manifesting_enabled_flag = 'Y'
174: AND b.carrier_manifesting_flag = 'Y'

Line 183: wsh_carriers c

179: IS
180: SELECT count(a.delivery_id)
181: FROM wsh_new_deliveries a,
182: mtl_parameters b,
183: wsh_carriers c
184: WHERE a.organization_id = b.organization_id
185: AND a.carrier_id = c.carrier_id
186: AND c.manifesting_enabled_flag = 'Y'
187: AND b.carrier_manifesting_flag = 'Y'

Line 202: FROM wsh_carriers

198:
199: CURSOR c_get_carrier_manifest_enabled(c_carrier_id NUMBER)
200: IS
201: SELECT manifesting_enabled_flag
202: FROM wsh_carriers
203: WHERE carrier_id = c_carrier_id;
204:
205: CURSOR c_get_del_manifest_enabled(c_delivery_id NUMBER)
206: IS

Line 239: FROM wsh_carriers

235: AND a.carrier_id = c_carrier_id;
236:
237: CURSOR c_get_generic_carrier_flag (c_carrier_id VARCHAR2) IS
238: SELECT generic_flag
239: FROM wsh_carriers
240: WHERE carrier_id = c_carrier_id;
241:
242: CURSOR c_get_carrier_name(c_carrier_id NUMBER)
243: IS

Line 245: FROM hz_parties hz, wsh_carriers wc

241:
242: CURSOR c_get_carrier_name(c_carrier_id NUMBER)
243: IS
244: SELECT hz.party_name carrier_name
245: FROM hz_parties hz, wsh_carriers wc
246: WHERE hz.party_id = wc.carrier_id
247: AND nvl(wc.generic_flag,'N') = 'N'
248: AND wc.carrier_id = c_carrier_id;
249: