[Home] [Help] [Dependency Information]
Object Name: | OKL_PROD_STRM_TYPES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_PROD_STRM_TYPES_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
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
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row Identifier in the database | |
ID | NUMBER | Yes | Primary key column | |
FROM_DATE | DATE | Yes | From date | |
TO_DATE | DATE | To date | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
ACCRUAL_YN | VARCHAR2 | (3) | Yes | Indicates to accrue or not |
STY_ID | NUMBER | Yes | Foreign key to table OKL_STRM_TYPE_B | |
PDT_ID | NUMBER | Yes | Foreign key to table OKL_PRODUCTS | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ID
, FROM_DATE
, TO_DATE
, OBJECT_VERSION_NUMBER
, ACCRUAL_YN
, STY_ID
, PDT_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM APPS.OKL_PROD_STRM_TYPES_V;
|
|
|