Search Results cst_projmfg_cmt_view




Overview
Explore in AI Chat

Overview

CST_PROJMFG_CMT_VIEW is a reporting view in Oracle E-Business Suite (12.1.1 and 12.2.2) whose documented title is View: CST_PROJMFG_CMT_VIEW, assigned to the BOM – Bills of Material product/module, with the description Manufacturing commitments. The view is designed to present project-related manufacturing commitments in a column structure that conforms to the Oracle Projects commitment interface used to feed commitment (encumbrance-style) data into Project Manufacturing cost collection and project reporting flows.

In ETRM documentation for 12.2.2 the view appears with no owner recorded and no formally documented referenced base objects, indicating that its metadata is sparse and that its definition must be read directly from the dictionary rather than inferred from a maintained object list. The position of the view within the BOM module and its reference to Project Manufacturing subelements suggests it serves reporting of material commitments arising from discrete manufacturing and purchasing transactions tied to a project and task context, rather than as an end-user maintenance object.

Underlying Base Objects

The documented ETRM metadata records no referenced base objects and notes that the implementation is Not implemented in this database; the object is therefore documented by its view text rather than by a maintained dependency listing. The view text shows a composite definition built over the following principal tables and functions:

The view therefore links inventory transaction cost data to purchasing and Project Manufacturing constructs rather than to a single base table.

Key Columns

Columns are projected into a fixed positional structure resembling the Project commitments interface. Notable columns include:

Common Use Cases and Queries

The view supports reconciliation of manufacturing commitments against project expenditures, review of purchase-order-driven commitments by project and task, and diagnostic queries over material transaction cost flow.

SELECT project_id, task_id, segment1, line_num,
       transaction_date, primary_quantity
  FROM cst_projmfg_cmt_view
 WHERE project_id = :project_id;

Summarizing commitment value by organization and period:

SELECT organization_id, period_name,
       SUM(primary_quantity) qty
  FROM cst_projmfg_cmt_view
 GROUP BY organization_id, period_name;

Because the view is documented as not implemented in every database, availability and column layout should be verified against the target instance before relying on it in production reporting.