PA Inactive Capital Projects

Description
Categories: BI Publisher, Financials
Application: Projects
Source: MGT: Inactive Capital Projects Report (XML)
Short Name: PACINTAR_XML
DB package: PA_PACINTAR_XMLP_PKG
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
Number of Inactive Periods
 
Number
To Project Number
 
LOV Oracle
From Project Number
 
LOV Oracle