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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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 PN Billing/Payment Upload PA Expenditure Types XXICON PO Requisition Upload CAC PO Price vs. Costing Method Comparison ONT Order Discount Detail ECC Procurement, Purchase Orders CAC WIP Account Value
Blitz Report™

Blitz Report™ provides multiple benefits: