[Home] [Help]
| Product: | WSH - Shipping Execution |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT HCSU.SITE_USE_ID SITE_USE_ID
, RCU.CUSTOMER_ID CUSTOMER_ID
, RAD.ADDRESS_ID ADDRESS_ID
, RAD.TP_HEADER_ID TP_HEADER_ID
, HCSU.LOCATION LOCATION
, RAD.ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE
, RAD.ECE_TP_LOCATION_CODE TP_LOCATION_CODE_EXT
, ETH.TP_REFERENCE_EXT1 TP_REFERENCE_EXT1
, ETH.TP_REFERENCE_EXT2 TP_REFERENCE_EXT2
, RCU.CUSTOMER_NAME CUSTOMER_NAME
, RAD.ADDRESS1 ADDRESS1
, RAD.ADDRESS2 ADDRESS2
, RAD.ADDRESS3 ADDRESS3
, RAD.ADDRESS4 ADDRESS4
, RAD.CITY CITY
, RAD.POSTAL_CODE POSTAL_CODE
, RAD.COUNTRY COUNTRY
, RAD.STATE STATE
, RAD.PROVINCE PROVINCE
, RAD.COUNTY COUNTY
, WSH_ECE_VIEWS_DEF.GET_CUST_AREA_CODE(RCU.CUSTOMER_ID) AREA_CODE
, WSH_ECE_VIEWS_DEF.GET_CONT_PHONE_NUMBER PHONE_NUMBER
, HCAS.CUST_ACCOUNT_ID
, HPS.LOCATION_ID
FROM RA_CUSTOMERS RCU
, RA_ADDRESSES RAD
, ECE_TP_HEADERS ETH
, HZ_CUST_SITE_USES_ALL HCSU
, HZ_CUST_ACCT_SITES_ALL HCAS
, HZ_PARTY_SITES HPS
WHERE RAD.TP_HEADER_ID = ETH.TP_HEADER_ID (+)
AND RAD.CUSTOMER_ID = RCU.CUSTOMER_ID
AND HCSU.CUST_ACCT_SITE_ID = RAD.ADDRESS_ID
AND HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID
AND HCAS.PARTY_SITE_ID = HPS.PARTY_SITE_ID
AND HCSU.SITE_USE_CODE = 'SHIP_TO'
AND HCSU.STATUS = 'A'
AND 'THIS VIEW IS OBSOLETE
FROM PATCHSET I ONWARDS' = 'TRUE' -- THIS VIEW HAS BEEN OBSOLETED
, NOBODY SHOULD USE THIS VIEW