Results for “ap_distribution_set_lines_all”
28 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
-
Individual Distribution Set line definitions
-
12.2.2 FND Design Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
PACKAGE BODY: APPS.AD_MORG 12.1.1
-
PACKAGE BODY: APPS.AD_MORG 12.2.2
-
Set Distribution Table.
-
Set Distribution Table.
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
Set Distribution Table.
-
Set Distribution Table.