Results for “ar_tax_condition_lines_all”

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

Overview

AR_TAX_CONDITION_LINES_ALL is a Receivables (AR) module table that stores the individual condition lines belonging to a tax condition. In Oracle EBS 12.1.1 and 12.2.2, it is part of the E-Business Tax (EBTax) configuration data model, which governs how tax determination rules are evaluated for transactions originating in Receivables. Each row represents a single predicate or rule component — a clause, entity, field, operator, and value — that the tax engine evaluates when deciding whether a given tax condition applies to an invoice, credit memo, or debit memo.

The table is owned by the AR schema and is documented as VALID in the ETRM reference. Its primary key is AR_TAX_CONDITION_LINES_PK, composed of TAX_CONDITION_LINE_ID, TAX_CONDITION_ID, and DISPLAY_ORDER. A secondary unique index, AR_TAX_CONDITION_LINES_U1, is defined on TAX_CONDITION_LINE_ID alone, making that column the strongest business-key candidate. From a data-modeling perspective, the heuristic Data Vault classification of this object is standalone, meaning it does not exhibit the parent-child FK lineage that would place it as a hub, link, or satellite; it is best modeled as an independent descriptive entity keyed by its own surrogate identifier.

Key Information Stored

The 52 documented columns divide naturally into identification, rule-definition, and auditing/extension groups. The most significant columns are:

• TAX_CONDITION_LINE_ID — surrogate primary key component and the target of the unique index AR_TAX_CONDITION_LINES_U1; uniquely identifies a condition line across the application.
• TAX_CONDITION_ID — foreign key to the parent tax condition; groups all lines that together form one logical rule.
• DISPLAY_ORDER — governs the evaluation sequence of lines within a condition and is part of the composite primary key.
• TAX_CONDITION_CLAUSE — the logical clause joining this line to the preceding expression (for example AND / OR).
• TAX_CONDITION_ENTITY — identifies the entity or context being tested, such as Bill To, Ship To, or a tax regime attribute.
• TAX_CONDITION_FIELD — the specific field or attribute within the entity that the rule evaluates.
• TAX_CONDITION_OPERATOR — the comparison operator applied (equals, not equals, in, between, and similar).
• TAX_CONDITION_VALUE — the literal or reference value the field is compared against.
• TAX_CONDITION_EXPR — the full rendered condition expression used by the tax determination engine.
• ORG_ID — the operating unit partitioning column that supports multi-org access control.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle EBS "WHO" auditing columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 — the DFF (descriptive flexfield) extension block.
• GLOBAL_ATTRIBUTE_CATEGORY and GLOBAL_ATTRIBUTE1–20 — the global descriptive flexfield block reserved for localization.

Common Use Cases and Queries

The principal reporting scenario is reconstructing the full rule definition for a tax condition so that configuration can be audited, migrated, or debugged. Because lines must be read in DISPLAY_ORDER, ordering is essential:

SELECT tc.tax_condition_id, tcl.display_order, tcl.tax_condition_clause,
  tcl.tax_condition_entity, tcl.tax_condition_field, tcl.tax_condition_operator, tcl.tax_condition_value
FROM ar.ar_tax_condition_lines_all tcl, ar.ar_tax_conditions_b tc
WHERE tcl.tax_condition_id = tc.tax_condition_id
  AND tcl.org_id = :p_org_id
ORDER BY tcl.tax_condition_id, tcl.display_order;

Other frequent uses include extracting configuration between environments during a tax setup migration, listing all conditions that reference a particular entity or field, validating that no condition line carries an unexpected operator or value, and troubleshooting tax determination failures by inspecting TAX_CONDITION_EXPR. Because the table is multi-org, queries should generally filter on ORG_ID to respect operating unit security.

Related Objects

The most significant objects associated with AR_TAX_CONDITION_LINES_ALL are:

• AR_TAX_CONDITIONS_B — parent header table; joined on TAX_CONDITION_ID.
• AR_TAX_CONDITIONS_TL — translation table supplying the condition name and description; joined on TAX_CONDITION_ID.
• AR_TAX_CONDITION_SETS / tax condition set members — logical groupings that assign conditions to tax rules.
• ZX_TAX_CONDITIONS — EBTax (ZX) side of the tax condition definition, referenced when the engine evaluates rules.
• ZX_RULES_B / ZX_TAX_RULES — tax rules that consume conditions and their lines during determination.
• FND_FLEX_VALUES_VL and related value-set views — supply the valid values referenced by TAX_CONDITION_VALUE where a value set is used.
• FND_ATTACHED_DOCUMENTS and the standard EBS attachments framework — attach supporting documentation to configured conditions.

These relationships allow developers to trace a Receivables tax rule from its header definition through its ordered condition lines and into the EBTax determination logic, which is the primary reason this table appears in tax configuration and diagnostic queries.