Results for “bom_eam_shutdown_type”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.BOM_STANDARD_OPERATIONS_V is a reporting and integration view in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 that presents standard manufacturing operations as defined in Oracle Bills of Material and Oracle Work in Process. A standard operation represents a reusable shop-floor step—identified by an operation code and sequence—that can be attached to routings, assemblies, and work orders. The view flattens the core BOM_STANDARD_OPERATIONS record and enriches it with department details, production line information, and decoded lookup values.
The view is significant because it exposes several denormalized and derived columns that are not directly present on the base table. It joins to the MFG_LOOKUPS view to resolve the SHUTDOWN_TYPE code into a user-facing meaning via the BOM_EAM_SHUTDOWN_TYPE lookup type, and it supplies derived flags—COUNT_POINT_FLAG, AUTOCHARGE_FLAG, and CHECK_SKILL—that simplify operational reporting. Within ETRM and other technical repositories, it is catalogued as an APPS-owned view referenced by external reporting, integration, and extension logic rather than by seeded concurrent programs.
Underlying Base Objects
The view is defined over four documented objects:
- BOM_STANDARD_OPERATIONS (SYNONYM) — the primary table holding the operation header: sequence, operation code, department, yield, shutdown type, and descriptive flexfield attributes.
- BOM_DEPARTMENTS (SYNONYM) — joined on DEPARTMENT_ID to supply the department code, description, and location.
- WIP_LINES (SYNONYM) — outer-joined on LINE_ID to return the production line code where an operation is line-specific.
- MFG_LOOKUPS (VIEW) — outer-joined on LOOKUP_TYPE = 'BOM_EAM_SHUTDOWN_TYPE' and LOOKUP_CODE = TO_NUMBER(SHUTDOWN_TYPE) to translate the shutdown type into its meaning.
The join to BOM_DEPARTMENTS is mandatory (no outer join), so every row returned requires a valid department. The joins to WIP_LINES and MFG_LOOKUPS are outer joins, meaning operations without an assigned line or a recognized shutdown type are still returned, with those columns null.
Key Columns
- STANDARD_OPERATION_ID — primary key of the standard operation; the principal identifier for integration.
- OPERATION_CODE and OPERATION_DESCRIPTION — the operation name and description.
- SEQUENCE_NUM — the operation's sequence within its owning structure.
- ORGANIZATION_ID — the inventory organization that owns the operation.
- DEPARTMENT_ID, DEPARTMENT_CODE, DEPARTMENT_DESCRIPTION, LOCATION_ID — department context sourced from BOM_DEPARTMENTS.
- LINE_CODE and LINE_ID — production line assignment from WIP_LINES.
- SHUTDOWN_TYPE and SHUTDOWN_TYPE_VALUE — the raw code and its decoded meaning from the BOM_EAM_SHUTDOWN_TYPE lookup.
- COUNT_POINT_FLAG and AUTOCHARGE_FLAG — derived via DECODE(COUNT_POINT_TYPE): COUNT_POINT_FLAG returns 1 for count point type 1 (else 2); AUTOCHARGE_FLAG returns 2 for count point type 3 (else 1).
- CHECK_SKILL — NVL(CHECK_SKILL, 2), defaulting the skill-check indicator when null.
- YIELD, LOWEST_ACCEPTABLE_YIELD, OPERATION_YIELD_ENABLED — yield control settings.
- BACKFLUSH_FLAG, WMS_TASK_TYPE, MINIMUM_TRANSFER_QUANTITY — shop-floor execution attributes.
- ATTRIBUTE_CATEGORY through ATTRIBUTE15 — descriptive flexfield columns.
- Standard WHO columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE.
Common Use Cases and Queries
Because the view resolves the BOM_EAM_SHUTDOWN_TYPE lookup, it is commonly used to report on EAM shutdown operations and count-point/autocharge configurations. Typical scenarios include querying operations by organization, department, or production line, and extracting flexfield attributes for integration.
Operations for a specific organization:
SELECT standard_operation_id, operation_code, department_code, sequence_num FROM apps.bom_standard_operations_v WHERE organization_id = :org_id ORDER BY operation_code;
EAM shutdown operations with decoded meaning:
SELECT operation_code, department_code, shutdown_type, shutdown_type_value FROM apps.bom_standard_operations_v WHERE organization_id = :org_id AND shutdown_type IS NOT NULL;
Count-point and autocharge analysis:
SELECT operation_code, count_point_flag, autocharge_flag, check_skill FROM apps.bom_standard_operations_v WHERE organization_id = :org_id;
Line-specific operations:
SELECT line_code, operation_code, department_code FROM apps.bom_standard_operations_v WHERE organization_id = :org_id AND line_code IS NOT NULL ORDER BY line_code, sequence_num;
For data extraction, the STANDARD_OPERATION_ID should be used as the stable join key to base tables, while the view's decoded columns eliminate the need for separate lookup joins in downstream reports.
-
Enterprise Asset Management Shutdown Type
-
Enterprise Asset Management Shutdown Type
-
VIEW: APPS.WIP_OPERATIONS_V 12.1.1
-
VIEW: APPS.WIP_OPERATIONS_V 12.2.2
-
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 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 →
-
12.2.2 FND Design Data 12.2.2
-
Standard operations
APPS.BOM_STANDARD_OPERATIONS_V·↳ BOM_DEPARTMENTS·↳ BOM_STANDARD_OPERATIONS·↳ MFG_LOOKUPS·Explore BOM module →
-
12.1.1 FND Design Data 12.1.1
-
PACKAGE: APPS.EAM_CONSTANTS 12.2.2
-
View: EAM_CFR_OPERATIONS_V 12.2.2
This view displays information on operations for work orders.
APPS.EAM_CFR_OPERATIONS_V·↳ BOM_DEPARTMENTS·↳ BOM_STANDARD_OPERATIONS·↳ MFG_LOOKUPS·Explore EAM module →
-
Standard operations
APPS.BOM_STANDARD_OPERATIONS_V·↳ BOM_DEPARTMENTS·↳ BOM_STANDARD_OPERATIONS·↳ MFG_LOOKUPS·Explore BOM module →
-
PACKAGE: APPS.EAM_CONSTANTS 12.1.1
-
View: WIP_OPERATIONS_V 12.1.1
Foreign-key data for WIP_OPERATIONS
APPS.WIP_OPERATIONS_V·↳ BOM_DEPARTMENTS·↳ BOM_STANDARD_OPERATIONS·↳ MFG_LOOKUPS·Explore WIP module →
-
View: WIP_OPERATIONS_V 12.2.2
Foreign-key data for WIP_OPERATIONS
APPS.WIP_OPERATIONS_V·↳ BOM_DEPARTMENTS·↳ BOM_STANDARD_OPERATIONS·↳ MFG_LOOKUPS·Explore WIP module →
-
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 →
-
Operations
APPS.BOM_OPERATION_SEQUENCES_V·↳ BOM_DEPARTMENTS·↳ BOM_OPERATION_SEQUENCES·↳ BOM_STANDARD_OPERATIONS·Explore BOM module →
-
Operations
APPS.BOM_OPERATION_SEQUENCES_V·↳ BOM_DEPARTMENTS·↳ BOM_OPERATION_SEQUENCES·↳ BOM_STANDARD_OPERATIONS·Explore BOM module →
-
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
-
View: MTL_SYSTEM_ITEMS_ER1_V 12.1.1
ERES : View to support ERES framework for Items
APPS.MTL_SYSTEM_ITEMS_ER1_V·↳ FA_CATEGORIES_B_KFV·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_GENERAL·Explore INV module →
-
View: MTL_SYSTEM_ITEMS_ER1_V 12.2.2
ERES : View to support ERES framework for Items
APPS.MTL_SYSTEM_ITEMS_ER1_V·↳ FA_CATEGORIES_B_KFV·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_GENERAL·Explore INV module →
-
VIEW: APPS.EAM_WORK_ORDERS_V 12.1.1
-
View: WIP_EAM_WORK_ORDERS_V 12.1.1
Maintenance Work Orders
APPS.WIP_EAM_WORK_ORDERS_V·↳ BOM_DEPARTMENTS·↳ CSI_ITEM_INSTANCES·↳ EAM_COMMON_UTILITIES_PVT·Explore WIP module →
-
View: WIP_EAM_WORK_ORDERS_V 12.2.2
Maintenance Work Orders
APPS.WIP_EAM_WORK_ORDERS_V·↳ BOM_DEPARTMENTS·↳ CSI_ITEM_INSTANCES·↳ EAM_COMMON_UTILITIES_PVT·Explore WIP module →