View: WSH_CUSTOMER_LOCATIONS_V

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSH_CUSTOMER_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
, WHZL.ADDRESS1 ADDRESS1
, WHZL.ADDRESS2 ADDRESS2
, WHZL.ADDRESS3 ADDRESS3
, WHZL.ADDRESS4 ADDRESS4
, WHZL.CITY CITY
, WHZL.POSTAL_CODE POSTAL_CODE
, WHZL.COUNTRY COUNTRY
, WHZL.STATE STATE
, WHZL.PROVINCE PROVINCE
, WHZL.COUNTY COUNTY
, WHZL.SOURCE_LOCATION_ID SOURCE_LOCATION_ID
, WHZL.INACTIVE_DATE
, HP.DUNS_NUMBER
, HPS.PARTY_SITE_NUMBER
, HCA.CUST_ACCOUNT_ID CUSTOMER_ID
, SUBSTRB(HP.PARTY_NAME
, 1
, 50) CUSTOMER_NAME
, HCA.ACCOUNT_NUMBER CUSTOMER_NUMBER
, HCA.STATUS CUSTOMER_STATUS
, HCAS.CUST_ACCT_SITE_ID ADDRESS_ID
, HCAS.TP_HEADER_ID TP_HEADER_ID
, HCAS.ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE
, HCAS.ECE_TP_LOCATION_CODE TP_LOCATION_CODE_EXT
, HCAS.ORG_ID
, HCAS.STATUS CUST_ACCT_SITE_STATUS
, HCSU.SITE_USE_ID SITE_USE_ID
, HCSU.SITE_USE_CODE SITE_USE_CODE
, HCSU.LOCATION LOCATION
, HCSU.GSA_INDICATOR
, HCSU.STATUS SITE_USE_STATUS
, HCSU.PRIMARY_FLAG
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.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'

Columns