DBA Data[Home] [Help]

VIEW: APPS.PA_TASKS_AP_V

Source

View Text - Preformatted

SELECT PAT.TASK_ID TASK_ID , PAT.PROJECT_ID PROJECT_ID , PAT.TASK_NUMBER TASK , LPAD ( ' ', ( NVL ( WBS_LEVEL,1 ) -1 ) * 3, ' ') ||PAT.TASK_NAME DESCRIPTION FROM PA_TASKS PAT
View Text - HTML Formatted

SELECT PAT.TASK_ID TASK_ID
, PAT.PROJECT_ID PROJECT_ID
, PAT.TASK_NUMBER TASK
, LPAD ( ' '
, ( NVL ( WBS_LEVEL
, 1 ) -1 ) * 3
, ' ') ||PAT.TASK_NAME DESCRIPTION
FROM PA_TASKS PAT