Results for “payment_number”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
ICX_AP_INVOICES_V is a PL/SQL view owned by the APPS schema in Oracle E-Business Suite, classified as a "Received Invoices View" within the iProcurement (ICX) product family. It presents a consolidated, user-facing snapshot of payables invoices that have been received against purchase orders, exposing header-level invoice information together with derived payment, vendor, and purchase order attributes. In Oracle EBS 12.1.1 and 12.2.2 the view serves as a query layer that shields iProcurement and related self-service pages from the complexity of joining the underlying Payables and Purchasing base tables directly. Because it returns formatted currency amounts, translated lookup descriptions, and computed withheld and payment figures, it is well suited to reporting, notification, and integration scenarios that require invoice data in a presentation-ready form rather than a normalized transactional format.
Underlying Base Objects
The view is defined over a join of several Payables and Purchasing objects. Documented base objects include AP_INVOICES, AP_INVOICE_DISTRIBUTIONS, AP_PAYMENT_SCHEDULES, AP_LOOKUP_CODES, PO_HEADERS, PO_DISTRIBUTIONS_AP_V, PO_VENDORS, and PO_VENDOR_SITES, together with the packages FND_CURRENCY, FND_GLOBAL, ICX_AP_INVOICES_PKG, and ICX_AP_INVOICE_PAYMENTS_PKG. The primary join links AP_INVOICES to AP_PAYMENT_SCHEDULES on INVOICE_ID and to AP_INVOICE_DISTRIBUTIONS on INVOICE_ID, with the distribution further linked to PO_DISTRIBUTIONS_AP_V via PO_DISTRIBUTION_ID and to PO_HEADERS via PO_HEADER_ID. Vendor identity is resolved through PO_VENDORS and PO_VENDOR_SITES. AP_LOOKUP_CODES is outer-joined twice to translate the invoice type and payment status flags. The DISTINCT keyword suppresses duplication introduced by the multi-line distribution join, and the package functions supply formatted currency masks and calculated amounts. Several referenced objects, such as PO_VENDORS and PO_VENDOR_SITES, are themselves views.
Key Columns
- PO_NUMBER — Purchase order segment value (SEGMENT1) associated with the invoice distribution.
- INVOICE_ID / INVOICE_NUM / DESCRIPTION — Primary invoice identifier, supplier-facing invoice number, and invoice description.
- INVOICE_AMOUNT / INVOICE_CURRENCY_CODE — Invoice amount formatted using the currency format mask, with its ISO currency code.
- WITHHELD_AMOUNT_CURRENCY_CODE — Amount withheld, returned by ICX_AP_INVOICES_PKG.GET_AMOUNT_WITHHELD and concatenated with the currency code.
- INVOICE_DATE / DUE_DATE / DISCOUNT_DATE — Invoice date and payment schedule due and discount dates.
- GROSS_AMOUNT / AMOUNT_REMAINING / DISCOUNT_AMOUNT_AVAILABLE — Payment schedule figures formatted with the currency mask.
- INVOICE_TYPE / PAYMENT_STATUS — Translated display values from AP_LOOKUP_CODES.
- PAYMENT_NUMBER — Returned by ICX_AP_INVOICE_PAYMENTS_PKG.GET_PAID_BY_LIST, combining invoice and schedule payment number.
- VENDOR_ID / VENDOR_SITE_ID / VENDOR_SITE_CODE / EMPLOYEE_ID — Supplier and supplier site identifiers, site code, and the employee reference from PO_VENDORS.
Common Use Cases and Queries
The view is typically queried to present received invoices to procurement users or to feed downstream reporting. A representative query filters by vendor site and orders by invoice date: SELECT po_number, invoice_num, invoice_amount, invoice_currency_code, payment_status FROM apps.icx_ap_invoices_v WHERE vendor_site_id = :site_id ORDER BY invoice_date DESC; Another common pattern groups by PO number to summarize invoiced value: SELECT po_number, COUNT(*) invoice_count, SUM(...) FROM apps.icx_ap_invoices_v GROUP BY po_number; Because amounts are already formatted as character strings, arithmetic aggregation requires care, and consumers should be aware that the DISTINCT and outer joins may affect row counts where invoices span multiple distributions. Filters on invoice_type or payment_status leverage the translated display values, making the view convenient for end-user search pages and notification content in iProcurement.
-
View: ICX_AP_INVOICES_V 12.1.1
Received Invoices View
APPS.ICX_AP_INVOICES_V·↳ AP_INVOICES·↳ AP_INVOICE_DISTRIBUTIONS·↳ AP_LOOKUP_CODES·Explore ICX module →
-
View: AP_INVOICES_WWW_V 12.2.2
(Release 10SC Only)
APPS.AP_INVOICES_WWW_V·↳ AP_INVOICES·↳ AP_INVOICES_PKG·↳ AP_INVOICE_PAYMENTS_PKG·Explore AP module →
-
APPS.POS_PO_SUP_ORDER_INVOICES_V·↳ AP_INVOICES_ALL·↳ AP_INVOICE_DISTRIBUTIONS_ALL·↳ AP_LOOKUP_CODES·Explore PO module →
-
APPS.AP_XML_INVOICE2_LEVEL_V·↳ AP_INVOICES·↳ AP_INVOICE_SELECTION_CRITERIA·↳ AP_SELECTED_INVOICES·Explore AP module →
-
View: LNS_REC_ACT_CASH_CM_V 12.1.1
Receipts and Creadit Memo Receivable Activities View
APPS.LNS_REC_ACT_CASH_CM_V·↳ AR_LOOKUPS·↳ AR_PAYMENT_SCHEDULES_ALL·↳ AR_RECEIVABLE_APPLICATIONS_ALL·Explore LNS module →
-
View: LNS_REC_ACT_ADJ_V 12.1.1
Receipts and Creadit Memo Receivable Activities View
APPS.LNS_REC_ACT_ADJ_V·↳ AR_ADJUSTMENTS_ALL·↳ AR_LOOKUPS·↳ AR_PAYMENT_SCHEDULES_ALL·Explore LNS module →
-
Purchase Order Invoices View
APPS.ICX_PO_SUP_ORDER_INVOICES_V·↳ AP_INVOICES·↳ AP_INVOICE_DISTRIBUTIONS·↳ AP_LOOKUP_CODES·Explore ICX module →
-
Purchase Order Invoices View
APPS.ICX_PO_SUP_ORDER_INVOICES_V·↳ AP_INVOICES·↳ AP_INVOICE_DISTRIBUTIONS·↳ AP_LOOKUP_CODES·Explore ICX module →
-
APPS.POS_PO_SUP_ORDER_INVOICES_V·↳ AP_INVOICES_ALL·↳ AP_INVOICE_DISTRIBUTIONS_ALL·↳ AP_LOOKUP_CODES·Explore PO module →
-
View: POS_AP_INVOICES_V 12.2.2
used to select the invoice details
APPS.POS_AP_INVOICES_V·↳ AP_INVOICES_ALL·↳ AP_LOOKUP_CODES·↳ AP_PAYMENT_SCHEDULES_ALL·Explore POS module →
-
APPS.OE_AK_HEADER_PAYMENTS_V·↳ OE_PAYMENTS·Explore ONT module →
-
View: POS_AP_INVOICES_V 12.1.1
APPS.POS_AP_INVOICES_V·↳ AP_INVOICES_ALL·↳ AP_LOOKUP_CODES·↳ AP_PAYMENT_SCHEDULES_ALL·Explore PO module →
-
View: LNS_AM_SCHEDS_DTL_V 12.1.1
Amortization Schedule Details View
APPS.LNS_AM_SCHEDS_DTL_V·↳ AR_PAYMENT_SCHEDULES_ALL·↳ FND_GLOBAL·↳ LNS_AMORTIZATION_SCHEDS·Explore LNS module →
-
Loans Custom Schedule Table
-
View: LNS_AM_SCHEDS_V 12.1.1
Amortization Schedules View
APPS.LNS_AM_SCHEDS_V·↳ AR_ADJUSTMENTS_ALL·↳ AR_PAYMENT_SCHEDULES_ALL·↳ AR_RECEIVABLE_APPLICATIONS_ALL·Explore LNS module →
-
Employee Expense Reports Header View
APPS.ICX_AP_EXPENSE_REPORTS_V·↳ AP_EXPENSE_REPORT_HEADERS·↳ AP_INVOICES·↳ AP_LOOKUP_CODES·Explore ICX module →
-
View: AP_INVOICES_WWW_V 12.1.1
(Release 10SC Only)
APPS.AP_INVOICES_WWW_V·↳ AP_INVOICES·↳ AP_INVOICES_PKG·↳ AP_INVOICE_PAYMENTS_PKG·Explore AP module →
-
View: ICX_AP_INVOICES_V 12.2.2
Received Invoices View
APPS.ICX_AP_INVOICES_V·↳ AP_INVOICES·↳ AP_INVOICE_DISTRIBUTIONS·↳ AP_LOOKUP_CODES·Explore ICX module →
-
APPS.POS_AP_EXPENSE_REPORTS_V·↳ AP_EXPENSE_REPORT_HEADERS_ALL·↳ AP_INVOICES_ALL·↳ AP_LOOKUP_CODES·Explore PO module →
-
APPS.POS_AP_EXPENSE_REPORTS_V·↳ AP_EXPENSE_REPORT_HEADERS_ALL·↳ AP_INVOICES_ALL·↳ AP_LOOKUP_CODES·Explore PO module →
-
View: POS_AP_INVOICES_V 12.2.2
APPS.POS_AP_INVOICES_V·↳ AP_INVOICES_ALL·↳ AP_LOOKUP_CODES·↳ AP_PAYMENT_SCHEDULES_ALL·Explore PO module →
-
This view contains billing and payment history information for every loan in the system
APPS.LNS_AMORTIZATION_SCHEDULES_V·↳ AR_PAYMENT_SCHEDULES_ALL·↳ AR_RECEIVABLE_APPLICATIONS_ALL·↳ FND_GLOBAL·Explore LNS module →
-
Business view
APPS.APFV_AP_INVOICE_PAYMENTS·↳ AP_CHECKS_ALL·↳ AP_INVOICES_ALL·↳ AP_INVOICE_PAYMENTS·Explore AP module →
-
Table to store payment audit trail.
-
Table to store payment audit trail.
-
Obsolete
APPS.ICX_PO_MATCHED_INVOICES_V·↳ AP_INVOICE_DISTRIBUTIONS·↳ FND_CURRENCY·↳ FND_GLOBAL·Explore ICX module →
-
Loans Custom Schedule Table
-
View: XLA_AR_REC_AEL_GL_V 12.2.2
APPS.XLA_AR_REC_AEL_GL_V·↳ ARPT_SQL_FUNC_UTIL·↳ AR_AEL_GL_REC_ALL_V·↳ FND_ACCESS_CONTROL_UTIL·Explore XLA module →
-
Interface table for transfer of refund data to a payables system.
-
View: XLA_INV_AEL_GL_V 12.1.1
APPS.XLA_INV_AEL_GL_V·↳ CST_AEL_GL_INV_V·Explore XLA module →
-
View: XLA_PO_AEL_SL_PAC_V 12.1.1
APPS.XLA_PO_AEL_SL_PAC_V·↳ CST_PAC_AEL_SL_RCV_V·↳ FND_GLOBAL·↳ HR_GENERAL·Explore XLA module →
-
View: XLA_WIP_AEL_SL_PAC_V 12.2.2
APPS.XLA_WIP_AEL_SL_PAC_V·↳ CST_PAC_AEL_SL_WIP_V·↳ HR_GENERAL·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_FA_AEL_SL_MRC_V 12.2.2
APPS.XLA_FA_AEL_SL_MRC_V·↳ FA_AEL_SL_MRC_V·Explore XLA module →
-
View: XLA_PO_AEL_SL_MRC_V 12.1.1
APPS.XLA_PO_AEL_SL_MRC_V·↳ FND_GLOBAL·↳ HR_GENERAL·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_JL_FA_AEL_SL_V 12.1.1
APPS.XLA_JL_FA_AEL_SL_V·↳ JL_CO_FA_AEL_SL_V·Explore XLA module →
-
View: XLA_WIP_AEL_SL_V 12.1.1
APPS.XLA_WIP_AEL_SL_V·↳ CST_AEL_SL_WIP_V·↳ HR_GENERAL·↳ HR_SECURITY·Explore XLA module →
-
APPS.XLA_AR_REC_AEL_SL_MRC_V·↳ ARPT_SQL_FUNC_UTIL·↳ AR_AEL_SL_REC_MRC_V·↳ FND_ACCESS_CONTROL_UTIL·Explore XLA module →
-
View: XLA_INV_AEL_GL_V 12.2.2
APPS.XLA_INV_AEL_GL_V·↳ CST_AEL_GL_INV_V·Explore XLA module →
-
View: XLA_PSA_PO_ENC_BC_GL_V 12.2.2
APPS.XLA_PSA_PO_ENC_BC_GL_V·↳ FND_GLOBAL·↳ HR_GENERAL·↳ HR_SECURITY·Explore XLA module →
-
View: XLA_AR_REC_AEL_SL_V 12.2.2
APPS.XLA_AR_REC_AEL_SL_V·↳ ARPT_SQL_FUNC_UTIL·↳ AR_AEL_SL_REC_V·↳ FND_ACCESS_CONTROL_UTIL·Explore XLA module →
-
View: XLA_PO_AEL_GL_V 12.2.2
APPS.XLA_PO_AEL_GL_V·↳ FND_GLOBAL·↳ HR_GENERAL·↳ HR_SECURITY·Explore XLA module →
-
View: APFV_PAYMENT_SCHEDULES 12.2.2
Business view
APPS.APFV_PAYMENT_SCHEDULES·↳ AP_INVOICES_ALL·↳ AP_PAYMENT_SCHEDULES·↳ PO_VENDORS·Explore AP module →
-
View: LNS_AR_AMORTIZATIONS_V 12.2.2
This view contains basic billing and payment information for every loan in the system.
-
View: JAI_AR_TRX_AEL_SL_V 12.2.2
APPS.JAI_AR_TRX_AEL_SL_V·↳ JAI_AR_TRX_AEL_V·Explore JA module →
-
View: JAI_AP_SET_AEL_SL_V 12.2.2
APPS.JAI_AP_SET_AEL_SL_V·↳ FND_GLOBAL·↳ JAI_AP_SET_AEL_V·Explore JA module →
-
View: JAI_INV_RG1_AEL_SL_V 12.2.2
APPS.JAI_INV_RG1_AEL_SL_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ JAI_INV_RG1_AEL_V·Explore JA module →
-
APPS.JAI_PO_REC_VAT_AEL_SL_V·↳ FND_GLOBAL·↳ HR_GENERAL·↳ JAI_PO_REC_VAT_AEL_V·Explore JA module →
-
View: XLA_AEL_GL_V 12.1.1
-
View: XLA_OKL_AEL_GL_TRX_V 12.2.2
APPS.XLA_OKL_AEL_GL_TRX_V·↳ OKL_ACCOUNTING_UTIL·↳ OKL_AEL_GL_TRX_V·Explore XLA module →
-
APPS.JAI_INV_INTERORG_AEL_GL_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ JAI_INV_INTERORG_AEL_V·Explore JA module →