[Home] [Help] [Dependency Information]
Object Name: | OKL_SIF_RETS |
---|---|
Object Type: | TABLE |
Owner: | OKL |
FND Design Data: | OKL.OKL_SIF_RETS |
Subobject Name: | |
Status: | VALID |
This holds the stream interface return header. The yields generated by the pricing engine are also
stored here.
Tablespace: | APPS_TS_NOLOGGING |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKL_SIR_U1 | NORMAL | UNIQUE | APPS_TS_NOLOGGING | ID |
OKL_SIR_U2 | NORMAL | UNIQUE | APPS_TS_NOLOGGING |
TRANSACTION_NUMBER
YIELD_NAME INDEX_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Primary key column | |
TRANSACTION_NUMBER | NUMBER | Yes | Unique identifier for a transaction. | |
SRT_CODE | VARCHAR2 | (30) | Lookup code for the transaction status. Valid values are DATA_ENTERED, PROCESSING_REQUEST, SERVER_NA, PROCESS_ABORTED, RET_DATA_RECEIVED, PROCESS_COMPLETE, PROCESSING_FAILED, TIME_OUT and HDR_INSERTED. | |
EFFECTIVE_PRE_TAX_YIELD | NUMBER | (18) | Holds the yield value. | |
YIELD_NAME | VARCHAR2 | (150) | Yes | Name of the yield. |
INDEX_NUMBER | NUMBER | Sequence number for the yield. | ||
EFFECTIVE_AFTER_TAX_YIELD | NUMBER | (18) | Holds the yield value. | |
NOMINAL_PRE_TAX_YIELD | NUMBER | (18) | Holds the yield value. | |
NOMINAL_AFTER_TAX_YIELD | NUMBER | (18) | Holds the yield value. | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Column used for locking records during updates | |
IMPLICIT_INTEREST_RATE | NUMBER | (18) | Implicit interest rate. | |
DATE_PROCESSED | DATE | Yes | Processing date. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
REQUEST_ID | NUMBER | Concurrent Manager column | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Manager column | ||
PROGRAM_ID | NUMBER | Concurrent Manager column | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Manager column | ||
STREAM_INTERFACE_ATTRIBUTE01 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE02 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE03 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE04 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE05 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE06 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE07 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE08 | VARCHAR2 | (450) | Generic attribute for extensions. | |
STREAM_INTERFACE_ATTRIBUTE09 | 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. |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, TRANSACTION_NUMBER
, SRT_CODE
, EFFECTIVE_PRE_TAX_YIELD
, YIELD_NAME
, INDEX_NUMBER
, EFFECTIVE_AFTER_TAX_YIELD
, NOMINAL_PRE_TAX_YIELD
, NOMINAL_AFTER_TAX_YIELD
, OBJECT_VERSION_NUMBER
, IMPLICIT_INTEREST_RATE
, DATE_PROCESSED
, CREATED_BY
, LAST_UPDATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, STREAM_INTERFACE_ATTRIBUTE01
, STREAM_INTERFACE_ATTRIBUTE02
, STREAM_INTERFACE_ATTRIBUTE03
, STREAM_INTERFACE_ATTRIBUTE04
, STREAM_INTERFACE_ATTRIBUTE05
, STREAM_INTERFACE_ATTRIBUTE06
, STREAM_INTERFACE_ATTRIBUTE07
, STREAM_INTERFACE_ATTRIBUTE08
, STREAM_INTERFACE_ATTRIBUTE09
, STREAM_INTERFACE_ATTRIBUTE10
, STREAM_INTERFACE_ATTRIBUTE11
, STREAM_INTERFACE_ATTRIBUTE12
, STREAM_INTERFACE_ATTRIBUTE13
, STREAM_INTERFACE_ATTRIBUTE14
, STREAM_INTERFACE_ATTRIBUTE15
FROM OKL.OKL_SIF_RETS;
OKL.OKL_SIF_RETS does not reference any database object
OKL.OKL_SIF_RETS is referenced by following:
|
|
|