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 JTA_SYNC_TASK_MAPPING

Line 96: FROM jta_sync_task_mapping tm

92: -- AND jtb.source_object_type_code = b_source_object_type , using entity instead of source_object_type_code
93: AND b_source_object_type = 'APPOINTMENT'
94: AND jtb.recurrence_rule_id IS NOT NULL
95: HAVING NOT EXISTS (SELECT 1
96: FROM jta_sync_task_mapping tm
97: WHERE tm.task_id = MIN(jtb.task_id)
98: AND tm.resource_id = cac_sync_task.g_login_resource_id
99: AND tm.principal_id = b_principal_id)
100: GROUP BY jtb.recurrence_rule_id) newtask

Line 189: jta_sync_task_mapping tm,

185: CAC_VIEW_UTIL_PUB.get_locations(t.task_id) locations,
186: ta.free_busy_type free_busy_type,
187: t.entity
188: FROM jtf_task_recur_rules rc,
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,

Line 320: , jta_sync_task_mapping tm

316: b_source_object_type VARCHAR2)
317: IS
318: SELECT tm.task_sync_id
319: FROM jtf_tasks_b t
320: , jta_sync_task_mapping tm
321: WHERE tm.resource_id = cac_sync_task.g_login_resource_id
322: AND tm.principal_id = b_principal_id
323: AND t.task_id = tm.task_id
324: AND ( (b_resource_type = 'RS_GROUP' AND

Line 348: , jta_sync_task_mapping tm

344: b_source_object_type VARCHAR2)
345: IS
346: SELECT tm.task_sync_id
347: FROM jtf_tasks_b t
348: , jta_sync_task_mapping tm
349: , jtf_task_all_assignments ta
350: WHERE tm.resource_id = cac_sync_task.g_login_resource_id
351: AND tm.principal_id = b_principal_id
352: AND t.task_id = tm.task_id

Line 375: , jta_sync_task_mapping tm

371: b_source_object_type VARCHAR2)
372: IS
373: SELECT tm.task_sync_id
374: FROM jtf_tasks_b t
375: , jta_sync_task_mapping tm
376: WHERE tm.resource_id = cac_sync_task.g_login_resource_id
377: AND tm.principal_id = b_principal_id
378: AND t.task_id = tm.task_id
379: AND ( (b_resource_type = 'RS_GROUP' AND

Line 420: , jta_sync_task_mapping tm

416: b_source_object_type VARCHAR2)
417: IS
418: SELECT tm.task_sync_id
419: FROM jtf_tasks_b t
420: , jta_sync_task_mapping tm
421: WHERE tm.resource_id = cac_sync_task.g_login_resource_id
422: AND tm.principal_id = b_principal_id
423: AND t.task_id = tm.task_id
424: AND t.owner_type_code = b_resource_type

Line 493: FROM jta_sync_task_mapping tm

489: )
490: )
491: AND task_type_id <> 22
492: AND NOT EXISTS (SELECT 1
493: FROM jta_sync_task_mapping tm
494: WHERE tm.task_id = t.task_id
495: AND tm.resource_id = cac_sync_task.g_login_resource_id
496: AND tm.principal_id = b_principal_id)
497: AND t.recurrence_rule_id IS NULL

Line 554: FROM jta_sync_task_mapping tm,

550: greatest(t.object_changed_date, ta.last_update_date) new_timestamp,
551: CAC_VIEW_UTIL_PUB.get_locations(t.task_id) locations,
552: ta.free_busy_type free_busy_type,
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

Line 603: FROM jtf_tasks_b b, jta_sync_task_mapping m

599: b_source_object_type VARCHAR2
600: )
601: IS
602: SELECT m.task_sync_id
603: FROM jtf_tasks_b b, jta_sync_task_mapping m
604: WHERE b.task_id = m.task_id
605: AND m.principal_id = b_principal_id
606: AND m.resource_id = cac_sync_task.g_login_resource_id
607: AND NVL (b.deleted_flag, 'N') = 'N'