Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Friday, 11 May 2018

AP Invoice Payment Audit Query In Oracle Apps




SELECT   acv.payment_type,
         acv.bank_account_name,
         acv.check_stock_name document_name,
         acv.check_number document_num,
         acv.check_date payment_date,
         acv.amount,
         acv.currency_code,
         acv.payment_method,
         acv.check_status,
         acv.doc_sequence_value voucher_number,
         aip.INVOICE_NUM,
         aip.INVOICE_DATE,
         aip.INVOICE_AMOUNT,
         aip.AMOUNT,
         aip.AMOUNT_PAID,
         aip.DESCRIPTION
  FROM   AP_CHECKS_V acv, ap_invoice_payments_v aip
 WHERE   acv.check_id = aip.CHECK_ID --  and acv.check_number = 422063
         AND UPPER (aip.DESCRIPTION) LIKE '%REJECT%'

Share this article :

0 comments:

Post a Comment