Product: | AS - Sales Foundation |
---|---|
Description: | Customer relationships view |
Implementation/DBA Data: | Not implemented in this database |
SELECT REL.ROWID
, REL.RELATED_CUSTOMER_ID
, REL.CUSTOMER_ID
, REL.LAST_UPDATE_DATE
, REL.LAST_UPDATED_BY
, REL.CREATION_DATE
, REL.CREATED_BY
, REL.LAST_UPDATE_LOGIN
, REL.RELATIONSHIP_TYPE
, LOOK1.MEANING
, CUST1.CUSTOMER_NAME
, CUST1.CUSTOMER_NUMBER
, CUST2.CUSTOMER_NAME
, CUST2.CUSTOMER_NUMBER
, REL.STATUS
, REL.COMMENTS
, REL.CUSTOMER_RECIPROCAL_FLAG
, REL.REQUEST_ID
, REL.PROGRAM_APPLICATION_ID
, REL.PROGRAM_ID
, REL.PROGRAM_UPDATE_DATE
, REL.ATTRIBUTE_CATEGORY
, REL.ATTRIBUTE1
, REL.ATTRIBUTE2
, REL.ATTRIBUTE3
, REL.ATTRIBUTE4
, REL.ATTRIBUTE5
, REL.ATTRIBUTE6
, REL.ATTRIBUTE7
, REL.ATTRIBUTE8
, REL.ATTRIBUTE9
, REL.ATTRIBUTE10
, REL.ATTRIBUTE11
, REL.ATTRIBUTE12
, REL.ATTRIBUTE13
, REL.ATTRIBUTE14
, REL.ATTRIBUTE15
FROM RA_CUSTOMER_RELATIONSHIPS REL
, AR_LOOKUPS LOOK1
, RA_CUSTOMERS CUST2
, RA_CUSTOMERS CUST1
WHERE REL.RELATED_CUSTOMER_ID = CUST2.CUSTOMER_ID
AND REL.CUSTOMER_ID = CUST1.CUSTOMER_ID
AND REL.RELATIONSHIP_TYPE = LOOK1.LOOKUP_CODE(+)
AND LOOK1.LOOKUP_TYPE(+) = 'RELATIONSHIP_TYPE'