APPS.WSH_VENDOR_PARTY_MERGE_PKG dependencies on HZ_PARTY_SITE_USES

Line 56: hz_party_site_uses hpsu

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'
60: AND hpsu.status = 'A'

Line 326: hz_party_site_uses hpsu

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
330: AND hpsu.site_use_type = 'SUPPLIER_SHIP_FROM';

Line 337: hz_party_site_uses hpsu

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
341: AND hpsu.site_use_type = 'SUPPLIER_SHIP_FROM';

Line 351: hz_party_site_uses hpsu

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
355: AND hpsu.site_use_type = 'SUPPLIER_SHIP_FROM';

Line 668: WSH_SUPPLIER_PARTY.Create_HZ_Party_Site_uses

664: --
665: -- Now create a party Site use record for the party site that we
666: -- just created above.
667: --
668: WSH_SUPPLIER_PARTY.Create_HZ_Party_Site_uses
669: (
670: P_party_site_id => l_to_party_site_id,
671: P_site_use_type => 'SUPPLIER_SHIP_FROM',
672: x_party_site_use_id => l_party_site_use_id,

Line 1160: hz_party_site_uses hpsu

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'
1164: AND hpsu.status = 'A';