[Home] [Help]
VIEW: APPS.WSH_SUPPLIER_SF_SITES_V
Source
View Text - Preformatted
SELECT hps.party_id, hps.party_site_id, hps.location_id, hps.party_site_number FROM hz_party_sites hps, hz_party_site_uses hpsu WHERE hps.party_site_id = hpsu.party_site_id AND hpsu.site_use_type = 'SUPPLIER_SHIP_FROM'
View Text - HTML Formatted
SELECT HPS.PARTY_ID
, HPS.PARTY_SITE_ID
, HPS.LOCATION_ID
, HPS.PARTY_SITE_NUMBER
FROM HZ_PARTY_SITES HPS
, HZ_PARTY_SITE_USES HPSU
WHERE HPS.PARTY_SITE_ID = HPSU.PARTY_SITE_ID
AND HPSU.SITE_USE_TYPE = 'SUPPLIER_SHIP_FROM'