eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: XNC_ACCT_RELATIONSHIP_V

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

View Text

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'

Columns

Name
ROW_ID
CUST_ACCOUNT_ID
RELATED_CUST_ACCOUNT_ID
RELATED_ACCOUNT_NAME
RELATED_ACCOUNT_NUMBER
LAST_UPDATE_DATE
RELATIONSHIP_TYPE
CUSTOMER_RECIPROCAL_FLAG
RELATED_ACCOUNT_STATUS
ACCOUNT_STATUS_DESCRIPTION