VIEW: APPS.CSD_TASK_TYPES_V

Source

View Text - Preformatted

SELECT distinct t.name, t.description from jtf_task_types_vl t ,jtf_object_mappings s WHERE to_char(t.task_type_id) = s.object_id and s.object_code = 'JTF_TASK_TYPE' and s.source_object_code = 'DR' and t.task_type_id !=22 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 order by 1

View Text - HTML Formatted

SELECT DISTINCT T.NAME
, T.DESCRIPTION
FROM JTF_TASK_TYPES_VL T
, JTF_OBJECT_MAPPINGS S
WHERE TO_CHAR(T.TASK_TYPE_ID) = S.OBJECT_ID
AND S.OBJECT_CODE = 'JTF_TASK_TYPE'
AND S.SOURCE_OBJECT_CODE = 'DR'
AND T.TASK_TYPE_ID !=22
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 ORDER BY 1