View: OKL_BPD_DISB_CONTRACT_LOV_UV

Product:	OKL - Lease and Finance Management
Description:	View to populate lov in the disbursement screen.
Implementation/DBA Data:	APPS.OKL_BPD_DISB_CONTRACT_LOV_UV

View Text

SELECT KHR.ID CONTRACT_ID
, KHR.CONTRACT_NUMBER CONTRACT_NUMBER
, KHR.CURRENCY_CODE CURRENCY_CODE
, V.ID1 VENDOR_ID
, V.NAME VENDOR_NAME
, V.PARTY_NUMBER VENDOR_NUMBER
FROM OKC_K_HEADERS_B KHR
, OKC_K_PARTY_ROLES_V PARTY_ROLE
, OKX_VENDORS_V V
WHERE KHR.ID = PARTY_ROLE.CHR_ID
AND PARTY_ROLE.RLE_CODE = 'OKL_VENDOR'
AND V.ID1 = PARTY_ROLE.OBJECT1_ID1

Columns