View: OKL_SEC_INVESTOR_REVENUE_UV

Product:	OKL - Lease and Finance Management
Description:	User Interface view for securitization investor revenue
Implementation/DBA Data:	APPS.OKL_SEC_INVESTOR_REVENUE_UV

View Text

SELECT CLES.ID ID
, CLET.ID TOP_LINE_ID
, KLEB.PERCENT_STAKE PERCENT_STAKE
, KLEB.AMOUNT_STAKE AMOUNT_STAKE
, CLES.LSE_ID LSE_ID
, CLET.DNZ_CHR_ID DNZ_CHR_ID
, CLES.DATE_TERMINATED DATE_TERMINATED
, CLES.START_DATE START_DATE
, CLES.END_DATE END_DATE
, CLES.STS_CODE STS_CODE
, CLES.CURRENCY_CODE CURRENCY_CODE
, CLES.LINE_NUMBER LINE_NUMBER
, CLES.DISPLAY_SEQUENCE DISPLAY_SEQUENCE
, CLES.EXCEPTION_YN EXCEPTION_YN
, KLEB.STREAM_TYPE_SUBCLASS STY_SUBCLASS_CODE
, FNDS.MEANING STREAM_TYPE_SUBCLASS
FROM OKL_K_LINES KLEB
, OKC_K_LINES_B CLET
, OKC_K_LINES_B CLES
, OKC_LINE_STYLES_B LSEB
, FND_LOOKUPS FNDS
WHERE KLEB.ID = CLES.ID
AND CLES.CLE_ID = CLET.ID
AND CLES.LSE_ID = LSEB.ID
AND LSEB.LTY_CODE = 'REVENUE_SHARE'
AND FNDS.LOOKUP_TYPE = 'OKL_STREAM_TYPE_SUBCLASS'
AND FNDS.LOOKUP_CODE = KLEB.STREAM_TYPE_SUBCLASS
AND CLES.STS_CODE <> 'ABANDONED'

Columns