Search Results mtl_org_assign_v




Overview
Explore in AI Chat

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.

Key Columns

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.