Product: | CSC - Customer Care |
---|---|
Description: | View for ACCOUNTS tab based on HZ_CUST_ACCOUNTS and AR_LOOKUPS |
Implementation/DBA Data: | APPS.CSC_ACCOUNT_BALI_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
, 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
WHERE ACCT.STATUS = AR.LOOKUP_CODE
AND AR.LOOKUP_TYPE = 'CODE_STATUS'