View: OKL_CS_CUST_ACCT_OVERVIEW_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_CS_CUST_ACCT_OVERVIEW_UV

View Text

SELECT CUST_ACCT.ROWID ROW_ID
, CUST_ACCT.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, CUST_ACCT.ORG_ID ORG_ID
, CUST_ACCT.PARTY_ID PARTY_ID
, CUST_ACCT.ACCOUNT_NUMBER ACCOUNT_NUMBER
, CUST_ACCT.ORIG_SYSTEM_REFERENCE
, CUST_ACCT.STATUS STATUS
, STATUS_LOOKUP.DESCRIPTION ACCOUNT_STATUS_DESCRIPTION
, CUST_ACCT.CUSTOMER_TYPE CUSTOMER_TYPE
, CUST_ACCT.CUSTOMER_CLASS_CODE CUSTOMER_CLASS_CODE
, NULL CATEGORY_CODE
, CUST_ACCT.SUBCATEGORY_CODE SUBCATEGORY_CODE
, CUST_ACCT.TAX_CODE TAX_CODE
, NULL THIRD_PARTY_FLAG
, NULL COMPETITOR_FLAG
, CUST_ACCT.PAYMENT_TERM_ID PAYMENT_TERM_ID
, PAY_TERMS.NAME PAYMENT_TERM_NAME
, CUST_ACCT.TAX_ROUNDING_RULE TAX_ROUNDING_RULE
, CUST_ACCT.CURRENT_BALANCE CURRENT_BALANCE
, CUST_ACCT.HIGH_PRIORITY_INDICATOR HIGH_PRIORITY_INDICATOR
, CUST_ACCT.ACCOUNT_ESTABLISHED_DATE ACCOUNT_ESTABLISHED_DATE
, CUST_ACCT.ACCOUNT_TERMINATION_DATE ACCOUNT_TERMINATION_DATE
, CUST_ACCT.ACCOUNT_ACTIVATION_DATE ACCOUNT_ACTIVATION_DATE
, CUST_ACCT.HIGH_PRIORITY_REMARKS HIGH_PRIORITY_REMARKS
, CUST_ACCT.ACCOUNT_NAME ACCOUNT_NAME
, CUST_ACCT.DEPOSIT_REFUND_METHOD DEPOSIT_REFUND_METHOD
, CUST_ACCT.SUSPENSION_DATE SUSPENSION_DATE
, CUST_ACCT.WRITE_OFF_ADJUSTMENT_AMOUNT WRITE_OFF_ADJUSTMENT_AMOUNT
, CUST_ACCT.WRITE_OFF_PAYMENT_AMOUNT WRITE_OFF_PAYMENT_AMOUNT
, CUST_ACCT.WRITE_OFF_AMOUNT WRITE_OFF_AMOUNT
, CUST_PROF.STATEMENT_CYCLE_ID STATEMENT_CYCLE_ID
, STMT_CYC.NAME STATEMENT_CYCLE_NAME
, CUST_ACCT.SOURCE_CODE SOURCE_CODE
, CUST_ACCT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CUST_ACCT.LAST_UPDATED_BY LAST_UPDATED_BY
, CUST_ACCT.CREATION_DATE CREATION_DATE
, CUST_ACCT.CREATED_BY CREATED_BY
, CUST_ACCT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CUST_ACCT.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CUST_ACCT.ATTRIBUTE1 ATTRIBUTE1
, CUST_ACCT.ATTRIBUTE2 ATTRIBUTE2
, CUST_ACCT.ATTRIBUTE3 ATTRIBUTE3
, CUST_ACCT.ATTRIBUTE4 ATTRIBUTE4
, CUST_ACCT.ATTRIBUTE5 ATTRIBUTE5
, CUST_ACCT.ATTRIBUTE6 ATTRIBUTE6
, CUST_ACCT.ATTRIBUTE7 ATTRIBUTE7
, CUST_ACCT.ATTRIBUTE8 ATTRIBUTE8
, CUST_ACCT.ATTRIBUTE9 ATTRIBUTE9
, CUST_ACCT.ATTRIBUTE10 ATTRIBUTE10
, CUST_ACCT.ATTRIBUTE11 ATTRIBUTE11
, CUST_ACCT.ATTRIBUTE12 ATTRIBUTE12
, CUST_ACCT.ATTRIBUTE13 ATTRIBUTE13
, CUST_ACCT.ATTRIBUTE14 ATTRIBUTE14
, CUST_ACCT.ATTRIBUTE15 ATTRIBUTE15
, CUST_ACCT.ATTRIBUTE16 ATTRIBUTE16
, CUST_ACCT.ATTRIBUTE17 ATTRIBUTE17
, CUST_ACCT.ATTRIBUTE18 ATTRIBUTE18
, CUST_ACCT.ATTRIBUTE19 ATTRIBUTE19
, CUST_ACCT.ATTRIBUTE20 ATTRIBUTE20
FROM HZ_CUST_ACCOUNTS CUST_ACCT
, AR_LOOKUPS STATUS_LOOKUP
, RA_TERMS_TL PAY_TERMS
, HZ_CUSTOMER_PROFILES CUST_PROF
, AR_STATEMENT_CYCLES STMT_CYC
WHERE CUST_ACCT.PAYMENT_TERM_ID = PAY_TERMS.TERM_ID(+)
AND CUST_ACCT.STATUS = STATUS_LOOKUP.LOOKUP_CODE
AND STATUS_LOOKUP.LOOKUP_TYPE = 'CODE_STATUS'
AND CUST_ACCT.CUST_ACCOUNT_ID = CUST_PROF.CUST_ACCOUNT_ID (+)
AND CUST_PROF.STATEMENT_CYCLE_ID = STMT_CYC.STATEMENT_CYCLE_ID (+)
AND CUST_PROF.SITE_USE_ID IS NULL
AND PAY_TERMS.LANGUAGE(+) = USERENV('LANG')

Columns