[Home] [Help]
| Product: | OKL - Leasing and Finance Management |
|---|---|
| Description: | View for table OKL_CSE_K_WRITEOFFS_B |
| Implementation/DBA Data: | Not implemented in this database |
SELECT CCWB.ROWID ROW_ID
, CCWB.ID ID
, CCWB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CCWT.SFWT_FLAG SFWT_FLAG
, CCWB.CAC_ID CAC_ID
, CCWT.AMO_REPOSSES AMO_REPOSSES
, CCWB.GURANTOR_CONTACT_DATE GURANTOR_CONTACT_DATE
, CCWT.WRITEOFF_COMMENTS WRITEOFF_COMMENTS
, CCWB.EQUIPMENT_STATUS_RECORDED_YN EQUIPMENT_STATUS_RECORDED_YN
, CCWB.DEMAND_LETTER_SENT_DATE DEMAND_LETTER_SENT_DATE
, CCWB.PAYMENT_CONCLUDE_YN PAYMENT_CONCLUDE_YN
, CCWB.BALANCE_PURSUIT_YN BALANCE_PURSUIT_YN
, CCWB.RECOURSE_YN RECOURSE_YN
, CCWB.WRITEOFF_REQUEST_DATE WRITEOFF_REQUEST_DATE
, CCWB.WRITEOFF_SCORE WRITEOFF_SCORE
, CCWB.WRITEOFF_STATUS WRITEOFF_STATUS
, CCWB.WRITEOFF_AMOUNT WRITEOFF_AMOUNT
, CCWB.WRITEOFF_TYPE WRITEOFF_TYPE
, CCWB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CCWB.ATTRIBUTE1 ATTRIBUTE1
, CCWB.ATTRIBUTE2 ATTRIBUTE2
, CCWB.ATTRIBUTE3 ATTRIBUTE3
, CCWB.ATTRIBUTE4 ATTRIBUTE4
, CCWB.ATTRIBUTE5 ATTRIBUTE5
, CCWB.ATTRIBUTE6 ATTRIBUTE6
, CCWB.ATTRIBUTE7 ATTRIBUTE7
, CCWB.ATTRIBUTE8 ATTRIBUTE8
, CCWB.ATTRIBUTE9 ATTRIBUTE9
, CCWB.ATTRIBUTE10 ATTRIBUTE10
, CCWB.ATTRIBUTE11 ATTRIBUTE11
, CCWB.ATTRIBUTE12 ATTRIBUTE12
, CCWB.ATTRIBUTE13 ATTRIBUTE13
, CCWB.ATTRIBUTE14 ATTRIBUTE14
, CCWB.ATTRIBUTE15 ATTRIBUTE15
, CCWB.DLM_CODE DLM_CODE
, CCWB.SEQUENCE_NUMBER SEQUENCE_NUMBER
, CCWB.ORG_ID ORG_ID
, CCWB.REQUEST_ID REQUEST_ID
, CCWB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, CCWB.PROGRAM_ID PROGRAM_ID
, CCWB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CCWB.CREATED_BY CREATED_BY
, CCWB.CREATION_DATE CREATION_DATE
, CCWB.LAST_UPDATED_BY LAST_UPDATED_BY
, CCWB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CCWB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM ZOKL_CSE_K_WRITEOFFS_B CCWB
, ZOKL_CSE_K_WRITEOFFS_TL CCWT
WHERE CCWB.ID = CCWT.ID
AND CCWT.LANGUAGE = USERENV('LANG')