PA Inactive Capital Projects

➜ Back to Library
Description
Categories: BI Publisher
Application: Projects
Source: MGT: Inactive Capital Projects Report (XML)
Short Name: PACINTAR_XML
DB package: PA_PACINTAR_XMLP_PKG
Run PA Inactive Capital Projects and other Oracle EBS reports with Blitz Report™ on our demo environment
select pev.project_id,pev.project_number,pev.project_name,
max(pev.expenditure_item_date) last_activity_date,
add_months(max(pev.expenditure_item_date),:p_periods) suspension_date
from pa_expend_items_adjust2_v  pev
where pev.project_number  between NVL(:p_from_proj_num,pev.project_number)
 and NVL(:p_to_proj_num,pev.project_number)
and pev.project_type_class_code = 'CAPITAL'
and nvl(pev.transaction_source,'X') <> 'Capitalized Interest'
group by pev.project_id,
pev.project_number,pev.project_name
having months_between(sysdate,max(pev.expenditure_item_date)) > :p_periods
Parameter Name SQL text Validation
From Project Number 
 
 LOV Oracle
To Project Number 
 
 LOV Oracle
Number of Inactive Periods 
 
 Number
Download
 
Related Blitz Reports
PO Endeca Template PA Project Expenditure Adjustment Activity PA Expenditure Types ONT Order Discount Detail PA Project Subledger: Detail by Expenditure Type PA Project Subledger Summary PA Project Subledger: Detail by Project ECC Projects, Projects Costing: Transactions, SQL1 ECC Procurement, Requisitions
Blitz Report™

Blitz Report™ provides multiple benefits: