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'