View: OKL_POOL_CUSTOMERS_UV

Product:	OKL - Leasing and Finance Management
Description:	Securitization - Pool Customers UI view
Implementation/DBA Data:	APPS.OKL_POOL_CUSTOMERS_UV

View Text

SELECT CPLB.DNZ_CHR_ID DNZ_CHR_ID
, HZPB.PARTY_ID CUST_OBJECT1_ID1
, HZPB.PARTY_NAME LESSEE
, HZPB.SIC_CODE SIC_CODE
FROM OKC_K_PARTY_ROLES_B CPLB
, HZ_PARTIES HZPB
WHERE CPLB.OBJECT1_ID1 = HZPB.PARTY_ID
AND CPLB.OBJECT1_ID2 = '#'
AND CPLB.RLE_CODE = 'LESSEE'

Columns