eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CAC_SYNC_TASK_CURSORS dependencies on JTF_TASKS_TL

Line 81: jtf_tasks_tl tl,

77: t.entity
78: FROM jtf_task_recur_rules rc,
79: jtf_task_statuses_b ts,
80: jtf_task_priorities_b tb,
81: jtf_tasks_tl tl,
82: jtf_task_all_assignments ta,
83: jtf_tasks_b t,
84: (SELECT jtb.recurrence_rule_id
85: , MIN (jtb.task_id) task_id

Line 193: jtf_tasks_tl tl,

189: jta_sync_task_mapping tm,
190: jtf_task_all_assignments ta,
191: jtf_task_statuses_b ts,
192: jtf_task_priorities_b tb,
193: jtf_tasks_tl tl,
194: jtf_tasks_b t
195: WHERE tm.resource_id = cac_sync_task.g_login_resource_id
196: AND tm.principal_id = b_principal_id
197: AND t.task_id = tm.task_id

Line 292: jtf_tasks_tl tl,

288:
289: end as event
290: FROM
291: jtf_task_priorities_b tp,
292: jtf_tasks_tl tl,
293: jtf_tasks_b tb,
294: jta_task_exclusions jte,
295: jtf_task_all_assignments ta
296: WHERE jte.recurrence_rule_id = b_recurrence_rule_id

Line 472: jtf_tasks_tl tl,

468: ta.free_busy_type free_busy_type,
469: t.entity
470: FROM jtf_task_all_assignments ta,
471: jtf_task_priorities_b tb,
472: jtf_tasks_tl tl,
473: jtf_tasks_b t
474: WHERE ta.resource_id = b_resource_id
475: AND ta.resource_type_code = b_resource_type
476: /* AND ta.assignment_status_id IN (3, -- Accepted

Line 557: jtf_tasks_tl tl,

553: t.entity
554: FROM jta_sync_task_mapping tm,
555: jtf_task_all_assignments ta,
556: jtf_task_priorities_b tb,
557: jtf_tasks_tl tl,
558: jtf_tasks_b t
559: WHERE tm.resource_id = cac_sync_task.g_login_resource_id
560: AND tm.principal_id = b_principal_id
561: AND t.task_id = tm.task_id