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
, WTA.ADDRESS_ID ADDRESS_ID
, WTA.TP_HEADER_ID TP_HEADER_ID
, HCSU.CONTACT_ID CONTACT_ID
, HCSU.LOCATION LOCATION
, WTA.ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE
, WTA.TP_LOCATION_CODE_EXT TP_LOCATION_CODE_EXT
, WTA.TP_REFERENCE_EXT1 TP_REFERENCE_EXT1
, WTA.TP_REFERENCE_EXT2 TP_REFERENCE_EXT2
, RCU.CUSTOMER_NAME CUSTOMER_NAME
, WTA.ADDRESS1 ADDRESS1
, WTA.ADDRESS2 ADDRESS2
, WTA.ADDRESS3 ADDRESS3
, WTA.ADDRESS4 ADDRESS4
, WTA.CITY CITY
, WTA.POSTAL_CODE POSTAL_CODE
, WTA.COUNTRY COUNTRY
, WTA.STATE STATE
, WTA.PROVINCE PROVINCE
, WTA.COUNTY COUNTY
, RCO.LAST_NAME LAST_NAME
, RCO.FIRST_NAME FIRST_NAME
, RCO.JOB_TITLE JOB_TITLE
, WSH_ECE_VIEWS_DEF.GET_CONT_AREA_CODE(HCSU.CONTACT_ID) AREA_CODE
, WSH_ECE_VIEWS_DEF.GET_CONT_PHONE_NUMBER PHONE_NUMBER
FROM RA_CONTACTS RCO
, WSH_ADDRESS_TP_V WTA
, RA_CUSTOMERS RCU
, HZ_CUST_SITE_USES_ALL HCSU
WHERE HCSU.CONTACT_ID = RCO.CONTACT_ID (+)
AND WTA.CUSTOMER_ID = RCU.CUSTOMER_ID
AND HCSU.CUST_ACCT_SITE_ID = WTA.ADDRESS_ID
AND 'THIS VIEW IS OBSOLETE
FROM PATCHSET I ONWARDS' = 'TRUE'