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
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
|
|
|