Search Results capitalized_date




Overview
Explore in AI Chat

Overview

PABV_ASSETS is an APPS-owned database view in the Oracle E-Business Suite Projects (PA) module. It is documented in ETRM as VALID with the description "- Retrofitted," indicating that the object was carried forward from an earlier release into the 12.1.1 / 12.2.2 code line without functional redesign. The view presents project asset information — capitalized, depreciating, or reversed assets created from capital projects — in a flattened, reporting-friendly shape.

The naming convention follows the PA "BV" view family, where the underlying table columns are augmented with Oracle Application Object Library (AOL) descriptive flexfield and lookup descriptors. These descriptors are exposed as string literals in the SELECT list: for example, '_LA:AMORTIZE_FLAG:FND_LOOKUPS:YES_NO:MEANING' and '_LA:DEPRECIATE_FLAG:FND_LOOKUPS:YES_NO:MEANING'. They instruct the AOL lookup/translate layer to render YES/NO meaning values rather than raw codes, and '_DF:PA:PA_PROJECT_ASSETS:PPA' references the PA_PROJECT_ASSETS descriptive flexfield. The view also carries a row-level security predicate, WHERE '_SEC:ORG_ID' IS NOT NULL, enforcing operating unit access through the standard security grouping. The view is defined WITH READ ONLY, so it is strictly a query surface.

Underlying Base Objects

ETRM documents a single referenced base object: PA_PROJECT_ASSETS_ALL, accessed through a synonym and aliased as PPA in the view text. This is the multi-organization (partitioned by ORG_ID) project asset table, and PABV_ASSETS is essentially a projected, lightly decorated view over it. The view exposes all standard WHO audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY) and ORG_ID directly from that table. Because PA_PROJECT_ASSETS_ALL is an _ALL table, the ORG_ID predicate is the mechanism by which a session sees only the assets belonging to its authorized operating units.

Key Columns

Common Use Cases and Queries

The view is typically used for capital project reporting and reconciliation between Projects and Oracle Assets — for example, listing assets awaiting transfer to a depreciation book, or validating capitalization timing. A representative query retrieving assets with their in-service dates is:

SELECT asset_number,
       asset_name,
       project_id,
       date_placed_in_service,
       capitalized_cost,
       book_type_code
  FROM apps.pabv_assets
 WHERE date_placed_in_service IS NOT NULL
   AND book_type_code = 'CORP'
 ORDER BY date_placed_in_service;

Because ORG_ID security is embedded, the query automatically returns only assets for the session's authorized operating units, eliminating the need for an explicit ORG_ID filter. The view is equally suited to feed downstream extracts or interface staging tables, since it flattens the _ALL table's multi-org structure and resolves lookup meanings without additional joins to FND_LOOKUPS or PA descriptive flexfield views. Owing to its READ ONLY definition and retrofitted status, it should be used for querying and reporting only, never for DML.