View: OKL_SEC_INVESTOR_DTLS_UV

Product:	OKL - Lease and Finance Management
Description:	Investor Agreement Investor Details View
Implementation/DBA Data:	APPS.OKL_SEC_INVESTOR_DTLS_UV

View Text

SELECT DISTINCT CHRA.ID KHR_ID
, CHRB.CONTRACT_NUMBER INVESTOR_AGRMNT_NUMBER
, STS.MEANING INVESTOR_AGRMNT_STATUS
, FNDT.MEANING INVESTOR_AGRMNT_TYPE
, FNDS.MEANING STRM_TYPE_SUBCLASS
, FNDP.MEANING STRM_TYPE_PURPOSE
, POL.POOL_NUMBER POOL_NUMBER
, POL.DISPLAY_IN_LEASE_CENTER
FROM OKC_K_HEADERS_ALL_B CHRA
, OKC_K_HEADERS_ALL_B CHRB
, OKL_K_HEADERS KHR
, OKC_STATUSES_TL STS
, FND_LOOKUPS FNDT
, FND_LOOKUPS FNDS
, FND_LOOKUPS FNDP
, OKL_POOLS POL
, OKL_POOL_CONTENTS POC
, OKL_STRM_TYPE_B STY
WHERE CHRA.ID= POC.KHR_ID
AND POC.STY_ID = STY.ID
AND STY.STREAM_TYPE_SUBCLASS IN ('RENT'
, 'RESIDUAL')
AND FNDS.LOOKUP_TYPE = 'OKL_STREAM_TYPE_SUBCLASS'
AND FNDS.LOOKUP_CODE = STY.STREAM_TYPE_SUBCLASS
AND POL.ID = POC.POL_ID
AND POL.KHR_ID =CHRB.ID
AND CHRB.SCS_CODE = 'INVESTOR'
AND CHRB.STS_CODE = STS.CODE
AND STS.LANGUAGE= USERENV('LANG')
AND KHR.ID = CHRB.ID
AND FNDT.LOOKUP_TYPE = 'OKL_SECURITIZATION_TYPE'
AND FNDT.LOOKUP_CODE = DECODE(KHR.SECURITIZATION_TYPE
, 'SALE'
, 'SECURITIZATION'
, 'LOAN'
, 'SYNDICATION'
, 'SECURITIZATION'
, 'SECURITIZATION'
, 'SYNDICATION'
, 'SYNDICATION')
AND FNDP.LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
AND FNDP.LOOKUP_CODE = STY.STREAM_TYPE_PURPOSE UNION ALL SELECT DISTINCT POC.KHR_ID KHR_ID
, TO_CHAR(NULL) INVESTOR_AGRMNT_NUMBER
, TO_CHAR(NULL) INVESTOR_AGRMNT_STATUS
, TO_CHAR(NULL) INVESTOR_AGRMNT_TYPE
, FNDS.MEANING STRM_TYPE_SUBCLASS
, FNDP.MEANING STRM_TYPE_PURPOSE
, POL.POOL_NUMBER POOL_NUMBER
, POL.DISPLAY_IN_LEASE_CENTER
FROM FND_LOOKUPS FNDS
, FND_LOOKUPS FNDP
, OKL_POOLS POL
, OKL_POOL_CONTENTS POC
, OKL_STRM_TYPE_B STY
WHERE POL.ID = POC.POL_ID
AND POC.STY_ID = STY.ID
AND STY.STREAM_TYPE_SUBCLASS IN ('RENT'
, 'RESIDUAL')
AND FNDS.LOOKUP_TYPE = 'OKL_STREAM_TYPE_SUBCLASS'
AND FNDS.LOOKUP_CODE = STY.STREAM_TYPE_SUBCLASS
AND FNDP.LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
AND FNDP.LOOKUP_CODE = STY.STREAM_TYPE_PURPOSE
AND POL.KHR_ID IS NULL

Columns