DBA Data[Home] [Help]

VIEW: APPS.OKL_ST_MAP_YIELDS_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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