VIEW: APPS.JTM_JTF_TASK_TYPES_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID , B.TASK_TYPE_ID , B.START_DATE_ACTIVE , B.END_DATE_ACTIVE , TL.NAME , B.PRIVATE_FLAG , B.RULE , TL.LANGUAGE FROM JTF_TASK_TYPES_B B , JTF_TASK_TYPES_TL TL , JTM_JTF_TASK_TYPES_ACC ACC WHERE B.TASK_TYPE_ID = TL.TASK_TYPE_ID AND TL.LANGUAGE = ASG_BASE.GET_LANGUAGE AND B.TASK_TYPE_ID = ACC.TASK_TYPE_ID

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, B.TASK_TYPE_ID
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, TL.NAME
, B.PRIVATE_FLAG
, B.RULE
, TL.LANGUAGE
FROM JTF_TASK_TYPES_B B
, JTF_TASK_TYPES_TL TL
, JTM_JTF_TASK_TYPES_ACC ACC
WHERE B.TASK_TYPE_ID = TL.TASK_TYPE_ID
AND TL.LANGUAGE = ASG_BASE.GET_LANGUAGE
AND B.TASK_TYPE_ID = ACC.TASK_TYPE_ID