Results for “quantity_ptd_base”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_TODATE_BASE_ORIG_BUDGET_V is a Projects (PA) module view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. As documented in ETRM, the view "displays the current, baselined budget lines by PA period." It is a budgeting and reporting construct rather than a transactional entity, and it exposes project budget data at the intersection of three qualifiers: the budget type, the budget version lifecycle status (current versus original), and period-to-date spread amounts.

The view is central to any reporting requirement that must distinguish between the currently baselined budget and the original baselined budget for a project, task, and resource combination. Because it surfaces both the "as-currently-baselined" and the "as-originally-baselined" figures side by side in a single row, it is well suited to baseline-versus-current variance analysis, budget change tracking, and integration extracts where a stable, denormalized budget snapshot is required. The user search term "current_original_flag" maps directly to this design: the view carries CURRENT_FLAG and CURRENT_ORIGINAL_FLAG as its core discriminator columns, allowing downstream consumers to select which baseline perspective populates each measure.

Underlying Base Objects

The documented base objects referenced by the view are PA_BUDGET_LINES, PA_BUDGET_VERSIONS, PA_RESOURCE_ASSIGNMENTS, PA_RESOURCE_LIST_MEMBERS, and the PA_ACCUM_UTILS package; all table references are accessed through APPS synonyms. PA_BUDGET_VERSIONS supplies the version-level context, including the CURRENT_FLAG and CURRENT_ORIGINAL_FLAG attributes that govern the DECODE logic throughout the SELECT list. PA_BUDGET_LINES provides the actual budgeted cost, burdened cost, revenue, and quantity amounts, along with the START_DATE and END_DATE used for period spreading. PA_RESOURCE_ASSIGNMENTS contributes task-level attributes such as TASK_ID and TRACK_AS_LABOR_FLAG. PA_RESOURCE_LIST_MEMBERS joins the resource list membership to resolve ALIAS, RESOURCE_LIST_ID, and RESOURCE_ID. The PA_ACCUM_UTILS package supplies GET_SPREAD_AMOUNT_VAL, which converts a whole budget line amount into a period-to-date value bounded by the line's start and end dates.

Key Columns

• PROJECT_ID, TASK_ID, BUDGET_TYPE_CODE — the primary business keys identifying the project, task, and budget type for each row.
• RESOURCE_LIST_MEMBER_ID, ALIAS, RESOURCE_LIST_ID, RESOURCE_ID — the resource identity and its list membership context.
• RESOURCE_ACCUMULATED_FLAG — indicates whether the resource is accumulated for budget purposes.
• CURRENT_FLAG and CURRENT_ORIGINAL_FLAG — the two discriminator flags. CURRENT_FLAG gates the BASE_* measures; CURRENT_ORIGINAL_FLAG gates the ORIG_* measures.
• BASE_RAW_COST, BASE_BURDENED_COST, BASE_REVENUE, BASE_QUANTITY, BASE_LABOR_QUANTITY — the current baselined amounts, returned as zero when the row does not satisfy CURRENT_FLAG = 'Y'.
• ORIG_RAW_COST, ORIG_BURDENED_COST, ORIG_REVENUE, ORIG_QUANTITY, ORIG_LABOR_QUANTITY — the original baselined amounts, returned as zero unless CURRENT_ORIGINAL_FLAG = 'Y'.
• RAW_COST_PTD_BASE, BURDENED_COST_PTD_BASE, REVENUE_PTD_BASE, QUANTITY_PTD_BASE, LABOR_QUANTITY_PTD_BASE — period-to-date spread values derived through PA_ACCUM_UTILS.GET_SPREAD_AMOUNT_VAL over the line's start and end dates.

Labor quantity measures are further conditioned on TRACK_AS_LABOR_FLAG, returning NULL when the assignment is not tracked as labor.

Common Use Cases and Queries

The view is typically used for baseline-versus-current budget reporting, budget revision auditing, and period-by-period budget spread extracts. A representative query filtering to original baseline cost is:

SELECT project_id, task_id, budget_type_code,
       resource_id, alias,
       orig_raw_cost, orig_burdened_cost,
       orig_revenue, orig_quantity
FROM   apps.pa_todate_base_orig_budget_v
WHERE  orig_raw_cost <> 0
AND    budget_type_code = 'COST';

To compare current and original baselines for the same resource row, query both measure sets in a single pass and compute the delta in the reporting layer. To obtain period-to-date spread figures, select the *_PTD_BASE columns; these are populated only where CURRENT_FLAG = 'Y' and therefore reflect the currently baselined view of the period. Because the ORIG_* and BASE_* columns are zeroed rather than NULL when the corresponding flag is not satisfied, aggregation queries can sum the columns without additional NULL handling, but consumers should be aware that a zero value may signify either a genuine zero amount or a flag-driven suppression.