Search Results denom_amount_delivered




Overview
Explore in AI Chat

Overview

APPS.CST_PROJMFG_CMT_STUB_V is an internal Oracle E-Business Suite view that exposes commitment (CMT) transaction data for project manufacturing cost collection. In EBS 12.1.1 and 12.2.2 it functions as a stub interface between Purchasing commitments and the Cost Management module, providing a flattened projection of commitment distribution lines together with their accounting and denominator (project cost) cost amounts. The view is registered under FND Design Data BOM.CST_PROJMFG_CMT_STUB_V and carries a status of VALID, with a View Type of Internal.

The object carries the standard Oracle warning that it is for Oracle Internal Use Only and is not supported for direct customer access. Its columns are consumed by standard Cost Management and Projects programs that transfer commitment costs into project cost and accounting distributions, rather than by end-user reporting tools. Because the display name is a stub view, the columns represent the denormalised shape required to feed the project manufacturing commitment processor.

Underlying Base Objects

The documented dependency for this view is PA_IMPLEMENTATIONS_ALL, referenced through a synonym. PA_IMPLEMENTATIONS_ALL is the Oracle Projects implementation/configuration table that stores the set of books and implementation options for each operating unit. Its presence indicates that CST_PROJMFG_CMT_STUB_V is filtered or joined against the implementation context so that returned commitment lines are restricted to valid, configured Projects implementations.

Conceptually the view sources commitment header and distribution information from the Purchasing commitment tables (PO_HEADERS, PO_LINES, PO_LINE_LOCATIONS, PO_DISTRIBUTIONS) and derives project/task association and cost amounts through Projects and Cost Management logic. The structure is intentionally denormalised: header attributes, distribution identifiers, quantity and amount metrics, and accounting versus denominator cost amounts are presented on a single row for downstream processing.

Key Columns

Common Use Cases and Queries

The view is used to feed commitment cost transfer and reconciliation routines, and to investigate open commitment balances. The user search term denom_amt_outstanding_invoice references the denominator amount not yet invoiced.

SELECT project_id, task_id, cmt_number, vendor_name,
       denom_amount_delivered, denom_amt_outstanding_invoice
FROM   apps.cst_projfmf_cmt_stub_v
WHERE  project_id = :p_project_id;