Results for “vat_code”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
AP_DISTRIBUTION_SET_LINES_ALL is the Oracle Payables (AP) table that stores the individual line definitions belonging to an AP Distribution Set. A distribution set is a reusable template that determines how an invoice or expense distribution is allocated across accounts, and this table holds one row for each allocation line within that template. It resides in the AP schema and is classified as VALID in Oracle E-Business Suite releases 12.1.1 and 12.2.2.
Because each line references a parent distribution set header while also pointing outward to accounting, project, and award entities, the table functions as a junction-style object. Using the heuristic Data Vault classification mined from its foreign-key structure, it is best modeled as a link — it connects the distribution set header to GL code combinations and to Oracle Projects and Grants constructs. Its primary key is AP_DISTRIBUTION_SET_LINES_PK, composed of DISTRIBUTION_SET_ID and DISTRIBUTION_SET_LINE_NUMBER.
Key Information Stored
The table contains 36 documented columns. The most significant are summarized below.
- DISTRIBUTION_SET_ID — Foreign key to AP_DISTRIBUTION_SETS_ALL; identifies the parent distribution set. Part of the primary key.
- DISTRIBUTION_SET_LINE_NUMBER — Sequence number of the line within the set. Part of the primary key.
- DIST_CODE_COMBINATION_ID — Foreign key to GL_CODE_COMBINATIONS; the accounting flexfield account to which the line distributes.
- SET_OF_BOOKS_ID — Foreign key to GL_SETS_OF_BOOKS_11I; the ledger context for the account.
- PERCENT_DISTRIBUTION — The percentage (or amount basis) allocated to this line.
- DESCRIPTION — Free-form description of the distribution line.
- TYPE_1099 — 1099 reporting classification for the line.
- VAT_CODE — Tax code associated with the distribution.
- ORG_ID — Operating unit identifier; included in the unique index AP_DISTRIBUTION_SET_LINES_U1 along with the two primary-key columns.
- PROJECT_ID, TASK_ID, EXPENDITURE_TYPE, EXPENDITURE_ORGANIZATION_ID — Oracle Projects attributes; the latter three carry foreign keys to PA_TASKS, PA_EXPENDITURE_TYPES, and PA_EXP_ORGS_IT.
- AWARD_ID — Foreign key to IGF_AW_AWARD_ALL, supporting Grants award tracking.
- PROJECT_ACCOUNTING_CONTEXT — Determines how project-related accounting is derived.
- ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — Descriptive flexfield (DFF) columns for client-specific extensions.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns.
The surrogate primary key is AP_DISTRIBUTION_SET_LINES_PK (DISTRIBUTION_SET_ID, DISTRIBUTION_SET_LINE_NUMBER). The unique index AP_DISTRIBUTION_SET_LINES_U1 additionally incorporates ORG_ID, making the combination of set, line number, and operating unit the business-key candidate.
Common Use Cases and Queries
Typical reporting needs include listing the accounts and percentages that make up a named distribution set, verifying that a set's percentages total correctly, and tracing which invoices reuse a given template. A common join pattern links the header and line tables:
- SELECT l.distribution_set_id, l.distribution_set_line_number, l.percent_distribution, g.concatenated_segments FROM ap.ap_distribution_set_lines_all l, ap.ap_distribution_sets_all s, gl.gl_code_combinations_kfv g WHERE l.distribution_set_id = s.distribution_set_id AND l.dist_code_combination_id = g.code_combination_id;
- Filter by ORG_ID to restrict results to a single operating unit, consistent with the U1 unique index.
- Sum PERCENT_DISTRIBUTION grouped by DISTRIBUTION_SET_ID to validate that each set reconciles to 100 percent.
- Join to PA_TASKS, PA_EXPENDITURE_TYPES, and IGF_AW_AWARD_ALL to report project- and award-charged distributions.
Related Objects
The following objects are most significant to this table, joined on the documented foreign keys:
- AP_DISTRIBUTION_SETS_ALL — Parent header table; join on DISTRIBUTION_SET_ID.
- GL_CODE_COMBINATIONS — Account definitions; join on DIST_CODE_COMBINATION_ID.
- GL_SETS_OF_BOOKS_11I — Ledger definition; join on SET_OF_BOOKS_ID.
- PA_TASKS — Project tasks; join on TASK_ID.
- PA_EXPENDITURE_TYPES — Project expenditure types; join on EXPENDITURE_TYPE.
- PA_EXP_ORGS_IT — Expenditure organizations; join on EXPENDITURE_ORGANIZATION_ID.
- IGF_AW_AWARD_ALL — Grants awards; join on AWARD_ID.
AP Distribution Sets are consumed by the Payables invoice and expense workbenches, and the corresponding OAF/Forms and public APIs that create or apply distribution sets read and write these lines during invoice entry and validation.
-
Individual Distribution Set line definitions
-
APPS.APBV_EXPENSE_REPORT_PARAMS·↳ AP_EXPENSE_REPORT_PARAMS_ALL·Explore AP module →
-
APPS.APBV_EXPENSE_REPORT_LINES·↳ AP_EXPENSE_REPORT_LINES_ALL·Explore AP module →
-
APPS.AP_XML_INVOICE2_LEVEL_V·↳ AP_INVOICES·↳ AP_INVOICE_SELECTION_CRITERIA·↳ AP_SELECTED_INVOICES·Explore AP module →
-
APPS.PO_VENDOR_SITES_ALL·↳ AP_LOOKUP_CODES·↳ AP_SUPPLIER_SITES_ALL·↳ FND_GLOBAL·Explore AP module →
-
Table: AP_WEB_DISC_LINES_GT 12.2.2
-
APPS.AP_XML_INVOICE2_LEVEL_V·↳ AP_INVOICES·↳ AP_INVOICE_SELECTION_CRITERIA·↳ AP_SELECTED_INVOICES·Explore AP module →
-
APPS.APBV_EXPENSE_REPORT_PARAMS·↳ AP_EXPENSE_REPORT_PARAMS_ALL·Explore AP module →
-
(Release 10SC Only)
APPS.AP_INVOICES_UNION_PREPAYS_V·↳ AP_HOLDS·↳ AP_INVOICES·↳ AP_INVOICE_DISTRIBUTIONS·Explore AP module →
-
Expense type information for expense report templates
-
View: PO_VENDOR_SITES 12.1.1
APPS.PO_VENDOR_SITES·↳ AP_SUPPLIER_SITES·Explore AP module →
-
APPS.APBV_EXPENSE_REPORT_LINES·↳ AP_EXPENSE_REPORT_LINES_ALL·Explore AP module →
-
Individual Distribution Set line definitions
-
Expense type information for expense report templates
-
Table: AP_WEB_DISC_LINES_GT 12.1.1
-
(Release 10SC Only)
APPS.AP_INVOICES_UNION_PREPAYS_V·↳ AP_HOLDS·↳ AP_INVOICES·↳ AP_INVOICE_DISTRIBUTIONS·Explore AP module →
-
AP_SUPPLIERS stores information about your supplier level attributes.
-
APPS.AP_INVOICE_DISTS_INQUIRY_V·↳ AP_AWT_GROUPS·↳ AP_BATCHES·↳ AP_INCOME_TAX_REGIONS·Explore AP module →
-
View: PO_VENDOR_SITES 12.2.2
APPS.PO_VENDOR_SITES·↳ AP_LOOKUP_CODES·↳ AP_SUPPLIER_SITES·↳ FND_GLOBAL·Explore AP module →
-
APPS.AP_INVOICE_DISTS_INQUIRY_V·↳ AP_AWT_GROUPS·↳ AP_BATCHES·↳ AP_INCOME_TAX_REGIONS·Explore AP module →
-
APPS.PO_VENDOR_SITES_ALL·↳ AP_SUPPLIER_SITES_ALL·Explore AP module →
-
Oracle Financials system parameters and defaults
-
Oracle Financials system parameters and defaults
-
Detailed invoice records
-
Detailed invoice records
-
AP_SUPPLIER_SITES_INT_ALL holds Supplier Site information which is loadedby the user for import. The columns in the table map to corresponding columnsin PO_VENDOR_SITES_ALL table. The Oracle Payables application uses this information to
-
Expense item information for employee expense reports
-
AP_SUPPLIERS_INT holds Supplier information which is loaded by the user for import. The columns in the table map to corresponding columns in the PO_VENDORS table. The Oracle Payables application uses this information to create a new Supp
-
Payables system defaults and parameters
-
AP_SUPPLIER_SITES_ALL stores information about your supplier site level attributes.
-
Payables system defaults and parameters
-
AP_SUPPLIERS stores information about your supplier level attributes.
-
Expense item information for employee expense reports
-
OIE Archive Table for Expense Report Lines
-
AP_SUPPLIERS_INT holds Supplier information which is loaded by the user for import. The columns in the table map to corresponding columns in the PO_VENDORS table. The Oracle Payables application uses this information to create a new Supp
-
AP_SUPPLIER_SITES_ALL stores information about your supplier site level attributes.
-
AP_SUPPLIER_SITES_INT_ALL holds Supplier Site information which is loadedby the user for import. The columns in the table map to corresponding columnsin PO_VENDOR_SITES_ALL table. The Oracle Payables application uses this information to
-
Invoice distribution line information
-
Invoice distribution line information
-
View: AP_TAX_CODES_ACTIVE_V 12.2.2
(Release 10SC Only)
Not implemented in this database·Explore AP module →
-
View: AP_TAX_CODES_ACTIVE_V 12.1.1
(Release 10SC Only)
Not implemented in this database·Explore AP module →
-
View: AP_INVOICES_MRC_V 12.1.1
SINGLE-ORG MRC view
Not implemented in this database·Explore AP module →
-
View: AP_INVOICES_MRC_V 12.2.2
SINGLE-ORG MRC view
Not implemented in this database·Explore AP module →
-
View: AP_INVOICES_ALL_MRC_V 12.1.1
MULTI-ORG MRC view
Not implemented in this database·Explore AP module →
-
View: AP_INVOICES_ALL_MRC_V 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 →
-
MULTI-ORG MRC view
Not implemented in this database·Explore AP module →
-
SINGLE-ORG view
Not implemented in this database·Explore AP module →