[Home] [Help]
View: PJM_PROJECT_PROJ_LS_WEEKLY_V
Product: | PJM - Project Manufacturing |
Description: | Project related line schedule weekly summary for the Web Inquiry. |
Implementation/DBA Data: |
APPS.PJM_PROJECT_PROJ_LS_WEEKLY_V
|
View Text
SELECT LINE_CODE
, LINE_ID
, PROJECT_ID
, ITEM_NUMBER
, END_ITEM_UNIT_NUMBER
, PRIMARY_ITEM_ID
, TRUNC(SCHEDULED_START_DATE
, 'D')+1
, 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
, ITEM_NUMBER
, TRUNC(SCHEDULED_START_DATE
, 'D')
, LINE_ID
, PROJECT_ID
, END_ITEM_UNIT_NUMBER
, PRIMARY_ITEM_ID
Columns
Name |
LINE_CODE |
LINE_ID |
PROJECT_ID |
ITEM_NUMBER |
END_ITEM_UNIT_NUMBER |
PRIMARY_ITEM_ID |
SCHEDULED_DATE |
PLANNED_QUANTITY |
QUANTITY_COMPLETED |
VARIANCE_QUANTITY |