Results for “structure_id”

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

Overview

ZX_FC_PRODUCT_FISCAL_V is an APPS-owned database view registered in the ETRM reference repository with a status of VALID. Although it is catalogued under the FND — Application Object Library product grouping, its naming and definition place it within the Oracle E-Business Tax (ZX) fiscal classification model. The view supplies a flattened, fiscal-ready representation of inventory product categories, resolving the key flexfield context of the item category structure into a form usable by tax determination and reporting logic.

The name indicates its purpose: a product fiscal view. It joins the country-level fiscal defaults held in ZX_FC_COUNTRY_DEFAULTS to the inventory category structures and descriptions maintained in the MTL category tables. The result is a row set in which each inventory category is presented together with its owning structure, the corresponding country code, and the descriptive name of the product fiscal classification. This makes the view a convenient access path for downstream reporting, tax configuration validation, and integration extracts that would otherwise require multi-table joins across the Inventory and E-Business Tax schemas.

Its relevance to the user search term, mtl_categories_b_kfv, is direct: that key flexfield view is one of the five documented base objects on which ZX_FC_PRODUCT_FISCAL_V is built.

Underlying Base Objects

The ETRM documentation for release 12.2.2 lists the following referenced objects:

• FND_ID_FLEX_STRUCTURES_VL (VIEW) — the key flexfield structure definitions; supplies the structure name and structure code, constrained to APPLICATION_ID = 401 and ID_FLEX_CODE = 'MCAT'.
• MTL_CATEGORIES_B_KFV (VIEW) — the key flexfield representation of inventory categories; provides CATEGORY_ID, STRUCTURE_ID, the concatenated segments, the enabled flag, and the end date.
• MTL_CATEGORIES_TL (SYNONYM) — the translated category descriptions, joined on LANGUAGE via USERENV('LANG').
• MTL_CATEGORY_SETS_B (SYNONYM) — the category set base table, linking each category set to its flexfield structure.
• ZX_FC_COUNTRY_DEFAULTS (SYNONYM) — the tax country defaults, supplying COUNTRY_CODE and the primary inventory category set identifier.

The primary join path runs from ZX_FC_COUNTRY_DEFAULTS.PRIMARY_INVENTORY_CATEGORY_SET to MTL_CATEGORY_SETS_B.CATEGORY_SET_ID, then to FND_ID_FLEX_STRUCTURES_VL on STRUCTURE_ID = ID_FLEX_NUM, and finally to MTL_CATEGORIES_B_KFV on STRUCTURE_ID = ID_FLEX_NUM and CATEGORY_ID = MTL_CATEGORIES_TL.CATEGORY_ID. Only categories with ENABLED_FLAG = 'Y' are returned.

Key Columns

• CATEGORY_ID — identifier of the inventory category from MTL_CATEGORIES_B_KFV.
• STRUCTURE_ID — the category flexfield structure identifier, keyed to the MCAT flexfield.
• CATEGORY_SET_ID — the category set associated with the country default.
• NAME — the translated category description from MTL_CATEGORIES_TL.
• CODE — the concatenated category segments with the flexfield delimiter removed via REPLACE.
• STRUCTURE_NAME / STRUCTURE_CODE — the flexfield structure's display name and code.
• COUNTRY_CODE — the country for which the fiscal default is defined.
• EFFECTIVE_TO — the category end date (END_DATE_ACTIVE).

Common Use Cases and Queries

Typical uses include verifying which inventory categories are mapped as product fiscal classifications for a given country, generating extracts for tax setup review, and reporting on active categories by structure.

Sample query:

• SELECT category_id, code, name, structure_code, country_code, effective_to FROM apps.zx_fc_product_fiscal_v WHERE country_code = 'US' AND effective_to IS NULL ORDER BY code;
• SELECT country_code, COUNT(*) FROM apps.zx_fc_product_fiscal_v GROUP BY country_code;