Search Results concat_classif_code

Overview

The view APPS.ZX_FC_BUSINESS_CATEGORIES_V is a reporting and integration object within the Oracle E-Business Suite ETRM (E-Business Tax) module. It presents transaction business categories — the classification of transactions for tax determination purposes — joined to the event class mappings that link those categories to application event classes and tax event classes. Because the source column of greatest interest is CONCAT_CLASSIF_NAME, the view is frequently queried to resolve the human-readable concatenated classification name associated with a given business category, country, and effective date range.

The view is owned by APPS and is defined as a UNION ALL of two result sets drawn from the same two base objects. The first branch matches the business category's SEGMENT1 against ZX_EVNT_CLS_MAPPINGS.TAX_EVENT_CLASS_CODE; the second branch matches the same segment against INTRCMP_TX_EVNT_CLS_CODE where that column is not null. This dual-branch structure allows the view to expose both standard and intra-company transaction event class mappings for the same business category.

Underlying Base Objects

The view is defined over two documented base objects, both accessed through synonyms in the APPS schema:

• ZX_FC_CODES_DENORM_B (aliased FC) — the denormalized flexfield code structure that stores classification codes and names, including the concatenated classification segments used to build CONCAT_CLASSIF_NAME.
• ZX_EVNT_CLS_MAPPINGS (aliased EV) — the mapping table that associates tax event classes and intra-company transaction event classes with application identifiers and entity codes.

The join predicate is EV.TAX_EVENT_CLASS_CODE = FC.SEGMENT1 in the first branch and EV.INTRCMP_TX_EVNT_CLS_CODE = FC.SEGMENT1 in the second. Both branches filter on FC.CLASSIFICATION_TYPE_CODE = 'TRX_BUSINESS_CATEGORY', restrict rows to the session language via FC.LANGUAGE = USERENV('LANG'), and require FC.ENABLED_FLAG = 'Y' so that only active, translatable classifications are surfaced.

Key Columns

• CONCAT_CLASSIF_CODE — the concatenated classification code identifying the business category.
• CONCAT_CLASSIF_NAME — the concatenated classification name (the column most often sought by users), resolved in the session language.
• COUNTRY_CODE — the country to which the classification applies.
• EFFECTIVE_FROM / EFFECTIVE_TO — the date range during which the classification is valid.
• APPLICATION_ID — the application owning the associated event class mapping.
• EVENT_CLASS_CODE — the application event class linked to the category.
• TAX_EVNT_CLS_CODE — the tax event class code, mapped from both the standard and intra-company branches.
• ENTITY_CODE — the entity associated with the event class mapping.
• CLASSIFICATION_CODE_LEVEL — the level of the classification code hierarchy.

Common Use Cases and Queries

The view is typically used to look up the business category name for a given tax event class, to drive tax determination reports, or to validate that a category and event class mapping exists before configuration. A representative query to find the classification name by event class code:

• SELECT concat_classif_name, country_code, effective_from, effective_to FROM apps.zx_fc_business_categories_v WHERE tax_evnt_cls_code = :event_class_code;

To restrict results to a specific country and currently effective rows:

• SELECT concat_classif_code, concat_classif_name FROM apps.zx_fc_business_categories_v WHERE country_code = :country AND SYSDATE BETWEEN effective_from AND effective_to;

Because the view is filtered by USERENV('LANG'), applications and reports that join to it must run in a session whose language is set appropriately, otherwise classification names may not resolve as expected. The UNION ALL can also produce multiple rows for the same classification when both a standard and an intra-company mapping exist, so consumers should account for potential row duplication by applying appropriate grouping or distinct filters.