Results for “amount_ordered”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AP_MATCH_CORRECTION_DISTS_V is an Oracle E-Business Suite Payables (AP) view owned by the APPS schema. It is a correction-oriented distribution view that joins invoice distribution data from AP_INVOICE_DISTRIBUTIONS_ALL with the corresponding purchase order distribution data from PO_DISTRIBUTIONS_ALL, along with supporting invoice line, project, task, and HR organization attributes. Its name and construction identify it as the view used by Payables matching and match-correction logic to reconcile invoiced quantities and amounts against the ordered, delivered, billed, and cancelled quantities recorded on the purchasing side.

Within Oracle EBS 12.1.1 and 12.2.2, the view does not store data; it projects a curated, denormalized row set that the match-correction form and related concurrent programs consume. It exposes the APPS.AP_INVOICE_DISTRIBUTIONS_ALL and APPS.AP_INVOICE_LINES_ALL columns alongside the PO distribution columns needed to evaluate a match, and it resolves organizational and project context through HR and PA constructs. Because it surfaces AMOUNT_CANCELLED directly, it is one of the objects referenced by users and reports investigating cancellation balances on PO-matched invoice distributions.

Underlying Base Objects

The view is defined over the following documented base objects:

• AP_INVOICE_DISTRIBUTIONS_ALL (alias AID) — supplies the invoice distribution row identifier, invoice and line identifiers, quantity invoiced, distribution code combination, expenditure type, and descriptive flexfield attributes.
• AP_INVOICE_LINES_ALL (alias AIL) — supplies audit columns such as CREATED_BY and CREATION_DATE for the invoice line.
• PO_DISTRIBUTIONS_ALL (alias PD) — supplies the purchasing distribution quantities and amounts, including AMOUNT_BILLED, AMOUNT_ORDERED, AMOUNT_DELIVERED, AMOUNT_CANCELLED, ENCUMBERED_AMOUNT, accrual flags, destination attributes, and accounting date fields.
• HR_ALL_ORGANIZATION_UNITS_TL / HR_ORG_UNITS_NO_JOIN (alias HOUT) — resolves the expenditure organization name.
• PER_PEOPLE_F, HR_PERSON_NAME, HR_SECURITY, HR_GENERAL — provide delivered-to person name resolution and organization security filtering.
• PA_PROJECTS_ALL, PA_TASKS_EXPEND_V, PA_TASK_UTILS, PA_UTILS4 — supply project and task context for project-related distributions.
• FND_PROFILE — retrieves profile option values used within the view's expressions.

Rows are keyed primarily on the invoice distribution, with the PO distribution matched through the associated purchasing linkage, so the view presents one row per invoice distribution with its corresponding procurement distribution data attached.

Key Columns

• ROW_ID — the ROWID of the AP invoice distribution row.
• INVOICE_ID, INVOICE_LINE_NUMBER, INVOICE_DISTRIBUTION_ID — keys identifying the invoice, line, and distribution.
• DIST_QTY_INVOICED — quantity invoiced on the AP distribution (AID.QUANTITY_INVOICED).
• AMOUNT_ORDERED, AMOUNT_DELIVERED, AMOUNT_BILLED, AMOUNT_CANCELLED — PO distribution amounts used to evaluate match tolerances and remaining balances. AMOUNT_CANCELLED reflects the value cancelled on the purchase order distribution.
• ACCRUED_FLAG, ACCRUE_ON_RECEIPT_FLAG, ENCUMBERED_FLAG, ENCUMBERED_AMOUNT — accrual and encumbrance state from the PO distribution.
• CODE_COMBINATION_ID — the AP distribution accounting flexfield.
• DESTINATION_* columns — destination context, organization, subinventory, and type code.
• EXPENDITURE_ORGANIZATION, EXPENDITURE_TYPE, EXPENDITURE_ITEM_DATE — organization name and project expenditure attributes.
• ATTRIBUTE1–ATTRIBUTE15, ATTRIBUTE_CATEGORY — descriptive flexfield values from the AP distribution.
• CREATED_BY, CREATION_DATE — audit columns sourced from the invoice line.

Common Use Cases and Queries

Typical uses include diagnosing match exceptions, auditing cancelled quantities on PO-matched distributions, and supporting reporting that needs distribution-level PO and AP amounts in one row. A representative query listing cancelled amounts by invoice is:

• SELECT invoice_id, invoice_line_number, invoice_distribution_id, amount_ordered, amount_delivered, amount_billed, amount_cancelled FROM apps.ap_match_correction_dists_v WHERE amount_cancelled > 0;
• SELECT invoice_distribution_id, dist_qty_invoiced, amount_billed, amount_cancelled, expenditure_organization FROM apps.ap_match_correction_dists_v WHERE invoice_id = :invoice_id;
• SELECT code_combination_id, SUM(amount_cancelled) FROM apps.ap_match_correction_dists_v GROUP BY code_combination_id;

Because the view embeds HR security and profile logic, queries executed outside the standard APPS context may return filtered rows; report authors should therefore run such queries as a user with the appropriate Payables and organization security responsibilities.