View: OKL_CURE_REFUNDS_SUMRY_UV

Product:	OKL - Lease and Finance Management
Description:	List all the cure refunds along with the invoice and the disbursed amount
Implementation/DBA Data:	APPS.OKL_CURE_REFUNDS_SUMRY_UV

View Text

SELECT CRF.CURE_REFUND_ID
, CRH.CURE_REFUND_HEADER_ID
, CRH.REFUND_HEADER_NUMBER
, CRH.REFUND_DUE_DATE
, CRF.DISBURSEMENT_AMOUNT
, CRF.TOTAL_REFUND_DUE
, CRF.REFUND_DATE
, CRF.CHR_ID
, OKC.CONTRACT_NUMBER
, CRF.TAP_ID
, TAP.INVOICE_NUMBER
, TAP.CURRENCY_CODE
, TAP.PAYMENT_METHOD_CODE
, TAP.IPPT_ID
, OPT.NAME
, TAP.TRX_STATUS_CODE
, PVS.VENDOR_ID
, CRF.VENDOR_SITE_ID
, PVS.VENDOR_SITE_CODE
FROM OKL_CURE_REFUND_HEADERS_B CRH
, OKL_TRX_AP_INVOICES_V TAP
, PO_VENDOR_SITES_ALL PVS
, OKL_CURE_REFUNDS CRF
, OKC_K_HEADERS_ALL_B OKC
, OKX_PAYABLES_TERMS_V OPT
WHERE OKC.ID=CRF.CHR_ID
AND CRF.VENDOR_SITE_ID=PVS.VENDOR_SITE_ID
AND CRH.CURE_REFUND_HEADER_ID = CRF.CURE_REFUND_HEADER_ID
AND CRF.TAP_ID=TAP.ID
AND TAP.IPPT_ID = OPT.ID1(+)

Columns