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_RCO_ADDRESS

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

View Text

SELECT RCU.CUSTOMER_ID CUSTOMER_ID
, ETA.ADDRESS_ID ADDRESS_ID
, ECP.CONTACT_ID CONTACT_ID
, 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
WHERE ECP.ADDRESS_ID = ETA.ADDRESS_ID (+) AND ECP.CUSTOMER_ID = RCU.CUSTOMER_ID

Columns

Name
CUSTOMER_ID
ADDRESS_ID
CONTACT_ID
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