[Home] [Help] [Dependency Information]
Object Name: | OKL_SIF_RET_LEVELS# |
---|---|
Object Type: | VIEW |
Owner: | OKL |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | ||
SIR_ID | NUMBER | Yes | ||
INDEX_NUMBER | NUMBER | Yes | ||
NUMBER_OF_PERIODS | NUMBER | |||
LEVEL_INDEX_NUMBER | NUMBER | |||
LEVEL_TYPE | VARCHAR2 | (30) | ||
AMOUNT | NUMBER | |||
ADVANCE_OR_ARREARS | VARCHAR2 | (10) | ||
PERIOD | VARCHAR2 | (30) | ||
LOCK_LEVEL_STEP | VARCHAR2 | (10) | ||
DAYS_IN_PERIOD | NUMBER | (4) | ||
FIRST_PAYMENT_DATE | DATE | |||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | |
STREAM_INTERFACE_ATTRIBUTE1 | VARCHAR2 | (450) | ||
STREAM_INTERFACE_ATTRIBUTE2 | VARCHAR2 | (450) | ||
STREAM_INTERFACE_ATTRIBUTE3 | VARCHAR2 | (450) | ||
STREAM_INTERFACE_ATTRIBUTE4 | VARCHAR2 | (450) | ||
STREAM_INTERFACE_ATTRIBUTE5 | VARCHAR2 | (450) | ||
STREAM_INTERFACE_ATTRIBUTE6 | VARCHAR2 | (450) | ||
STREAM_INTERFACE_ATTRIBUTE7 | VARCHAR2 | (450) | ||
STREAM_INTERFACE_ATTRIBUTE8 | VARCHAR2 | (450) | ||
STREAM_INTERFACE_ATTRIBUTE9 | VARCHAR2 | (450) | ||
STREAM_INTERFACE_ATTRIBUTE10 | VARCHAR2 | (450) | ||
STREAM_INTERFACE_ATTRIBUTE11 | VARCHAR2 | (450) | ||
STREAM_INTERFACE_ATTRIBUTE12 | VARCHAR2 | (450) | ||
STREAM_INTERFACE_ATTRIBUTE13 | VARCHAR2 | (450) | ||
STREAM_INTERFACE_ATTRIBUTE14 | VARCHAR2 | (450) | ||
STREAM_INTERFACE_ATTRIBUTE15 | VARCHAR2 | (450) | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
RATE | NUMBER | |||
REAMORT_BALANCE | NUMBER | |||
REAMORT_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, SIR_ID
, INDEX_NUMBER
, NUMBER_OF_PERIODS
, LEVEL_INDEX_NUMBER
, LEVEL_TYPE
, AMOUNT
, ADVANCE_OR_ARREARS
, PERIOD
, LOCK_LEVEL_STEP
, DAYS_IN_PERIOD
, FIRST_PAYMENT_DATE
, OBJECT_VERSION_NUMBER
, STREAM_INTERFACE_ATTRIBUTE1
, STREAM_INTERFACE_ATTRIBUTE2
, STREAM_INTERFACE_ATTRIBUTE3
, STREAM_INTERFACE_ATTRIBUTE4
, STREAM_INTERFACE_ATTRIBUTE5
, STREAM_INTERFACE_ATTRIBUTE6
, STREAM_INTERFACE_ATTRIBUTE7
, STREAM_INTERFACE_ATTRIBUTE8
, STREAM_INTERFACE_ATTRIBUTE9
, STREAM_INTERFACE_ATTRIBUTE10
, STREAM_INTERFACE_ATTRIBUTE11
, STREAM_INTERFACE_ATTRIBUTE12
, STREAM_INTERFACE_ATTRIBUTE13
, STREAM_INTERFACE_ATTRIBUTE14
, STREAM_INTERFACE_ATTRIBUTE15
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, RATE
, REAMORT_BALANCE
, REAMORT_DATE
FROM OKL.OKL_SIF_RET_LEVELS#;
|
|
|