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_B

Line 83: jtf_tasks_b t,

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
86: FROM jtf_tasks_b jtb
87: , jtf_task_all_assignments jtaa

Line 86: FROM jtf_tasks_b jtb

82: jtf_task_all_assignments ta,
83: jtf_tasks_b t,
84: (SELECT jtb.recurrence_rule_id
85: , MIN (jtb.task_id) task_id
86: FROM jtf_tasks_b jtb
87: , jtf_task_all_assignments jtaa
88: WHERE jtaa.resource_id = b_resource_id
89: AND jtaa.resource_type_code = b_resource_type
90: AND jtb.task_id = jtaa.task_id

Line 115: (select 1 from jtf_tasks_b b where

111: AND (t.object_changed_date > b_syncanchor OR
112: ta.last_update_date > b_syncanchor)
113: AND exists
114: --rhshriva.. The following lines will check for start date to be in range for any of the repeating tasks
115: (select 1 from jtf_tasks_b b where
116: b.recurrence_rule_id = ( select a.recurrence_rule_id from jtf_tasks_b a
117: where a.task_id= t.task_id)
118: and b.calendar_start_date > (sysdate-G_SYNC_DAYS_BEFORE))
119:

Line 116: b.recurrence_rule_id = ( select a.recurrence_rule_id from jtf_tasks_b a

112: ta.last_update_date > b_syncanchor)
113: AND exists
114: --rhshriva.. The following lines will check for start date to be in range for any of the repeating tasks
115: (select 1 from jtf_tasks_b b where
116: b.recurrence_rule_id = ( select a.recurrence_rule_id from jtf_tasks_b a
117: where a.task_id= t.task_id)
118: and b.calendar_start_date > (sysdate-G_SYNC_DAYS_BEFORE))
119:
120: -- AND t.calendar_start_date > (sysdate - G_SYNC_DAYS_BEFORE )

Line 194: jtf_tasks_b t

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
198: AND t.task_id = ta.task_id

Line 225: (select 1 from jtf_tasks_b b where

221: -- AND t.source_object_type_code = b_source_object_type using entity instead of source_object_type_code
222: AND b_source_object_type = 'APPOINTMENT'
223: AND exists
224: --rhshriva.. The following lines will check for start date to be in range for any of the repeating tasks
225: (select 1 from jtf_tasks_b b where
226: b.recurrence_rule_id = t.recurrence_rule_id
227: --commented for bug 5352055
228: /*( select a.recurrence_rule_id from jtf_tasks_b a
229: where a.task_id= t.task_id)*/

Line 228: /*( select a.recurrence_rule_id from jtf_tasks_b a

224: --rhshriva.. The following lines will check for start date to be in range for any of the repeating tasks
225: (select 1 from jtf_tasks_b b where
226: b.recurrence_rule_id = t.recurrence_rule_id
227: --commented for bug 5352055
228: /*( select a.recurrence_rule_id from jtf_tasks_b a
229: where a.task_id= t.task_id)*/
230: and b.calendar_start_date > (sysdate-G_SYNC_DAYS_BEFORE)
231: and rownum=1 )
232:

Line 238: OR (SELECT MAX(m.object_changed_date) FROM jtf_tasks_b m WHERE m.task_id IN

234: AND ( rc.last_update_date > b_syncanchor
235: OR (SELECT MAX(last_update_date) FROM jtf_task_all_assignments
236: WHERE task_id = t.task_id) > b_syncanchor
237: OR t.object_changed_date > b_syncanchor
238: OR (SELECT MAX(m.object_changed_date) FROM jtf_tasks_b m WHERE m.task_id IN
239: (SELECT jte.task_id FROM jta_task_exclusions jte
240: WHERE jte.recurrence_rule_id=t.recurrence_rule_id)) > b_syncanchor)
241: AND ts.task_status_id = t.task_status_id
242: AND NVL (t.deleted_flag, 'N') = 'N';

Line 293: jtf_tasks_b tb,

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
297: and tb.task_id=jte.task_id

Line 319: FROM jtf_tasks_b t

315: b_resource_type VARCHAR2,
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

Line 347: FROM jtf_tasks_b t

343: b_resource_type VARCHAR2,
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

Line 374: FROM jtf_tasks_b t

370: b_principal_id NUMBER,
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

Line 419: FROM jtf_tasks_b t

415: b_principal_id NUMBER,
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

Line 473: jtf_tasks_b t

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
477: 18 -- Invited

Line 558: jtf_tasks_b t

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
562: AND ( (b_resource_type = 'RS_GROUP' AND

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'