Results for “txn_tax_attribute”

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

Overview

JL_ZZ_AR_TX_CATEGRY_V is a Latin America Localizations (JL) reporting view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes transaction tax category configuration for Latin American localization regimes, most notably the Argentine and Brazilian tax setups managed through the JL_ZZ_AR_TX_CATEG tables. The view resolves internal lookup codes into user-facing descriptions by calling JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING, a helper package function that translates a lookup code and lookup type into its display meaning. Every code-valued column is therefore accompanied by a derived, human-readable meaning column when the view text supplies one.

Because the underlying tables store codes for tax category, threshold check level, threshold grouping, authority, regime, and the various tax attributes, the view is the preferred source for reports, extracts, and integration queries that must be legible without independently joining FND_LOOKUP_VALUES. In the reported context, the user searched for "transaction_attribute", which corresponds to the TXN_TAX_ATTRIBUTE column and its lookup meaning resolved against the TRANSACTION_ATTRIBUTE lookup type. This attribute determines how transaction-level tax attributes are applied within the Latin American tax determination logic.

Underlying Base Objects

The ETRM 12.2.2 metadata documents the following referenced base objects:

• AR_SYSTEM_PARAMETERS_ALL (SYNONYM) — supplies operating unit level receivable system parameters used in conjunction with tax category configuration.
• AR_VAT_TAX (SYNONYM) — the tax definition view carrying rate and tax code relationships.
• AR_VAT_TAX_ALL_B (SYNONYM) — the multilingual base table behind tax definitions, providing tax rate, tax code, and authority data through the ART alias.
• JL_ZZ_AR_TX_CATEG (SYNONYM) — the transactional tax category base table, referenced by the TAX alias.
• JL_ZZ_AR_TX_CATEG_ALL (SYNONYM) — the language-enabled tax category table, used for the self-join that resolves TAX_CATEG_TO_REDUCE_DESC through the CAT alias.
• JL_ZZ_AR_TX_LIB_PKG (PACKAGE) — the localization library package whose GET_LOOKUP_MEANING function performs all lookup translation.

The view is a pure join and decoding layer: it does not persist data, and all ROWID, creation, and last-update values are inherited directly from the base rows.

Key Columns

• TAX_CATEGORY_ID and TAX_CATEGORY — primary identifier and code of the tax category; SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(TAX.TAX_CATEGORY,'JLZZ_AR_TX_CATEGRY'),1,80) returns the descriptive category name.
• TXN_TAX_ATTRIBUTE — the transaction attribute related to tax determination, decoded through the TRANSACTION_ATTRIBUTE lookup type. This is the column most relevant to the user's search.
• ORG_TAX_ATTRIBUTE and CUS_TAX_ATTRIBUTE — organization and contributor attribute codes, decoded against ORGANIZATION_ATTRIBUTE and CONTRIBUTOR_ATTRIBUTE lookup types.
• THRESHOLD_CHECK_LEVEL, THRESHOLD_CHECK_GRP_BY, and THRESHOLD_CHECK_GRP_BY_NB — thresholds that control whether minimums are evaluated per LINE, DOCUMENT, or TRANSACTION.
• MIN_AMOUNT, MIN_TAXABLE_BASIS, MIN_PERCENTAGE — numeric thresholds governing tax applicability.
• TAX_INCLUSIVE, TAX_CODE, TAX_RATE, TAX_AUTHORITY_CODE, TAX_RULE_SET, PRINT_FLAG — core tax computation and printing attributes joined from AR_VAT_TAX_ALL_B.
• TAX_REGIME, TRIBUTARY_SUBSTITUTION, USED_TO_REDUCE, TAX_CATEG_TO_REDUCE_ID, TAX_CATEG_TO_REDUCE_DESC — regime and reduction relationships.
• START_DATE_ACTIVE, END_DATE_ACTIVE, ORG_ID, and the standard WHO audit columns.

Common Use Cases and Queries

The view supports tax category verification, threshold configuration review, and integration extracts that must present decoded attribute values. A query isolating transaction attributes follows:

SELECT tax_category,
       txn_tax_attribute,
       tax_code,
       tax_rate,
       org_id
FROM   apps.jl_zz_ar_tx_categry_v
WHERE  txn_tax_attribute IS NOT NULL
  AND  TRUNC(SYSDATE) BETWEEN NVL(start_date_active, SYSDATE)
                          AND NVL(end_date_active, SYSDATE);

For a specific operating unit and category, filtering on ORG_ID and TAX_CATEGORY returns the effective configuration with all decoded meanings. Reports comparing threshold behavior can group by THRESHOLD_CHECK_GRP_BY_NB and THRESHOLD_CHECK_LEVEL to confirm whether minimum checks apply at line, document, or transaction level. Because the view references synonym-backed base objects, queries should always be issued with the APPS prefix or from a synonymed application schema, and the underlying JL_ZZ_AR_TX_LIB_PKG lookup calls should be considered when evaluating performance on large extracts.