View: WSH_SHIP_TO_LOCATIONS_V

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

View Text

SELECT WHZL.WSH_LOCATION_ID WSH_LOCATION_ID
, WHZL.UI_LOCATION_CODE UI_LOCATION_CODE
, WHZL.LOCATION_CODE || ':' || NVL(WHZL.CITY
, SUBSTRB(WHZL.ADDRESS1
, 1
, 60)) UI_SHORT_LOCATION_CODE
FROM WSH_LOCATIONS WHZL
, HZ_PARTIES HP
, HZ_CUST_ACCOUNTS HCA
, HZ_CUST_SITE_USES_ALL HCSU
, HZ_CUST_ACCT_SITES_ALL HCAS
, HZ_PARTY_SITES HPS
WHERE HCA.STATUS = 'A'
AND HCAS.STATUS = 'A'
AND HCSU.STATUS = 'A'
AND HCSU.SITE_USE_CODE = 'SHIP_TO'
AND HCA.CUST_ACCOUNT_ID = HCAS.CUST_ACCOUNT_ID
AND HCA.PARTY_ID = HP.PARTY_ID
AND HP.PARTY_ID = HPS.PARTY_ID
AND HCAS.PARTY_SITE_ID = HPS.PARTY_SITE_ID
AND HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID
AND NVL( HCSU.ORG_ID
, -999) = NVL( HCAS.ORG_ID
, -999)
AND HPS.LOCATION_ID = WHZL.SOURCE_LOCATION_ID
AND WHZL.LOCATION_SOURCE_CODE ='HZ' GROUP BY WHZL.WSH_LOCATION_ID
, WHZL.UI_LOCATION_CODE
, WHZL.LOCATION_CODE || ':' || NVL(WHZL.CITY
, SUBSTRB(WHZL.ADDRESS1
, 1
, 60))

Columns