View: OKL_BPD_INVESTOR_LOV_UV

Product:	OKL - Lease and Finance Management
Description:	View for investor lov.
Implementation/DBA Data:	APPS.OKL_BPD_INVESTOR_LOV_UV

View Text

SELECT DISTINCT PARTY.NAME INVESTOR_NAME
FROM OKC_K_HEADERS_B OKL
, OKC_K_PARTY_ROLES_V PARTY_ROLE
, OKX_PARTIES_V PARTY
WHERE OKL.SCS_CODE = 'INVESTOR'
AND OKL.ID = PARTY_ROLE.DNZ_CHR_ID
AND PARTY_ROLE.RLE_CODE = 'INVESTOR'
AND PARTY_ROLE.OBJECT1_ID1 = PARTY.ID1

Columns