[Home] [Help]
View: OKL_REFUND_UV
Product: | OKL - Lease 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
Name |
VENDOR_PROGRAM_ID |
CHR_ID |
CONTRACT_NUMBER |
CONTRACT_DESCRIPTION |
VENDOR_PROGRAM |
CUSTOMER_NAME |
REFUND_AMOUNT |
TOTAL_REFUNDED |
BALANCE |
AMOUNT_RECEIVED |
CHOICE |
SELECT_FLAG |
CURE_REFUND_ID |
VENDOR_ID |