Results for “attr_val_desc”

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

Overview

The JL_ZZ_AR_TX_ATT_VAL_V view is a Latin America Localizations (JL) object owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents tax attribute values maintained for Latin American tax categories, joining the attribute value storage table with Oracle Receivables system parameters to enforce organization-level context. The view is primarily consumed by ETRM (E-Business Tax and Latin America Tax Reporting) reporting, tax configuration inquiries, and integration interfaces that require a human-readable description of stored tax attribute codes.

The column name ATTR_VAL_DESC reflects the view's core design intent: it derives display-friendly meaning from coded attribute values rather than exposing raw stored identifiers. This makes the view particularly useful wherever a descriptive label is required in an LOV, report, or outbound interface payload.

Underlying Base Objects

The view is defined over three documented referenced objects:

• JL_ZZ_AR_TX_ATT_VAL_ALL (synonym) — the principal base table holding tax category attribute values, aliased as VAL in the view definition.
• AR_SYSTEM_PARAMETERS_ALL (synonym) — the Receivables system parameters table, aliased as SYS, providing the organization context used in the join predicate.
• JL_ZZ_AR_TX_LIB_PKG (package) — a Latin America tax library package supplying the GET_LOOKUP_MEANING function that resolves lookup codes into descriptive meanings.

The join is expressed as NVL(VAL.ORG_ID, -99) = NVL(SYS.ORG_ID, -99), using the -99 sentinel to match records where ORG_ID is null on either side. The ROWID of the base attribute value row is exposed as ROW_ID.

Key Columns

• ROW_ID — the base table ROWID, enabling direct row identification.
• TAX_CATEGORY_ID — foreign key to the tax category owning the attribute.
• TAX_CATEG_ATTR_VAL_ID — primary identifier for the attribute value record.
• TAX_ATTRIBUTE_TYPE / TAX_ATTRIBUTE_NAME — classify and name the attribute (for example CONTRIBUTOR_ATTRIBUTE or TRANSACTION_ATTRIBUTE).
• TAX_ATTRIBUTE_VALUE — the stored attribute value, resolved through GET_LOOKUP_MEANING into the derived ATTR_VAL_DESC column (truncated to 80 characters, lookup type JLZZ_AR_TX_ATTR_VALUE).
• TAX_ATTR_VALUE_CODE — the coded value, resolved into TAX_ATTR_VALUE_MEANING using a lookup type selected by DECODE based on TAX_ATTRIBUTE_TYPE.
• DEFAULT_TO_CLASS — indicates whether the attribute value defaults to the tax class.
• ORG_ID and the standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, LAST_UPDATED_BY) — audit and organization context.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard DFF/context flexfield columns.

Common Use Cases and Queries

Typical scenarios include reviewing the descriptive meaning of configured tax attribute values, driving tax LOVs, and building extraction queries for Latin American tax reporting.

• Listing attribute values for a tax category with their descriptive labels.
• Filtering contributor or transaction attributes by type.
• Retrieving organization-specific configuration using ORG_ID.

Sample query:

SELECT TAX_CATEGORY_ID, TAX_ATTRIBUTE_NAME, TAX_ATTRIBUTE_VALUE, ATTR_VAL_DESC, TAX_ATTR_VALUE_MEANING, ORG_ID FROM JL_ZZ_AR_TX_ATT_VAL_V WHERE TAX_CATEGORY_ID = :p_category_id AND ORG_ID = :p_org_id;

Because ATTR_VAL_DESC is derived at query time through package calls, report performance benefits from restricting predicates to the indexed base columns (TAX_CATEGORY_ID, ORG_ID) before the lookup resolution is applied.