Search Results pa_project_asset_lines_bas




Overview
Explore in AI Chat

Overview

APPS.PA_PROJECT_ASSETS_V is a reporting view in Oracle E-Business Suite that consolidates project asset information from Projects (PA) and interfaces it with Oracle Assets (FA). It presents one row per project asset, enriched with cost data drawn from both the baseline project asset lines and the Multiple Reporting Currencies (MRC) asset lines. The view is a core component of the Project Asset capitalization and capitalization-to-assets lifecycle, exposing the descriptive, financial, and audit attributes required to transfer capitalized project costs into the fixed asset register.

Because it joins the primary asset table to its associated asset lines and aggregates line-level costs, the view provides a rolled-up asset cost figure (TOTAL_ASSET_COST) that is central to capitalized cost reconciliation. It is widely used in Oracle Projects and Oracle Assets integrations, reporting, and reconciliation of Capitalized Interest and Capital Projects (CIP) to the final asset record.

Underlying Base Objects

The view is defined over four principal data sources, documented in the ETRM 12.2.2 metadata:

  • PA_PROJECT_ASSETS (synonym to PA.PA_PROJECT_ASSETS) — the driving table holding the asset master record, aliased PPA.
  • PA_PROJECT_ASSET_LINES_BAS (synonym) — the baseline project asset lines that carry the current asset cost at the line level, aliased PAL.
  • PA_MC_PRJ_AST_LINES_ALL (synonym) — MRC asset lines used to supply reporting currency cost values, aliased MC.
  • PER_PEOPLE_F (view) — the effective-dated person record supplying the assignee name and employee/party number.

The view also references several PL/SQL packages: HR_GENERAL, HR_PERSON_NAME, HR_SECURITY, and PA_MC_CURRENCY_PKG. The latter is used in the join predicate to resolve the reporting set of books and MRC sob type. The outer joins ((+)) indicate that an asset row is retained even when no matching line, MRC row, or person record exists.

Key Columns

Common Use Cases and Queries

Typical scenarios include reconciling project costs against the fixed asset register, verifying capitalization timing, and listing assets awaiting transfer to Oracle Assets.

  • Reconcile capitalized project cost to the FA asset.
  • Identify assets where CAPITALIZED_FLAG is not yet set.
  • Extract asset details for external reporting or integration.
SELECT asset_number, asset_name, capitalized_flag,
       capitalized_date, total_asset_cost, fa_asset_id
FROM   apps.pa_project_assets_v
WHERE  org_id = :p_org_id
AND    NVL(capitalized_flag,'N') = 'N';

The view should be queried with the standard MO security context applied, since ORG_ID filtering is essential in multi-org deployments.