[Home] [Help]
SELECT task_number , indented_task_name , start_date , completion_date , decode(chargeable_flag,'Y','*',null) chargeable , task_id , 2 "enabled_task_level", project_id, wbs_sort_order from pa_tasks_expend_v
SELECT TASK_NUMBER
, INDENTED_TASK_NAME
, START_DATE
, COMPLETION_DATE
, DECODE(CHARGEABLE_FLAG
, 'Y'
, '*'
, NULL) CHARGEABLE
, TASK_ID
, 2 "ENABLED_TASK_LEVEL"
, PROJECT_ID
, WBS_SORT_ORDER
FROM PA_TASKS_EXPEND_V
|
|
|
|