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