[Home] [Help]
View: OKL_BPD_DISB_CONTRACT_LOV_UV
Product: | OKL - Leasing 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
Name |
CONTRACT_ID |
CONTRACT_NUMBER |
CURRENCY_CODE |
VENDOR_ID |
VENDOR_NAME |
VENDOR_NUMBER |