Search Results concat_classif_name

Overview

The view ZX_FC_BUSINESS_CATEGORIES_V resides in the APPS schema and belongs to the FND – Application Object Library product family, though its contents are owned by the E-Business Tax (ZX) module. It exposes the set of transaction business categories (TRX_BUSINESS_CATEGORY) that are actively mapped to tax event classes within Oracle E-Business Tax. In Oracle EBS 12.1.1 and 12.2.2, transaction business categories are the fiscal classification codes used by tax configuration to determine which tax rules and regimes apply to a given transaction line. This view therefore serves as a reporting and integration bridge: it presents the concatenated, language-specific, enabled business category codes alongside their corresponding event class mappings, so that downstream applications, extracts, and diagnostic reports can resolve the tax relevance of a business category without directly navigating the denormalized classification tables.

Underlying Base Objects

The view is defined over two synonym-referenced base objects:

• ZX_FC_CODES_DENORM_B — the denormalized fiscal classification codes table, filtered here to CLASSIFICATION_TYPE_CODE = 'TRX_BUSINESS_CATEGORY', restricted to the current session language via LANGUAGE = USERENV('LANG') and to enabled rows via ENABLED_FLAG = 'Y'.
• ZX_EVNT_CLS_MAPPINGS — the tax event class mapping table, which links fiscal classification segment values to application, event class, tax event class, and entity identifiers.

Because the definition uses a UNION ALL, each qualifying business category may appear twice: once where the category matches TAX_EVENT_CLASS_CODE, and once where it matches INTRCMP_TX_EVNT_CLS_CODE (the intra-company tax event class) provided that intra-company value is not null. This dual mapping is significant for intercompany and intracompany tax determination, and explains why the view can return multiple rows for a single CONCAT_CLASSIF_CODE.

Key Columns

• CONCAT_CLASSIF_CODE — the concatenated classification code for the transaction business category. This is the value most commonly stored on transaction lines and used in tax rule qualifiers.
• CONCAT_CLASSIF_NAME — the descriptive, language-specific name of the business category.
• COUNTRY_CODE — the country to which the category applies, supporting country-specific tax configuration.
• EFFECTIVE_FROM / EFFECTIVE_TO — the date range during which the category mapping is valid; critical for date-effective reporting.
• APPLICATION_ID / EVENT_CLASS_CODE — identify the owning application and event class to which the category is mapped.
• TAX_EVNT_CLS_CODE (aliased from TAX_EVENT_CLASS_CODE) — the mapped tax event class, the primary join key against SEGMENT1.
• ENTITY_CODE — the entity identifier associated with the mapping.
• CLASSIFICATION_CODE_LEVEL — indicates the hierarchy level of the classification code.

Common Use Cases and Queries

Typical usage includes validating tax setup, building reconciliation extracts for transaction business categories, and driving integration interfaces that must translate an internal category into its tax event class. A basic query to list all enabled business categories and their mappings is:

• SELECT concat_classif_code, concat_classif_name, country_code, event_class_code, tax_evnt_cls_code, entity_code FROM zx_fc_business_categories_v ORDER BY concat_classif_code;

To locate the tax event class applicable to a specific category on the current date, a filtered query is more appropriate:

• SELECT concat_classif_code, tax_evnt_cls_code, application_id FROM zx_fc_business_categories_v WHERE concat_classif_code = :p_code AND SYSDATE BETWEEN NVL(effective_from, SYSDATE) AND NVL(effective_to, SYSDATE);

Because the view is constrained to the session language and enabled rows only, it is well suited to LOVs and interface lookups where only currently active, localized categories should be offered. Analysts should remain aware of the UNION ALL behavior, applying DISTINCT or explicit filters on tax_evnt_cls_code when duplicate rows must be eliminated.