APPS.WSH_ITM_PARTY_SYNC dependencies on WSH_CARRIERS

Line 173: 'wsh_carriers_v wsh_car '||

169: ' FROM '||
170: 'hz_party_sites party_site,'||
171: 'hz_parties party,'||
172: 'hz_locations loc ,'||
173: 'wsh_carriers_v wsh_car '||
174: 'WHERE '||
175: ' party_site.party_id = party.party_id'||
176: ' AND wsh_car.ACTIVE = ''A'' '||
177: ' AND party.party_id = wsh_car.carrier_id'||

Line 328: WSH_CARRIERS WC,

324: CURSOR cur_carrier_party_name(c_freight_code varchar2) IS
325: SELECT
326: HP.PARTY_NAME
327: FROM
328: WSH_CARRIERS WC,
329: HZ_PARTIES HP
330: WHERE
331: HP.PARTY_ID = WC.CARRIER_ID AND
332: wc.freight_code = c_freight_code;