Search Results gms_commitment_txns_v




Overview
Explore in AI Chat

Overview

GMS_COMMITMENT_TXNS_V is a Grants Accounting (GMS) reporting view owned by the APPS schema. The view consolidates outstanding project-related commitment costs, giving grant administrators and project accountants a single, denormalized source for encumbrance and obligation data tied to sponsored projects. Because commitments represent purchase requisitions, purchase orders, and other pre-invoice obligations, the view is central to funds-availability analysis, award budget monitoring, and period-end commitment reporting.

The view is defined as a UNION ALL of two underlying sources: the primary commitment transaction stream and the override stream exposed through GMS_COMMITMENTS_OVERRIDE_V. This union lets the view surface both standard commitment records and manually overridden commitment values without the caller needing to reconcile them separately. Columns are largely sourced from Oracle Purchasing and Projects commitment tables, with currency amounts wrapped by PA_CURRENCY.ROUND_CURRENCY_AMT to enforce project accounting round-off conventions.

Underlying Base Objects

The documented metadata lists a broad set of referenced objects rather than a single base table, reflecting the computed nature of the view. Key dependencies include:

Because these are packages, synonyms, and views rather than a single physical table, the view is effectively a computed reporting layer over the Projects commitment engine.

Key Columns

Common Use Cases and Queries

Typical scenarios include outstanding commitment reporting by project/award, funds-availability checks before new requisitions, and reconciliation of ordered versus invoiced quantities. A query keyed on CMT_HEADER_ID — the term searched — is common when tracing a specific commitment document.

SELECT cmt_header_id, cmt_number, project_id, task_id,
       expenditure_type, acct_raw_cost, acct_burdened_cost,
       quantity_ordered, quantity_invoiced
FROM   apps.gms_commitment_txns_v
WHERE  cmt_header_id = :p_cmt_header_id;

SELECT project_id, task_id, expenditure_type,
       SUM(acct_burdened_cost) outstanding_cost
FROM   apps.gms_commitment_txns_v
WHERE  cmt_approved_flag = 'Y'
GROUP  BY project_id, task_id, expenditure_type;

Because security and profile checks are embedded via HR_SECURITY and FND_PROFILE, results are naturally filtered according to the operating unit and security context of the querying user.