VIEW: APPS.CSC_ACCT_RELATIONSHIP_V

Source

View Text - Preformatted

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.bill_to_flag ,acct_relate.ship_to_flag ,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.object_version_number ,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'

View Text - HTML Formatted

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.BILL_TO_FLAG
, ACCT_RELATE.SHIP_TO_FLAG
, 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.OBJECT_VERSION_NUMBER
, 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'