VIEW: APPS.OKL_POOL_CONTENTS_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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