View: OKL_POOL_TRANS_CONTENTS_UV

Product:	OKL - Lease and Finance Management
Description:	User interface view for securitization pool transaction contents
Implementation/DBA Data:	APPS.OKL_POOL_TRANS_CONTENTS_UV

View Text

SELECT POCB.ID POC_ID
, POCB.POL_ID
, POCB.TRANSACTION_NUMBER_IN TRANSACTION_NUMBER_IN
, POCB.TRANSACTION_NUMBER_OUT TRANSACTION_NUMBER_OUT
, POCB.STATUS_CODE
, CHRB.ID DNZ_CHR_ID
, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER
, POCB.KLE_ID KLE_ID
, CLET.NAME ASSET_NUMBER
, HZPB.PARTY_NAME LESSEE
, STYV.ID STY_ID
, STYV.NAME STREAM_TYPE_NAME
, STYV.STREAM_TYPE_SUBCLASS STY_SUBCLASS_CODE
, FNDS.MEANING STY_SUBCLASS
, POCB.STREAMS_FROM_DATE STREAMS_FROM_DATE
, POCB.STREAMS_TO_DATE STREAMS_TO_DATE
, POCB.STM_ID STM_ID
, 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
, OKC_K_LINES_TL CLET
, OKL_STRM_TYPE_V STYV
, FND_LOOKUPS FNDS
, FND_LOOKUPS FNDT
WHERE POCB.KHR_ID = CHRB.ID
AND CPLB.DNZ_CHR_ID = CHRB.ID
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 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