[Home] [Help]
View: ICX_PANEL_RELATIONSHIPS_V
Product: | ICX - Oracle iProcurement |
Description: | Obsolete |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT REL.CUSTOMER_ID
, REL.RELATED_CUSTOMER_ID
, REL.CUSTOMER_RECIPROCAL_FLAG
, RA.CUSTOMER_NAME
, REL.COMMENTS
FROM RA_CUSTOMER_RELATIONSHIPS REL
, RA_CUSTOMERS RA
WHERE REL.STATUS = 'A'
AND RA.CUSTOMER_ID = REL.RELATED_CUSTOMER_ID
Columns
Name |
CUSTOMER_ID |
RELATED_CUSTOMER_ID |
CUSTOMER_RECIPROCAL_FLAG |
CUSTOMER_NAME |
COMMENTS |