Search Results cmt_quantity




Overview
Explore in AI Chat

Overview

PA_CMT_BY_PA_PERIOD_V is an APPS-owned database view in the Oracle E-Business Suite Projects (PA) module. It presents current commitment totals at the lowest level of task and resource detail, summarized by Oracle Projects (PA) accounting period. In ETRM 12.1.1 and 12.2.2 the object is documented with a VALID status and is defined over the transaction accumulation and resource accumulation structures that underpin commitment reporting.

The view serves reporting and integration scenarios where commitment quantity and cost must be grouped by PA period rather than by raw transaction or expenditure batch. Because it aggregates at the resource list member level, it is suited to commitment reporting, project cost forecasting, and downstream extracts that require periodized commitment balances. The term cmt_quantity relates to the CMT_QUANTITY column exposed by this view, which carries the summed commitment quantity for the lowest-level task and resource combination.

Underlying Base Objects

The documented definition references three base objects through APPS synonyms:

The view joins RAD.TXN_ACCUM_ID to TA.TXN_ACCUM_ID and TA.PA_PERIOD to PER.PERIOD_NAME, then groups by project, task, resource list member, resource list, PA period, period dates, and operating unit. This relationship means the view reflects accumulated commitment state rather than individual commitment transactions.

Key Columns

  • PROJECT_ID / TASK_ID — identify the project and lowest-level task for the commitment totals.
  • RESOURCE_LIST_MEMBER_ID / RESOURCE_LIST_ID — identify the specific resource and its resource list.
  • PA_PERIOD_NAME — the PA period name used for grouping and period comparison.
  • PERIOD_START_DATE / PERIOD_END_DATE — the calendar bounds of the reporting period.
  • CMT_QUANTITY — the summed commitment quantity (from TOT_CMT_QUANTITY, with nulls defaulted to zero). This is the column most commonly associated with the cmt_quantity search term.
  • CMT_RAW_COST — the summed raw commitment cost.
  • CMT_BURDENED_COST — the summed burdened commitment cost.
  • ORG_ID — the operating unit associated with the PA period, supporting multi-org filtering.

Common Use Cases and Queries

Typical uses include period-by-period commitment reporting, reconciliation of commitment totals against expenditure, and forecasting interfaces that consume periodized commitment quantities and costs.

Query commitment quantity for a specific project by period:

  • SELECT project_id, task_id, pa_period_name, CMT_QUANTITY, CMT_RAW_COST, CMT_BURDENED_COST FROM pa_cmt_by_pa_period_v WHERE project_id = :p_project_id AND org_id = :p_org_id ORDER BY pa_period_name;

Aggregate commitment quantity across all resources for a task:

  • SELECT task_id, pa_period_name, SUM(CMT_QUANTITY) cmt_qty, SUM(CMT_BURDENED_COST) cmt_bc FROM pa_cmt_by_pa_period_v WHERE project_id = :p_project_id GROUP BY task_id, pa_period_name;

Because the view relies on accumulated commitment data, results reflect the current commitment totals loaded into PA_TXN_ACCUM and should be validated against the Projects commitment processes in use.

  • View: PA_CMT_BY_PA_PERIOD_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_CMT_BY_PA_PERIOD_V,  object_name:PA_CMT_BY_PA_PERIOD_V,  status:VALID,  product: PA - Projects ,  description: This view displays current commitment totals for lowest level tasks and resources by PA periods. ,  implementation_dba_data: APPS.PA_CMT_BY_PA_PERIOD_V , 

  • View: PA_CMT_BY_GL_PERIOD_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_CMT_BY_GL_PERIOD_V,  object_name:PA_CMT_BY_GL_PERIOD_V,  status:VALID,  product: PA - Projects ,  description: This view displays current commitment totals for lowest level tasks and resources by GL periods. ,  implementation_dba_data: APPS.PA_CMT_BY_GL_PERIOD_V , 

  • View: PA_CMT_BY_GL_PERIOD_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_CMT_BY_GL_PERIOD_V,  object_name:PA_CMT_BY_GL_PERIOD_V,  status:VALID,  product: PA - Projects ,  description: This view displays current commitment totals for lowest level tasks and resources by GL periods. ,  implementation_dba_data: APPS.PA_CMT_BY_GL_PERIOD_V , 

  • View: PA_CMT_BY_PA_PERIOD_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_CMT_BY_PA_PERIOD_V,  object_name:PA_CMT_BY_PA_PERIOD_V,  status:VALID,  product: PA - Projects ,  description: This view displays current commitment totals for lowest level tasks and resources by PA periods. ,  implementation_dba_data: APPS.PA_CMT_BY_PA_PERIOD_V , 

  • View: PA_TXN_ACCUM_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_TXN_ACCUM_V,  object_name:PA_TXN_ACCUM_V,  status:VALID,  product: PA - Projects ,  description: This view displays detail information for a given transaction by various transaction attributes ,  implementation_dba_data: APPS.PA_TXN_ACCUM_V , 

  • Lookup Type: ACCUMULATION_COLUMN 12.2.2

    product: PA - Projects ,  meaning: Accumulation Column ,  description: Accumulation_Column , 

  • View: PA_TXN_ACCUM_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_TXN_ACCUM_V,  object_name:PA_TXN_ACCUM_V,  status:VALID,  product: PA - Projects ,  description: This view displays detail information for a given transaction by various transaction attributes ,  implementation_dba_data: APPS.PA_TXN_ACCUM_V , 

  • Lookup Type: ACCUMULATION_COLUMN 12.1.1

    product: PA - Projects ,  meaning: Accumulation Column ,  description: Accumulation_Column ,