[Home] [Help]
| Product: | WSH - Shipping Execution |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT RCU.CUSTOMER_ID CUSTOMER_ID
, WTA.ADDRESS_ID ADDRESS_ID
, RCO.CONTACT_ID CONTACT_ID
, 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(RCO.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
WHERE RCO.ADDRESS_ID = WTA.ADDRESS_ID (+)
AND RCO.CUSTOMER_ID = RCU.CUSTOMER_ID
AND 'THIS VIEW IS OBSOLETE
FROM PATCHSET I ONWARDS' = 'TRUE'