View: OKL_LEASE_VENDORS_UV

Product:	OKL - Lease and Finance Management
Description:	JTF Object Reference for Evergreen Eligibility
Implementation/DBA Data:	APPS.OKL_LEASE_VENDORS_UV

View Text

SELECT POVV.VENDOR_ID ID1
, CHPB.ID ID2
, POVV.VENDOR_NAME NAME
, POVV.SEGMENT1 DESCRIPTION
, CHPB.DNZ_CHR_ID DNZ_CHR_ID
FROM OKC_K_PARTY_ROLES_B CHPB
, PO_VENDORS POVV
WHERE CHPB.RLE_CODE = 'OKL_VENDOR'
AND POVV.VENDOR_ID = CHPB.OBJECT1_ID1
AND CHPB.OBJECT1_ID2 = '#'
AND CHPB.JTOT_OBJECT1_CODE = 'OKX_VENDOR'
AND CHPB.CLE_ID IS NULL
AND CHPB.CHR_ID = CHPB.DNZ_CHR_ID

Columns