[Home] [Help]
View: OKL_K_VENDOR_PROGRAMS_UV
View Text
SELECT VND.ID1 VENDOR_ID
, VND.NAME VENDOR_NAME
, PROG.ID PROGRAM_ID
, PROG.CONTRACT_NUMBER PROGRAM_NUMBER
, PROG.SHORT_DESCRIPTION PROGRAM_NAME
, LEASE.ID CONTRACT_ID
, LEASE.CONTRACT_NUMBER CONTRACT_NUMBER
, LEASE.SHORT_DESCRIPTION CONTRACT_DESCRIPTION
, LEASE.CURRENCY_CODE
FROM OKC_K_HEADERS_V PROG
, OKC_K_HEADERS_V LEASE
, OKL_K_HEADERS KHR
, OKC_K_PARTY_ROLES_B PTY
, OKX_VENDORS_V VND
WHERE KHR.ID = LEASE.ID
AND KHR.KHR_ID = PROG.ID
AND PROG.SCS_CODE = 'PROGRAM'
AND LEASE.SCS_CODE IN ('LEASE'
, 'LOAN')
AND PROG.ID = PTY.CHR_ID
AND PTY.RLE_CODE = 'OKL_VENDOR'
AND PTY.OBJECT1_ID1 = VND.ID1
AND PTY.OBJECT1_ID2 = VND.ID2
Columns
Name |
VENDOR_ID |
VENDOR_NAME |
PROGRAM_ID |
PROGRAM_NUMBER |
PROGRAM_NAME |
CONTRACT_ID |
CONTRACT_NUMBER |
CONTRACT_DESCRIPTION |
CURRENCY_CODE |