Results for “leaf_node”

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

Overview

The view APPS.ZX_OUTPUT_CLASSIFICATIONS_V is a reporting and integration object within the Oracle E-Business Tax (E-Business Tax / ETRM) module, registered in the Oracle EBS 12.1.1 and 12.2.2 data models under the FND — Application Object Library product grouping. It exposes the set of output-side tax classifications configured for a given operating unit or organization, presenting a denormalized, query-ready projection that joins lookup definitions against the Tax Classification Code to Tax Type/Class mapping. Its primary role is to allow downstream reports, user-extensible lookups, and integration interfaces to retrieve valid output tax classifications without directly navigating the underlying mapping and lookup tables. The view is marked VALID in the APPS schema, indicating it is compiled and available for use by concurrent programs, OA Framework pages, and custom SQL.

Underlying Base Objects

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

• FND_LOOKUP_VALUES (SYNONYM) — supplies the lookup rows with lookup type ZX_OUTPUT_CLASSIFICATIONS, filtered by the user's language (USERENV('LANG')), SECURITY_GROUP_ID = 0, and VIEW_APPLICATION_ID = 0. A decode on CREATED_BY = -1087 uses the tagged value in SUBSTRB(TAG, 50) when the lookup code is seeded.
• ZX_ID_TCC_MAPPING_ALL (SYNONYM) — the Tax Classification Code mapping table (alias TCC), which links each classification code to its TAX_TYPE, TAX_CLASS, organization, and effectiveness dates. Rows are restricted to ACTIVE_FLAG = 'Y' and to TAX_CLASS = 'OUTPUT' (or null).
• ZX_RATES_VL (VIEW) — documented as a referenced object, providing the translated tax rate value list used within the E-Business Tax decision and classification framework.

The driving join is TCC.TAX_CLASSIFICATION_CODE = LKP.LOOKUP_CODE, producing an inner join that yields only classifications with both a lookup entry and an active mapping.

Key Columns

The view exposes the following principal columns:

• ORG_ID — the operating unit / organization identifier from the mapping table, enabling multi-org filtering.
• MEANING / DESCRIPTION — the user-facing name and description of the output classification.
• LOOKUP_CODE — the tax classification code, decoded for seeded lookups via the TAG value.
• LOOKUP_TYPE — the lookup type identifier, ZX_OUTPUT_CLASSIFICATIONS.
• LEAF_NODE / ENABLED_FLAG — flags indicating hierarchy leaf status and whether the classification is enabled for use.
• START_DATE_ACTIVE / END_DATE_ACTIVE — computed from the later of the TCC effective dates and the lookup active dates, with the 31/12/4712 sentinel representing an open-ended range.
• TAX_TYPE / TAX_CLASS — the mapped tax type and the tax class, filtered to OUTPUT.

Common Use Cases and Queries

The view is typically used to populate output tax classification selection lists, drive tax determination, and support reconciliation reporting. A representative query retrieving enabled output classifications for an operating unit:

• SELECT ORG_ID, LOOKUP_CODE, MEANING, TAX_TYPE, START_DATE_ACTIVE, END_DATE_ACTIVE FROM APPS.ZX_OUTPUT_CLASSIFICATIONS_V WHERE ORG_ID = :p_org_id AND ENABLED_FLAG = 'Y' AND SYSDATE BETWEEN START_DATE_ACTIVE AND END_DATE_ACTIVE ORDER BY MEANING;
• Integration usage: expose the view to an interface table or BI Publisher report as the authoritative source of valid OUTPUT classification codes, filtering on TAX_TYPE to constrain the acceptable values.

Because the view joins against ZX_ID_TCC_MAPPING_ALL and applies multi-org and language filters, developers should always supply an ORG_ID predicate and observe the effectiveness date logic to avoid returning stale or cross-organization records.