[Home] [Help]
VIEW: APPS.PA_TOP_TASK_FC_RESULTS_V
Source
View Text - Preformatted
SELECT project_id , top_task_id, budget_version_id, start_date, end_date, sum(budget), sum(actuals), sum(encumbrances) from pa_project_bal_v group by budget_version_id, project_id, top_task_id, start_date, end_date
View Text - HTML Formatted
SELECT PROJECT_ID
, TOP_TASK_ID
, BUDGET_VERSION_ID
, START_DATE
, END_DATE
, SUM(BUDGET)
, SUM(ACTUALS)
, SUM(ENCUMBRANCES)
FROM PA_PROJECT_BAL_V GROUP BY BUDGET_VERSION_ID
, PROJECT_ID
, TOP_TASK_ID
, START_DATE
, END_DATE