DBA Data[Home] [Help]

APPS.WSH_UTIL_VALIDATE dependencies on HZ_PARTY_SITE_USES

Line 4646: hz_party_site_uses hpsu

4642: CURSOR locn_csr (p_location_id IN NUMBER, p_party_id IN NUMBER)
4643: IS
4644: SELECT 1
4645: FROM hz_party_sites hps,
4646: hz_party_site_uses hpsu
4647: WHERE hps.party_id = p_party_id
4648: AND hps.location_id = p_location_id
4649: AND hpsu.party_site_id = hps.party_site_id
4650: AND hpsu.site_use_type = 'SUPPLIER_SHIP_FROM';