View: OKL_POOL_STREAM_ELEMENTS_UV

Product:	OKL - Lease and Finance Management
Description:	User Interface view for securitization pool stream elements
Implementation/DBA Data:	APPS.OKL_POOL_STREAM_ELEMENTS_UV

View Text

SELECT POCB.ID POC_ID
, POCB.KHR_ID KHR_ID
, POCB.POL_ID POL_ID
, POCB.STM_ID
, POLV.POOL_NUMBER POOL_NUMBER
, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER
, CLET.NAME ASSET_NUMBER
, STYV.NAME STREAM_TYPE
, SELB.STREAM_ELEMENT_DATE STREAM_ELEMENT_DATE
, SELB.DATE_BILLED DATE_BILLED
, SELB.AMOUNT AMOUNT
, POLV.CURRENCY_CODE CURRENCY_CODE
, STYV.STREAM_TYPE_SUBCLASS STY_SUBCLASS_CODE
, FNDS.MEANING STY_SUBCLASS
, STYV.STREAM_TYPE_PURPOSE STY_PURPOSE_CODE
, FNDT.MEANING STREAM_TYPE_PURPOSE
FROM OKL_POOL_CONTENTS POCB
, OKL_POOLS POLV
, OKL_STRM_ELEMENTS SELB
, OKL_STREAMS STMB
, OKC_K_HEADERS_ALL_B CHRB
, OKC_K_LINES_TL CLET
, OKL_STRM_TYPE_V STYV
, FND_LOOKUPS FNDS
, FND_LOOKUPS FNDT
WHERE POCB.POL_ID = POLV.ID
AND POCB.KHR_ID = CHRB.ID
AND POCB.KLE_ID = CLET.ID
AND CLET.LANGUAGE = USERENV('LANG')
AND POCB.STM_ID = STMB.ID
AND STMB.ID = SELB.STM_ID
AND (SELB.STREAM_ELEMENT_DATE BETWEEN POCB.STREAMS_FROM_DATE
AND NVL(POCB.STREAMS_TO_DATE
, TO_DATE('1'
, 'J')+5300000) )
AND STMB.STY_ID = STYV.ID
AND FNDS.LOOKUP_TYPE = 'OKL_STREAM_TYPE_SUBCLASS'
AND FNDS.LOOKUP_CODE = STYV.STREAM_TYPE_SUBCLASS
AND FNDT.LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
AND FNDT.LOOKUP_CODE = STYV.STREAM_TYPE_PURPOSE ORDER BY STREAM_ELEMENT_DATE

Columns