VIEW: APPS.WSH_SHIP_TO_LOCATIONS_V

Source

View Text - Preformatted

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))

View Text - HTML Formatted

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))