View: CSC_ACCT_RELATIONSHIP_V

Product:	CSC - Customer Care
Description:	CSC_ACCT_RELATIONSHIP_V retrieves related accounts for a customer account.
Implementation/DBA Data:	APPS.CSC_ACCT_RELATIONSHIP_V

View Text

SELECT ACCT_RELATE.ROWID
, ACCT_RELATE.CUST_ACCOUNT_ID
, ACCT_RELATE.RELATED_CUST_ACCOUNT_ID
, CUST_ACCT.ACCOUNT_NAME
, CUST_ACCT.ACCOUNT_NUMBER
, ACCT_RELATE.RELATIONSHIP_TYPE
, RELATION_LOOKUP.DESCRIPTION
, ACCT_RELATE.CUSTOMER_RECIPROCAL_FLAG
, ACCT_RELATE.STATUS
, STATUS_LOOKUP.DESCRIPTION
, ACCT_RELATE.LAST_UPDATE_DATE
, ACCT_RELATE.LAST_UPDATED_BY
, ACCT_RELATE.CREATION_DATE
, ACCT_RELATE.CREATED_BY
, ACCT_RELATE.LAST_UPDATE_LOGIN
, ACCT_RELATE.ATTRIBUTE_CATEGORY
, ACCT_RELATE.ATTRIBUTE1
, ACCT_RELATE.ATTRIBUTE2
, ACCT_RELATE.ATTRIBUTE3
, ACCT_RELATE.ATTRIBUTE4
, ACCT_RELATE.ATTRIBUTE5
, ACCT_RELATE.ATTRIBUTE6
, ACCT_RELATE.ATTRIBUTE7
, ACCT_RELATE.ATTRIBUTE8
, ACCT_RELATE.ATTRIBUTE9
, ACCT_RELATE.ATTRIBUTE10
, ACCT_RELATE.ATTRIBUTE11
, ACCT_RELATE.ATTRIBUTE12
, ACCT_RELATE.ATTRIBUTE13
, ACCT_RELATE.ATTRIBUTE14
, ACCT_RELATE.ATTRIBUTE15
FROM HZ_CUST_ACCT_RELATE ACCT_RELATE
, HZ_CUST_ACCOUNTS CUST_ACCT
, AR_LOOKUPS STATUS_LOOKUP
, AR_LOOKUPS RELATION_LOOKUP
WHERE ACCT_RELATE.RELATED_CUST_ACCOUNT_ID = CUST_ACCT.CUST_ACCOUNT_ID
AND ACCT_RELATE.STATUS = STATUS_LOOKUP.LOOKUP_CODE
AND ACCT_RELATE.RELATIONSHIP_TYPE = RELATION_LOOKUP.LOOKUP_CODE (+)
AND STATUS_LOOKUP.LOOKUP_TYPE = 'CODE_STATUS'
AND RELATION_LOOKUP.LOOKUP_TYPE(+) = 'RELATIONSHIP_TYPE'

Columns