[Home] [Help]
| Product: | OKL - Leasing and Finance Management |
|---|---|
| Description: | View for table OKL_CURE_REP_AMTS_B |
| Implementation/DBA Data: | Not implemented in this database |
SELECT CRAB.ROWID ROW_ID
, CRAB.ID ID
, CRAB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CRAT.SFWT_FLAG SFWT_FLAG
, CRAB.CCF_ID CCF_ID
, CRAB.TAI_ID TAI_ID
, CRAB.TAI_ID_GENERATE TAI_ID_GENERATE
, CRAB.CURE_AMOUNT CURE_AMOUNT
, CRAT.PERIOD PERIOD
, CRAB.REPURCHASE_AMOUNT REPURCHASE_AMOUNT
, CRAB.RUN_DATE RUN_DATE
, CRAB.DNZ_PROGRAM_ID DNZ_PROGRAM_ID
, CRAT.COMMENTS COMMENTS
, CRAB.EXCLUDED_FLAG EXCLUDED_FLAG
, CRAB.RECONCILE_FLAG RECONCILE_FLAG
, CRAB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CRAB.ATTRIBUTE1 ATTRIBUTE1
, CRAB.ATTRIBUTE2 ATTRIBUTE2
, CRAB.ATTRIBUTE3 ATTRIBUTE3
, CRAB.ATTRIBUTE4 ATTRIBUTE4
, CRAB.ATTRIBUTE5 ATTRIBUTE5
, CRAB.ATTRIBUTE6 ATTRIBUTE6
, CRAB.ATTRIBUTE7 ATTRIBUTE7
, CRAB.ATTRIBUTE8 ATTRIBUTE8
, CRAB.ATTRIBUTE9 ATTRIBUTE9
, CRAB.ATTRIBUTE10 ATTRIBUTE10
, CRAB.ATTRIBUTE11 ATTRIBUTE11
, CRAB.ATTRIBUTE12 ATTRIBUTE12
, CRAB.ATTRIBUTE13 ATTRIBUTE13
, CRAB.ATTRIBUTE14 ATTRIBUTE14
, CRAB.ATTRIBUTE15 ATTRIBUTE15
, CRAB.ORG_ID ORG_ID
, CRAB.REQUEST_ID REQUEST_ID
, CRAB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, CRAB.PROGRAM_ID PROGRAM_ID
, CRAB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CRAB.CREATED_BY CREATED_BY
, CRAB.CREATION_DATE CREATION_DATE
, CRAB.LAST_UPDATED_BY LAST_UPDATED_BY
, CRAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CRAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM ZOKL_CURE_REP_AMTS_B CRAB
, ZOKL_CURE_REP_AMTS_TL CRAT
WHERE CRAB.ID = CRAT.ID
AND CRAT.LANGUAGE = USERENV('LANG')