DBA Data[Home] [Help]

APPS.AP_TP_STMT_PKG dependencies on AP_INVOICE_PAYMENTS

Line 239: FROM ap_invoice_payments aip

235: OR (P_UNAPPROVED_TRX = 'Y' ))
236: UNION ALL
237: SELECT 'P' transaction_type
238: ,SUM(NVL(aip.amount * NVL(aip.exchange_rate,1),0)) accounted_amount
239: FROM ap_invoice_payments aip
240: ,ap_checks ac
241: WHERE aip.check_id = ac.check_id
242: AND ac.vendor_id = p_in_vendor_id
243: AND ac.vendor_site_id = p_in_vendor_site_id