DBA Data[Home] [Help]

VIEW: APPS.PA_RES_FC_RESULTS_V

Source

View Text - Preformatted

SELECT project_id , resource_list_member_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, resource_list_member_id, start_date, end_date
View Text - HTML Formatted

SELECT PROJECT_ID
, RESOURCE_LIST_MEMBER_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
, RESOURCE_LIST_MEMBER_ID
, START_DATE
, END_DATE