[Home] [Help]
View: OKL_ST_MAP_TARGETS_V
Product: | OKL - Lease and Finance Management |
Description: | View on OKL_SIF_YIELDS & OKL_STREAM_INTERFACES. |
Implementation/DBA Data: |
APPS.OKL_ST_MAP_TARGETS_V
|
View Text
SELECT SIYB.SIY_TYPE TARGET_TYPE
, SIYB.INDEX_NUMBER TARGET_TYPE_INDEX
, SIYB.NOMINAL_YN NOMINAL_YN
, SIYB.PRE_TAX_YN PRE_TAX_YN
, SIYB.TARGET_VALUE TARGET_VALUE
, SIFB.ADJUST ADJUST
, SIFB.ADJUSTMENT_METHOD ADJUSTMENT_METHOD
, SIFB.TRANSACTION_NUMBER TRANSACTION_NUMBER
FROM OKL_SIF_YIELDS SIYB
, OKL_STREAM_INTERFACES SIFB
WHERE SIYB.SIF_ID = SIFB.ID
AND SIYB.TARGET_VALUE IS NOT NULL
Columns
Name |
TARGET_TYPE |
TARGET_TYPE_INDEX |
NOMINAL_YN |
PRE_TAX_YN |
TARGET_VALUE |
ADJUST |
ADJUSTMENT_METHOD |
TRANSACTION_NUMBER |