VIEW: APPS.OKL_CURE_VENDOR_PROGRAM_UV

Source

View Text - Preformatted

SELECT vnd.id1 vendor_id ,vnd.name vendor_name ,prog.id program_id ,prog.contract_number program_number ,prog.short_description program_name FROM OKC_K_HEADERS_V PROG,OKC_K_PARTY_ROLES_B PTY,OKX_VENDORS_V VND,OKC_RULE_GROUPS_V RGD WHERE prog.scs_code = 'PROGRAM' AND prog.id = pty.chr_id AND pty.rle_code = 'OKL_VENDOR' AND pty.object1_id1 = vnd.id1 AND pty.object1_id2 = vnd.id2 AND prog.id = rgd.chr_id AND RGD_CODE = 'COCURP'

View Text - HTML Formatted

SELECT VND.ID1 VENDOR_ID
, VND.NAME VENDOR_NAME
, PROG.ID PROGRAM_ID
, PROG.CONTRACT_NUMBER PROGRAM_NUMBER
, PROG.SHORT_DESCRIPTION PROGRAM_NAME
FROM OKC_K_HEADERS_V PROG
, OKC_K_PARTY_ROLES_B PTY
, OKX_VENDORS_V VND
, OKC_RULE_GROUPS_V RGD
WHERE PROG.SCS_CODE = 'PROGRAM'
AND PROG.ID = PTY.CHR_ID
AND PTY.RLE_CODE = 'OKL_VENDOR'
AND PTY.OBJECT1_ID1 = VND.ID1
AND PTY.OBJECT1_ID2 = VND.ID2
AND PROG.ID = RGD.CHR_ID
AND RGD_CODE = 'COCURP'