[Home] [Help]
| Product: | OKL - Leasing and Finance Management |
|---|---|
| Description: | View for table OKL_CURE_REP_ADVCES_B |
| Implementation/DBA Data: | Not implemented in this database |
SELECT CRVB.ROWID ROW_ID
, CRVB.ID ID
, CRVB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CRVT.SFWT_FLAG SFWT_FLAG
, CRVB.IPV_ID IPV_ID
, CRVB.XCM_CODE XCM_CODE
, CRVB.OKL_CC_VD_ID OKL_CC_VD_ID
, CRVT.PERIOD PERIOD
, CRVB.ADVICE_RUN_DATE ADVICE_RUN_DATE
, CRVB.PAYMENT_DUE_DATE PAYMENT_DUE_DATE
, CRVB.CHEQUE_NUMBER CHEQUE_NUMBER
, CRVB.CHEQUE_AMOUNT CHEQUE_AMOUNT
, CRVB.CHEQUE_RECEIVED_DATE CHEQUE_RECEIVED_DATE
, CRVT.COMMENTS COMMENTS
, CRVB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CRVB.ATTRIBUTE1 ATTRIBUTE1
, CRVB.ATTRIBUTE2 ATTRIBUTE2
, CRVB.ATTRIBUTE3 ATTRIBUTE3
, CRVB.ATTRIBUTE4 ATTRIBUTE4
, CRVB.ATTRIBUTE5 ATTRIBUTE5
, CRVB.ATTRIBUTE6 ATTRIBUTE6
, CRVB.ATTRIBUTE7 ATTRIBUTE7
, CRVB.ATTRIBUTE8 ATTRIBUTE8
, CRVB.ATTRIBUTE9 ATTRIBUTE9
, CRVB.ATTRIBUTE10 ATTRIBUTE10
, CRVB.ATTRIBUTE11 ATTRIBUTE11
, CRVB.ATTRIBUTE12 ATTRIBUTE12
, CRVB.ATTRIBUTE13 ATTRIBUTE13
, CRVB.ATTRIBUTE14 ATTRIBUTE14
, CRVB.ATTRIBUTE15 ATTRIBUTE15
, CRVB.ORG_ID ORG_ID
, CRVB.REQUEST_ID REQUEST_ID
, CRVB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, CRVB.PROGRAM_ID PROGRAM_ID
, CRVB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CRVB.CREATED_BY CREATED_BY
, CRVB.CREATION_DATE CREATION_DATE
, CRVB.LAST_UPDATED_BY LAST_UPDATED_BY
, CRVB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CRVB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM ZOKL_CURE_REP_ADVCES_B CRVB
, ZOKL_CURE_REP_ADVCES_TL CRVT
WHERE CRVB.ID = CRVT.ID
AND CRVT.LANGUAGE = USERENV('LANG')