INVOICE PAYMENT CHECK

INVOICE PAYMENT CHECK

SELECT --PVSA.ADDRESS_LINE1 "SUPPLIER SITE TYPE"

GSOBA.NAME "SET OF BOOKS NAME"

,ACA.CHECK_NUMBER "CHECK NUMBER"

,ACA.CHECK_DATE "CHECK DATE"

,TRUNC(SYSDATE-ACA.CHECK_DATE) "AGE OF CHECK"

,AIA.PAYMENT_CURRENCY_CODE "PAYMENT CURRENCY CODE"

,ACA.AMOUNT "CHECK AMOUNT"

,AIA.INVOICE_NUM "INVOICE NUMBER"

,AIA.INVOICE_CURRENCY_CODE "INVOICE CURRENCY CODE"

,AIA.AMOUNT_PAID "INVOICE AMOUNT PAID"

,PV.VENDOR_NAME "SUPPLIER NAME"

,PVSA.VENDOR_SITE_CODE "SUPPLIER SITE CODE"

,AIDA.DESCRIPTION "DESCRIPTION"

,PVSA.ADDRESS_LINE1 "ADDRESS LINE1"

,PVSA.ADDRESS_LINE2 "ADDRESS LINE2"

,PVSA.ADDRESS_LINE3 "ADDRESS LINE3"

,PVSA.CITY "CITY"

,PVSA.STATE "STATE"

,PVSA.ZIP "ZIP"

FROM AP_INVOICES_ALL AIA

,AP_CHECKS_ALL ACA

,AP_INVOICE_PAYMENTS_ALL AIPA

,AP_INVOICE_DISTRIBUTIONS_ALL AIDA

,PO_DISTRIBUTIONS_ALL PDA

,PO_VENDOR_SITES_ALL PVSA

,PO_VENDORS PV

,GL_SETS_OF_BOOKS GSOBA

WHERE AIPA.CHECK_ID=ACA.CHECK_ID

AND AIA.INVOICE_ID=AIPA.INVOICE_ID

AND AIA.INVOICE_ID=AIDA.INVOICE_ID

AND PV.VENDOR_ID=PVSA.VENDOR_ID

AND AIA.VENDOR_ID=PV.VENDOR_ID

AND AIDA.PO_DISTRIBUTION_ID=PDA.PO_DISTRIBUTION_ID

AND AIA.SET_OF_BOOKS_ID=GSOBA.SET_OF_BOOKS_ID