Product: | CSC - Customer Care |
---|---|
Description: | CSC_ACCOUNT_OVERVIEW_V retrieves an overview of the customer account. |
Implementation/DBA Data: | APPS.CSC_ACCOUNT_OVERVIEW_V |
SELECT ACCT.ROWID
, ACCT.CUST_ACCOUNT_ID
, ACCT.ORG_ID
, ACCT.PARTY_ID
, ACCT.ACCOUNT_NUMBER
, ACCT.ORIG_SYSTEM_REFERENCE
, ACCT.STATUS
, AR.DESCRIPTION
, ACCT.CUSTOMER_TYPE
, ACCT.CUSTOMER_CLASS_CODE
, NULL
, ACCT.SUBCATEGORY_CODE
, ACCT.TAX_CODE
, NULL
, NULL
, ACCT.PAYMENT_TERM_ID
, PAY_TERMS.NAME
, ACCT.TAX_ROUNDING_RULE
, ACCT.CURRENT_BALANCE
, ACCT.HIGH_PRIORITY_INDICATOR
, ACCT.ACCOUNT_ESTABLISHED_DATE
, ACCT.ACCOUNT_TERMINATION_DATE
, ACCT.ACCOUNT_ACTIVATION_DATE
, ACCT.HIGH_PRIORITY_REMARKS
, ACCT.ACCOUNT_NAME
, ACCT.DEPOSIT_REFUND_METHOD
, ACCT.SUSPENSION_DATE
, ACCT.WRITE_OFF_ADJUSTMENT_AMOUNT
, ACCT.WRITE_OFF_PAYMENT_AMOUNT
, ACCT.WRITE_OFF_AMOUNT
, ACCT.SOURCE_CODE
, ACCT.LAST_UPDATE_DATE
, ACCT.LAST_UPDATED_BY
, ACCT.CREATION_DATE
, ACCT.CREATED_BY
, ACCT.LAST_UPDATE_LOGIN
, ACCT.ATTRIBUTE_CATEGORY
, ACCT.ATTRIBUTE1
, ACCT.ATTRIBUTE2
, ACCT.ATTRIBUTE3
, ACCT.ATTRIBUTE4
, ACCT.ATTRIBUTE5
, ACCT.ATTRIBUTE6
, ACCT.ATTRIBUTE7
, ACCT.ATTRIBUTE8
, ACCT.ATTRIBUTE9
, ACCT.ATTRIBUTE10
, ACCT.ATTRIBUTE11
, ACCT.ATTRIBUTE12
, ACCT.ATTRIBUTE13
, ACCT.ATTRIBUTE14
, ACCT.ATTRIBUTE15
, ACCT.ATTRIBUTE16
, ACCT.ATTRIBUTE17
, ACCT.ATTRIBUTE18
, ACCT.ATTRIBUTE19
, ACCT.ATTRIBUTE20
FROM HZ_CUST_ACCOUNTS ACCT
, AR_LOOKUPS AR
, RA_TERMS_TL PAY_TERMS
WHERE ACCT.PAYMENT_TERM_ID = PAY_TERMS.TERM_ID(+)
AND ACCT.STATUS = AR.LOOKUP_CODE
AND AR.LOOKUP_TYPE = 'CODE_STATUS'
AND NVL(ACCT.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)
AND PAY_TERMS.LANGUAGE = USERENV('LANG')