View: OKL_POOL_CONTENTS_UV

Product:	OKL - Lease and Finance Management
Description:	Securitization - Pool Contents UI view
Implementation/DBA Data:	APPS.OKL_POOL_CONTENTS_UV

View Text

SELECT HZPB.PARTY_ID CUST_OBJECT1_ID1
, HZPB.PARTY_NAME LESSEE
, HZPB.SIC_CODE SIC_CODE
, CHRB.ID DNZ_CHR_ID
, CHRB.CONTRACT_NUMBER
, KHRB.PRE_TAX_YIELD PRE_TAX_YIELD
, KHRB.DEAL_TYPE BOOK_CLASSIFICATION
, KHRB.PDT_ID PDT_ID
, CHRB.START_DATE START_DATE
, CHRB.END_DATE END_DATE
, CHRB.CURRENCY_CODE CURRENCY_CODE
, RULB.RULE_INFORMATION1 TAX_OWNER
, POCB.KLE_ID
, CLET.NAME ASSET_NUMBER
, STYV.ID STY_ID
, STYV.NAME STREAM_TYPE_NAME
, POCB.ID POC_ID
, POCB.POL_ID
, POCB.STREAMS_FROM_DATE
, POCB.STREAMS_TO_DATE
, POCB.STATUS_CODE
, FNDP.MEANING STATUS
, STYV.STREAM_TYPE_SUBCLASS STY_SUBCLASS_CODE
, FNDS.MEANING STY_SUBCLASS
, STYV.STREAM_TYPE_PURPOSE STY_PURPOSE_CODE
, FNDT.MEANING STREAM_TYPE_PURPOSE
FROM OKL_POOL_CONTENTS POCB
, OKC_K_HEADERS_B CHRB
, OKC_K_PARTY_ROLES_B CPLB
, HZ_PARTIES HZPB
, OKL_K_HEADERS KHRB
, OKC_RULE_GROUPS_B RGPB
, OKC_RULES_B RULB
, OKC_K_LINES_TL CLET
, OKL_STRM_TYPE_V STYV
, FND_LOOKUPS FNDP
, FND_LOOKUPS FNDS
, FND_LOOKUPS FNDT
WHERE POCB.KHR_ID = CHRB.ID
AND CHRB.ID = KHRB.ID
AND CPLB.DNZ_CHR_ID = CHRB.ID
AND CHRB.ID = RGPB.DNZ_CHR_ID
AND CHRB.ID = RULB.DNZ_CHR_ID
AND RGPB.ID = RULB.RGP_ID
AND RULB.RULE_INFORMATION_CATEGORY= 'LATOWN'
AND CPLB.OBJECT1_ID1 = HZPB.PARTY_ID
AND CPLB.OBJECT1_ID2 = '#'
AND CPLB.RLE_CODE = 'LESSEE'
AND POCB.KLE_ID = CLET.ID
AND CLET.LANGUAGE = USERENV('LANG')
AND STYV.ID = POCB.STY_ID
AND FNDP.LOOKUP_TYPE = 'OKL_POOL_CONTENT_STATUS'
AND FNDP.LOOKUP_CODE = POCB.STATUS_CODE
AND FNDS.LOOKUP_TYPE = 'OKL_STREAM_TYPE_SUBCLASS'
AND FNDS.LOOKUP_CODE = STYV.STREAM_TYPE_SUBCLASS
AND FNDT.LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
AND FNDT.LOOKUP_CODE = STYV.STREAM_TYPE_PURPOSE

Columns