Results for “tax_attr_class_code”

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

Overview

The view JL_ZZ_AR_TX_ATTCLS_VAL_V is an Oracle E-Business Suite database object owned by the APPS schema and delivered as part of the JL – Latin America Localizations product family. It is a validation view, as indicated by the _VAL_V suffix, and is used primarily to expose the set of tax attribute classifications that are valid for the tax rule set currently configured in the Receivables system parameters. The view is defined with a DISTINCT query, meaning it returns a de-duplicated list of tax attribute classification codes together with a translated description and the attribute classification type.

In the context of EBS 12.1.1 and 12.2.2, Latin American tax processing relies on flexible attribute classes to drive tax determination and reporting. Rather than hard-coding valid values, the localization framework stores tax attribute classifications in setup tables and filters them at runtime against the active global tax configuration. This view encapsulates that filtering logic so that forms, concurrent programs, and integrations can query a ready-made list of valid values without re-implementing the join conditions. Its role is therefore both a reporting source and a validation source for downstream tax setup and transactional processing.

Underlying Base Objects

The view is defined over several documented base objects, all exposed to APPS through synonyms:

• AR_SYSTEM_PARAMETERS_ALL — supplies the Receivables system parameters, and specifically the GLOBAL_ATTRIBUTE13 column, which stores the active tax rule set.
• JL_ZZ_AR_TX_ATT_CLS — the tax attribute classification setup table holding TAX_ATTR_CLASS_CODE, TAX_ATTR_CLASS_TYPE, TAX_CATEGORY_ID, ENABLED_FLAG, and ORG_ID.
• JL_ZZ_AR_TX_CATEG_ALL — the tax category table, providing the TAX_CATEGORY_ID and TAX_RULE_SET linkage.
• JL_ZZ_AR_TX_LIB_PKG — a package whose GET_LOOKUP_MEANING function resolves the display description for each attribute class.

The join requires that the tax category's rule set equals the system parameter GLOBAL_ATTRIBUTE13, that the classification is enabled, and that the organization identifiers align across all three tables. Null ORG_ID values are normalized to -99 to permit matching between global and organization-specific rows.

Key Columns

• TAX_ATTR_CLASS_CODE — the identifier of the tax attribute classification; the primary value consumed by validation and lookup logic.
• DESCRIPTION — the user-facing meaning of the attribute class, truncated to 80 characters and obtained via the localization library package lookup function.
• TAX_ATTR_CLASS_TYPE — the classification type that groups related attribute class codes and determines the context in which the code is valid.

Common Use Cases and Queries

Typical scenarios include populating validation lists of tax attribute classes for a given rule set, verifying which classifications are currently active before configuring tax rules, and reconciling localization tax setup against Receivables parameters.

A basic query retrieves all valid classifications:

• SELECT TAX_ATTR_CLASS_CODE, DESCRIPTION, TAX_ATTR_CLASS_TYPE FROM JL_ZZ_AR_TX_ATTCLS_VAL_V ORDER BY TAX_ATTR_CLASS_TYPE, TAX_ATTR_CLASS_CODE;

A filtered query returns values for a single type:

• SELECT TAX_ATTR_CLASS_CODE, DESCRIPTION FROM JL_ZZ_AR_TX_ATTCLS_VAL_V WHERE TAX_ATTR_CLASS_TYPE = :p_type;

Because the view already enforces the rule-set and enabled-flag conditions, callers do not need to repeat those joins. Access is read-only and governed by APPS privileges.