Search Results cdl_burdened_cost

Overview

The view PA_CAP_EVENTS_CDL_COST_V is a Projects (PA) module aggregation view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents capitalized cost information for project capital events by summarizing cost distribution line amounts against expenditure items that have been associated with a capital event. The view consolidates transaction-level cost distribution data into project, capital event, and line type groupings, producing summed cost and burdened cost figures.

The view serves a reporting and integration role for capital event processing within Oracle Projects. Capital events are used to capitalize costs incurred on a project so they can be transferred to fixed assets. Because the raw cost distribution data resides at the individual transaction line level, this view provides the pre-aggregated totals that reporting, reconciliation, and downstream capital event processing logic require. The inclusion of a CDL_AMOUNT column makes the view a primary reference point for users searching on capital event cost amounts and burdened cost totals.

Underlying Base Objects

The view is defined over two documented base objects, both accessed via APPS synonyms:

• PA_COST_DISTRIBUTION_LINES_ALL — the cost distribution lines table, referenced by the alias CDL. It supplies the monetary values (AMOUNT, BURDENED_COST), the PROJECT_ID, LINE_TYPE, and the EXPENDITURE_ITEM_ID foreign key.
• PA_EXPENDITURE_ITEMS_ALL — the expenditure items table, referenced by the alias EI. It supplies CAPITAL_EVENT_ID and is joined to the cost distribution lines on EXPENDITURE_ITEM_ID.

The join is an inner equijoin between the two tables on EI.EXPENDITURE_ITEM_ID = CDL.EXPENDITURE_ITEM_ID, with an additional filter requiring EI.CAPITAL_EVENT_ID IS NOT NULL. This restriction excludes all expenditure items not tied to a capital event, so only capitalized cost activity is reflected. The result set is grouped by CDL.PROJECT_ID, EI.CAPITAL_EVENT_ID, and CDL.LINE_TYPE, with SUM applied to the amount and burdened cost columns.

Key Columns

• PROJECT_ID — Identifier of the project to which the cost distribution lines belong. Part of the grouping key.
• CAPITAL_EVENT_ID — Identifier of the capital event associated with the expenditure items. Part of the grouping key and the principal linkage to capital event processing.
• LINE_TYPE — Classification of the cost distribution line. Part of the grouping key; it distinguishes categories of cost activity being summarized.
• CDL_AMOUNT — The aggregated raw (unburdened) amount, computed as SUM(CDL.AMOUNT). This is the column most commonly referenced when users search on capital event cost amounts.
• CDL_BURDENED_COST — The aggregated burdened cost, computed as SUM(CDL.BURDENED_COST), representing raw cost plus applied burden.

Common Use Cases and Queries

Typical usage includes reconciling capitalized costs for a capital event, validating burdened versus raw cost totals prior to asset capitalization, and feeding summarized cost figures into custom reports or interfaces. A representative query retrieving all summarized capitalized costs for a project is:

• SELECT project_id, capital_event_id, line_type, cdl_amount, cdl_burdened_cost FROM apps.pa_cap_events_cdl_cost_v WHERE project_id = :p_project_id ORDER BY capital_event_id, line_type;

To examine a single capital event and compare raw against burdened amounts:

• SELECT line_type, cdl_amount, cdl_burdened_cost FROM apps.pa_cap_events_cdl_cost_v WHERE capital_event_id = :p_capital_event_id;

To obtain consolidated totals across line types for a capital event:

• SELECT capital_event_id, SUM(cdl_amount) total_amount, SUM(cdl_burdened_cost) total_burdened FROM apps.pa_cap_events_cdl_cost_v GROUP BY capital_event_id;

Because the view performs aggregation, it is well suited for read-only reporting and integration extraction. It should not be used for transactional updates, since it exposes no base-table row identity.