Search Results wip_order

Overview

CSP_EOO_CANCEL_RECOMM_V is an APPS-owned database view within the CSP (Spares Management) product module of Oracle E-Business Suite, valid in both the 12.1.1 and 12.2.2 releases. The view is designed to support the Excess On Order (EOO) business process by returning a consolidated list of supply orders that are candidates for cancellation once an excess on order notification has been raised. It presents demand-side and supply-side context in a single result set, allowing planners, buyers, and the Spares Management planning engine to identify surplus incoming supply — requisitions, internal sales order shipments, receiving transactions, purchase orders, and work in process jobs — that can be eliminated without adversely affecting material availability.

As a reporting and integration view, CSP_EOO_CANCEL_RECOMM_V is not a transactional entity; it is a read-only projection joined across the Oracle Purchasing, Order Management, Inventory, and Work in Process schemas. It provides a normalized status description for each candidate row and surfaces the originating document reference so that downstream cancellation or deferral actions can be traced back to their source record.

Underlying Base Objects

The view text is a UNION of multiple branches, each addressing a distinct supply type. The documented base objects referenced by the view include:

• MTL_SUPPLY — the central supply/demand table from which quantity, item, organization, and supply type are derived.
• PO_REQUISITION_HEADERS_ALL and PO_REQUISITION_LINES_ALL — provide the requisition number, authorization status, line type, and the requisition line that a supply row is tied to.
• OE_ORDER_HEADERS_ALL and OE_ORDER_LINES_ALL — resolve internal sales order context where a requisition has been transferred to Order Management.
• PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_TYPES, PO_LOOKUP_CODES, and PO_VENDORS — support the purchase order branch of the union.
• WIP_DISCRETE_JOBS, WIP_REPETITIVE_ITEMS, WIP_REPETITIVE_SCHEDULES, and WIP_ENTITIES — support the work in process branch.
• FND_LOOKUPS, OE_LOOKUPS, and MFG_LOOKUPS — supply meaning values for status and supply type decoding.
• FND_GLOBAL and PO_HEADERS_SV3 — security and document-numbering packages used internally.
• MTL_SYSTEM_ITEMS_KFV and HR_ALL_ORGANIZATION_UNITS — item and organization descriptive information.

Key Columns

• QUANTITY — the on-order quantity for the supply row (TO_ORG_PRIMARY_QUANTITY, defaulted to 0).
• ITEM_ID and ORGANIZATION_ID — the inventory item and destination organization.
• REQUISITION — the requisition segment1 identifier, populated only on the requisition branch.
• INTERNAL_ORDER — the internal sales order number.
• PURCHASE_ORDER and WIP_ORDER — document references populated on their respective union branches.
• STATUS — a decoded, human-readable status derived from supply type and authorization or transferred-to-OE flags.
• LINE_TYPE — the purchasing line type (e.g., goods, services) from PO_LINE_TYPES.

Common Use Cases and Queries

The view is most frequently queried by planners reviewing excess on order notifications, by buyers identifying purchase orders eligible for cancellation, and by custom reports in Spares Management. A representative query filtering by organization and item is:

• SELECT requisition, purchase_order, internal_order, wip_order, quantity, status FROM csp_eoo_cancel_recomm_v WHERE organization_id = :org AND item_id = :item;
• Reporting on all cancel-ready purchase orders: SELECT purchase_order, item_id, organization_id, quantity FROM csp_eoo_cancel_recomm_v WHERE purchase_order IS NOT NULL;
• Requisition-based candidates: SELECT requisition, line_type, status FROM csp_eoo_cancel_recomm_v WHERE requisition IS NOT NULL AND status = 'Approved';

Because the view joins several high-volume base tables, queries should always be constrained by organization and item to avoid full scans, and it should be treated strictly as a read-only diagnostic aid.