[Home] [Help] [Dependency Information]
Object Name: | OKL_SIF_RETS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_SIF_RETS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This holds the stream interface return header. The yields generated by the pricing engine are also
stored here.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Auto-generated by Headstart Utilities | |
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 ROW_ID
, 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 APPS.OKL_SIF_RETS_V;
|
|
|