View: OKL_CS_SCHINTR_PAYMENTS_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_CS_SCHINTR_PAYMENTS_UV

View Text

SELECT STRM.KLE_ID KLE_ID
, STR_ELM.AMOUNT AMOUNT
, STR_ELM.STREAM_ELEMENT_DATE STREAM_ELEMENT_DATE
FROM OKL_STRM_TYPE_B STR_TYPE
, OKL_STREAMS STRM
, OKL_STRM_ELEMENTS STR_ELM
WHERE STR_TYPE.STREAM_TYPE_PURPOSE = 'INTEREST_PAYMENT'
AND STR_TYPE.ID = STRM.STY_ID
AND STR_ELM.STM_ID = STRM.ID
AND STRM.SAY_CODE = 'CURR'
AND STRM.ACTIVE_YN = 'Y'
AND STRM.PURPOSE_CODE IS NULL

Columns