View: CSD_TASK_TYPES_V

Product:	CSD - Depot Repair
Description:
Implementation/DBA Data:	APPS.CSD_TASK_TYPES_V

View Text

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

Columns