[Home] [Help] [Dependency Information]
Object Name: | OKL_SIF_RET_LEVELS |
---|---|
Object Type: | TABLE |
Owner: | OKL |
FND Design Data: | OKL.OKL_SIF_RET_LEVELS |
Subobject Name: | |
Status: | VALID |
The payment level details returned by the external pricing engine like payment amount, first
payment date, period etc. are stored here. Reference to the stream interface return header is also
stored here.
Tablespace: | APPS_TS_NOLOGGING |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SRL_SIR_FK_I | NORMAL | NONUNIQUE | APPS_TS_NOLOGGING | SIR_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Primary key column | |
SIR_ID | NUMBER | Yes | Foreign key to table OKL_SIF_RETS | |
INDEX_NUMBER | NUMBER | Yes | Reference to the asset index number. | |
NUMBER_OF_PERIODS | NUMBER | Number of payments for a payment level. | ||
LEVEL_INDEX_NUMBER | NUMBER | Sequence number of the payment level. | ||
LEVEL_TYPE | VARCHAR2 | (30) | Payment type. | |
AMOUNT | NUMBER | Amount | ||
ADVANCE_OR_ARREARS | VARCHAR2 | (10) | Whether the payment is in advance or arrear. | |
PERIOD | VARCHAR2 | (30) | Frequency of the payment. | |
LOCK_LEVEL_STEP | VARCHAR2 | (10) | Whether modifications are allowed for the payment level for pricing. | |
DAYS_IN_PERIOD | NUMBER | (4) | Number of days in a payment period. | |
FIRST_PAYMENT_DATE | DATE | First payment date for a payment level. | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
STREAM_INTERFACE_ATTRIBUTE1 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE2 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE3 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE4 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE5 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE6 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE7 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE8 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE9 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE10 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE11 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE12 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE13 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE14 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE15 | VARCHAR2 | (450) | Generic attribute for extensions. | |
CREATION_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
RATE | NUMBER | Rate |
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
FROM OKL.OKL_SIF_RET_LEVELS;
OKL.OKL_SIF_RET_LEVELS does not reference any database object
OKL.OKL_SIF_RET_LEVELS is referenced by following:
|
|
|