[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 |