Results for “wip_eam_activity_priority”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.MTL_EAM_ASSET_ACTIVITIES_WB_V is a supplementary view in Oracle E-Business Suite, owned by the APPS schema and registered under FND Design Data as INV.MTL_EAM_ASSET_ACTIVITIES_WB_V. Consistent with Oracle's convention for "WB" (workbench) views, it is designed to simplify forms coding rather than to serve as a stable public interface. The ETRM documentation explicitly warns that Oracle does not recommend querying or altering data through this view, as its definition may change dramatically across minor or major releases. Its core purpose is to denormalize Enterprise Asset Management (EAM) activity associations — the linkage between rebuildable assets and the maintenance activities assigned to them — so that the Asset Activities workbench form can display decoded, human-readable information without embedding complex joins.
Because the view joins organization, item, instance, department, and lookup data, it is a convenient read-only source for reporting on EAM activity assignments. The user search term "activity_organization" maps directly to the ORGANIZATION_ID column, which identifies the inventory organization in which the asset activity association is defined. This makes the view relevant to multi-organization EAM deployments where activities must be reported per maintenance organization.
Underlying Base Objects
The documented referenced base objects are MTL_EAM_ASSET_ACTIVITIES (the primary table of asset-to-activity associations), MTL_SYSTEM_ITEMS_B and MTL_SYSTEM_ITEMS_KFV (item definition and concatenated segment descriptions), MTL_SYSTEM_ITEMS_VL (translated item descriptions), CSI_ITEM_INSTANCES (asset instance and serial number detail), BOM_DEPARTMENTS (owning department), MTL_PARAMETERS (organization defaults), EAM_ORG_MAINT_DEFAULTS (EAM-specific organization maintenance defaults), MFG_LOOKUPS (lookup meanings for priority, cause, type, and shutdown type), and EAM_ACTIVITYUTILITIES_PVT (the utility package supplying derived activity attributes). These sources are exposed through APPS synonyms and public views rather than directly referenced. Together they resolve foreign keys and lookup codes into descriptive values.
Key Columns
- ACTIVITY_ASSOCIATION_ID — unique identifier of the asset activity association (primary key of the base table).
- ORGANIZATION_ID — inventory organization in which the association is defined; the "activity_organization" reference.
- ASSET_ACTIVITY_ID — identifier of the activity definition itself.
- ACTIVITY / ACTIVITY_DESCRIPTION — concatenated activity segments and the full description.
- INVENTORY_ITEM_ID, INSTANCE_NUMBER, SERIAL_NUMBER — identifies the rebuildable asset item and its specific instance.
- EAM_ITEM_TYPE, ASSET_REBUILD_GROUP — item classification and rebuildable group.
- START_DATE_ACTIVE / END_DATE_ACTIVE — effective dating of the association.
- PRIORITY / PRIORITY_CODE, ACTIVITY_CAUSE / ACTIVITY_CAUSE_CODE, ACTIVITY_TYPE / ACTIVITY_TYPE_CODE, SHUTDOWN_TYPE / SHUTDOWN_TYPE_CODE — decoded lookup meanings paired with their base lookup codes.
- OWNING_DEPARTMENT / OWNING_DEPARTMENT_ID, ACCOUNTING_CLASS_CODE, TAGGING_REQUIRED_FLAG — organizational and accounting attributes.
- ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 — the descriptive flexfield structure and segments.
- ROW_ID — ROWID pseudocolumn for row identification in the form.
- WHO columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN.
Common Use Cases and Queries
Typical uses include EAM activity assignment reports, asset maintenance plans by organization, and lookups resolved for audit. A representative query filters activities for a given organization:
SELECT activity_association_id, organization_id, activity, activity_description, instance_number, serial_number, priority, activity_type FROM apps.mtl_eam_asset_activities_wb_v WHERE organization_id = :p_org_id AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE+1);
Because the view is informational and release-fragile, production integrations should query the base tables MTL_EAM_ASSET_ACTIVITIES and MTL_SYSTEM_ITEMS_B directly, reserving this view for form-level or diagnostic reporting.
-
Asset Activity Priority
-
Asset Activity Priority
-
12.1.1 FND Design Data 12.1.1
-
View: WIP_EAM_WO_SRV_ASSOC_V 12.1.1
APPS.WIP_EAM_WO_SRV_ASSOC_V·↳ BOM_DEPARTMENTS·↳ CSI_ITEM_INSTANCES·↳ EAM_WORK_ORDER_DETAILS_V·Explore WIP module →
-
View: WIP_EAM_WO_SRV_ASSOC_V 12.2.2
APPS.WIP_EAM_WO_SRV_ASSOC_V·↳ BOM_DEPARTMENTS·↳ CSI_ITEM_INSTANCES·↳ EAM_WORK_ORDER_DETAILS_V·Explore WIP module →
-
12.2.2 FND Design Data 12.2.2
-
View for Activity Workbench
APPS.MTL_EAM_ASSET_ACTIVITIES_WB_V·↳ BOM_DEPARTMENTS·↳ CSI_ITEM_INSTANCES·↳ EAM_ACTIVITYUTILITIES_PVT·Explore INV module →
-
View provides details about the operations of a work order
APPS.EAM_OPERATIONS_DETAILS_V·↳ BOM_DEPARTMENTS·↳ BOM_RESOURCE_EMPLOYEES·↳ CSI_ITEM_INSTANCES·Explore EAM module →
-
View for Asset Activities
APPS.MTL_EAM_ASSET_ACTIVITIES_V·↳ BOM_DEPARTMENTS·↳ CSI_ITEM_INSTANCES·↳ EAM_ORG_MAINT_DEFAULTS·Explore INV module →
-
View for Asset Activities
APPS.MTL_EAM_ASSET_ACTIVITIES_V·↳ BOM_DEPARTMENTS·↳ CSI_ITEM_INSTANCES·↳ EAM_ORG_MAINT_DEFAULTS·Explore INV module →
-
View for Activity Workbench
APPS.MTL_EAM_ASSET_ACTIVITIES_WB_V·↳ BOM_DEPARTMENTS·↳ CSI_ITEM_INSTANCES·↳ EAM_ACTIVITYUTILITIES_PVT·Explore INV module →
-
View for Work Request information
APPS.WIP_EAM_WORK_REQUESTS_V·↳ BOM_DEPARTMENTS·↳ CSI_ITEM_INSTANCES·↳ EAM_ORG_MAINT_DEFAULTS·Explore WIP module →
-
View for Work Request information
APPS.WIP_EAM_WORK_REQUESTS_V·↳ BOM_DEPARTMENTS·↳ CSI_ITEM_INSTANCES·↳ EAM_ORG_MAINT_DEFAULTS·Explore WIP module →
-
PACKAGE: APPS.EAM_CONSTANTS 12.1.1
-
PACKAGE: APPS.EAM_CONSTANTS 12.2.2
-
View shows work orders forecasted by Preventive Maintenance scheduling.
APPS.EAM_OUTSTANDING_WORK_ORDERS_V·↳ BOM_DEPARTMENTS·↳ EAM_FORECASTED_WORK_ORDERS·↳ EAM_PM_SCHEDULINGS·Explore EAM module →
-
VIEW: APPS.AHL_WORKORDERS_V 12.1.1
-
View shows work orders forecasted by Preventive Maintenance scheduling.
APPS.EAM_OUTSTANDING_WORK_ORDERS_V·↳ BOM_DEPARTMENTS·↳ EAM_FORECASTED_WORK_ORDERS·↳ EAM_PM_SCHEDULINGS·Explore EAM module →
-
VIEW: APPS.EAM_WORK_ORDERS_V 12.2.2