Search Results zx_input_classifications




Overview
Explore in AI Chat

Overview

APPS.ZX_INPUT_CLASSIFICATIONS_V is a reporting and integration view within the Oracle E-Business Suite ETRM (E-Business Tax) module. It presents a consolidated list of input tax classifications available for a given operating unit (ORG_ID), combining the seeded and user-defined lookup values from the ZX_INPUT_CLASSIFICATIONS and ZX_WEB_EXP_TAX_CLASSIFICATIONS lookup types with the tax configuration and rate definitions held in the E-Business Tax repository. The view is registered in ETRM 12.2.2 (and compatible with 12.1.1) under the APPS schema and is used primarily to expose the valid set of input tax classification codes that can be applied to inbound transactions, self-assessed taxes, and expenses.

Because it merges lookup metadata with tax regime configuration, the view is valuable for reporting on which classifications are active, enabled, and date-effective for a specific operating unit, and for feeding downstream integrations that need to validate or default an input tax classification.

Underlying Base Objects

The view is defined over three documented base objects:

  • FND_LOOKUP_VALUES (SYNONYM) — Holds the lookup codes, meanings, descriptions, language, and effective dates for the ZX_INPUT_CLASSIFICATIONS and ZX_WEB_EXP_TAX_CLASSIFICATIONS lookup types. Filters restrict results to LANGUAGE = userenv('LANG'), view_application_id = 0, and security_group_id = 0.
  • ZX_ID_TCC_MAPPING_ALL (SYNONYM) — The Tax Classification Code mapping table that associates a tax classification code with tax types, tax classes, tax rate codes, and the owning ORG_ID. The view constrains this table to active_flag = 'Y' and input-side records (tax_class = 'INPUT').
  • ZX_RATES_VL (VIEW) — A view over tax rates used to resolve the tax rate name and description for a given tax classification. The join is made on source_id / tax_rate_id and tax_rate_code.

The two branches of the UNION ALL distinguish records that have an associated tax rate (first branch) from those that map only to a lookup value without a rate (second branch), which is why COALESCE and NVL are used extensively across the MEANING, DESCRIPTION, and date columns.

Key Columns

  • ORG_ID — Operating unit for which the classification is defined.
  • MEANING — The display name of the classification, derived from the tax rate name, or the lookup meaning, or the lookup code.
  • DESCRIPTION — A longer textual description, similarly resolved through COALESCE.
  • LOOKUP_CODE / LOOKUP_TYPE — The classification code identifier and the source lookup type (ZX_INPUT_CLASSIFICATIONS or ZX_WEB_EXP_TAX_CLASSIFICATIONS).
  • LEAF_NODE / ENABLED_FLAG — Indicate whether the lookup is a leaf value and whether it is currently enabled.
  • START_DATE_ACTIVE / END_DATE_ACTIVE — Effective date range, taking the tighter of the lookup and mapping dates.
  • TAX_TYPE / TAX_CLASS — The tax type and tax class associated with the classification (TAX_CLASS resolves to 'INPUT').

Common Use Cases and Queries

Typical uses include validating input tax classifications in inbound interfaces, building LOVs for custom DFFs, and reconciling tax configuration across operating units. A representative query returning all enabled input classifications for an operating unit:

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

Because the view already applies the language and active-flag filters, reports built on it remain consistent with the values presented in the E-Business Tax setup and transaction entry forms.