View: SO_SHIP_TO_CONTACTS_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
, RA_CONTACT_ROLES RCR
WHERE RC.STATUS = 'A'
AND RC.CONTACT_ID = RPH.CONTACT_ID(+)
AND RC.CONTACT_ID = RCR.CONTACT_ID(+)
AND NVL(RPH.PRIMARY_FLAG(+)
, 'N') = 'Y'
AND NVL(RPH.STATUS(+)
, 'A') = 'A'
AND NVL(RCR.USAGE_CODE
, 'SHIP_TO') = 'SHIP_TO'

Columns