Search Results share_from_dept_code

Overview

APPS.MTL_EAM_EQUIP_RESOURCES_V is a reporting and integration view in the Oracle E-Business Suite Inventory (INV) module, specifically supporting Enterprise Asset Management (EAM) equipment resource functionality. The view consolidates equipment resource definitions, their assignment to departments, and their associated serialized instances into a single denormalized result set, allowing callers to retrieve resource-level attributes (such as unit of measure, autocharge behavior, and capacity sharing rules) alongside department ownership information and instance-level serial numbers.

The object is owned by the APPS schema and is marked VALID in the ETRM repository. Its principal role is to provide a stable, queryable interface for EAM and manufacturing scheduling logic that must resolve which resource an equipment instance belongs to, which department owns or shares it, and how capacity and charging are governed. Because the view is exposed in the APPS schema, it is intended for use by concurrent programs, form logic, and external integrations rather than direct base-table access. It is commonly queried in scenarios involving resource utilization reporting, maintenance scheduling, and capacity planning across departments.

Underlying Base Objects

The view is defined over a set of APPS synonyms referencing the following base objects: BOM_DEPARTMENTS, BOM_DEPARTMENT_RESOURCES, BOM_DEPT_RES_INSTANCES, BOM_RESOURCES, BOM_RESOURCE_EQUIPMENTS, and the subordinate view GMP_EAM_EQUIP_RESOURCES_V. The primary SELECT joins these objects on organization, resource, instance, and department identifiers, then forms a UNION with the corresponding rows drawn from GMP_EAM_EQUIP_RESOURCES_V. Joins include BOM_DEPT_RES_INSTANCES to BOM_RESOURCE_EQUIPMENTS on both RESOURCE_ID and INSTANCE_ID, BOM_RESOURCES on ORGANIZATION_ID and RESOURCE_ID, and BOM_DEPARTMENT_RESOURCES via a DECODE that resolves the owning department (using SHARE_FROM_DEPT_ID when present, otherwise DEPARTMENT_ID). BOM_DEPARTMENTS is joined twice — once as the primary department (BD) and once as an outer-joined shared department (BD1, using BD1.DEPARTMENT_ID(+) = BDR.SHARE_FROM_DEPT_ID) — to derive SHARE_FROM_DEPT_CODE and OWNING_DEPARTMENT_CODE.

Key Columns

• ROW_ID — row identifier derived from the BOM_DEPARTMENT_RESOURCES row.
• ORGANIZATION_ID, INVENTORY_ITEM_ID, SERIAL_NUMBER — identify the equipment item and its serialized instance.
• RESOURCE_ID, RESOURCE_CODE, DESCRIPTION — the resource definition.
• INSTANCE_ID — the EAM instance tied to the resource.
• DEPARTMENT_ID, DEPARTMENT_CODE, SHARE_FROM_DEPT_ID, SHARE_FROM_DEPT_CODE, OWNING_DEPARTMENT_CODE — department ownership and sharing resolution.
• CAPACITY_UNITS, AVAILABLE_24_HOURS_FLAG, RESOURCE_GROUP_NAME, SHARE_CAPACITY_FLAG, UNIT_OF_MEASURE — capacity and scheduling attributes.
• AUTOCHARGE_TYPE — indicates how the resource is charged or costed (a value of particular interest to users searching this term).
• CTP_FLAG — capability-to-promise indicator.
• SCHEDULE_TO_INSTANCE — flag controlling whether scheduling targets the instance level.

Common Use Cases and Queries

A typical integration query retrieves all equipment resources for an organization together with their charging model and owning department:

SELECT resource_code, serial_number, owning_department_code, unit_of_measure, autocharge_type, ctp_flag
FROM apps.mtl_eam_equip_resources_v
WHERE organization_id = :org_id;

The AUTOCHARGE_TYPE column is frequently used to filter resources by charging behavior, for example to isolate resources set to charge automatically versus manually. Capacity planning reports join CAPACITY_UNITS and AVAILABLE_24_HOURS_FLAG to compute available hours, while scheduling integrations consult CTP_FLAG and SCHEDULE_TO_INSTANCE. Because the view includes an outer join to the shared department, OWNING_DEPARTMENT_CODE should be used rather than DEPARTMENT_CODE when the true owning department is required.