[Home] [Help] [Dependency Information]
Object Name: | OKL_SIF_RET_STRMS |
---|---|
Object Type: | TABLE |
Owner: | OKL |
FND Design Data: | OKL.OKL_SIF_RET_STRMS |
Subobject Name: | |
Status: | VALID |
The streams returned by the external pricing engine are stored here. Various details like stream
type name, amount 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 |
---|---|---|---|---|
OKL_SRS_U1 | NORMAL | UNIQUE | APPS_TS_NOLOGGING | ID |
OKL_SRS_IDX1 | NORMAL | NONUNIQUE | APPS_TS_NOLOGGING |
SIR_ID
STREAM_TYPE_NAME INDEX_NUMBER SEQUENCE_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Primary key column | |
STREAM_TYPE_NAME | VARCHAR2 | (150) | Yes | Name |
INDEX_NUMBER | NUMBER | Reference to the asset or fee index number. | ||
ACTIVITY_TYPE | VARCHAR2 | (30) | Not in use. | |
SEQUENCE_NUMBER | NUMBER | (5) | Sequence number | |
SRE_DATE | DATE | Yes | Payment due date. | |
AMOUNT | NUMBER | Yes | Amount | |
SIR_ID | NUMBER | Yes | Foreign key to table OKL_SIF_RETS | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
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 | |
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
, STREAM_TYPE_NAME
, INDEX_NUMBER
, ACTIVITY_TYPE
, SEQUENCE_NUMBER
, SRE_DATE
, AMOUNT
, SIR_ID
, OBJECT_VERSION_NUMBER
, CREATED_BY
, LAST_UPDATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, 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_RET_STRMS;
OKL.OKL_SIF_RET_STRMS does not reference any database object
OKL.OKL_SIF_RET_STRMS is referenced by following:
|
|
|