AP CHECKS STATUS INFORMATION

AP CHECKS STATUS INFORMATION

SELECT    PVS.Attribute6 "SUPPLIER SITE TYPE"
,GSOB.NAME "SET OF BOOKS NAME"
,AC.CHECK_NUMBER
 ,AC.CHECK_DATE
 ,TRUNC(SYSDATE-AC.CHECK_DATE) "AGE OF CHECK"
 ,AI.PAYMENT_CURRENCY_CODE "PAYMENT CURRENCY CODE"
 ,AC.AMOUNT "CHECK AMOUNT"
 ,AIA.INVOICE_NUM "INVOICE NUMBER"
 ,AI.INVOICE_CURRENCY_CODE "INVOICE CURRENCY CODE"
 ,AI.AMOUNT_PAID "INVOICE AMOUNT PAID"
 ,PV.VENDOR_NAME "SUPPLIER NAME"
 ,PVS.VENDOR_SITE_CODE "SUPPLIER SITE CODE"
 ,AID.DESCRIPTION "DESCRIPTION"
 ,PVS.ADDRESS_LINE1 "ADDRESS LINE1"
 ,PVS.ADDRESS_LINE2 "ADDRESS LINE2"
 ,PVS.ADDRESS_LINE3 "ADDRESS LINE3"
 ,PVS.CITY "CITY"
 ,PVS.STATE "STATE"
 ,PVS.ZIP "ZIP"
FROM   PO_VENDOR_SITES PVS
,GL_SETS_OF_BOOKS GSOB
,AP_CHECKS AC
 ,AP_INVOICES AI
 ,AP_INVOICES_ALL AIA
 ,PO_VENDORS PV
 ,AP_INVOICE_DISTRIBUTIONS AID