[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 |