Search Results inv_distribution_total

Overview

APPS.AP_INVOICE_EXTRACT_HEADER_V is a reporting and integration view in the Oracle E-Business Suite Payables (SQLAP) product family. It presents invoice header information in a denormalized, extraction-friendly form intended primarily for feeder programs and downstream systems that must consume complete invoice header context without joining across the core Payables transactional tables. The view consolidates invoice attributes from AP_INVOICES_ALL with supplier, supplier site, batch, accounting, and document-sequencing information, along with XLA event identifiers. Because it carries the AI_ prefix on several columns, it is designed to resemble the AP_INVOICES_ALL interface structure, which simplifies loading into interface tables and supports the Payables Open Interface and invoice import patterns. The view status is VALID in the APPS schema, and its FND Design Data registration is SQLAP.AP_INVOICE_EXTRACT_HEADER_V.

Underlying Base Objects

The view is defined over a documented set of synonyms resolving to base objects in the APPS schema:

• AP_INVOICES_ALL — the primary source of invoice header attributes (AI_INVOICE_ID, AI_INVOICE_AMOUNT, AI_INVOICE_DATE, and related columns).
• AP_BATCHES_ALL — supplies batch context, surfaced through AB_BATCH_NAME.
• AP_SUPPLIERS and AP_SUPPLIER_SITES_ALL — provide trading partner and supplier site information (AI_VENDOR_ID, AI_VENDOR_SITE_ID).
• HZ_PARTIES, HZ_PARTY_SITES, and HZ_LOCATIONS — TCA entities used for party and location details.
• FND_DOCUMENT_SEQUENCES — supports the document sequencing columns (INV_DOC_SEQUENCE_IDENTIFIER, INV_DOC_SEQUENCE_VALUE, INV_DOC_SEQUENCE_CATEGORY, DOC_SEQUENCE_NAME).
• XLA_EVENTS_GT — a global temporary table used for subledger accounting event linkage, exposing EVENT_ID.

The view therefore remains tightly coupled to the core invoice transaction model while presenting a single flat row per invoice header for extraction.

Key Columns

AI_INVOICE_ID and AI_ORG_ID uniquely identify the invoice and its operating unit. AI_INVOICE_AMOUNT, AI_INVOICE_BASE_AMOUNT, and AI_INVOICE_CURRENCY_CODE convey the invoice value and currency. INV_AMOUNT_PAID and INV_DISCOUNT_AMOUNT_TAKEN support payment analysis. INV_DISTRIBUTION_TOTAL — the column referenced in the user's search — exposes the aggregate distribution amount for the invoice header and is commonly used to reconcile header amounts against summed distribution lines. EVENT_ID and AI_SOURCE link the row to its subledger accounting event and extraction origin. AI_VENDOR_ID and AI_VENDOR_SITE_ID tie the invoice to its supplier. The twelve AI_ATTRIBUTE columns and ten INV_GLOBAL_ATTRIBUTE columns provide descriptor flexfield context. INV_AWT_GROUP_ID identifies withholding tax grouping.

Common Use Cases and Queries

Typical scenarios include validating that an invoice header total equals its distribution total, feeding invoices to external systems, and reconciling subledger events. A representative query is:

• SELECT ai_invoice_id, ai_invoice_amount, inv_distribution_total FROM apps.ap_invoice_extract_header_v WHERE ai_org_id = :p_org_id;
• Detecting mismatches: WHERE ai_invoice_amount <> inv_distribution_total.
• Extracting by event: SELECT event_id, ai_invoice_id, ai_source FROM apps.ap_invoice_extract_header_v WHERE event_id = :p_event_id.

Because the view exposes TCA and XLA joins, consumers should filter by operating unit and date ranges to control performance.