[Home] [Help]
View: ICX_RELATIONSHIPS_COUNT_V
Product: | ICX - Oracle iProcurement |
Description: | Obsolete |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT CUSTOMER_ID
, COUNT(*)
FROM RA_CUSTOMER_RELATIONSHIPS
WHERE STATUS = 'A' GROUP BY CUSTOMER_ID
Columns
Name |
CUSTOMER_ID |
TOT_NUM_RELATIONSHIPS |