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 PN Billing/Payment Upload PA Expenditure Types ECC Procurement, Purchase Orders PON Solicitation data template COPY OF: PO Requisition Upload ECC Procurement, Requisitions ONT Order Discount Detail
Blitz Report™

Blitz Report™ provides multiple benefits: