VIEW: APPS.OKL_CS_SCHINTR_PAYMENTS_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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