VIEW: APPS.CSM_TASK_PRIORITIES_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID , B.TASK_PRIORITY_ID , TL.NAME , B.IMPORTANCE_LEVEL ,B.START_DATE_ACTIVE, B.END_DATE_ACTIVE FROM JTF_TASK_PRIORITIES_B B , JTF_TASK_PRIORITIES_TL TL , CSM_TASK_PRIORITIES_ACC ACC WHERE TL.LANGUAGE = ASG_BASE.GET_LANGUAGE AND ACC.TASK_PRIORITY_ID = B.TASK_PRIORITY_ID AND B.TASK_PRIORITY_ID = TL.TASK_PRIORITY_ID

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, B.TASK_PRIORITY_ID
, TL.NAME
, B.IMPORTANCE_LEVEL
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
FROM JTF_TASK_PRIORITIES_B B
, JTF_TASK_PRIORITIES_TL TL
, CSM_TASK_PRIORITIES_ACC ACC
WHERE TL.LANGUAGE = ASG_BASE.GET_LANGUAGE
AND ACC.TASK_PRIORITY_ID = B.TASK_PRIORITY_ID
AND B.TASK_PRIORITY_ID = TL.TASK_PRIORITY_ID