VIEW: APPS.AMW_AUDIT_TASKS_V

Source

View Text - Preformatted

SELECT ap.audit_project_id, task.project_id, task.task_id, task.task_number, task.task_name, task.description, task.top_task_id, task.wbs_level, task.parent_task_id, task.task_manager_person_id, (select full_name from PER_ALL_PEOPLE_F where PERSON_ID = task.TASK_MANAGER_PERSON_ID and TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE and EMPLOYEE_NUMBER IS NOT NULL ), task.start_date, task.completion_date, 'PA', (select org_id from pa_projects_all where project_id = ap.project_id) from amw_audit_projects ap, pa_tasks task where task.project_id = ap.project_id UNION select tb.audit_project_id, ap.project_id, tb.task_id, tb.task_number, tl.task_name, tl.description, tb.top_task_id, tb.level_id, tb.parent_task_id, tb.task_manager_person_id, (select full_name from PER_ALL_PEOPLE_F where PERSON_ID = tb.TASK_MANAGER_PERSON_ID and TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE and EMPLOYEE_NUMBER IS NOT NULL ), tb.start_date, tb.completion_date, 'ICM', TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',null,SUBSTR(USERENV('CLIENT_INFO'),1,10))) from amw_audit_projects ap, amw_audit_tasks_b tb, amw_audit_tasks_tl tl where tb.audit_project_id = ap.audit_project_id and tl.task_id = tb.task_id and tl.language = userenv('LANG') and ap.project_id is null

View Text - HTML Formatted

SELECT AP.AUDIT_PROJECT_ID
, TASK.PROJECT_ID
, TASK.TASK_ID
, TASK.TASK_NUMBER
, TASK.TASK_NAME
, TASK.DESCRIPTION
, TASK.TOP_TASK_ID
, TASK.WBS_LEVEL
, TASK.PARENT_TASK_ID
, TASK.TASK_MANAGER_PERSON_ID
, (SELECT FULL_NAME
FROM PER_ALL_PEOPLE_F
WHERE PERSON_ID = TASK.TASK_MANAGER_PERSON_ID
AND TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE
AND EFFECTIVE_END_DATE
AND EMPLOYEE_NUMBER IS NOT NULL )
, TASK.START_DATE
, TASK.COMPLETION_DATE
, 'PA'
, (SELECT ORG_ID
FROM PA_PROJECTS_ALL
WHERE PROJECT_ID = AP.PROJECT_ID)
FROM AMW_AUDIT_PROJECTS AP
, PA_TASKS TASK
WHERE TASK.PROJECT_ID = AP.PROJECT_ID UNION SELECT TB.AUDIT_PROJECT_ID
, AP.PROJECT_ID
, TB.TASK_ID
, TB.TASK_NUMBER
, TL.TASK_NAME
, TL.DESCRIPTION
, TB.TOP_TASK_ID
, TB.LEVEL_ID
, TB.PARENT_TASK_ID
, TB.TASK_MANAGER_PERSON_ID
, (SELECT FULL_NAME
FROM PER_ALL_PEOPLE_F
WHERE PERSON_ID = TB.TASK_MANAGER_PERSON_ID
AND TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE
AND EFFECTIVE_END_DATE
AND EMPLOYEE_NUMBER IS NOT NULL )
, TB.START_DATE
, TB.COMPLETION_DATE
, 'ICM'
, TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10)))
FROM AMW_AUDIT_PROJECTS AP
, AMW_AUDIT_TASKS_B TB
, AMW_AUDIT_TASKS_TL TL
WHERE TB.AUDIT_PROJECT_ID = AP.AUDIT_PROJECT_ID
AND TL.TASK_ID = TB.TASK_ID
AND TL.LANGUAGE = USERENV('LANG')
AND AP.PROJECT_ID IS NULL