Product: | XNC - Sales for Communications (Obsolete) |
---|---|
Description: | XNC_ACCT_RELATIONSHIP_V retrieves related accounts for a customer account. |
Implementation/DBA Data: | Not implemented in this database |
SELECT ACCT_RELATE.ROWID
, ACCT_RELATE.CUST_ACCOUNT_ID
, ACCT_RELATE.RELATED_CUST_ACCOUNT_ID
, CUST_ACCT.ACCOUNT_NAME RELATED_ACCOUNT_NAME
, CUST_ACCT.ACCOUNT_NUMBER RELATED_ACCOUNT_NUMBER
, ACCT_RELATE.LAST_UPDATE_DATE
, ACCT_RELATE.RELATIONSHIP_TYPE
, ACCT_RELATE.CUSTOMER_RECIPROCAL_FLAG
, ACCT_RELATE.STATUS RELATED_ACCOUNT_STATUS
, STATUS_LOOKUP.DESCRIPTION ACCOUNT_STATUS_DESCRIPTION
FROM JTF_HZ_CUST_ACCT_RELATE_V ACCT_RELATE
, JTF_CUST_ACCOUNTS_V CUST_ACCT
, AR_LOOKUPS STATUS_LOOKUP
WHERE ACCT_RELATE.RELATED_CUST_ACCOUNT_ID = CUST_ACCT.CUST_ACCOUNT_ID
AND ACCT_RELATE.STATUS = STATUS_LOOKUP.LOOKUP_CODE
AND STATUS_LOOKUP.LOOKUP_TYPE = 'CODE_STATUS'