Results for “cus_class_id”

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

Overview

JL_ZZ_AR_TX_CUS_CLS_V is a reporting view owned by the APPS schema within the JL (Latin America Localizations) product family of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It exposes customer tax classification and tax attribute assignments used by the Latin America tax engine, which drives tax determination for Receivables and related subledgers in countries such as Argentina, Brazil, Colombia, and Mexico.

The view joins the customer tax classification base table to tax categories and to global Receivables system parameters, restricting the result set to categories belonging to the active tax rule set. Its principal purpose is to provide a denormalized, reporting-friendly projection of customer-level tax attributes: which customer address carries which tax attribute, its value, and the human-readable meaning of both the attribute name and value. Because the underlying tables store lookup codes rather than descriptive text, the view applies JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING to resolve codes into displayable meanings, truncating to 80 characters, which makes it suitable for concurrent reports and extracts without additional decoding logic.

Underlying Base Objects

Per the documented ETRM metadata, the view is defined over the following referenced base objects:

• JL_ZZ_AR_TX_CUS_CLS (synonym) — the driving table, aliased TCAC, holding customer tax classification and attribute records keyed by CUS_CLASS_ID and ADDRESS_ID.
• JL_ZZ_AR_TX_CATEG_ALL (synonym) — tax categories, aliased TC, joined on TAX_CATEGORY_ID and matched to the customer class on a null-safe ORG_ID comparison using NVL(ORG_ID, -99).
• AR_SYSTEM_PARAMETERS_ALL (synonym) — Receivables system parameters, aliased ASP, joined on TAX_RULE_SET = GLOBAL_ATTRIBUTE13, also with the null-safe ORG_ID match against the customer class.
• JL_ZZ_AR_TX_LIB_PKG (package) — the Latin America tax library package supplying GET_LOOKUP_MEANING, used twice to translate the attribute name (CONTRIBUTOR_ATTRIBUTE lookup) and attribute value (JLZZ_AR_TX_ATTR_VALUE lookup).

The joins restrict the view to tax categories tied to the tax rule set configured in Receivables system parameters, and to records within the same operating unit (ORG_ID), ensuring that only currently relevant classifications are surfaced.

Key Columns

• ROW_ID — the ROWID of the underlying JL_ZZ_AR_TX_CUS_CLS row, supporting row-level identification and update-through-view operations.
• CUS_CLASS_ID, ADDRESS_ID — the customer tax classification identifier and the customer site address to which the attributes apply.
• TAX_CATEGORY_ID, TAX_CATEGORY — the tax category key and its descriptive name from JL_ZZ_AR_TX_CATEG_ALL.
• TAX_ATTR_CLASS_CODE — the tax attribute class code classifying the attribute.
• TAX_ATTRIBUTE_NAME, ATTR_NAME_MEANING — the stored contributor attribute code and its translated meaning.
• TAX_ATTRIBUTE_VALUE, ATTR_VALUE_MEANING — the stored attribute value code and its translated meaning.
• ENABLED_FLAG — indicates whether the classification row is active.
• ORG_ID — operating unit identifier, central to the multi-org filtering applied in the view.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns inherited from the base table.

Common Use Cases and Queries

Typical uses include auditing customer tax attribute setup for a given operating unit, extracting classification data for tax reporting, and diagnosing tax determination issues by inspecting the resolved attribute and value meanings.

List active classifications for an operating unit:

• SELECT cus_class_id, address_id, tax_category, tax_attribute_name, attr_name_meaning, tax_attribute_value, attr_value_meaning FROM apps.jl_zz_ar_tx_cus_cls_v WHERE enabled_flag = 'Y' AND org_id = :p_org_id;

Retrieve all attributes for a specific customer site:

• SELECT tax_category, attr_name_meaning, attr_value_meaning FROM apps.jl_zz_ar_tx_cus_cls_v WHERE address_id = :p_address_id AND org_id = :p_org_id ORDER BY tax_category, attr_name_meaning;

Audit recently changed classifications:

• SELECT cus_class_id, address_id, tax_category, attr_value_meaning, last_update_date, last_updated_by FROM apps.jl_zz_ar_tx_cus_cls_v WHERE last_update_date >= TRUNC(SYSDATE) - 30;

Because the view filters on the active tax rule set via AR_SYSTEM_PARAMETERS_ALL, queries automatically reflect the currently configured localization behavior for the operating unit.