PA Inactive Capital Projects
Description
- Categories
- BI Publisher
- Application
- Projects
- Source
- MGT: Inactive Capital Projects Report (XML)
- Short Name
- PACINTAR_XML
- DB package
- PA_PACINTAR_XMLP_PKG
SQL 12 lines
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 |
Parameters 3
| Parameter | Type | List of values SQL |
|---|---|---|
| From Project Number | LOV Oracle | |
| To Project Number | LOV Oracle | |
| Number of Inactive Periods | Number |