| layout | default |
|---|---|
| title | PA Project Expenditure Items with WIP and INV Detail | Oracle EBS SQL Report |
| description | Project expenditure items showing WIP and inventory transaction details including transaction types, quantities, WIP job, assembly, department, resource… |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, Project, Expenditure, Items, WIP, pa_project_statuses, pa_system_linkages, pa_transaction_sources |
| permalink | /PA%20Project%20Expenditure%20Items%20with%20WIP%20and%20INV%20Detail/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Project expenditure items showing WIP and inventory transaction details including transaction types, quantities, WIP job, assembly, department, resource, and inventory item information.
Operating Unit, Project, Task, Date From, Date To, Expenditure Type, Expenditure Type Class, Job, Employee
pa_project_statuses, pa_system_linkages, pa_transaction_sources, pa_expenditure_items_all, pa_expenditures_all, pa_expenditure_types, pa_projects_all, pa_tasks, hr_all_organization_units_vl, per_people_x, wip_transactions, wip_entities, wip_discrete_jobs, wip_repetitive_items, mtl_system_items_vl, bom_departments, bom_resources, mtl_material_transactions, mtl_transaction_types, mo_glob_org_access_tmp, dual
GL Account Analysis, GL Account Analysis (Distributions), GL Account Distribution Analysis, GL Account Analysis (Drilldown) (with inventory and WIP), PA Cost Audit, GL Account Analysis 11g
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.
| Resource | Link |
|---|---|
| Excel Example Output | PA Project Expenditure Items with WIP and INV Detail 23-Mar-2026 081847.xlsx |
| Blitz Report™ XML Import | PA_Project_Expenditure_Items_with_WIP_and_INV_Detail.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/pa-project-expenditure-items-with-wip-and-inv-detail/ |
- 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