[Home] [Help]
View: SO_BILL_TO_CONTACTS_V
Product: | OE - Order Entry |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
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(+)
, 'BILL_TO') = 'BILL_TO'
Columns
Name |
LAST_NAME |
FIRST_NAME |
FULL_NAME |
JOB_TITLE |
AREA_CODE |
PHONE_NUMBER |
EXTENSION |
PHONE_NUMBER_LONG |
CONTACT_ID |
CUSTOMER_ID |