Search Results update_wip




Overview
Explore in AI Chat

Overview

ENG_WEB_SCHEDULE_V is an APPS-owned reporting view in the Oracle E-Business Suite Engineering (ENG) module, documented under ETRM for releases 12.1.1 and 12.2.2 with a status of VALID. Its documented description is "Revised items," and in practice it exposes the schedule of revised items awaiting or undergoing engineering change implementation. The view consolidates Engineering Change Order (ECO) header data, revised item lines, item master attributes, bill of material references, lookup meanings, and organizational context into a single flattened result set.

The view is designed primarily for web-facing inquiry and reporting against revised item schedules — that is, which items within which organizations are targeted for revision, under what ECO, with what scheduled and actual implementation dates. Because it joins lkpup-driven status and approval columns through MFG_LOOKUPS, it delivers business-readable values rather than raw lookup codes, which suits concurrent-program extracts, Oracle Reports, and custom OAF or JSP inquiry pages.

Underlying Base Objects

The view is defined over a mixture of ENG synonyms, MTL and BOM views, HR views, and lookup views. Documented referenced objects include:

The joins are driven by the composite key CHANGE_NOTICE plus ORGANIZATION_ID between the ECO and its revised items, with the revised item then resolved to MTL_ITEM_FLEXFIELDS on ORGANIZATION_ID and INVENTORY_ITEM_ID. Several joins are outer joins, including the BOM designator, approval status lookup, requestor person, and responsible organization, so revised items remain visible even where those attributes are not yet populated.

Key Columns

Common Use Cases and Queries

Typical uses include revised item schedule reports, ECO impact listings, and integration extracts feeding downstream planning or PLM systems. A basic query filtering by revised item description resembles:

SELECT change_notice, organization_code, revised_item, revised_item_description, new_item_revision, eco_status, scheduled_date, implementation_date FROM apps.eng_web_schedule_v WHERE revised_item_description LIKE 'CABLE%' ORDER BY scheduled_date;

To list open revised items by organization and status:

SELECT organization_code, revised_item, revised_item_status, approval_status, requestor FROM apps.eng_web_schedule_v WHERE revised_item_status = 'Open' AND organization_id = :org_id;

Because the view applies no responsibility-based row filtering in its text, access control is typically enforced by the calling form, report, or by joining to MTL_PARAMETERS / FND_GLOBAL-resolved org security. Queries should therefore be constrained by organization to avoid cross-org data exposure.