VIEW: APPS.AST_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.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 , acct_relate.object_version_number , acct_relate.created_by_module , acct_relate.application_id, acct_relate.org_id 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.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
, ACCT_RELATE.OBJECT_VERSION_NUMBER
, ACCT_RELATE.CREATED_BY_MODULE
, ACCT_RELATE.APPLICATION_ID
, ACCT_RELATE.ORG_ID
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'