Results for “zx_output_classifications”

50+ results




Overview
Explore in AI Chat

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

Overview

The APPS.ZX_TAX_CLASSIFICATIONS_V view is a reporting and integration object within the Oracle E-Business Suite tax (E-Business Tax / ETRM) schema. It presents a consolidated, user-facing catalog of tax classifications that drive tax determination and tax registration logic. The view joins Oracle's seeded and user-defined lookup values (from FND_LOOKUP_VALUES) against the tax classification-to-tax-type/class mapping table (ZX_ID_TCC_MAPPING_ALL), producing one row per organization, classification code, and lookup type. This design allows callers to retrieve classification meaning, description, validity dates, and the parent tax type and tax class in a single query rather than assembling this information manually.

The view supports the Oracle EBS 12.1.1 and 12.2.2 releases. It is commonly used in reports, concurrent programs, and integration layers that must expose valid tax classifications to external systems or to configuration screens. Because it is a view and not a table, no direct DML is possible; consumers use it strictly for read access.

Underlying Base Objects

Per the documented ETRM metadata, the view is defined over three referenced objects: FND_LOOKUP_VALUES (SYNONYM), ZX_ID_TCC_MAPPING_ALL (SYNONYM), and ZX_RATES_VL (VIEW). The principal drivers are:

A notable internal transformation occurs for output classifications: when LOOKUP_TYPE equals ZX_OUTPUT_CLASSIFICATIONS and CREATED_BY equals the Oracle seeded identifier (-1087), the view substitutes a 50-byte substring of the TAG attribute (falling back to LOOKUP_CODE) as the effective lookup code. This normalizes Oracle-seeded output classifications so that the mapped tax classification codes align with user-visible meanings.

Key Columns

  • ORG_ID — the operating unit (legal entity context) owning the classification mapping; drives multi-org security.
  • MEANING / DESCRIPTION — translated display text from FND_LOOKUP_VALUES.
  • LOOKUP_CODE / TAX_CLASSIFICATION_CODE — the classification code used to join to tax rules and registrations.
  • LOOKUP_TYPE — one of the ZX_* classification classes (input, output, web expense).
  • LEAF_NODE, ENABLED_FLAG — indicate whether the lookup is a leaf and currently active.
  • START_DATE_ACTIVE / END_DATE_ACTIVE — derived via NVL and a CASE expression to reconcile the mapping's effective dates with the lookup's active dates, using 31/12/4712 as the open-ended sentinel.
  • TAX_TYPE / TAX_CLASS — the parent tax type and classification grouping from the mapping table.

Common Use Cases and Queries

Typical consumers retrieve active output classifications for a specific operating unit to populate selection lists or integration payloads:

SELECT lookup_code, meaning, tax_type, tax_class FROM apps.zx_tax_classifications_v WHERE org_id = :p_org_id AND lookup_type = 'ZX_OUTPUT_CLASSIFICATIONS' AND enabled_flag = 'Y' AND SYSDATE BETWEEN start_date_active AND end_date_active;

The view is also used to audit date alignment between the seeded lookup definition and the organization-level mapping, and to validate that all mapped classifications resolve to a valid lookup meaning. Because it filters on LANGUAGE = USERENV('LANG'), reports using it respect the session's language, which is essential for multilingual deployments. When searching for "zx_output_classifications," this view is the most direct, supported source, since the LOOKUP_TYPE column isolates that classification category while still returning the associated tax type and tax class context.