Search Results awt_invoice_id




Overview
Explore in AI Chat

Overview

AP_INVOICE_DISTS_INQUIRY_V is a VALID view owned by the APPS schema within the Oracle E-Business Suite Payables (AP) module. It exposes invoice distribution lines for inquiry and reporting purposes, presenting data from AP_INVOICE_DISTRIBUTIONS alongside denormalized attributes resolved from related invoice, batch, tax, withholding, purchasing, and project objects. The view's design reflects the standard EBS pattern in which a base transaction table supplies the primary rows and joined synonyms, views, and packages supply descriptive context for inquiry screens, ad hoc extracts, and downstream integration. The view text projects the ROWID of AP_INVOICE_DISTRIBUTIONS as ROW_ID, allowing consumers to correlate a returned row to its underlying distribution record. Because the view is inquiry-oriented, it centralizes both accounting and non-accounting distribution attributes, including accrual and cash posting flags, match status, encumbrance status, and withholding tax information.

Underlying Base Objects

The documented ETRM 12.2.2 metadata lists the referenced base objects as AP_INVOICE_DISTRIBUTIONS (SYNONYM), AP_INVOICES (SYNONYM), AP_BATCHES (SYNONYM), AP_AWT_GROUPS (SYNONYM), AP_INCOME_TAX_REGIONS (SYNONYM), AP_TAX_CODES (SYNONYM), AP_LOOKUP_CODES (VIEW), AP_INVOICE_DISTRIBUTIONS_PKG (PACKAGE), FND_GLOBAL (PACKAGE), FND_PROFILE (PACKAGE), GL_SETS_OF_BOOKS (VIEW), HR_GENERAL (PACKAGE), HR_ORGANIZATION_UNITS (VIEW), HR_SECURITY (PACKAGE), PA_PROJECTS_ALL (SYNONYM), PA_TASKS_EXPEND_V (VIEW), PA_TASK_UTILS (PACKAGE), PA_UTILS4 (PACKAGE), PO_DISTRIBUTIONS (SYNONYM), PO_HEADERS (SYNONYM), PO_LINES (SYNONYM), PO_LINE_LOCATIONS (SYNONYM), PO_VENDORS (VIEW), and PO_VENDOR_SITES (VIEW). The primary driver is AP_INVOICE_DISTRIBUTIONS, aliased as AID in the view text. AP_INVOICES supplies invoice header context, AP_BATCHES supplies batch grouping, and AP_AWT_GROUPS and AP_TAX_CODES support withholding tax attributes. The inclusion of FND_GLOBAL, FND_PROFILE, HR_SECURITY, and HR_GENERAL indicates that the view applies organization and security context, consistent with multi-org access control. The PO_* and PA_* objects support matched purchasing and project-related distribution detail.

Key Columns

The view exposes the full set of distribution columns referenced in the view text. Notable grouping and identity columns include INVOICE_ID, DISTRIBUTION_LINE_NUMBER, BATCH_ID, ORG_ID, AWT_GROUP_ID, AWT_INVOICE_ID, and AWT_ORIGIN_GROUP_ID. Accounting columns include ACCOUNTING_DATE, DIST_CODE_COMBINATION_ID, ACCTS_PAY_CODE_COMBINATION_ID, and AMOUNT. Status and control flags include ACCRUAL_POSTED_FLAG, CASH_POSTED_FLAG, ENCUMBERED_FLAG, FINAL_MATCH_FLAG, MATCH_STATUS_FLAG, ASSETS_ADDITION_FLAG, ASSETS_TRACKING_FLAG, LINE_TYPE_LOOKUP_CODE, and AWT_FLAG. Withholding tax attributes include AWT_TAX_RATE_ID, AWT_GROSS_AMOUNT, and AWT_GROUP_ID; the AWT_TAX_RATE_ID column is the identifier sought by the user's search term. Project and expenditure columns include EXPENDITURE_TYPE, EXPENDITURE_ITEM_DATE, EXPENDITURE_ORGANIZATION_ID, and INCOME_TAX_REGION. The columns ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 provide the standard descriptive flexfield segment storage, and BASE_AMOUNT and BASE_QUANTITY_VARIANCE carry currency and quantity variances.

Common Use Cases and Queries

Typical uses include invoice distribution inquiry, withholding tax analysis, reconciliation of accrual and cash posting status, and project or purchasing matched distribution reporting. Because the view already joins invoice and supplier context, it is convenient for reporting without reconstructing joins. A basic filter by withholding tax rate is shown below.

  • Query distributions tied to a withholding tax rate: SELECT invoice_id, distribution_line_number, awt_flag, awt_gross_amount, awt_tax_rate_id, amount FROM ap_invoice_dists_inquiry_v WHERE awt_tax_rate_id = :rate_id;
  • Review unposted accruals: SELECT invoice_id, distribution_line_number, amount, accrual_posted_flag FROM ap_invoice_dists_inquiry_v WHERE accrual_posted_flag = 'N';
  • Inspect project-related distributions: SELECT invoice_id, expenditure_type, expenditure_item_date, expenditure_organization_id FROM ap_invoice_dists_inquiry_v WHERE expenditure_organization_id IS NOT NULL;
  • Trace a row back to its base record using ROW_ID: SELECT row_id, invoice_id, dist_code_combination_id FROM ap_invoice_dists_inquiry_v WHERE invoice_id = :invoice_id;

Consumers should apply ORG_ID and security predicates consistent with their EBS access, since HR and FND packages referenced in the definition imply organization-sensitive filtering.