View: OKL_BPD_DISB_LOV_UV

Product:	OKL - Lease and Finance Management
Description:	View to populate lov in the disbursement screen.
Implementation/DBA Data:	APPS.OKL_BPD_DISB_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_SITE.VENDOR_SITE_ID VENDOR_SITE_ID
, V_SITE.VENDOR_SITE_CODE VENDOR_SITE_CODE
, V_SITE.PAY_GROUP_LOOKUP_CODE PAY_GROUP_LOOKUP_CODE
, V_SITE.PAYMENT_METHOD_LOOKUP_CODE PAYMENT_METHOD_LOOKUP_CODE
, V_SITE.TERMS_ID TERMS_ID
, V_TERMS.TERMS TERMS
FROM PO_VENDOR_SITES_ALL V_SITE
, OKX_VENDORS_V V
, OKC_K_PARTY_ROLES_V PARTY_ROLE
, OKC_K_HEADERS_B KHR
, OKL_BPD_PAY_TERMS_V V_TERMS
WHERE KHR.ID = PARTY_ROLE.CHR_ID
AND PARTY_ROLE.RLE_CODE = 'OKL_VENDOR'
AND V.ID1 = PARTY_ROLE.OBJECT1_ID1
AND V_SITE.VENDOR_ID = V.ID1
AND V_SITE.PAY_SITE_FLAG = 'Y'
AND V_SITE.TERMS_ID = V_TERMS.TERM_ID

Columns