[Home] [Help]
View: OKL_ST_MAP_YIELDS_V
| Product: | OKL - Lease and Finance Management |
| Description: | View on OKL_SIF_YIELDS & OKL_STREAM_INTERFACES. |
| Implementation/DBA Data: |
APPS.OKL_ST_MAP_YIELDS_V
|
View Text
SELECT YIELD_NAME
, INDEX_NUMBER
, TRANSACTION_NUMBER
, OKL_SIF_YIELDS.SIF_ID SIF_ID
, TARGET_VALUE
, METHOD
, ROE_TYPE
, ROE_BASE
, ARRAY_TYPE
, COMPOUNDED_METHOD
, NOMINAL_YN
, PRE_TAX_YN
, SIY_TYPE
FROM OKL_STREAM_INTERFACES
, OKL_SIF_YIELDS
WHERE OKL_STREAM_INTERFACES.ID = OKL_SIF_YIELDS.SIF_ID ORDER BY OKL_SIF_YIELDS.INDEX_NUMBER
Columns
| Name |
| YIELD_NAME |
| INDEX_NUMBER |
| TRANSACTION_NUMBER |
| SIF_ID |
| TARGET_VALUE |
| METHOD |
| ROE_TYPE |
| ROE_BASE |
| ARRAY_TYPE |
| COMPOUNDED_METHOD |
| NOMINAL_YN |
| PRE_TAX_YN |
| SIY_TYPE |