Search Results get_inv_item_id

Overview

APPS.MTL_ORG_ASSIGN_V is a supplementary view in the Oracle E-Business Suite 12.1.1 and 12.2.2 data model, owned by the APPS schema and registered under FND Design Data as INV.MTL_ORG_ASSIGN_V. Its documented status is VALID, and it is classified as a view type "used to simplify forms coding." Oracle explicitly warns that this view is not intended for direct customer query or data manipulation, as its definition may change dramatically in subsequent minor or major releases. Because it is a non-updatable helper view, it should be treated as a read-only reporting surface.

The view presents item-organization assignment information in a single denormalized result set. It joins inventory item master records to organization definitions and unit-of-measure translations, producing one row per organization/item combination together with the accounting, planning, and dual-unit-of-measure attributes that govern how the item behaves within that organization. In practice it is the fastest path to the frequently requested question "which items are assigned to which inventory organizations, and under what UOM and accounting rules?"

Underlying Base Objects

The documented dependency list for APPS.MTL_ORG_ASSIGN_V includes:

• MTL_SYSTEM_ITEMS_B (synonym) — the item master; supplies INVENTORY_ITEM_ID, PRIMARY_UNIT_OF_MEASURE, SALES_ACCOUNT, COST_OF_SALES_ACCOUNT, EXPENSE_ACCOUNT, ENCUMBRANCE_ACCOUNT, ASSIGNED_FLAG, and the dual-UOM deviation columns.
• HR_ORGANIZATION_UNITS (view) and HR_GENERAL (package) — supply organization code and name (ORGANIZATION_CODE, ORGANIZATION_NAME).
• MTL_PARAMETERS (synonym) — organization-level inventory parameters, including MASTER_ORGANIZATION_ID and EAM_ENABLED_FLAG.
• MTL_UNITS_OF_MEASURE_TL (synonym) — translated UOM descriptions (PRIMARY_UNIT_OF_MEASURE_TL).
• HR_SECURITY (package) and INVIDIT3 (package) — applied to enforce organization access security and item validation logic.

The view references no other database objects downward, and the metadata records that MTL_ORG_ASSIGN_V is not referenced by any other database object.

Key Columns

• ORGANIZATION_ID / ORGANIZATION_CODE / ORGANIZATION_NAME — identify the inventory organization.
• INVENTORY_ITEM_ID — the item identifier within MTL_SYSTEM_ITEMS_B.
• PRIMARY_UNIT_OF_MEASURE / PRIMARY_UNIT_OF_MEASURE_TL — the item's primary UOM code and its translated description.
• SALES_ACCOUNT, COST_OF_SALES_ACCOUNT, EXPENSE_ACCOUNT, ENCUMBRANCE_ACCOUNT — the accounting flexfield identifiers applied when the item is transacted in that organization.
• ASSIGNED_FLAG — indicates whether the item is assigned to the organization.
• MASTER_ORGANIZATION_ID — the master organization from which the item assignment derives.
• EAM_ENABLED_FLAG — indicates Enterprise Asset Management enablement.
• SECONDARY_UOM_CODE, TRACKING_QUANTITY_IND, SECONDARY_DEFAULT_IND, ONT_PRICING_QTY_SOURCE — control dual-unit-of-measure behavior for the item.
• DUAL_UOM_DEVIATION_HIGH / DUAL_UOM_DEVIATION_LOW — the tolerance thresholds governing acceptable deviation between primary and secondary quantity, the columns most directly associated with the search term "dual_uom_deviation_high."

Common Use Cases and Queries

A typical reporting query lists assigned items for a set of organizations, including dual-UOM tolerance settings:

• SELECT organization_code, inventory_item_id, primary_unit_of_measure, secondary_uom_code, dual_uom_deviation_high, dual_uom_deviation_low FROM apps.mtl_org_assign_v WHERE assigned_flag = 'Y';

The view is also used to audit accounting defaults per organization, and to review which items carry dual-UOM deviation tolerances outside expected policy ranges. Because Oracle warns against querying this view directly in production customizations, the recommended approach is to replicate the required logic against its underlying base tables — MTL_SYSTEM_ITEMS_B, MTL_PARAMETERS, and HR_ORGANIZATION_UNITS — using the view definition as a reference template.