View: OKL_SEC_BUYBACK_STREAMS_UV

Product:	OKL - Lease and Finance Management
Description:	User interface view for securitized buyback streams
Implementation/DBA Data:	APPS.OKL_SEC_BUYBACK_STREAMS_UV

View Text

SELECT POCB.KHR_ID KHR_ID
, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER
, CHRB.CURRENCY_CODE CURRENCY_CODE
, HZPB.PARTY_NAME LESSEE
, POCB.POL_ID POL_ID
, POLV.POOL_NUMBER POOL_NUMBER
, POLV.KHR_ID AGREEMENT_ID
, AGRB.CONTRACT_NUMBER AGREEMENT_NUMBER
, STYV.STREAM_TYPE_SUBCLASS STY_SUBCLASS_CODE
, FNDS.MEANING STY_SUBCLASS
, NVL(SUM(SELB.AMOUNT)
, 0) STREAMS_AMOUNT
FROM OKL_POOL_CONTENTS POCB
, OKC_K_HEADERS_ALL_B CHRB
, OKC_K_PARTY_ROLES_B CPLB
, HZ_PARTIES HZPB
, OKL_POOLS POLV
, OKL_STRM_TYPE_V STYV
, OKL_STREAMS STMB
, OKL_STRM_ELEMENTS SELB
, FND_LOOKUPS FNDS
, OKC_K_HEADERS_ALL_B AGRB
WHERE POCB.STATUS_CODE = 'ACTIVE'
AND POCB.KHR_ID = CHRB.ID
AND CPLB.DNZ_CHR_ID = CHRB.ID
AND CPLB.OBJECT1_ID1 = HZPB.PARTY_ID
AND CPLB.OBJECT1_ID2 = '#'
AND CPLB.RLE_CODE = 'LESSEE'
AND POCB.POL_ID = POLV.ID
AND POLV.KHR_ID = AGRB.ID
AND POCB.STY_ID = STYV.ID
AND POCB.STM_ID = STMB.ID
AND SELB.STM_ID = STMB.ID
AND SELB.DATE_BILLED IS NULL
AND SELB.STREAM_ELEMENT_DATE > SYSDATE
AND SELB.STREAM_ELEMENT_DATE BETWEEN POCB.STREAMS_FROM_DATE
AND NVL(POCB.STREAMS_TO_DATE
, TO_DATE('1'
, 'J')+5300000)
AND FNDS.LOOKUP_TYPE = 'OKL_STREAM_TYPE_SUBCLASS'
AND FNDS.LOOKUP_CODE = STYV.STREAM_TYPE_SUBCLASS GROUP BY POCB.KHR_ID
, CHRB.CONTRACT_NUMBER
, CHRB.CURRENCY_CODE
, HZPB.PARTY_NAME
, POCB.POL_ID
, POOL_NUMBER
, POLV.KHR_ID
, AGRB.CONTRACT_NUMBER
, STYV.STREAM_TYPE_SUBCLASS
, FNDS.MEANING ORDER BY CONTRACT_NUMBER
, STREAM_TYPE_SUBCLASS

Columns