Search Results total_asset_cost

Overview

PA_PROJECT_ASSETS_MRC_V is a reporting view in the Oracle E-Business Suite Projects (PA) module that exposes project asset information across multiple reporting currencies. The "MRC" suffix designates it as a Multiple Reporting Currencies view, a construct used in EBS to present the same underlying transaction data in both the primary functional currency and one or more reporting currencies. The view consolidates asset header attributes from PA_PROJECT_ASSETS with cost lines drawn from the project asset lines infrastructure and the multiple reporting currencies asset lines table.

Per the supplied ETRM metadata, the object carries the description "10SC Only," indicating it is relevant exclusively to the 10SC (ten-set-of-books) configuration context and is not implemented in a standard single-book database. The view text therefore serves primarily as a reference definition rather than an active database object in most environments.

Underlying Base Objects

The view is defined over four base objects in an outer-join and aggregation pattern:

• PA_PROJECT_ASSETS (PPA) — the primary driving table, supplying asset header attributes such as asset number, asset name, assigned person, book type, and capitalization details.
• PA_PROJECT_ASSET_LINES_BAS (PAL) — the base asset lines table, joined by PROJECT_ASSET_ID and contributing the primary-currency asset cost.
• PA_MC_PRJ_AST_LINES_ALL (MC) — the multiple reporting currencies asset lines table, joined by PROJECT_ASSET_LINE_ID and contributing the reporting-currency asset cost along with SET_OF_BOOKS_ID.
• PER_PEOPLE_F (PER) — the effective-dated person table, outer-joined by PERSON_ID and constrained by the current system date, supplying the full name and employee or NPW number of the assignee.

Cost amounts are aggregated using SUM over CURRENT_ASSET_COST from both the base and reporting-currency line tables. Although the ETRM metadata documents no referenced base objects explicitly for 12.2.2, the view text clearly identifies these four sources.

Key Columns

The most significant column for the user's search term is TOTAL_ASSET_COST, defined as SUM(NVL(PAL.CURRENT_ASSET_COST, 0)). It represents the aggregate capitalized asset cost for the project asset in the primary functional currency. Its reporting-currency counterpart is REP_TOTAL_ASSET_COST, defined as SUM(NVL(MC.CURRENT_ASSET_COST, 0)).

Other notable columns include PROJECT_ASSET_ID and PROJECT_ID (join keys), ASSET_NUMBER, ASSET_NAME, and ASSET_DESCRIPTION (identification attributes), BOOK_TYPE_CODE and ASSET_CATEGORY_ID (Asset Management references), CAPITALIZED_FLAG, CAPITALIZED_DATE, and CAPITALIZED_COST (capitalization status), plus DATE_PLACED_IN_SERVICE and ESTIMATED_IN_SERVICE_DATE. The view also exposes FA_ASSET_ID, LOCATION_ID, DEPRECIATE_FLAG, AMORTIZE_FLAG, and the full set of DFF attribute columns, along with SET_OF_BOOKS_ID and ORG_ID for multi-org and multi-book filtering.

Common Use Cases and Queries

The view is used to reconcile capitalization activity between Projects and the multiple reporting currency books, to report asset cost by book, and to drive asset transfer logic. A representative query filtering by asset number follows:

• SELECT project_asset_id, asset_number, total_asset_cost, rep_total_asset_cost, set_of_books_id FROM pa_project_assets_mrc_v WHERE asset_number = :p_asset_number;
• SELECT project_id, SUM(total_asset_cost), SUM(rep_total_asset_cost) FROM pa_project_assets_mrc_v GROUP BY project_id;
• SELECT asset_number, capitalized_cost, capitalized_flag, date_placed_in_service FROM pa_project_assets_mrc_v WHERE org_id = :p_org_id AND book_type_code = :p_book;

Because the object is documented as 10SC only and not implemented in standard databases, developers should validate its presence and grants before relying on it in report definitions or integrations.