The task ID for projects for which cost breakdown planning is disabled or the alternate task ID for projects which have cost breakdown planning enabled
TASK_NUMBER
VARCHAR2
(278)
The task number for projects for which cost breakdown planning is disabled or the alternate task number for projects which have cost breakdown planning enabled
TASK_NAME
VARCHAR2
(263)
The task name for projects for which cost breakdown planning is disabled or the alternate task name for projects which have cost breakdown planning enabled
INDENTED_TASK_NAME
VARCHAR2
(4000)
Alternate Task Name instaed of task name for the CBS enabled projects
START_DATE
DATE
LABOR_COST_MULTIPLIER_NAME
VARCHAR2
(20)
COMPLETION_DATE
DATE
CHARGEABLE_FLAG
VARCHAR2
(1)
WBS_SORT_ORDER
VARCHAR2
(2000)
ALLOW_CROSS_CHARGE_FLAG
VARCHAR2
(1)
Flag to indicate whether cross charge are allowed
PROJECT_RATE_DATE
DATE
Task level default value for project rate date
PROJECT_RATE_TYPE
VARCHAR2
(30)
Task level default value for project rate type
BILLABLE_FLAG
VARCHAR2
(1)
TASK_ORGANIZATION
NUMBER
(15)
PROJFUNC_COST_RATE_TYPE
VARCHAR2
(30)
Task level default value for project functional rate type
PROJFUNC_COST_RATE_DATE
DATE
Task level default value for project functional rate date
WORK_TYPE_ID
NUMBER
(15)
WORK_TYPE_NAME
VARCHAR2
(200)
TP_AMT_TYPE_CODE
VARCHAR2
(200)
TASK_DESCRIPTION
VARCHAR2
(250)
ORG_ID
NUMBER
(15)
CBS_ELEMENT_ID
NUMBER
The unique identifier of the cost breakdown structure element
COST_CODE
VARCHAR2
(250)
The unique cost code generated for the cost attribute
COST_CODE_NAME
VARCHAR2
(240)
The cost code name
ACTUAL_TASK_ID
NUMBER
(15)
The system generated unique task identifier
TOP_TASK_ID
NUMBER
(15)
The identifier of the top task. If this is a top task, this value is the task ID
TASK_MANAGER_PERSON_ID
NUMBER
(9)
The identifier of the employee who manages the task
Query Text
Cut, paste (and edit) the following text to query this object: