View: WSH_SUPPLIER_SF_SITES_V

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSH_SUPPLIER_SF_SITES_V

View Text

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'

Columns