View: SO_CONTACTS_ACTIVE_V

View Text

SELECT RC.LAST_NAME
, RC.FIRST_NAME
, RC.LAST_NAME || '
, ' || RC.FIRST_NAME FULL_NAME
, RC.JOB_TITLE
, RPH.AREA_CODE
, RPH.PHONE_NUMBER
, RPH.EXTENSION
, DECODE(AREA_CODE
, ''
, ''
, '(' || AREA_CODE || ') ' || PHONE_NUMBER || DECODE(EXTENSION
, ''
, ''
, ' EXT ' || EXTENSION)) PHONE_NUMBER_LONG
, RC.CONTACT_ID
, RC.CUSTOMER_ID
FROM RA_PHONES RPH
, RA_CONTACTS RC
WHERE RC.STATUS = 'A'
AND RC.CONTACT_ID = RPH.CONTACT_ID(+)
AND NVL(RPH.PRIMARY_FLAG(+)
, 'N') = 'Y'
AND NVL(RPH.STATUS(+)
, 'A') = 'A'

Columns