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
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 |