359: x_last_update_login,
360: x_task_id,
361: l.language_code,
362: USERENV ('LANG')
363: FROM fnd_languages l
364: WHERE l.installed_flag IN ('I', 'B')
365: AND NOT EXISTS (SELECT NULL
366: FROM jtf_tasks_tl t
367: WHERE t.task_id = x_task_id
1017: b.last_update_login,
1018: b.task_id,
1019: l.language_code,
1020: b.source_lang
1021: FROM jtf_tasks_tl b, fnd_languages l
1022: WHERE l.installed_flag IN ('I', 'B')
1023: AND b.language = USERENV ('LANG')
1024: AND NOT EXISTS (SELECT NULL
1025: FROM jtf_tasks_tl t
1037: FROM ( SELECT /*+ no_merge ordered parallel(b) */
1038: b.task_name, b.description, b.created_by, b.creation_date,
1039: b.last_updated_by, b.last_update_date, b.last_update_login,
1040: b.task_id, l.language_code, b.source_lang
1041: FROM fnd_languages l, jtf_tasks_tl b
1042: WHERE l.installed_flag IN ('I', 'B')
1043: AND b.language = USERENV ('LANG')
1044: ) v, jtf_tasks_tl t
1045: WHERE t.task_id(+) = v.task_id