APPS.WSH_VENDOR_PARTY_MERGE_PKG dependencies on HZ_PARTY_SITE_USES

Line 63: hz_party_site_uses hpsu

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

Line 333: hz_party_site_uses hpsu

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

Line 344: hz_party_site_uses hpsu

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

Line 358: hz_party_site_uses hpsu

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

Line 675: WSH_SUPPLIER_PARTY.Create_HZ_Party_Site_uses

671: --
672: -- Now create a party Site use record for the party site that we
673: -- just created above.
674: --
675: WSH_SUPPLIER_PARTY.Create_HZ_Party_Site_uses
676: (
677: P_party_site_id => l_to_party_site_id,
678: P_site_use_type => 'SUPPLIER_SHIP_FROM',
679: x_party_site_use_id => l_party_site_use_id,

Line 1167: hz_party_site_uses hpsu

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

Line 3377: hz_party_site_uses hzp

3373: SELECT pvs.location_id, hzp.party_site_use_id
3374: FROM po_vendors pov,
3375: po_vendor_sites pvs,
3376: hz_locations hz,
3377: hz_party_site_uses hzp
3378: WHERE pov.vendor_id = pvs.vendor_id
3379: AND pvs.location_id = hz.location_id
3380: AND pov.vendor_id = c_vendor_id
3381: AND (c_vendor_site is null or pvs.vendor_site_id = c_vendor_site)