View: OKL_REFUND_UV

Product:	OKL - Leasing and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_REFUND_UV

View Text

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

Columns