VIEW: APPS.OKL_C_V_RULES_UV

Source

View Text - Preformatted

SELECT vnd.id1 vendor_id ,vnd.name vendor_name ,prog.id vendor_program_id ,prog.contract_number vendor_program_number ,prog.short_description vendor_program_name ,lease.id contract_id ,lease.contract_number contract_number ,lease.short_description contract_description ,rul.rule_information_category rule_code ,rul.rule_information1 rule_information1 ,rul.rule_information2 rule_information2 ,rul.rule_information3 rule_information3 ,rul.rule_information4 rule_information4 ,rul.rule_information5 rule_information5 ,rul.rule_information6 rule_information6 ,rul.rule_information7 rule_information7 ,rul.rule_information8 rule_information8 ,rul.rule_information9 rule_information9 ,rul.rule_information10 rule_information10 ,rul.rule_information11 rule_information11 ,rul.rule_information12 rule_information12 ,rul.rule_information13 rule_information13 ,rul.rule_information14 rule_information14 ,rul.rule_information15 rule_information15 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,OKC_RULES_B RUL 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 prog.id = rul.dnz_chr_id AND pty.rle_code = 'OKL_VENDOR' AND pty.object1_id1 = vnd.id1 AND pty.object1_id2 = vnd.id2

View Text - HTML Formatted

SELECT VND.ID1 VENDOR_ID
, VND.NAME VENDOR_NAME
, PROG.ID VENDOR_PROGRAM_ID
, PROG.CONTRACT_NUMBER VENDOR_PROGRAM_NUMBER
, PROG.SHORT_DESCRIPTION VENDOR_PROGRAM_NAME
, LEASE.ID CONTRACT_ID
, LEASE.CONTRACT_NUMBER CONTRACT_NUMBER
, LEASE.SHORT_DESCRIPTION CONTRACT_DESCRIPTION
, RUL.RULE_INFORMATION_CATEGORY RULE_CODE
, RUL.RULE_INFORMATION1 RULE_INFORMATION1
, RUL.RULE_INFORMATION2 RULE_INFORMATION2
, RUL.RULE_INFORMATION3 RULE_INFORMATION3
, RUL.RULE_INFORMATION4 RULE_INFORMATION4
, RUL.RULE_INFORMATION5 RULE_INFORMATION5
, RUL.RULE_INFORMATION6 RULE_INFORMATION6
, RUL.RULE_INFORMATION7 RULE_INFORMATION7
, RUL.RULE_INFORMATION8 RULE_INFORMATION8
, RUL.RULE_INFORMATION9 RULE_INFORMATION9
, RUL.RULE_INFORMATION10 RULE_INFORMATION10
, RUL.RULE_INFORMATION11 RULE_INFORMATION11
, RUL.RULE_INFORMATION12 RULE_INFORMATION12
, RUL.RULE_INFORMATION13 RULE_INFORMATION13
, RUL.RULE_INFORMATION14 RULE_INFORMATION14
, RUL.RULE_INFORMATION15 RULE_INFORMATION15
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
, OKC_RULES_B RUL
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 PROG.ID = RUL.DNZ_CHR_ID
AND PTY.RLE_CODE = 'OKL_VENDOR'
AND PTY.OBJECT1_ID1 = VND.ID1
AND PTY.OBJECT1_ID2 = VND.ID2