VIEW: APPS.OKL_SEC_BUYBACK_CUSTOMERS_UV

Source

View Text - Preformatted

SELECT hzpb.party_id cust_object1_id1, hzpb.party_name lessee, hzpb.party_number party_description FROM HZ_PARTIES HZPB WHERE hzpb.party_id IN ( SELECT cplb.object1_id1 FROM okl_pool_contents pocb ,okc_k_headers_all_b chrb ,okc_k_party_roles_b cplb WHERE pocb.khr_id = chrb.id AND pocb.status_code = 'ACTIVE' AND cplb.dnz_chr_id = chrb.id AND cplb.object1_id2 = '#' AND cplb.rle_code = 'LESSEE')

View Text - HTML Formatted

SELECT HZPB.PARTY_ID CUST_OBJECT1_ID1
, HZPB.PARTY_NAME LESSEE
, HZPB.PARTY_NUMBER PARTY_DESCRIPTION
FROM HZ_PARTIES HZPB
WHERE HZPB.PARTY_ID IN ( SELECT CPLB.OBJECT1_ID1
FROM OKL_POOL_CONTENTS POCB
, OKC_K_HEADERS_ALL_B CHRB
, OKC_K_PARTY_ROLES_B CPLB
WHERE POCB.KHR_ID = CHRB.ID
AND POCB.STATUS_CODE = 'ACTIVE'
AND CPLB.DNZ_CHR_ID = CHRB.ID
AND CPLB.OBJECT1_ID2 = '#'
AND CPLB.RLE_CODE = 'LESSEE')