Results for “dist_match_type”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
AP_PPA_INVOICE_DISTS_GT is a Payables module table owned by the AP schema in Oracle E-Business Suite 12.1.1 and 12.2.2. The suffix _GT identifies it as a global temporary table. In the Oracle EBS architecture, global temporary tables are used as transient staging structures whose data is visible only within a session or transaction. In the context of Payables, AP_PPA_INVOICE_DISTS_GT supports the Public Sector Payables (PPA) processing path, which handles invoice distributions subject to special accounting treatments such as award tracking, project-related expenditure recognition, and withholding tax processing.
The physical schema documented in ETRM 12.1.1 contains 108 columns, reflecting the breadth of attributes required to capture invoice distribution detail while also carrying ancillary data for assets, projects, encumbrances, tax, and payables withholding. Although the object is not formally constrained as a parent or child within a warehouse star schema, the heuristic Data Vault classification derived from its foreign key structure is standalone, suggesting it is best modeled as an independent staging or source object rather than a standard hub, link, or satellite.
Key Information Stored
The most consequential columns in this table describe the identity, accounting, and classification of each invoice distribution line:
- INVOICE_DISTRIBUTION_ID — the surrogate primary key for an invoice distribution, linking back to the permanent AP_INVOICE_DISTRIBUTIONS_ALL table.
- INVOICE_ID and INVOICE_LINE_NUMBER — the parent invoice header and line to which the distribution belongs.
- DIST_CODE_COMBINATION_ID — the accounting flexfield combination for the distribution.
- AMOUNT and BASE_AMOUNT — the entered and functional-currency distribution amounts.
- ACCOUNTING_DATE and PERIOD_NAME — the accounting date and Payables period for the distribution.
- DISTRIBUTION_LINE_NUMBER and DISTRIBUTION_CLASS — ordering and classification of the distribution line (for example, ITEM, TAX, FREIGHT).
- LINE_TYPE_LOOKUP_CODE and DIST_MATCH_TYPE — lookups identifying the line type and matching behavior.
- POSTED_FLAG, ACCRUAL_POSTED_FLAG, and CASH_POSTED_FLAG — status indicators for accounting, accrual, and cash posting activity.
- AWARD_ID — a foreign key into IGF_AW_AWARD_ALL, tying the distribution to Public Sector award management.
- PROJECT_ID, TASK_ID, and EXPENDITURE_TYPE — project accounting attributes for distributions that feed Oracle Projects.
- SET_OF_BOOKS_ID and ORG_ID — the ledger and operating unit context.
- ASSETS_TRACKING_FLAG and ASSETS_ADDITION_FLAG — flags indicating whether the line is tracked as or posted to a fixed asset.
The surrogate key is INVOICE_DISTRIBUTION_ID. Business-key candidates for uniqueness are formed from INVOICE_ID, INVOICE_LINE_NUMBER, and DISTRIBUTION_LINE_NUMBER.
Common Use Cases and Queries
This staging table is typically populated during PPA invoice processing and consumed to produce permanent invoice distribution records. Common scenarios include:
- Reviewing unposted accrual or cash lines before final posting:
SELECT invoice_id, invoice_line_number, distribution_line_number,
amount, accounting_date, period_name, posted_flag
FROM ap.ap_ppa_invoice_dists_gt
WHERE posted_flag = 'N';
- Award-linked reporting for Public Sector clients:
SELECT g.award_id, a.award_number, SUM(g.amount) award_total
FROM ap.ap_ppa_invoice_dists_gt g,
igf.igf_aw_award_all a
WHERE g.award_id = a.award_id
GROUP BY g.award_id, a.award_number;
- Reconciling project expenditure attributes before Project Accounting import.
- Validating distribution class and lookup codes against FND_LOOKUPS.
- Auditing withholding tax distributions using WITHHOLDING_TAX_CODE_ID and AWT_GROUP_ID.
Related Objects
The following objects are most significant when working with this table:
- IGF_AW_AWARD_ALL — joined on AWARD_ID; the sole documented foreign key target.
- AP_INVOICE_DISTRIBUTIONS_ALL — the permanent distribution table populated from staged rows via INVOICE_DISTRIBUTION_ID.
- AP_INVOICES_ALL — parent invoice header, joined on INVOICE_ID.
- AP_INVOICE_LINES_ALL — invoice line detail, joined on INVOICE_ID and INVOICE_LINE_NUMBER.
- AP_PAYMENT_SCHEDULES_ALL — payment schedules generated from distributions sharing INVOICE_ID.
- GL_CODE_COMBINATIONS — accounting flexfield validation, joined on DIST_CODE_COMBINATION_ID.
- PA_PROJECTS_ALL and PA_TASKS — project and task validation on PROJECT_ID and TASK_ID.
- FA_ASSET_HEADERS / FA_ADDITIONS_B — asset creation targets referenced through the asset tracking flags.
-
APPS.AP_INVOICE_DISTRIBUTIONS_V·↳ AP_AWT_GROUPS·↳ AP_BATCHES_ALL·↳ AP_INCOME_TAX_REGIONS·Explore AP module →
-
Copy of AP_INVOICE_DISTRIBUTIONS and two more columns for investment tax
-
Copy of AP_INVOICE_DISTRIBUTIONS and two more columns for investment tax
-
ap_self_assessed_tax_dist contains self assessed tax distributions
-
Used in the table handler for inserting records into IGI_INVOICE_DISTRIBUTIONS_ALL.
APPS.IGI_INVOICE_DISTRIBUTIONS_V·↳ AP_INVOICE_DISTRIBUTIONS_ALL·↳ IGI_INVOICE_DISTRIBUTIONS·Explore IGI module →
-
Used in the table handler for inserting records into IGI_INVOICE_DISTRIBUTIONS_ALL.
APPS.IGI_INVOICE_DISTRIBUTIONS_V·↳ AP_INVOICE_DISTRIBUTIONS_ALL·↳ IGI_INVOICE_DISTRIBUTIONS·Explore IGI module →
-
APPS.AP_INVOICE_DISTRIBUTIONS_V·↳ AP_AWT_GROUPS·↳ AP_BATCHES_ALL·↳ AP_INCOME_TAX_REGIONS·Explore AP module →
-
Invoice distribution line information
-
Invoice distribution line information
-
ap_self_assessed_tax_dist contains self assessed tax distributions
-
VIEW: AP.JE_NO_INVEST_LINES# 12.2.2
-
VIEW: AP.JE_NO_INVEST_LINES# 12.2.2
-
TABLE: AP.JE_NO_INVEST_LINES 12.1.1
-
TABLE: AP.JE_NO_INVEST_LINES 12.2.2
-
TABLE: AP.AP_DIST_LINE_GT 12.1.1
-
TABLE: AP.AP_DIST_LINE_GT 12.2.2
-
MULTI-ORG MRC view
Not implemented in this database·Explore AP module →
-
MULTI-ORG MRC view
Not implemented in this database·Explore AP module →
-
View: AP_INVOICE_DISTS_MRC_V 12.1.1
SINGLE-ORG MRC view
Not implemented in this database·Explore AP module →
-
View: AP_INVOICE_DISTS_MRC_V 12.2.2
SINGLE-ORG MRC view
Not implemented in this database·Explore AP module →