View: CSD_TASK_PRIORITIES_V

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

View Text

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

Columns