[Home] [Help] [Dependency Information]
Object Name: | OKL_STRM_TYP_ALLOCS |
---|---|
Object Type: | TABLE |
Owner: | OKL |
FND Design Data: | OKL.OKL_STRM_TYP_ALLOCS |
Subobject Name: | |
Status: | VALID |
describes the priority or sequence in which to apply insufficient cash to stream types
or alternatively the group over which to prorate
Apply receipt payment in the defined order of transaction types
For under payments, apply receipt payments by prorating them amongst selected transaction types
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKL_STRM_TYP_ALLOCS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ID |
OKL_STRM_TYP_ALLOCS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CAT_ID
STY_ID STREAM_ALLC_TYPE |
STA_STY_FK_I | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | STY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Primary key column | |
CAT_ID | NUMBER | Yes | Foreign key to table OKL_CASH_ALLCTN_RLS | |
STY_ID | NUMBER | Yes | Foreign key to table OKL_STRM_TYPE_B | |
STREAM_ALLC_TYPE | VARCHAR2 | (10) | Yes | Stream allocation type |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
SEQUENCE_NUMBER | NUMBER | (5) | Sequence number | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | Descriptive flexfield category column | |
ATTRIBUTE1 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE2 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE3 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE4 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE5 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE6 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE7 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE8 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE9 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE10 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE11 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE12 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE13 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE14 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE15 | VARCHAR2 | (450) | Descriptive flexfield column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
ORG_ID | NUMBER | (15) | Operating unit identifier |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, CAT_ID
, STY_ID
, STREAM_ALLC_TYPE
, OBJECT_VERSION_NUMBER
, SEQUENCE_NUMBER
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORG_ID
FROM OKL.OKL_STRM_TYP_ALLOCS;
OKL.OKL_STRM_TYP_ALLOCS does not reference any database object
OKL.OKL_STRM_TYP_ALLOCS is referenced by following:
|
|
|