View: OKL_CURE_REFUNDS_HDRS_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_HDRS_UV

View Text

SELECT CRD.CURE_REFUND_HEADER_ID
, CRD.REFUND_HEADER_NUMBER
, CRD.REFUND_DUE_DATE
, CRD.CURRENCY_CODE
, NVL(CRD.DISBURSEMENT_AMOUNT
, 0) DISBURSEMENT_AMOUNT
, CRD.REFUND_STATUS
, LOOKUP.MEANING
, CRD.PAYMENT_METHOD
, CRD.PAYMENT_TERM_ID
, OPT.NAME
, PVS.VENDOR_ID
, CRD.VENDOR_SITE_ID
, PVS.VENDOR_SITE_CODE
, NVL(VCURE.VENDOR_CURE_DUE
, 0) VENDOR_CURE_DUE
, CRD.DESCRIPTION
, NVL(CRD.OFFSET_AMOUNT
, 0) OFFSET_AMOUNT
, NVL(CRD.RECEIVED_AMOUNT
, 0) RECEIVED_AMOUNT
, PV.VENDOR_NAME VENDOR_NAME
, (PVS.ADDRESS_LINE1|| DECODE(PVS.ADDRESS_LINE2
, NULL
, PVS.ADDRESS_LINE2
, '
, ' ||PVS.ADDRESS_LINE2) ||DECODE(PVS.ADDRESS_LINE3
, NULL
, PVS.ADDRESS_LINE3
, '
, ' ||PVS.ADDRESS_LINE3) || DECODE(PVS.CITY
, NULL
, PVS.CITY
, '
, '||PVS.CITY) || DECODE(PVS.STATE
, NULL
, PVS.STATE
, '
, '||PVS.STATE) || DECODE(PVS.ZIP
, NULL
, PVS.ZIP
, '
, '||PVS.ZIP) ) VENDOR_ADDRESS
FROM PO_VENDORS PV
, OKL_CURE_REFUND_HEADERS_V CRD
, PO_VENDOR_SITES PVS
, OKX_PAYABLES_TERMS_V OPT
, FND_LOOKUPS LOOKUP
, OKL_CURE_VENDOR_DUE_UV VCURE
WHERE CRD.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID
AND CRD.PAYMENT_TERM_ID = OPT.ID1(+)
AND PVS.VENDOR_ID = VCURE.VENDOR_ID (+)
AND LOOKUP.LOOKUP_CODE =CRD.REFUND_STATUS
AND LOOKUP.LOOKUP_TYPE ='OKL_CURE_REFUND_STATUS'
AND PV.VENDOR_ID = PVS.VENDOR_ID ORDER BY CRD.REFUND_DUE_DATE DESC

Columns