eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: ECE_RSU_CONTACT

Product:	EC - e-Commerce Gateway
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT RSU.SITE_USE_ID SITE_USE_ID
, RCU.CUSTOMER_ID CUSTOMER_ID
, ETA.ADDRESS_ID ADDRESS_ID
, ETA.TP_HEADER_ID TP_HEADER_ID
, RSU.CONTACT_ID CONTACT_ID
, RSU.LOCATION LOCATION
, ETA.ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE
, ETA.TP_LOCATION_CODE_EXT TP_LOCATION_CODE_EXT
, ETA.TP_REFERENCE_EXT1 TP_REFERENCE_EXT1
, ETA.TP_REFERENCE_EXT2 TP_REFERENCE_EXT2
, RCU.CUSTOMER_NAME CUSTOMER_NAME
, ETA.ADDRESS1 ADDRESS1
, ETA.ADDRESS2 ADDRESS2
, ETA.ADDRESS3 ADDRESS3
, ETA.ADDRESS4 ADDRESS4
, ETA.CITY CITY
, ETA.POSTAL_CODE POSTAL_CODE
, ETA.COUNTRY COUNTRY
, ETA.STATE STATE
, ETA.PROVINCE PROVINCE
, ETA.COUNTY COUNTY
, ECP.LAST_NAME LAST_NAME
, ECP.FIRST_NAME FIRST_NAME
, ECP.JOB_TITLE JOB_TITLE
, ECP.AREA_CODE AREA_CODE
, ECP.PHONE_NUMBER PHONE_NUMBER
FROM ECE_CONTACT_PHONE ECP
, ECE_ADDRESS_TP ETA
, RA_CUSTOMERS RCU
, RA_SITE_USES_ALL RSU
WHERE RSU.CONTACT_ID = ECP.CONTACT_ID (+) AND ETA.CUSTOMER_ID = RCU.CUSTOMER_ID AND RSU.ADDRESS_ID = ETA.ADDRESS_ID

Columns

Name
SITE_USE_ID
CUSTOMER_ID
ADDRESS_ID
TP_HEADER_ID
CONTACT_ID
LOCATION
ORIG_SYSTEM_REFERENCE
TP_LOCATION_CODE_EXT
TP_REFERENCE_EXT1
TP_REFERENCE_EXT2
CUSTOMER_NAME
ADDRESS1
ADDRESS2
ADDRESS3
ADDRESS4
CITY
POSTAL_CODE
COUNTRY
STATE
PROVINCE
COUNTY
LAST_NAME
FIRST_NAME
JOB_TITLE
AREA_CODE
PHONE_NUMBER