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)