Product: | OKL - Leasing and Finance Management |
---|---|
Description: | View for table OKL_CSE_K_STASTICS |
Implementation/DBA Data: | Not implemented in this database |
SELECT CCSB.ROWID ROW_ID
, CCSB.ID ID
, CCSB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CCSB.CCC_ID CCC_ID
, CCSB.SEQUENCE_NUMBER SEQUENCE_NUMBER
, CCSB.AS_OF_DATE AS_OF_DATE
, CCSB.PAST_DUE_AMOUNT PAST_DUE_AMOUNT
, CCSB.DAYS_PAST_DUE DAYS_PAST_DUE
, CCSB.TOTAL_DUE_AMOUNT TOTAL_DUE_AMOUNT
, CCSB.NEXT_INVOICE_DATE NEXT_INVOICE_DATE
, CCSB.NEXT_INVOICE_AMOUNT NEXT_INVOICE_AMOUNT
, CCSB.LAST_INVOICE_DATE LAST_INVOICE_DATE
, CCSB.LAST_INVOICE_DUE_DATE LAST_INVOICE_DUE_DATE
, CCSB.LAST_INVOICE_AMOUNT LAST_INVOICE_AMOUNT
, CCSB.LAST_PAYMENT_AMOUNT LAST_PAYMENT_AMOUNT
, CCSB.LAST_PAYMENT_METHOD LAST_PAYMENT_METHOD
, CCSB.NUMBER_PAST_DUE_30 NUMBER_PAST_DUE_30
, CCSB.NUMBER_PAST_DUE_45 NUMBER_PAST_DUE_45
, CCSB.NUMBER_PAST_DUE_60 NUMBER_PAST_DUE_60
, CCSB.NUMBER_PAST_DUE_90 NUMBER_PAST_DUE_90
, CCSB.LAST_PAYMENT_STATUS LAST_PAYMENT_STATUS
, CCSB.NUMBER_OF_NSF_FEES NUMBER_OF_NSF_FEES
, CCSB.TOTAL_NUMBER_OF_PAYMENTS TOTAL_NUMBER_OF_PAYMENTS
, CCSB.REMAINING_NUMBER_OF_PAYMENTS REMAINING_NUMBER_OF_PAYMENTS
, CCSB.TOTAL_OVERDUE_INVOICES TOTAL_OVERDUE_INVOICES
, CCSB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CCSB.ATTRIBUTE1 ATTRIBUTE1
, CCSB.ATTRIBUTE2 ATTRIBUTE2
, CCSB.ATTRIBUTE3 ATTRIBUTE3
, CCSB.ATTRIBUTE4 ATTRIBUTE4
, CCSB.ATTRIBUTE5 ATTRIBUTE5
, CCSB.ATTRIBUTE6 ATTRIBUTE6
, CCSB.ATTRIBUTE7 ATTRIBUTE7
, CCSB.ATTRIBUTE8 ATTRIBUTE8
, CCSB.ATTRIBUTE9 ATTRIBUTE9
, CCSB.ATTRIBUTE10 ATTRIBUTE10
, CCSB.ATTRIBUTE11 ATTRIBUTE11
, CCSB.ATTRIBUTE12 ATTRIBUTE12
, CCSB.ATTRIBUTE13 ATTRIBUTE13
, CCSB.ATTRIBUTE14 ATTRIBUTE14
, CCSB.ATTRIBUTE15 ATTRIBUTE15
, CCSB.ORG_ID ORG_ID
, CCSB.REQUEST_ID REQUEST_ID
, CCSB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, CCSB.PROGRAM_ID PROGRAM_ID
, CCSB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CCSB.CREATED_BY CREATED_BY
, CCSB.CREATION_DATE CREATION_DATE
, CCSB.LAST_UPDATED_BY LAST_UPDATED_BY
, CCSB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CCSB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM ZOKL_CSE_K_STATS CCSB