[Home] [Help]
View: SO_CUSTOMERS_CR_V
Product: | OE - Order Entry |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT RC.CUSTOMER_NAME
, RC.CUSTOMER_NUMBER
, RC.CUSTOMER_ID
, RELATED_CUSTOMER_ID
FROM RA_CUSTOMERS RC
, RA_CUSTOMER_RELATIONSHIPS RCR
WHERE RC.CUSTOMER_ID = RCR.CUSTOMER_ID(+)
AND RCR.STATUS(+) = 'A'
AND RC.STATUS = 'A'
AND NVL(CUSTOMER_PROSPECT_CODE
, 'CUSTOMER') = 'CUSTOMER'
Columns
Name |
CUSTOMER_NAME |
CUSTOMER_NUMBER |
CUSTOMER_ID |
RELATED_CUSTOMER_ID |