VIEW: APPS.OKL_CURE_REFUNDS_SUMRY_UV

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)