DBA Data[Home] [Help]

APPS.WSH_UTIL_VALIDATE dependencies on HZ_PARTY_SITE_USES

Line 4602: hz_party_site_uses hpsu

4598: CURSOR locn_csr (p_location_id IN NUMBER, p_party_id IN NUMBER)
4599: IS
4600: SELECT 1
4601: FROM hz_party_sites hps,
4602: hz_party_site_uses hpsu
4603: WHERE hps.party_id = p_party_id
4604: AND hps.location_id = p_location_id
4605: AND hpsu.party_site_id = hps.party_site_id
4606: AND hpsu.site_use_type = 'SUPPLIER_SHIP_FROM';