View: OKL_KLE_STRM_V

Product:	OKL - Leasing and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_KLE_STRM_V

View Text

SELECT STM.NAME NAME
, STY.ID ID
, STY.KLE_ID KLE_ID
, STY.KHR_ID KHR_ID
, STEM.AMOUNT BILLED_AMOUNT
, STEM.STREAM_ELEMENT_DATE NEXT_BILLED_DATE
, STY.SAY_CODE STATUS
FROM OKL_STREAMS_V STY
, OKL_STRM_ELEMENTS_V STEM
, OKL_STRM_TYPE_V STM
WHERE STM.ID = STY.STY_ID
AND STEM.STM_ID = STY.ID
AND STY.SAY_CODE IN ( 'CURR'
, 'HOLD')
AND STY.KLE_ID IS NOT NULL
AND STEM.STREAM_ELEMENT_DATE = ( SELECT MIN(OKL_STRM_ELEMENTS_V.STREAM_ELEMENT_DATE)
FROM OKL_STRM_ELEMENTS_V
WHERE OKL_STRM_ELEMENTS_V.STM_ID = STY.ID
AND DATE_BILLED IS NULL )
AND STY.PURPOSE_CODE IS NULL
AND STM.BILLABLE_YN = 'Y'

Columns