PA Project Asset Details – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Capital project asset information showing CIP costs, capitalized amounts, FA asset numbers, estimated and actual in-service dates, and asset line transfer status.

Report Parameters

Operating Unit, Project

Oracle EBS Tables Used

pa_project_statuses, fa_additions_b, pa_capital_events, pa_project_assets_all, pa_projects_all, pa_project_asset_lines_all, hr_all_organization_units_vl, mo_glob_org_access_tmp, dual

Report Categories

Enginatics

Related Reports

PA Project Upload, CAC Receiving Expense Value (Period-End), CAC Receiving Value (Period-End), GL Account Distribution Analysis, GL Account Analysis

Running This SQL Without Blitz Report

Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.

Download & Import Options

Resource	Link
Excel Example Output	PA Project Asset Details 07-Apr-2018 145706.xlsx
Blitz Report™ XML Import	PA_Project_Asset_Details.xml
Full SQL on Enginatics	www.enginatics.com/reports/pa-project-asset-details/

---

Useful Links

• Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
• Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
• Oracle EBS Reporting Toolkits by Blitz Report™
• Blitz Report™ FAQ & Community Q&A
• Supply Chain Hub by Blitz Report™
• Blitz Report™ Customer Case Studies
• Oracle EBS Reporting Blog
• Oracle EBS Reporting Resource Centre

© 2026 Enginatics