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

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_TASK_DET_SCH_OPT_V

View Text

SELECT SCH.PROJECT_ID
, SCH.PROJ_ELEMENT_ID
, SCH.ELEMENT_VERSION_ID
, SCH.DEF_SCH_TOOL_TSK_TYPE_CODE
, PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('PA_SCHEDULE_TASK_TYPE'
, SCH.DEF_SCH_TOOL_TSK_TYPE_CODE)
, SCH.CONSTRAINT_TYPE_CODE
, PA_PROJ_ELEMENTS_UTILS.GET_FND_LOOKUP_MEANING('PA_SCHEDULE_CONSTRAINT_TYPE'
, SCH.CONSTRAINT_TYPE_CODE)
, SCH.CONSTRAINT_DATE
, SCH.FREE_SLACK
, SCH.TOTAL_SLACK
, SCH.EFFORT_DRIVEN_FLAG
, SCH.LEVEL_ASSIGNMENTS_FLAG
, SCH.RECORD_VERSION_NUMBER
, SCH.EXT_ACT_DURATION
, SCH.EXT_REMAIN_DURATION
, SCH.EXT_SCH_DURATION
FROM PA_PROJ_ELEM_VER_SCHEDULE SCH

Columns

Name
PROJECT_ID
PROJ_ELEMENT_ID
ELEMENT_VERSION_ID
DEF_SCH_TOOL_TSK_TYPE_CODE
DEF_SCH_TOOL_TSK_TYPE_M
CONSTRAINT_TYPE_CODE
CONSTRAINT_TYPE_M
CONSTRAINT_DATE
FREE_SLACK
TOTAL_SLACK
EFFORT_DRIVEN_FLAG
LEVEL_ASSIGNMENTS_FLAG
PEVS_RECORD_VERSION_NUMBER
ACTUAL_DURATION
REMAINING_DURATION
SCHEDULED_DURATION