Skip to content
[Home] [Help]
View: ICX_PANEL_RELATION_TYPE_V
View Text
SELECT CUSTOMER_ID
, COUNT(*)
FROM RA_CUSTOMER_RELATIONSHIPS
WHERE STATUS = 'A'
AND CUSTOMER_RECIPROCAL_FLAG = 'Y' GROUP BY CUSTOMER_ID
Columns
| Name |
| CUSTOMER_ID |
| TOT_NUM_RECIPROCAL_REL_SHIPS |