VIEW: APPS.OKL_REFUND_UV

Source

View Text - Preformatted

SELECT prog.id VENDOR_PROGRAM_ID ,chr.id CHR_ID ,chr.contract_number CONTRACT_NUMBER ,chr.short_description CONTRACT_DESCRIPTION ,prog.short_description VENDOR_PROGRAM ,pty.name CUSTOMER_NAME ,crf.amount REFUND_AMOUNT ,(crf.amount - crf.balance) TOTAL_REFUNDED ,crf.balance BALANCE ,nvl(NULL,0) ,NULL ,NULL ,CRF.cure_refund_id ,vnd.id1 vendor_id FROM OKX_VENDORS_V VND,OKC_K_PARTY_ROLES_V VLE,OKL_CURE_REFUNDS_ALL CRF,OKC_K_PARTY_ROLES_V RLE,OKX_PARTIES_V PTY,OKL_K_HEADERS_V LEASE,OKC_K_HEADERS_V PROG,OKC_K_HEADERS_V CHR WHERE CRF.chr_id = CHR.id and LEASE.id = CHR.id and LEASE.khr_id = PROG.id and PROG.scs_code = 'PROGRAM' and CHR.scs_code in ('LEASE','LOAN') and RLE.chr_id = CHR.id and RLE.object1_id1 = PTY.id1 and RLE.object1_id2 = PTY.id2 and RLE.rle_code = 'LESSEE' and CRF.status in ('PENDING','PARTIAL_REFUND') AND CRF.balance > 0 AND prog.id = vle.chr_id AND vle.rle_code = 'OKL_VENDOR' AND vle.object1_id1 = vnd.id1 AND vle.object1_id2 = vnd.id2

View Text - HTML Formatted

SELECT PROG.ID VENDOR_PROGRAM_ID
, CHR.ID CHR_ID
, CHR.CONTRACT_NUMBER CONTRACT_NUMBER
, CHR.SHORT_DESCRIPTION CONTRACT_DESCRIPTION
, PROG.SHORT_DESCRIPTION VENDOR_PROGRAM
, PTY.NAME CUSTOMER_NAME
, CRF.AMOUNT REFUND_AMOUNT
, (CRF.AMOUNT - CRF.BALANCE) TOTAL_REFUNDED
, CRF.BALANCE BALANCE
, NVL(NULL
, 0)
, NULL
, NULL
, CRF.CURE_REFUND_ID
, VND.ID1 VENDOR_ID
FROM OKX_VENDORS_V VND
, OKC_K_PARTY_ROLES_V VLE
, OKL_CURE_REFUNDS_ALL CRF
, OKC_K_PARTY_ROLES_V RLE
, OKX_PARTIES_V PTY
, OKL_K_HEADERS_V LEASE
, OKC_K_HEADERS_V PROG
, OKC_K_HEADERS_V CHR
WHERE CRF.CHR_ID = CHR.ID
AND LEASE.ID = CHR.ID
AND LEASE.KHR_ID = PROG.ID
AND PROG.SCS_CODE = 'PROGRAM'
AND CHR.SCS_CODE IN ('LEASE'
, 'LOAN')
AND RLE.CHR_ID = CHR.ID
AND RLE.OBJECT1_ID1 = PTY.ID1
AND RLE.OBJECT1_ID2 = PTY.ID2
AND RLE.RLE_CODE = 'LESSEE'
AND CRF.STATUS IN ('PENDING'
, 'PARTIAL_REFUND')
AND CRF.BALANCE > 0
AND PROG.ID = VLE.CHR_ID
AND VLE.RLE_CODE = 'OKL_VENDOR'
AND VLE.OBJECT1_ID1 = VND.ID1
AND VLE.OBJECT1_ID2 = VND.ID2