View: OKL_POOL_STREAMS_PAY_UV

Product:	OKL - Lease and Finance Management
Description:	Securitization - Pool payment UI view
Implementation/DBA Data:	APPS.OKL_POOL_STREAMS_PAY_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
, TUOM.NAME PAYMENT_FREQ
, STMB.ID STM_ID
FROM OKL_STREAMS STMB
, OKL_STRM_ELEMENTS SELB
, OKL_STRM_TYPE_V STYV
, OKL_TIME_UNITS_V TUOM
, OKC_RULES_B SLLB
, OKC_RULES_B SLHB
, OKC_RULE_GROUPS_B RGPB
WHERE STMB.ID = SELB.STM_ID
AND STMB.STY_ID = STYV.ID
AND RGPB.CLE_ID = STMB.KLE_ID
AND TUOM.ID1 = SLLB.OBJECT1_ID1
AND SLLB.OBJECT2_ID1 = TO_CHAR(SLHB.ID)
AND SLLB.RGP_ID = RGPB.ID
AND SLLB.RULE_INFORMATION_CATEGORY = 'LASLL'
AND STMB.STY_ID = SLHB.OBJECT1_ID1
AND SLHB.RGP_ID = RGPB.ID
AND SLHB.RULE_INFORMATION_CATEGORY = 'LASLH'
AND RGPB.RGD_CODE = 'LALEVL'
AND SLLB.RULE_INFORMATION2 IS NOT NULL

Columns