eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: OKL.OKL_SIF_RET_LEVELS#

Source

View Text - Preformatted


select ID ID, SIR_ID SIR_ID, INDEX_NUMBER INDEX_NUMBER, NUMBER_OF_PERIODS NUMBER_OF_PERIODS, LEVEL_INDEX_NUMBER LEVEL_INDEX_NUMBER, LEVEL_TYPE LEVEL_TYPE, AMOUNT AMOUNT, ADVANCE_OR_ARREARS ADVANCE_OR_ARREARS, PERIOD PERIOD, LOCK_LEVEL_STEP LOCK_LEVEL_STEP, DAYS_IN_PERIOD DAYS_IN_PERIOD, FIRST_PAYMENT_DATE FIRST_PAYMENT_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, STREAM_INTERFACE_ATTRIBUTE1 STREAM_INTERFACE_ATTRIBUTE1, STREAM_INTERFACE_ATTRIBUTE2 STREAM_INTERFACE_ATTRIBUTE2, STREAM_INTERFACE_ATTRIBUTE3 STREAM_INTERFACE_ATTRIBUTE3, STREAM_INTERFACE_ATTRIBUTE4 STREAM_INTERFACE_ATTRIBUTE4, STREAM_INTERFACE_ATTRIBUTE5 STREAM_INTERFACE_ATTRIBUTE5, STREAM_INTERFACE_ATTRIBUTE6 STREAM_INTERFACE_ATTRIBUTE6, STREAM_INTERFACE_ATTRIBUTE7 STREAM_INTERFACE_ATTRIBUTE7, STREAM_INTERFACE_ATTRIBUTE8 STREAM_INTERFACE_ATTRIBUTE8, STREAM_INTERFACE_ATTRIBUTE9 STREAM_INTERFACE_ATTRIBUTE9, STREAM_INTERFACE_ATTRIBUTE10 STREAM_INTERFACE_ATTRIBUTE10, STREAM_INTERFACE_ATTRIBUTE11 STREAM_INTERFACE_ATTRIBUTE11, STREAM_INTERFACE_ATTRIBUTE12 STREAM_INTERFACE_ATTRIBUTE12, STREAM_INTERFACE_ATTRIBUTE13 STREAM_INTERFACE_ATTRIBUTE13, STREAM_INTERFACE_ATTRIBUTE14 STREAM_INTERFACE_ATTRIBUTE14, STREAM_INTERFACE_ATTRIBUTE15 STREAM_INTERFACE_ATTRIBUTE15, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, RATE RATE, REAMORT_BALANCE REAMORT_BALANCE, REAMORT_DATE REAMORT_DATE from "OKL"."OKL_SIF_RET_LEVELS"

View Text - HTML Formatted

SELECT ID ID
, SIR_ID SIR_ID
, INDEX_NUMBER INDEX_NUMBER
, NUMBER_OF_PERIODS NUMBER_OF_PERIODS
, LEVEL_INDEX_NUMBER LEVEL_INDEX_NUMBER
, LEVEL_TYPE LEVEL_TYPE
, AMOUNT AMOUNT
, ADVANCE_OR_ARREARS ADVANCE_OR_ARREARS
, PERIOD PERIOD
, LOCK_LEVEL_STEP LOCK_LEVEL_STEP
, DAYS_IN_PERIOD DAYS_IN_PERIOD
, FIRST_PAYMENT_DATE FIRST_PAYMENT_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, STREAM_INTERFACE_ATTRIBUTE1 STREAM_INTERFACE_ATTRIBUTE1
, STREAM_INTERFACE_ATTRIBUTE2 STREAM_INTERFACE_ATTRIBUTE2
, STREAM_INTERFACE_ATTRIBUTE3 STREAM_INTERFACE_ATTRIBUTE3
, STREAM_INTERFACE_ATTRIBUTE4 STREAM_INTERFACE_ATTRIBUTE4
, STREAM_INTERFACE_ATTRIBUTE5 STREAM_INTERFACE_ATTRIBUTE5
, STREAM_INTERFACE_ATTRIBUTE6 STREAM_INTERFACE_ATTRIBUTE6
, STREAM_INTERFACE_ATTRIBUTE7 STREAM_INTERFACE_ATTRIBUTE7
, STREAM_INTERFACE_ATTRIBUTE8 STREAM_INTERFACE_ATTRIBUTE8
, STREAM_INTERFACE_ATTRIBUTE9 STREAM_INTERFACE_ATTRIBUTE9
, STREAM_INTERFACE_ATTRIBUTE10 STREAM_INTERFACE_ATTRIBUTE10
, STREAM_INTERFACE_ATTRIBUTE11 STREAM_INTERFACE_ATTRIBUTE11
, STREAM_INTERFACE_ATTRIBUTE12 STREAM_INTERFACE_ATTRIBUTE12
, STREAM_INTERFACE_ATTRIBUTE13 STREAM_INTERFACE_ATTRIBUTE13
, STREAM_INTERFACE_ATTRIBUTE14 STREAM_INTERFACE_ATTRIBUTE14
, STREAM_INTERFACE_ATTRIBUTE15 STREAM_INTERFACE_ATTRIBUTE15
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RATE RATE
, REAMORT_BALANCE REAMORT_BALANCE
, REAMORT_DATE REAMORT_DATE
FROM "OKL"."OKL_SIF_RET_LEVELS"