VIEW: APPS.BIV_FS_TASK_TYPE_LVL_V

Source

View Text - Preformatted

SELECT b.task_type_id id , t.name value from jtf_task_types_tl t, jtf_task_types_b b WHERE b.task_type_id = t.task_type_id and t.language = userenv('LANG') and b.rule = 'DISPATCH'

View Text - HTML Formatted

SELECT B.TASK_TYPE_ID ID
, T.NAME VALUE
FROM JTF_TASK_TYPES_TL T
, JTF_TASK_TYPES_B B
WHERE B.TASK_TYPE_ID = T.TASK_TYPE_ID
AND T.LANGUAGE = USERENV('LANG')
AND B.RULE = 'DISPATCH'