[Home] [Help]
View: AS_CUSTOMER_CONTACTS_V
Product: | AS - Sales Foundation |
Description: | Customer contacts view |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT CONT.CONTACT_ID
, CONT.LAST_NAME
, CONT.FIRST_NAME
, CONT.CONTACT_NUMBER
, CONT.JOB_TITLE
, CONT.STATUS
, DECODE(CONT.STATUS
, 'A'
, '*'
, NULL) ACTIVE
, CONT.CUSTOMER_ID
, CONT.ADDRESS_ID
, CONT.ADDRESS_ID
, ADDR.ADDRESS1
, ADDR.CITY
, ADDR.STATE
, ADDR.PROVINCE
, ADDR.STATE || DECODE(ADDR.STATE
, NULL
, NULL
, DECODE(ADDR.PROVINCE
, NULL
, NULL
, '/')) || ADDR.PROVINCE
, ADDR.POSTAL_CODE
, TERR.TERRITORY_SHORT_NAME
FROM FND_TERRITORIES_TL TERR
, RA_ADDRESSES ADDR
, RA_CONTACTS CONT
WHERE CONT.ADDRESS_ID = ADDR.ADDRESS_ID
AND ADDR.COUNTRY = TERR.TERRITORY_CODE(+)
AND TERR.LANGUAGE(+) = USERENV('LANG')
Columns
Name |
CONTACT_ID |
LAST_NAME |
FIRST_NAME |
CONTACT_NUMBER |
JOB_TITLE |
STATUS_CODE |
ACTIVE |
CUSTOMER_ID |
ACCOUNT_CODE |
ADDRESS_ID |
ADDRESS1 |
CITY |
STATE |
PROVINCE |
STATE_PROVINCE |
POSTAL_CODE |
COUNTRY |