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.

VIEW: APPS.ICX_AP_INVOICE_PAYMENTS_V

Source

View Text - Preformatted


SELECT AI.INVOICE_NUM INVOICE_NUM , AI.INVOICE_ID INVOICE_ID , AI.INVOICE_CURRENCY_CODE INVOICE_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 , TO_CHAR(AIP.AMOUNT , FND_CURRENCY.SAFE_GET_FORMAT_MASK(AC.CURRENCY_CODE,30)) AMOUNT , TO_CHAR(NVL(AIP.DISCOUNT_TAKEN,0), FND_CURRENCY.SAFE_GET_FORMAT_MASK(AC.CURRENCY_CODE,30)) DISCOUNT_TAKEN , AIP.ACCOUNTING_DATE ACCOUNTING_DATE , AIP.INVOICE_PAYMENT_ID INVOICE_PAYMENT_ID 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

View Text - HTML Formatted

SELECT AI.INVOICE_NUM INVOICE_NUM
, AI.INVOICE_ID INVOICE_ID
, AI.INVOICE_CURRENCY_CODE INVOICE_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
, TO_CHAR(AIP.AMOUNT
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(AC.CURRENCY_CODE
, 30)) AMOUNT
, TO_CHAR(NVL(AIP.DISCOUNT_TAKEN
, 0)
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(AC.CURRENCY_CODE
, 30)) DISCOUNT_TAKEN
, AIP.ACCOUNTING_DATE ACCOUNTING_DATE
, AIP.INVOICE_PAYMENT_ID INVOICE_PAYMENT_ID
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