Search Results work_request_asset_num_reqd

Overview

WIP_EAM_PARAMETERS_V is an APPS-owned database view in the Work in Process (WIP) module of Oracle E-Business Suite, documented under ETRM 12.2.2 and applicable to releases 12.1.1 and 12.2.2. Its stated purpose is to expose Enterprise Asset Management (EAM) organization parameters in a denormalized, report-friendly format. Where the underlying table WIP_EAM_PARAMETERS stores foreign keys and coded values, this view resolves those keys into descriptive meanings by joining to lookups, accounting classes, cost elements, and departments.

The view occupies a central role in EAM reporting and integration because it consolidates the operational defaults that govern maintenance work orders for each organization: work request approval behavior, work order prefixes, default maintenance cost categories, accounting classes, departments, and asset-handling flags. For the user search term "eam_cost_element_id," the view is directly relevant: it exposes DEF_EAM_COST_ELEMENT_ID (stored in WIP_EAM_PARAMETERS) alongside EAM_COST_ELEMENT, the descriptive value fetched from CST_EAM_COST_ELEMENTS. This lets consumers retrieve both the identifier and its resolved name in a single query without maintaining their own join logic. Because it is a view rather than a table, it is read-only and inherits the security and synonyms of the APPS schema.

Underlying Base Objects

The view is defined with the following documented base objects, all referenced through APPS synonyms except MFG_LOOKUPS, which is a view:

• WIP_EAM_PARAMETERS (SYNONYM) — the driving table, aliased E1, holding one row of EAM parameters per organization.
• MFG_LOOKUPS (VIEW) — aliased B1, joined on DEF_MAINT_COST_CATEGORY = LOOKUP_CODE with LOOKUP_TYPE = 'BOM_EAM_COST_CATEGORY' to supply the MEANING column. This is an inner join.
• CST_EAM_COST_ELEMENTS (SYNONYM) — aliased C1, outer-joined on EAM_COST_ELEMENT_ID(+) = DEF_EAM_COST_ELEMENT_ID to resolve the default EAM cost element.
• WIP_ACCOUNTING_CLASSES (SYNONYM) — aliased W1, outer-joined on CLASS_CODE(+) = DEFAULT_EAM_CLASS and ORGANIZATION_ID(+) = ORGANIZATION_ID, yielding the DESCRIPTION column.
• BOM_DEPARTMENTS (SYNONYM) — aliased BD, outer-joined on DEPARTMENT_ID(+) = DEFAULT_DEPARTMENT_ID, providing DEPARTMENT_CODE as DEFAULT_DEPARTMENT.

The outer joins ensure a parameter row is returned even when the cost element, accounting class, or department is not yet defined, with the resolved descriptive columns returned as NULL in those cases.

Key Columns

• ROW_ID — the ROWID of the WIP_EAM_PARAMETERS row, used as a unique identifier.
• ORGANIZATION_ID — the inventory organization whose EAM parameters are represented; the primary filter key.
• DEF_EAM_COST_ELEMENT_ID — the foreign key to CST_EAM_COST_ELEMENTS identifying the default EAM cost element.
• EAM_COST_ELEMENT — the resolved descriptive name of the default cost element, sourced from CST_EAM_COST_ELEMENTS.
• DEF_MAINT_COST_CATEGORY and MEANING — the maintenance cost category code and its decoded lookup meaning.
• DEFAULT_EAM_CLASS and DESCRIPTION — the default accounting class code and its WIP_ACCOUNTING_CLASSES description.
• DEFAULT_DEPARTMENT_ID and DEFAULT_DEPARTMENT — the default department identifier and its BOM_DEPARTMENTS code.
• AUTO_APPROVE_ENABLED_FLAG, AUTO_FIRM_FLAG, AUTO_FIRM_ON_CREATE — work request and work order automation flags.
• WORK_ORDER_PREFIX, EASY_WORK_ORDER_PREFIX, WIP_EAM_REQUEST_TYPE — numbering and request-type configuration.
• MAINTENANCE_OFFSET_ACCOUNT, DEFAULT_ASSET_FLAG, MATERIAL_ISSUE_BY_MO, INVOICE_BILLABLE_ITEMS_ONLY, SERIAL_NUMBER_ENABLED — accounting and asset-tracking controls.
• PM_IGNORE_MISSED_WO, ISSUE_ZERO_COST_FLAG, WORK_REQUEST_ASSET_NUM_REQD, EAM_WO_WORKFLOW_ENABLED — preventive maintenance and workflow behavior.

Common Use Cases and Queries

A frequent requirement is retrieving the default EAM cost element for an organization, which is the scenario implied by the search term "eam_cost_element_id":

• Configuration validation — confirming that DEF_EAM_COST_ELEMENT_ID is populated and resolves to a valid EAM_COST_ELEMENT for each organization.
• Integration and interfaces — supplying cost element identifiers to external maintenance or costing systems.
• Reporting — listing work order prefixes, approval flags, and default departments across organizations.

Representative query for a single organization:

SELECT organization_id, def_eam_cost_element_id, eam_cost_element, def_maint_cost_category, meaning FROM wip_eam_parameters_v WHERE organization_id = :org_id;

To audit rows where the cost element could not be resolved (outer join produced NULL):

SELECT organization_id, def_eam_cost_element_id FROM wip_eam_parameters_v WHERE def_eam_cost_element_id IS NOT NULL AND eam_cost_element IS NULL;

To list EAM-enabled parameters across all organizations:

SELECT organization_id, eam_cost_element, default_department, auto_firm_flag FROM wip_eam_parameters_v ORDER BY organization_id;