Results for “dual_uom_deviation_low”

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

Overview

MTL_ORG_ASSIGN_V is a view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It is documented under the Inventory (INV) product module with a description marker of "10SC ONLY," indicating that the object is intended for a restricted or specialized deployment context rather than general-purpose use across all implementations. The view exposes inventory organization assignment information by joining organization parameters, organization definitions, item master records, and unit-of-measure translations.

The view's role is to present, in a single flattened result set, the relationship between an inventory organization and the items it can hold, along with financial accounts and several item-level attribute flags. It is commonly surfaced in reporting and integration scenarios where consumers need a consolidated list of organization/item combinations together with the EAM_ENABLED_FLAG indicator that signals whether Enterprise Asset Management functionality is active for an organization. Because the view carries a DISTINCT keyword and a UNION ALL construct, it produces one row per qualifying organization/item pairing in the item-aware branch, plus a synthetic row per organization where no item assignment exists.

Underlying Base Objects

The documented base objects referenced by MTL_ORG_ASSIGN_V are: HR_GENERAL (package), HR_ORGANIZATION_UNITS (view), HR_SECURITY (package), INVIDIT3 (package), MTL_PARAMETERS (synonym), MTL_SYSTEM_ITEMS_B (synonym), and MTL_UNITS_OF_MEASURE_TL (synonym). The view text also draws on INVIDIT3.GET_INV_ITEM_ID, a package function used in the second branch of the UNION ALL to supply a fallback item identifier.

• MTL_PARAMETERS supplies organization-level attributes including ORGANIZATION_CODE, SALES_ACCOUNT, COST_OF_SALES_ACCOUNT, EXPENSE_ACCOUNT, ENCUMBRANCE_ACCOUNT, MASTER_ORGANIZATION_ID, and EAM_ENABLED_FLAG.
• HR_ORGANIZATION_UNITS supplies the organization NAME and enforces the effective-dating filter NVL(DATE_TO, SYSDATE+1) > SYSDATE.
• MTL_SYSTEM_ITEMS_B supplies item-level data including INVENTORY_ITEM_ID, PRIMARY_UOM_CODE, SECONDARY_UOM_CODE, tracking and dual-unit-of-measure attributes.
• MTL_UNITS_OF_MEASURE_TL supplies the translated unit-of-measure names, filtered by USERENV('LANG').
• INVIDIT3 provides the fallback item ID for organizations lacking a matching item row.
• HR_GENERAL and HR_SECURITY are referenced as supporting packages, typically involved in organizational security and session context.

Key Columns

• ORGANIZATION_ID / ORGANIZATION_CODE / ORGANIZATION_NAME — Identify the inventory organization.
• INVENTORY_ITEM_ID — The item identifier, or the INVIDIT3 fallback value.
• PRIMARY_UNIT_OF_MEASURE / PRIMARY_UNIT_OF_MEASURE_TL — UOM code and translated description.
• SALES_ACCOUNT, COST_OF_SALES_ACCOUNT, EXPENSE_ACCOUNT, ENCUMBRANCE_ACCOUNT — Organization-level accounting flexfield references.
• ASSIGNED_FLAG — Hard-coded 'Y' in the item branch and 'N' in the non-item branch.
• MASTER_ORGANIZATION_ID — The master organization for the given organization.
• EAM_ENABLED_FLAG — Sourced from MTL_PARAMETERS; indicates whether EAM is enabled.
• SECONDARY_UOM_CODE, TRACKING_QUANTITY_IND, SECONDARY_DEFAULT_IND, ONT_PRICING_QTY_SOURCE, DUAL_UOM_DEVIATION_HIGH, DUAL_UOM_DEVIATION_LOW — Dual-unit-of-measure and pricing quantity attributes.

Common Use Cases and Queries

A frequent use case is identifying organizations where EAM is enabled, which is directly relevant to the searched term eam_enabled_flag.

SELECT ORGANIZATION_ID, ORGANIZATION_CODE, EAM_ENABLED_FLAG
FROM   APPS.MTL_ORG_ASSIGN_V
WHERE  EAM_ENABLED_FLAG = 'Y';

Another scenario lists assigned items per organization with their EAM status:

SELECT ORGANIZATION_CODE, INVENTORY_ITEM_ID, ASSIGNED_FLAG, EAM_ENABLED_FLAG
FROM   APPS.MTL_ORG_ASSIGN_V
WHERE  ASSIGNED_FLAG = 'Y'
ORDER BY ORGANIZATION_CODE;

The view also supports account validation and UOM reporting extracts, joining MASTER_ORGANIZATION_ID or account columns to downstream financial or item-master processes.