View: OKL_LA_VENDORS_UV

Product:	OKL - Lease and Finance Management
Description:	User interface view for asset vendors lists of values page
Implementation/DBA Data:	APPS.OKL_LA_VENDORS_UV

View Text

SELECT CHP.ID ID
, PV.SEGMENT1 SEGMENT1
, PV.VENDOR_ID VENDOR_ID
, PV.VENDOR_NAME VENDOR_NAME
, CHP.DNZ_CHR_ID DNZ_CHR_ID
, CHP.OBJECT1_ID1 OBJECT1_ID1
, CHP.OBJECT1_ID2 OBJECT1_ID2
FROM OKC_K_PARTY_ROLES_B CHP
, PO_VENDORS PV
WHERE CHP.RLE_CODE = 'OKL_VENDOR'
AND PV.VENDOR_ID = CHP.OBJECT1_ID1
AND CHP.OBJECT1_ID2 = '#'
AND CLE_ID IS NULL

Columns