Product: | PA - Projects |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PA_TASK_DET_SCH_OPT_V |
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