Search Results pa_project_assets_v




Overview
Explore in AI Chat

Overview

PA_PROJECT_ASSETS_V is an APPS-owned database view within the Oracle Projects (PA) module. Per the ETRM metadata, its documented description is "10SC Only," indicating that the object is intended for a restricted, internal, or specific localization/implementation scope rather than general customer-facing use. The view presents project asset information maintained by Oracle Projects, exposing attributes used to track capitalizable project costs that flow into Oracle Assets (FA). It consolidates the master project asset record with its associated asset lines and, where applicable, multiple reporting currency (MRC) balances.

Functionally, the view serves reporting and integration purposes: it surfaces the asset identity, capitalized and estimated cost amounts, depreciation and amortization flags, asset category and key accounting information, and descriptive fields such as manufacturer, model, tag, and serial numbers. Because it aggregates current asset cost across the base asset lines, it is well suited to summarizing the total cost associated with a project asset or capitalized CIP (Construction-in-Process) group.

Underlying Base Objects

The ETRM documented base objects for this view are HR_GENERAL (package), HR_PERSON_NAME (package), HR_SECURITY (package), PA_MC_CURRENCY_PKG (package), PA_MC_PRJ_AST_LINES_ALL (synonym), PA_PROJECT_ASSETS (synonym), PA_PROJECT_ASSET_LINES_BAS (synonym), and PER_PEOPLE_F (view). The driving table is PA_PROJECT_ASSETS (aliased PPA), which supplies the master asset attributes. PA_PROJECT_ASSET_LINES_BAS (PAL) is outer-joined on PROJECT_ASSET_ID to provide the base asset line costs. PA_MC_PRJ_AST_LINES_ALL (MC) is outer-joined and its SET_OF_BOOKS_ID is compared to PA_MC_CURRENCY_PKG.SET_OF_BOOKS, with a DECODE on PA_MC_CURRENCY_PKG.GET_MRC_SOB_TYPE_CODE controlling whether the MRC line is matched for reporting set-of-books scenarios.

PER_PEOPLE_F is outer-joined on PERSON_ID = PPA.ASSIGNED_TO_PERSON_ID to return the assignee's name and identifier. The HR packages (HR_GENERAL, HR_PERSON_NAME, HR_SECURITY) support person-name resolution and row-level security within that join. PA_MC_CURRENCY_PKG drives the currency set-of-books logic used in the MRC join condition.

Key Columns

Common Use Cases and Queries

Typical uses include reconciling project asset costs against Oracle Assets, reporting capitalized versus CIP amounts by project or category, and auditing asset assignments. A representative query follows:

SELECT project_asset_id, asset_number, asset_name, project_id, capitalized_flag, capitalized_cost, total_asset_cost, book_type_code FROM pa_project_assets_v WHERE project_id = :p_project_id ORDER BY asset_number;

To analyze capitalization status by category, filter on CAPITALIZED_FLAG and aggregate TOTAL_ASSET_COST. To identify assets pending in-service dating, select records where DATE_PLACED_IN_SERVICE is null and ESTIMATED_IN_SERVICE_DATE is populated. Because the view is documented as "10SC Only," deployments should confirm supported usage before relying on it in custom integrations.