View: CSC_ACCOUNT_BALI_V

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

View Text

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'

Columns