Product: | XNC - Sales for Communications (Obsolete) |
---|---|
Description: | XNC_CUST_ACCT_OVERVIEW_V retrieves an overview of the customer account. |
Implementation/DBA Data: | Not implemented in this database |
SELECT CUST_ACCT.ROWID
, CUST_ACCOUNT_ID
, CUST_ACCT.ORG_ID
, CUST_ACCT.PARTY_ID
, PARTIES.PARTY_NAME PARTY_NAME
, ACCOUNT_NUMBER
, ORIG_SYSTEM_REFERENCE
, CUST_ACCT.STATUS
, STATUS_LOOKUP.DESCRIPTION ACCOUNT_STATUS_DESCRIPTION
, DECODE(UPPER(HIGH_PRIORITY_INDICATOR)
, 'Y'
, 'HIGH'
, 'N'
, 'LOW'
, 'NOT SPECIFIED') ACCOUNT_PRIORITY
, CUSTOMER_TYPE
, CUSTOMER_CLASS_CODE
, PRIMARY_SALESREP_ID
, NAME PRIMARY_SALESREP_NAME
, CUST_ACCT.SALES_CHANNEL_CODE
, SALES_CHANNEL.SALES_CHANNEL SALES_CHANNEL_NAME
, SALES_CHANNEL.DESCRIPTION SALES_CHANNEL_DESCRIPTION
, NULL CATEGORY_CODE
, SUBCATEGORY_CODE
, TAX_CODE
, NULL THIRD_PARTY_FLAG
, NULL COMPETITOR_FLAG
, PAYMENT_TERM_ID
, TAX_ROUNDING_RULE
, CURRENT_BALANCE
, HIGH_PRIORITY_INDICATOR
, ACCOUNT_ESTABLISHED_DATE
, ACCOUNT_TERMINATION_DATE
, ACCOUNT_ACTIVATION_DATE
, HIGH_PRIORITY_REMARKS
, ACCOUNT_NAME
, DEPOSIT_REFUND_METHOD
, SUSPENSION_DATE
, WRITE_OFF_ADJUSTMENT_AMOUNT
, WRITE_OFF_PAYMENT_AMOUNT
, WRITE_OFF_AMOUNT
, SOURCE_CODE
, CUST_ACCT.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM JTF_CUST_ACCOUNTS_V CUST_ACCT
, ASO_I_SALES_CHANNELS_V SALES_CHANNEL
, RA_SALESREPS SALES_REP
, ASO_I_PARTIES_V PARTIES
, AR_LOOKUPS STATUS_LOOKUP
WHERE CUST_ACCT.SALES_CHANNEL_CODE = SALES_CHANNEL.SALES_CHANNEL_CODE (+)
AND CUST_ACCT.PRIMARY_SALESREP_ID = SALES_REP.SALESREP_ID (+)
AND CUST_ACCT.PARTY_ID = PARTIES.PARTY_ID
AND CUST_ACCT.STATUS = STATUS_LOOKUP.LOOKUP_CODE
AND STATUS_LOOKUP.LOOKUP_TYPE = 'CODE_STATUS'