VIEW: APPS.PA_TASKS_LOV_V

Source

View Text - Preformatted

SELECT t.task_number , lpad (' ',(nvl(wbs_level,1)-1)*3,' ')||t.task_name task_name , t.task_id , t.project_id FROM pa_tasks t , pa_projects p where p.project_id = t.project_id

View Text - HTML Formatted

SELECT T.TASK_NUMBER
, LPAD (' '
, (NVL(WBS_LEVEL
, 1)-1)*3
, ' ')||T.TASK_NAME TASK_NAME
, T.TASK_ID
, T.PROJECT_ID
FROM PA_TASKS T
, PA_PROJECTS P
WHERE P.PROJECT_ID = T.PROJECT_ID