Search Results notification_required

Overview

The view APPS.WIP_EAM_WORK_ORDER_DTLS_V is a reporting and inquiry object within the Work in Process (WIP) product family of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It consolidates detailed information about Enterprise Asset Management (EAM) maintenance work orders into a single denormalized row per work order. Where the base WIP_DISCRETE_JOBS table stores technical identifiers (numeric IDs, lookup codes, and flags), this view resolves those identifiers into human-readable values: concatenated item segments, instance numbers and descriptions, department codes, lookup meanings, location codes, and parent asset references.

The view is the primary source for maintenance work order reporting—work order listings, work order detail forms, dispatch and planning reports, and integration extracts. Because it derives asset, rebuild, and parent asset information through inline subqueries and a call to EAM_COMMON_UTILITIES_PVT, it should be treated as a query-only reporting object rather than a target for DML. It is particularly valuable to users searching for attributes such as NOTIFICATION_REQUIRED, since that column is exposed directly by the view alongside its sibling maintenance flags.

Underlying Base Objects

The documented base objects are WIP_DISCRETE_JOBS, WIP_ENTITIES, MTL_SYSTEM_ITEMS_KFV, MTL_PARAMETERS, MTL_CATEGORIES_KFV, MTL_EAM_LOCATIONS, CSI_ITEM_INSTANCES, EAM_ORG_MAINT_DEFAULTS, BOM_DEPARTMENTS, MFG_LOOKUPS, and the package EAM_COMMON_UTILITIES_PVT (all table references resolve through APPS synonyms).

• WIP_DISCRETE_JOBS supplies the core work order attributes—organization, status, type, priority, scheduling dates, activity classifications, and maintenance flags.
• WIP_ENTITIES supplies the work order name and the parent work order name through a self-join.
• MTL_SYSTEM_ITEMS_KFV supplies concatenated item segments for the maintenance item, asset group, and rebuild item, with EAM_ITEM_TYPE driving conditional DECODE logic.
• CSI_ITEM_INSTANCES supplies the asset instance number and description.
• MTL_CATEGORIES_KFV and MTL_EAM_LOCATIONS provide category segments and location codes; EAM_ORG_MAINT_DEFAULTS provides the area and owning department; BOM_DEPARTMENTS resolves department codes; MFG_LOOKUPS resolves status meanings; and MTL_PARAMETERS identifies the maintenance organization for parent asset resolution.
• EAM_COMMON_UTILITIES_PVT.GET_PARENT_ASSET is invoked to retrieve the parent asset instance for child work orders.

Key Columns

• WIP_ENTITY_ID, WIP_ENTITY_NAME, ORGANIZATION_ID — unique work order identity and organization.
• STATUS_TYPE, STATUSLOOKUP.MEANING — numeric status and its translated meaning.
• WORK_ORDER_TYPE, DESCRIPTION, PRIORITY, CLASS_CODE — work order classification and priority.
• SCHEDULED_START_DATE, SCHEDULED_COMPLETION_DATE, REQUESTED_START_DATE — planning dates.
• ACTIVITY_TYPE, ACTIVITY_CAUSE, ACTIVITY_SOURCE — maintenance activity coding.
• NOTIFICATION_REQUIRED — flag indicating whether a notification is required for the work order.
• SHUTDOWN_TYPE, TAGOUT_REQUIRED, PLAN_MAINTENANCE, MANUAL_REBUILD_FLAG — additional maintenance and safety flags.
• ASSET_GROUP_ID, PRIMARY_ITEM_ID, REBUILD_ITEM_ID — item and asset group references, with concatenated segments exposed conditionally.
• PARENT_WIP_ENTITY_ID and the resolved parent asset columns — parent/child work order hierarchy.
• AREA_ID, OWNING_DEPARTMENT_ID, OWNING_DEPARTMENT, LOCATION_CODES — maintenance location and ownership context.
• PROJECT_ID, TASK_ID, EAM_LINEAR_LOCATION_ID — project and linear asset linkage.

Common Use Cases and Queries

Typical uses include work order status reporting, maintenance planning extracts, asset history reporting, and notification/shutdown screening. Because NOTIFICATION_REQUIRED is a direct column, teams frequently query it to identify work orders requiring permits or notifications.

• List all work orders requiring notifications for an organization:

  SELECT wip_entity_name, description, status_type, priority,
         scheduled_start_date, notification_required
  FROM   apps.wip_eam_work_order_dtls_v
  WHERE  organization_id = :org_id
  AND    notification_required = 'Y'
  ORDER BY scheduled_start_date;

• Retrieve full detail for a single work order:

  SELECT *
  FROM   apps.wip_eam_work_order_dtls_v
  WHERE  wip_entity_id = :wip_entity_id;

• Report on maintenance flags together with ownership:

  SELECT wip_entity_name, owning_department, shutdown_type,
         tagout_required, plan_maintenance, notification_required
  FROM   apps.wip_eam_work_order_dtls_v
  WHERE  organization_id = :org_id;

• Join to work order operations or material requirements by WIP_ENTITY_ID for integrated reporting and extracts.

All queries should be issued against the APPS synonym and treated as read-only.