PA Revenue, Cost, Budgets by Resources

Description

Categories
Enginatics, R12 only
Application
Projects
Source
MGT: Task - Revenue, Cost, Budgets by Resources (XML)
Short Name
PAXMGTSD_XML
DB package
PA_PAXMGTSD_XMLP_PKG
Repository
GitHub
This Blitz Report is the implements the following standard oracle reports.

- MGT: Task - Revenue, Cost, Budgets by Resources
- MGT: Revenue, Cost, Budgets by Resources (Project Level)

The 'Report Level' parameter determines if the report is run at the Project Level or Task Level

Report Level Parameter:
Project - equivalent to running the MGT: Revenue, Cost, Budgets by Resources (Project Level) report
Task - equivalent to running the MGT: Task - Revenue, Cost, Budgets by Resources report

The report has been extended to pull in additional datapoints as displayed in the Project Status Inquiry Form.

SQL 435 lines

Parameters 10

ParameterTypeList of values SQL
Operating UnitLOV
haouv.name=:operating_unit
Project OrganizationLOV Oracle
p.carrying_out_organization_id = :org
Project ManagerLOV Oracle
pi.manager_person_id = :mgr
Project NumberLOV
p.project_id=:proj
Project NameLOV
pi.project_id=:proj_name_id
Task NumberLOV
exists (select null from pa_tasks pt where pt.project_id = p.project_id and pt.task_number = :task_number)
Report LevelLOV
Cost Budget TypeLOV Oracle
Revenue Budget TypeLOV Oracle
Period NameLOV Oracle