APPS.WSH_VENDOR_PARTY_MERGE_PKG dependencies on HZ_PARTY_SITES

Line 62: FROM hz_party_sites hps,

58: CURSOR get_party_site_csr(p_party_id NUMBER, p_site_id NUMBER) IS
59: SELECT location_id,
60: hps.party_site_id,
61: hps.object_version_number
62: FROM hz_party_sites hps,
63: hz_party_site_uses hpsu
64: WHERE hps.party_id = p_party_id
65: AND hps.party_site_id = hpsu.party_site_id
66: AND hpsu.site_use_type = 'SUPPLIER_SHIP_FROM'

Line 332: FROM hz_party_sites hps,

328: l_debug_on BOOLEAN;
329: --
330: CURSOR check_location_id IS
331: SELECT 'x', hps.party_site_id
332: FROM hz_party_sites hps,
333: hz_party_site_uses hpsu
334: WHERE hps.party_id = p_to_id
335: AND hps.location_id = p_location_id
336: AND hps.party_site_id = hpsu.party_site_id

Line 343: FROM hz_party_sites hps,

339: CURSOR check_location_code IS
340: SELECT substr(party_site_number, 1,
341: instr(party_site_number, '|')-1) location_code,
342: hps.party_site_id
343: FROM hz_party_sites hps,
344: hz_party_site_uses hpsu
345: WHERE hps.location_id = p_location_id
346: AND hps.party_id = p_from_id
347: AND hps.party_site_id = hpsu.party_site_id

Line 357: FROM hz_party_sites hps,

353: l_from_party_site_id NUMBER;
354: --
355: CURSOR chk_locn_csr (p_site_number IN VARCHAR2) IS
356: SELECT 'x'
357: FROM hz_party_sites hps,
358: hz_party_site_uses hpsu
359: WHERE hps.party_id = p_to_id
360: AND hps.party_site_number = p_site_number
361: AND hps.party_site_id = hpsu.party_site_id

Line 371: FROM hz_party_sites hps,

367: p_party_site_id NUMBER ) IS
368: SELECT contact_person.party_name shipper_name,
369: phone_record.phone_number phone_number,
370: email_record.email_address email_address
371: FROM hz_party_sites hps,
372: hz_parties contact_person,
373: hz_org_contacts supplier_contact,
374: hz_contact_points phone_record,
375: hz_contact_points email_record,

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

572: IF l_debug_on THEN
573: WSH_DEBUG_SV.log(l_module_name,'L_SITE_NUMBER', l_site_number);
574: END IF;
575: --
576: -- Check if we have an entry in hz_party_sites with the same
577: -- party_site_number and merge TO vendor ID
578: --
579: l_dummy := NULL;
580: OPEN chk_locn_csr( p_site_number => l_site_number );

Line 1166: FROM hz_party_sites hps,

1162: CURSOR get_party_site_csr(p_party_id NUMBER) IS
1163: SELECT location_id,
1164: hps.party_site_id,
1165: hps.object_version_number
1166: FROM hz_party_sites hps,
1167: hz_party_site_uses hpsu
1168: WHERE hps.party_id = p_party_id
1169: AND hps.party_site_id = hpsu.party_site_id
1170: AND hpsu.site_use_type = 'SUPPLIER_SHIP_FROM'