View: OKL_SEC_BUYBACK_CUSTOMERS_UV

Product:	OKL - Lease and Finance Management
Description:	User inteface view for securitization buyback customers
Implementation/DBA Data:	APPS.OKL_SEC_BUYBACK_CUSTOMERS_UV

View Text

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')

Columns