VIEW: APPS.PA_ALLOC_EXCEPTIONS_V

Source

View Text - Preformatted

SELECT e.run_id, e.exception_type, l1.meaning exception_type, e.level_code, l2.meaning exception_level, e.project_id, p.segment1 project, p.name, e.task_id, t.task_number task, t.task_name, e.exception_code, nvl(fnd_message.get_string('PA',e.exception_code),e.exception_code) FROM pa_lookups l1, pa_lookups l2, pa_projects_all p, pa_tasks t, pa_alloc_exceptions e WHERE (l1.lookup_type = 'ALLOC_EXCEPTION_TYPE' and l1.lookup_code = e.exception_type) and (l2.lookup_type = 'ALLOC_EXCEPTION_LEVEL' and l2.lookup_code = e.level_code) and p.project_id (+)= e.project_id and t.task_id(+) = e.task_id

View Text - HTML Formatted

SELECT E.RUN_ID
, E.EXCEPTION_TYPE
, L1.MEANING EXCEPTION_TYPE
, E.LEVEL_CODE
, L2.MEANING EXCEPTION_LEVEL
, E.PROJECT_ID
, P.SEGMENT1 PROJECT
, P.NAME
, E.TASK_ID
, T.TASK_NUMBER TASK
, T.TASK_NAME
, E.EXCEPTION_CODE
, NVL(FND_MESSAGE.GET_STRING('PA'
, E.EXCEPTION_CODE)
, E.EXCEPTION_CODE)
FROM PA_LOOKUPS L1
, PA_LOOKUPS L2
, PA_PROJECTS_ALL P
, PA_TASKS T
, PA_ALLOC_EXCEPTIONS E
WHERE (L1.LOOKUP_TYPE = 'ALLOC_EXCEPTION_TYPE'
AND L1.LOOKUP_CODE = E.EXCEPTION_TYPE)
AND (L2.LOOKUP_TYPE = 'ALLOC_EXCEPTION_LEVEL'
AND L2.LOOKUP_CODE = E.LEVEL_CODE)
AND P.PROJECT_ID (+)= E.PROJECT_ID
AND T.TASK_ID(+) = E.TASK_ID