View: OKL_POOL_STREAMS_UV

Product:	OKL - Lease and Finance Management
Description:	Securitization - Pool Streams UI
Implementation/DBA Data:	APPS.OKL_POOL_STREAMS_UV

View Text

SELECT STMB.KHR_ID KHR_ID
, STMB.KLE_ID KLE_ID
, STMB.STY_ID STY_ID
, STYV.CODE STREAM_TYPE_CODE
, STYV.NAME STREAM_TYPE_NAME
, STYV.STREAM_TYPE_SUBCLASS
, STMB.SAY_CODE STREAM_SAY_CODE
, STMB.ACTIVE_YN STREAM_ACTIVE_YN
, SELB.STREAM_ELEMENT_DATE STREAM_ELEMENT_DUE_DATE
, SELB.AMOUNT STREAM_ELEMENT_AMOUNT
, SELB.DATE_BILLED STREAM_ELEMENT_DATE_BILLED
, STMB.ID STM_ID
FROM OKL_STREAMS STMB
, OKL_STRM_ELEMENTS SELB
, OKL_STRM_TYPE_V STYV
WHERE STMB.ID = SELB.STM_ID
AND STMB.STY_ID = STYV.ID

Columns