VIEW: APPS.CSD_TASK_PRIORITIES_V

Source

View Text - Preformatted

SELECT distinct t.name , t.description from jtf_task_priorities_vl t ,jtf_object_mappings s where to_char(t.task_priority_id) = s.object_id and s.object_code = 'JTF_TASK_PRIORITY' and trunc(sysdate) between trunc(NVL(t.start_date_active,sysdate))and trunc(NVL(t.end_date_active,sysdate)) and nvl(s.end_date, sysdate+1) >= sysdate UNION select distinct t.name, t.description from jtf_task_priorities_vl t where t.task_priority_id NOT IN ( select to_number(object_id) from jtf_object_mappings WHERE object_code='JTF_TASK_PRIORITY' and trunc(sysdate) between trunc(NVL(t.start_date_active,sysdate)) and trunc(NVL(t.end_date_active,sysdate)))and trunc(sysdate) between trunc(NVL(t.start_date_active, sysdate)) and trunc(NVL(t.end_date_active, sysdate))order by 2

View Text - HTML Formatted

SELECT DISTINCT T.NAME
, T.DESCRIPTION
FROM JTF_TASK_PRIORITIES_VL T
, JTF_OBJECT_MAPPINGS S
WHERE TO_CHAR(T.TASK_PRIORITY_ID) = S.OBJECT_ID
AND S.OBJECT_CODE = 'JTF_TASK_PRIORITY'
AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(T.START_DATE_ACTIVE
, SYSDATE))AND TRUNC(NVL(T.END_DATE_ACTIVE
, SYSDATE))
AND NVL(S.END_DATE
, SYSDATE+1) >= SYSDATE UNION SELECT DISTINCT T.NAME
, T.DESCRIPTION
FROM JTF_TASK_PRIORITIES_VL T
WHERE T.TASK_PRIORITY_ID NOT IN ( SELECT TO_NUMBER(OBJECT_ID)
FROM JTF_OBJECT_MAPPINGS
WHERE OBJECT_CODE='JTF_TASK_PRIORITY'
AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(T.START_DATE_ACTIVE
, SYSDATE))
AND TRUNC(NVL(T.END_DATE_ACTIVE
, SYSDATE)))AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(T.START_DATE_ACTIVE
, SYSDATE))
AND TRUNC(NVL(T.END_DATE_ACTIVE
, SYSDATE))ORDER BY 2