Search Results reverse_flag




Overview
Explore in AI Chat

Overview

PA_PROJECT_ASSETS_AMG_V is a single-organization (Single-Org) view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the PA (Projects) product family. It exposes project asset records maintained in Oracle Projects, including the capitalized cost, depreciation, amortization, and reversal attributes required to reconcile project costs to Oracle Assets. The "_AMG_V" suffix identifies it as an AutoMedia/AMG-style reporting view used for multi-organization-aware reporting scenarios where the caller must supply or be restricted to a specific ORG_ID.

The view surfaces the project asset lifecycle end to end: estimated in-service dates and costs, capitalization flags and dates, capitalized cost, grouped CIP cost, reversal indicators (REVERSE_FLAG, REVERSAL_DATE), and the FA_ASSET_ID link to the corresponding Oracle Assets asset. Because it is a pass-through projection of PA_PROJECT_ASSETS with no filtering predicates, it behaves as a secured, reporting-friendly layer over the base table for extracts, interfaces, and reconciliation queries.

Underlying Base Objects

Per the documented ETRM metadata (12.2.2), the view is defined over a single referenced base object: PA_PROJECT_ASSETS (accessible through its SYNONYM in the APPS schema). The view text selects a fixed column list directly from PA_PROJECT_ASSETS with no joins, unions, or WHERE clause—column names are identical to the base table's columns. Consequently, all behavioral characteristics (organization partitioning via ORG_ID, transactional updates, descriptive flexfield columns ATTRIBUTE_CATEGORY and ATTRIBUTE1–15, and the WHO columns) are inherited unchanged. Any insert, update, or delete must target PA_PROJECT_ASSETS itself; the view is read-only in practice.

Key Columns

Common Use Cases and Queries

Typical uses include reconciling capitalized project costs to Oracle Assets, reporting CIP and grouping status, and auditing capitalization reversals. The following query lists assets whose capitalization was reversed for a given operating unit and accounting period:

SELECT pa.project_asset_id, pa.project_id, pa.asset_number, pa.asset_name, pa.capitalized_flag, pa.reverse_flag, pa.reversal_date, pa.fa_asset_id
FROM apps.pa_project_assets_amg_v pa
WHERE pa.org_id = :p_org_id
AND pa.reverse_flag = 'Y'
AND pa.fa_period_name = :p_period_name
ORDER BY pa.project_id, pa.asset_number;

A second common pattern extracts capitalized assets ready for transfer or analysis, including category and cost data:

SELECT a.project_id, a.asset_number, a.asset_category_id, a.book_type_code, a.capitalized_cost, a.capitalized_date, a.fa_asset_id
FROM apps.pa_project_assets_amg_v a
WHERE a.org_id = :p_org_id
AND a.capitalized_flag = 'Y'
AND a.reverse_flag = 'N';

Because the view is unfiltered, always constrain queries by ORG_ID and, where possible, by PROJECT_ID or FA_PERIOD_NAME to preserve performance on PA_PROJECT_ASSETS.