View: OKL_LA_ASSET_PARTIES_UV

Product:	OKL - Lease and Finance Management
Description:	User interface view for asset vendor list of values page - funding
Implementation/DBA Data:	APPS.OKL_LA_ASSET_PARTIES_UV

View Text

SELECT CHP.ID ID
, CHP.DNZ_CHR_ID DNZ_CHR_ID
, CHP.CLE_ID CLE_ID
, CHP.OBJECT1_ID1 OBJECT1_ID1
, CHP.OBJECT1_ID2 OBJECT1_ID2
, CHP.JTOT_OBJECT1_CODE JTOT_OBJECT1_CODE
, PV.VENDOR_NAME VENDOR_NAME
, PV.VENDOR_ID VENDOR_ID
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 = '#'

Columns