Search Results awt_gross_amount

Overview

The IGI_INVOICE_DISTRIBUTIONS_V view is an Oracle E-Business Suite database object owned by the APPS schema within the IGI – Public Sector Financials International product family. It exposes invoice distribution records in a form suitable for reporting, integration, and — most notably — the table handler logic that inserts rows into IGI_INVOICE_DISTRIBUTIONS_ALL. The view has a status of VALID in both 12.1.1 and 12.2.2 and is a join of the standard Payables distribution table with the IGI extension table, meaning it carries both the native Oracle Payables columns and the IGI-specific auditing columns.

Because the view surfaces the standard Payables distribution attributes alongside IGI columns, it is commonly used when downstream processes (public sector accounting, grant/fund tracking, or custom extensions) need a single source for distribution data that respects the IGI record structure. Users searching for posted_amount are typically looking for the amount actually posted to the General Ledger for a given distribution line, which this view exposes directly.

Underlying Base Objects

The documented metadata lists two referenced base objects:

• AP_INVOICE_DISTRIBUTIONS_ALL (accessed via SYNONYM) — the core Oracle Payables table storing every distribution line for an invoice, including accounting, amount, and match columns. In the view text this alias is AP.
• IGI_INVOICE_DISTRIBUTIONS (accessed via SYNONYM) — the IGI extension table, aliased IGI, which supplies the LAST_UPDATED_BY and LAST_UPDATE_DATE audit columns that override the Payables equivalents.

The view is therefore a horizontal join across these two objects keyed on the distribution identity, projecting the Payables distribution attributes and overlaying the IGI who-columns. This design allows IGI-managed records to be inserted into IGI_INVOICE_DISTRIBUTIONS_ALL through a table handler while still drawing standard distribution data from the Payables base table.

Key Columns

• INVOICE_ID and DISTRIBUTION_LINE_NUMBER — identify the invoice and its distribution line.
• DIST_CODE_COMBINATION_ID — the accounting flexfield combination charged by the distribution.
• AMOUNT, BASE_AMOUNT, STAT_AMOUNT — entered, converted, and statistical amounts.
• POSTED_AMOUNT and POSTED_BASE_AMOUNT — the amounts actually posted to GL; these are the columns most relevant to a posted_amount search.
• POSTED_FLAG, ACCRUAL_POSTED_FLAG, CASH_POSTED_FLAG — posting state indicators.
• AMOUNT_TO_POST, BASE_AMOUNT_TO_POST — amounts pending posting.
• PERIOD_NAME, ACCOUNTING_DATE, SET_OF_BOOKS_ID — accounting period and ledger context.
• LAST_UPDATED_BY, LAST_UPDATE_DATE — sourced from the IGI table, reflecting IGI-level maintenance.

Numerous attribute columns (ATTRIBUTE1–ATTRIBUTE15, ATTRIBUTE_CATEGORY) and project/encumbrance columns are also exposed for extensibility and subledger integration.

Common Use Cases and Queries

Typical usage includes reconciling posted versus entered distribution amounts, auditing IGI-maintained distributions, and feeding integration extracts. A query to retrieve posted amounts for an invoice:

• SELECT invoice_id, distribution_line_number, amount, posted_amount, posted_base_amount, posted_flag FROM igi_invoice_distributions_v WHERE invoice_id = :p_invoice_id;
• SELECT invoice_id, SUM(posted_amount) FROM igi_invoice_distributions_v WHERE period_name = :p_period GROUP BY invoice_id;
• SELECT * FROM igi_invoice_distributions_v WHERE posted_amount <> amount AND posted_flag = 'Y'; — isolates variances between entered and posted values.

Because the view is the documented source for inserts into IGI_INVOICE_DISTRIBUTIONS_ALL, customizations should treat it as read-oriented for reporting and via table handlers for maintenance, respecting IGI product conventions.