[Home] [Help]
VIEW: APPS.PA_ALLOC_SRC_TASKS_V
Source
View Text - Preformatted
SELECT project_id ,task_id ,task_number ,task_name ,service_type_code ,carrying_out_organization_id from pa_tasks WHERE (task_id = top_task_id or pa_task_utils.check_child_exists(task_id) =0)
View Text - HTML Formatted
SELECT PROJECT_ID
, TASK_ID
, TASK_NUMBER
, TASK_NAME
, SERVICE_TYPE_CODE
, CARRYING_OUT_ORGANIZATION_ID
FROM PA_TASKS
WHERE (TASK_ID = TOP_TASK_ID OR PA_TASK_UTILS.CHECK_CHILD_EXISTS(TASK_ID) =0)