Search Results tax_group

Overview

The ZX_INPUT_CLASSIFICATIONS_V view is an Oracle E-Business Suite application view owned by the APPS schema and registered in the Application Object Library (FND). It exposes the set of tax classification codes that are valid for use on input (purchasing and accounts payable) tax determination. Despite its FND registration, the view is functionally part of the E-Business Tax (ETRM) module, since it joins the tax configuration mapping table ZX_ID_TCC_MAPPING_ALL to the tax rate repository ZX_RATES_VL and to the shared FND lookup repository.

In Oracle EBS 12.1.1 and 12.2.2, the view presents a consolidated, language-aware list of input tax classification codes together with their display names and effective dating. It differs from a raw lookup listing because it merges lookup rows (type ZX_INPUT_CLASSIFICATIONS and ZX_WEB_EXP_TAX_CLASSIFICATIONS) with per-organization tax classification-to-rate mappings. This design supports reporting and integration scenarios in which a user needs to know both the classification code delivered through lookups and the organization-specific rate name attached to it. Users searching on the term "tax_group" will typically encounter this view because its definition explicitly excludes rows whose tax type is TAX_GROUP, meaning tax groups are filtered out of the result set rather than returned by it.

Underlying Base Objects

The documented dependencies of this view are three objects:

• FND_LOOKUP_VALUES (SYNONYM) — the shared lookup repository, filtered to LOOKUP_TYPE IN ('ZX_INPUT_CLASSIFICATIONS','ZX_WEB_EXP_TAX_CLASSIFICATIONS') and to the current session language via USERENV('LANG').
• ZX_ID_TCC_MAPPING_ALL (SYNONYM) — the tax classification (TCC) mapping table, holding ORG_ID, TAX_CLASSIFICATION_CODE, TAX_RATE_CODE_ID, TAX_TYPE, TAX_CLASS, effective dates, and the ACTIVE_FLAG.
• ZX_RATES_VL (VIEW) — the tax rate view holding TAX_RATE_CODE, TAX_RATE_NAME, DESCRIPTION, SOURCE_ID, and TAX_CLASS.

The outer query is a UNION ALL of two branches. The first joins all three objects and selects rate-driven names where a rate mapping exists; the second joins only FND_LOOKUP_VALUES and ZX_ID_TCC_MAPPING_ALL, returning classifications that have no corresponding rate row. Both branches apply the same lookup-type filters and restrict TAX_CLASS to INPUT.

Key Columns

• ORG_ID — the operating unit (or global) context of the mapping row.
• MEANING — the display name; for the first branch it coalesces the rate name, lookup meaning, and lookup code; for the second it uses the lookup meaning or code.
• DESCRIPTION — a longer descriptive string derived from rate description, rate name, lookup description, meaning, or code, in that order of preference.
• LOOKUP_CODE and LOOKUP_TYPE — the classification code and the lookup type it originates from.
• LEAF_NODE and ENABLED_FLAG — lookup hierarchy and enabled status indicators.
• START_DATE_ACTIVE and END_DATE_ACTIVE — effective dating, where the end date is the earlier of the mapping end date and the lookup end date.
• TAX_TYPE and TAX_CLASS — the tax type associated with the classification and the tax class, constrained to INPUT.

Common Use Cases and Queries

The view is commonly used to drive input tax classification list-of-values replacements, to reconcile lookup-based classifications against rate mappings, and to export valid input classifications to external tax engines. A typical query returning active input classifications for an operating unit is:

SELECT org_id, lookup_code, meaning, tax_type, start_date_active, end_date_active
FROM apps.zx_input_classifications_v
WHERE enabled_flag = 'Y'
AND TRUNC(SYSDATE) BETWEEN NVL(start_date_active, SYSDATE) AND NVL(end_date_active, SYSDATE);

To find classifications that have a rate mapping rather than only a lookup entry, join back to ZX_ID_TCC_MAPPING_ALL on tax_classification_code = lookup_code. Because the definition explicitly adds NVL(TCC.TAX_TYPE,'XXX') <> 'TAX_GROUP', rows of tax type TAX_GROUP are never returned; any expectation of retrieving tax groups from this view is therefore incorrect, and the underlying ZX_ID_TCC_MAPPING_ALL or corresponding tax group views should be queried instead.