VIEW: APPS.OKL_SEC_BUYBACK_CONTRACTS_UV

Source

View Text - Preformatted

SELECT hzpb.party_id cust_object1_id1, hzpb.party_name lessee, chrb.id dnz_chr_id, chrb.contract_number, chrt.short_description, khrb.deal_type book_class_code, fndb.meaning book_class , khrb.pdt_id pdt_id, pdtv.name product, chrb.start_date start_date, chrb.end_date end_date, chrb.currency_code currency_code, chrb.org_id FROM OKC_K_HEADERS_B CHRB,OKC_K_HEADERS_TL CHRT,OKC_K_PARTY_ROLES_B CPLB,HZ_PARTIES HZPB,OKL_K_HEADERS KHRB,OKL_PRODUCTS PDTV,FND_LOOKUPS FNDB WHERE chrb.id = chrt.id AND chrt.LANGUAGE = USERENV('LANG') AND chrb.id = khrb.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 khrb.pdt_id = pdtv.id AND fndb.lookup_type = 'OKL_BOOK_CLASS' AND fndb.lookup_code = khrb.deal_type AND EXISTS ( SELECT 1 FROM okl_pool_contents pocb WHERE pocb.khr_id = chrb.id AND pocb.status_code = 'ACTIVE')

View Text - HTML Formatted

SELECT HZPB.PARTY_ID CUST_OBJECT1_ID1
, HZPB.PARTY_NAME LESSEE
, CHRB.ID DNZ_CHR_ID
, CHRB.CONTRACT_NUMBER
, CHRT.SHORT_DESCRIPTION
, KHRB.DEAL_TYPE BOOK_CLASS_CODE
, FNDB.MEANING BOOK_CLASS
, KHRB.PDT_ID PDT_ID
, PDTV.NAME PRODUCT
, CHRB.START_DATE START_DATE
, CHRB.END_DATE END_DATE
, CHRB.CURRENCY_CODE CURRENCY_CODE
, CHRB.ORG_ID
FROM OKC_K_HEADERS_B CHRB
, OKC_K_HEADERS_TL CHRT
, OKC_K_PARTY_ROLES_B CPLB
, HZ_PARTIES HZPB
, OKL_K_HEADERS KHRB
, OKL_PRODUCTS PDTV
, FND_LOOKUPS FNDB
WHERE CHRB.ID = CHRT.ID
AND CHRT.LANGUAGE = USERENV('LANG')
AND CHRB.ID = KHRB.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 KHRB.PDT_ID = PDTV.ID
AND FNDB.LOOKUP_TYPE = 'OKL_BOOK_CLASS'
AND FNDB.LOOKUP_CODE = KHRB.DEAL_TYPE
AND EXISTS ( SELECT 1
FROM OKL_POOL_CONTENTS POCB
WHERE POCB.KHR_ID = CHRB.ID
AND POCB.STATUS_CODE = 'ACTIVE')