VIEW: APPS.OKL_BPD_DISB_CONTRACT_LOV_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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