[Home] [Help] [Dependency Information]
Object Name: | OKL_PROD_STRM_TYPES |
---|---|
Object Type: | TABLE |
Owner: | OKL |
FND Design Data: | OKL.OKL_PROD_STRM_TYPES |
Subobject Name: | |
Status: | VALID |
This represents the Accrual Status of Stream Types attached to a Product.
Ex:-Returned Asset Fee,Quote Fee
Miscellaneous.
The Stream Type Rent may be accrued for Product Direct Finance Lease and Not accrued for Operating Lease. This functionality is acheived by having and association.
Product Stream Type Accrual Status
-------------------------------------------------------------------------------------------------------------------------
Operating Lease Rent Yes
Direct Finance Lease Rent No
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKL_PSY_UK1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Primary key column | |
TO_DATE | DATE | To date | ||
ACCRUAL_YN | VARCHAR2 | (3) | Yes | Indicates to accrue or not |
FROM_DATE | DATE | Yes | From date | |
STY_ID | NUMBER | Yes | Foreign key to table OKL_STRM_TYPE_B | |
PDT_ID | NUMBER | Yes | Foreign key to table OKL_PRODUCTS | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, TO_DATE
, ACCRUAL_YN
, FROM_DATE
, STY_ID
, PDT_ID
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM OKL.OKL_PROD_STRM_TYPES;
OKL.OKL_PROD_STRM_TYPES does not reference any database object
OKL.OKL_PROD_STRM_TYPES is referenced by following:
|
|
|