Product: | OKL - Leasing and Finance Management |
---|---|
Description: | Stores details at line level when refunds are made against a contract |
Implementation/DBA Data: | Not implemented in this database |
SELECT CRL.ROWID ROW_ID
, CRL.CURE_REFUND_LINE_ID CURE_REFUND_LINE_ID
, CRL.CURE_REFUND_ID CURE_REFUND_ID
, CRL.ORG_ID ORG_ID
, CRL.AMOUNT AMOUNT
, CRL.TRANSACTION_ID TRANSACTION_ID
, CRL.STATUS STATUS
, CRL.APPROVAL_STATUS APPROVAL_STATUS
, CRL.APPROVAL_REASON APPROVAL_REASON
, CRL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CRL.REQUEST_ID REQUEST_ID
, CRL.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, CRL.PROGRAM_ID PROGRAM_ID
, CRL.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CRL.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CRL.ATTRIBUTE1 ATTRIBUTE1
, CRL.ATTRIBUTE2 ATTRIBUTE2
, CRL.ATTRIBUTE3 ATTRIBUTE3
, CRL.ATTRIBUTE4 ATTRIBUTE4
, CRL.ATTRIBUTE5 ATTRIBUTE5
, CRL.ATTRIBUTE6 ATTRIBUTE6
, CRL.ATTRIBUTE7 ATTRIBUTE7
, CRL.ATTRIBUTE8 ATTRIBUTE8
, CRL.ATTRIBUTE9 ATTRIBUTE9
, CRL.ATTRIBUTE10 ATTRIBUTE10
, CRL.ATTRIBUTE11 ATTRIBUTE11
, CRL.ATTRIBUTE12 ATTRIBUTE12
, CRL.ATTRIBUTE13 ATTRIBUTE13
, CRL.ATTRIBUTE14 ATTRIBUTE14
, CRL.ATTRIBUTE15 ATTRIBUTE15
, CRL.CREATED_BY CREATED_BY
, CRL.CREATION_DATE CREATION_DATE
, CRL.LAST_UPDATED_BY LAST_UPDATED_BY
, CRL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CRL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKL_CURE_REFUND_LINES CRL