VIEW: APPS.FV_PAYABLE_REFUNDS_V

Source

View Text - Preformatted

SELECT apc.vendor_id, apc.vendor_name, po.segment1 vendor_num, apc.vendor_site_code, apc.vendor_site_id, apip.amount refund_amount, apc.check_id, apc.check_number, apc.amount check_amount, apc.check_date refund_gl_date, apip.period_name refund_gl_period, apc.org_id, api.invoice_id, api.invoice_num, api.invoice_amount, api.gl_date invoice_gl_date, apip.set_of_books_id , apip.invoice_payment_id FROM ap_checks_all apc, ap_invoice_payments_all apip, ap_invoices_all api , po_vendors po WHERE apip.set_of_books_id = api.set_of_books_id AND apc.org_id = apip.org_id AND apip.org_id = api.org_id AND apc.check_id = apip.check_id AND apip.invoice_id = api.invoice_id AND po.vendor_id = apc.vendor_id AND api.invoice_type_lookup_code IN ( 'CREDIT','DEBIT') AND apc.payment_type_flag = 'R' AND apip.posted_flag = 'Y' AND apip.reversal_inv_pmt_id IS NULL

View Text - HTML Formatted

SELECT APC.VENDOR_ID
, APC.VENDOR_NAME
, PO.SEGMENT1 VENDOR_NUM
, APC.VENDOR_SITE_CODE
, APC.VENDOR_SITE_ID
, APIP.AMOUNT REFUND_AMOUNT
, APC.CHECK_ID
, APC.CHECK_NUMBER
, APC.AMOUNT CHECK_AMOUNT
, APC.CHECK_DATE REFUND_GL_DATE
, APIP.PERIOD_NAME REFUND_GL_PERIOD
, APC.ORG_ID
, API.INVOICE_ID
, API.INVOICE_NUM
, API.INVOICE_AMOUNT
, API.GL_DATE INVOICE_GL_DATE
, APIP.SET_OF_BOOKS_ID
, APIP.INVOICE_PAYMENT_ID
FROM AP_CHECKS_ALL APC
, AP_INVOICE_PAYMENTS_ALL APIP
, AP_INVOICES_ALL API
, PO_VENDORS PO
WHERE APIP.SET_OF_BOOKS_ID = API.SET_OF_BOOKS_ID
AND APC.ORG_ID = APIP.ORG_ID
AND APIP.ORG_ID = API.ORG_ID
AND APC.CHECK_ID = APIP.CHECK_ID
AND APIP.INVOICE_ID = API.INVOICE_ID
AND PO.VENDOR_ID = APC.VENDOR_ID
AND API.INVOICE_TYPE_LOOKUP_CODE IN ( 'CREDIT'
, 'DEBIT')
AND APC.PAYMENT_TYPE_FLAG = 'R'
AND APIP.POSTED_FLAG = 'Y'
AND APIP.REVERSAL_INV_PMT_ID IS NULL