VIEW: APPS.OKL_SEC_INVESTOR_REVENUE_UV

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'