View: PJM_PROJECT_TASK_LS_DAILY_V

Product:	PJM - Project Manufacturing
Description:	Task-related line schedule daily summary information for the Web Inquiry.
Implementation/DBA Data:	APPS.PJM_PROJECT_TASK_LS_DAILY_V

View Text

SELECT LINE_CODE
, LINE_ID
, PROJECT_ID
, TASK_ID
, ITEM_NUMBER
, END_ITEM_UNIT_NUMBER
, PRIMARY_ITEM_ID
, TRUNC(SCHEDULED_START_DATE)
, 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
WHERE PROJECT_ID IS NOT NULL GROUP BY LINE_CODE
, LINE_ID
, PROJECT_ID
, TASK_ID
, ITEM_NUMBER
, END_ITEM_UNIT_NUMBER
, PRIMARY_ITEM_ID
, TRUNC(SCHEDULED_START_DATE) ORDER BY LINE_CODE
, ITEM_NUMBER
, TRUNC(SCHEDULED_START_DATE)

Columns