[Home] [Help]
View: PJM_PROJECT_TASK_LS_LINE_SUM_V
View Text
SELECT LINE_CODE
, LINE_ID
, PROJECT_ID
, TASK_ID
, SUM(NVL(PLANNED_QUANTITY
, 0))
, SUM(NVL(QUANTITY_COMPLETED
, 0))
, SUM(NVL(PLANNED_QUANTITY
, 0)) - SUM(NVL(QUANTITY_COMPLETED
, 0))
FROM PJM_LINE_SCHEDULES_V GROUP BY LINE_CODE
, LINE_ID
, PROJECT_ID
, TASK_ID
Columns
Name |
LINE_CODE |
LINE_ID |
PROJECT_ID |
TASK_ID |
PLANNED_QUANTITY |
QUANTITY_COMPLETED |
VARIANCE_QUANTITY |