eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKL_CURE_REFUNDS_HDRS_UV

Source

View Text - Preformatted


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

View Text - HTML Formatted

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