Product: | AS - Sales Foundation |
---|---|
Description: | Contact names view |
Implementation/DBA Data: | Not implemented in this database |
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
, CUST.CUSTOMER_NAME
, CUST.CUSTOMER_NUMBER
, 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_CUSTOMERS CUST
, RA_ADDRESSES ADDR
, RA_CONTACTS CONT
WHERE CONT.CUSTOMER_ID = CUST.CUSTOMER_ID
AND CONT.ADDRESS_ID = ADDR.ADDRESS_ID
AND ADDR.COUNTRY = TERR.TERRITORY_CODE(+)
AND TERR.LANGUAGE(+) = USERENV('LANG')