View: FV_PAYABLE_REFUNDS_V

Product:	FV - Federal Financials
Description:	Retrieves Refund payment details from Account Payables
Implementation/DBA Data:	APPS.FV_PAYABLE_REFUNDS_V

View Text

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
AND EXISTS (SELECT 1
FROM GL_JE_LINES GLJL
, AP_INVOICE_DISTRIBUTIONS_ALL APID WHERE GLJL.LEDGER_ID = APID.SET_OF_BOOKS_ID
AND GLJL.STATUS = 'P' AND GLJL.CODE_COMBINATION_ID = APID.DIST_CODE_COMBINATION_ID AND APID.INVOICE_ID = API.INVOICE_ID AND GLJL.REFERENCE_2 = TO_CHAR(API.INVOICE_ID))

Columns