VIEW: APPS.OKL_KLE_STRM_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'