[Home] [Help]
| Product: | PA - Projects |
|---|---|
| Description: | R10SC Only - Actual cost and revenue totals for projects and tasks by GL Period and expenditure organization |
| Implementation/DBA Data: | Not implemented in this database |
SELECT AV.PROJECT_ID
, AV.TASK_ID
, AV.GL_PERIOD
, AV.GL_START_DATE
, AV.GL_END_DATE
, ORG.NAME ORGANIZATION_NAME
, AV.EXPENDITURE_ORGANIZATION_ID
, ROUND(SUM(TOTAL_REVENUE)) TOTAL_REVENUE
, ROUND(SUM(TOTAL_RAW_COST)) TOTAL_RAW_COST
, ROUND(SUM(TOTAL_BURDEN_COST)) TOTAL_BURDEN_COST
, ROUND(SUM(TOTAL_QUANTITY)) TOTAL_QUANTITY
, ROUND(SUM(TOTAL_LABOR_HOURS)) TOTAL_LABOR_HOURS
, ROUND(SUM(BILLABLE_RAW_COST)) BILLABLE_RAW_COST
, ROUND(SUM(BILLABLE_BURDEN_COST)) BILLABLE_BURDEN_COST
, ROUND(SUM(BILLABLE_QUANTITY)) BILLABLE_QUANTITY
, ROUND(SUM(BILLABLE_LABOR_HOURS)) BILLABLE_LABOR_HOURS
, ROUND(SUM(BUDGETED_COST)) BUDGETED_COST
, ROUND(SUM(BUDGETED_REVENUE)) BUDGETED_REVENUE
, ROUND(SUM(BUDGETED_LABOR_HOURS)) BUDGETED_LABOR_HOURS
FROM PA_ACCUM_VIEW AV
, HR_ALL_ORGANIZATION_UNITS ORG
WHERE AV.EXPENDITURE_ORGANIZATION_ID = ORG.ORGANIZATION_ID(+) GROUP BY AV.PROJECT_ID
, AV.TASK_ID
, AV.GL_PERIOD
, AV.GL_START_DATE
, AV.GL_END_DATE
, ORG.NAME
, AV.EXPENDITURE_ORGANIZATION_ID