eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PJM_PROJECT_PROJ_LS_DETAIL_V

Product:	PJM - Project Manufacturing
Description:	Project-related line schedule detail information for the Web Inquiry
Implementation/DBA Data:	APPS.PJM_PROJECT_PROJ_LS_DETAIL_V

View Text

SELECT LINE_CODE
, LINE_ID
, PJM_PROJECT.ALL_PROJ_IDTONUM(PROJECT_ID)
, PJM_PROJECT.ALL_PROJ_IDTONAME(PROJECT_ID)
, PROJECT_ID
, PJM_PROJECT.ALL_TASK_IDTONUM(TASK_ID)
, PJM_PROJECT.ALL_TASK_IDTONAME(TASK_ID)
, TASK_ID
, SCHEDULE_TYPE_TEXT
, SCHEDULE_NUMBER
, ITEM_NUMBER
, END_ITEM_UNIT_NUMBER
, PRIMARY_ITEM_ID
, SCHEDULED_START_DATE
, SCHEDULED_COMPLETION_DATE
, NVL(PLANNED_QUANTITY
, 0)
, NVL(QUANTITY_COMPLETED
, 0)
, NVL(PLANNED_QUANTITY
, 0) - NVL(QUANTITY_COMPLETED
, 0)
FROM PJM_LINE_SCHEDULES_V ORDER BY LINE_CODE
, ITEM_NUMBER
, SCHEDULED_START_DATE

Columns

Name
LINE_CODE
LINE_ID
PROJECT_NUMBER
PROJECT_NAME
PROJECT_ID
TASK_NUMBER
TASK_NAME
TASK_ID
SOURCE
SCHEDULE_NUMBER
ITEM_NUMBER
END_ITEM_UNIT_NUMBER
PRIMARY_ITEM_ID
SCHEDULED_START_DATE
SCHEDULED_COMPLETION_DATE
PLANNED_QUANTITY
QUANTITY_COMPLETED
VARIANCE_QUANTITY