eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: AP_INVOICE_PAYMENTS_WWW_V

Product:	AP - Payables
Description:	(Release 10SC Only)
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT AI.INVOICE_NUM INVOICE_NUM
, AI.INVOICE_ID INVOICE_ID
, AI.INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, TO_CHAR(AI.INVOICE_AMOUNT) || ' ' || AI.INVOICE_CURRENCY_CODE INVOICE_AMOUNT_CURRENCY_CODE
, AC.CHECK_NUMBER CHECK_NUMBER
, AC.CHECK_ID CHECK_ID
, AC.CURRENCY_CODE CHECK_CURRENCY_CODE
, AC.VENDOR_SITE_ID VENDOR_SITE_ID
, AC.VENDOR_ID VENDOR_ID
, AIP.AMOUNT AMOUNT
, TO_CHAR(AIP.AMOUNT) || ' ' || AC.CURRENCY_CODE AMOUNT_CURRENCY_CODE
, NVL(AIP.DISCOUNT_TAKEN
, 0) DISCOUNT_TAKEN
, AIP.ACCOUNTING_DATE ACCOUNTING_DATE
FROM AP_INVOICE_PAYMENTS AIP
, AP_INVOICES AI
, AP_CHECKS AC
WHERE AIP.INVOICE_ID = AI.INVOICE_ID
AND AIP.CHECK_ID = AC.CHECK_ID

Columns

Name
INVOICE_NUM
INVOICE_ID
INVOICE_CURRENCY_CODE
INVOICE_AMOUNT_CURRENCY_CODE
CHECK_NUMBER
CHECK_ID
CHECK_CURRENCY_CODE
VENDOR_SITE_ID
VENDOR_ID
AMOUNT
AMOUNT_CURRENCY_CODE
DISCOUNT_TAKEN
ACCOUNTING_DATE