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), PA Project Billing Status, GL Account Distribution Analysis, PA Cost Audit, 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