View: AS_CUSTOMER_CONTACTS_V

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