APPS.WSH_VENDOR_PARTY_MERGE_PKG dependencies on HZ_PARTY_SITES

Line 55: FROM hz_party_sites hps,

51: CURSOR get_party_site_csr(p_party_id NUMBER, p_site_id NUMBER) IS
52: SELECT location_id,
53: hps.party_site_id,
54: hps.object_version_number
55: FROM hz_party_sites hps,
56: hz_party_site_uses hpsu
57: WHERE hps.party_id = p_party_id
58: AND hps.party_site_id = hpsu.party_site_id
59: AND hpsu.site_use_type = 'SUPPLIER_SHIP_FROM'

Line 325: FROM hz_party_sites hps,

321: l_debug_on BOOLEAN;
322: --
323: CURSOR check_location_id IS
324: SELECT 'x', hps.party_site_id
325: FROM hz_party_sites hps,
326: hz_party_site_uses hpsu
327: WHERE hps.party_id = p_to_id
328: AND hps.location_id = p_location_id
329: AND hps.party_site_id = hpsu.party_site_id

Line 336: FROM hz_party_sites hps,

332: CURSOR check_location_code IS
333: SELECT substr(party_site_number, 1,
334: instr(party_site_number, '|')-1) location_code,
335: hps.party_site_id
336: FROM hz_party_sites hps,
337: hz_party_site_uses hpsu
338: WHERE hps.location_id = p_location_id
339: AND hps.party_id = p_from_id
340: AND hps.party_site_id = hpsu.party_site_id

Line 350: FROM hz_party_sites hps,

346: l_from_party_site_id NUMBER;
347: --
348: CURSOR chk_locn_csr (p_site_number IN VARCHAR2) IS
349: SELECT 'x'
350: FROM hz_party_sites hps,
351: hz_party_site_uses hpsu
352: WHERE hps.party_id = p_to_id
353: AND hps.party_site_number = p_site_number
354: AND hps.party_site_id = hpsu.party_site_id

Line 364: FROM hz_party_sites hps,

360: p_party_site_id NUMBER ) IS
361: SELECT contact_person.party_name shipper_name,
362: phone_record.phone_number phone_number,
363: email_record.email_address email_address
364: FROM hz_party_sites hps,
365: hz_parties contact_person,
366: hz_org_contacts supplier_contact,
367: hz_contact_points phone_record,
368: hz_contact_points email_record,

Line 569: -- Check if we have an entry in hz_party_sites with the same

565: IF l_debug_on THEN
566: WSH_DEBUG_SV.log(l_module_name,'L_SITE_NUMBER', l_site_number);
567: END IF;
568: --
569: -- Check if we have an entry in hz_party_sites with the same
570: -- party_site_number and merge TO vendor ID
571: --
572: l_dummy := NULL;
573: OPEN chk_locn_csr( p_site_number => l_site_number );

Line 1159: FROM hz_party_sites hps,

1155: CURSOR get_party_site_csr(p_party_id NUMBER) IS
1156: SELECT location_id,
1157: hps.party_site_id,
1158: hps.object_version_number
1159: FROM hz_party_sites hps,
1160: hz_party_site_uses hpsu
1161: WHERE hps.party_id = p_party_id
1162: AND hps.party_site_id = hpsu.party_site_id
1163: AND hpsu.site_use_type = 'SUPPLIER_SHIP_FROM'