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.CSF_MAINTAIN_GRP dependencies on JTF_TASK_ASSIGNMENTS

Line 263: , JTF_TASK_ASSIGNMENTS tska

259: FROM
260: JTF_NOTE_CONTEXTS jtfnl
261: , JTF_NOTES_B jtfnb
262: , CSF_DEBRIEF_HEADERS dbfh
263: , JTF_TASK_ASSIGNMENTS tska
264: , JTF_TASKS_B tskt
265: , JTF_OBJECT_PURGE_PARAM_TMP tmp
266: WHERE
267: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and

Line 289: , JTF_TASK_ASSIGNMENTS tska

285: jtfnb.jtf_note_id
286: FROM
287: JTF_NOTES_B jtfnb
288: , CSF_DEBRIEF_HEADERS dbfh
289: , JTF_TASK_ASSIGNMENTS tska
290: , JTF_TASKS_B tskt
291: , JTF_OBJECT_PURGE_PARAM_TMP tmp
292: WHERE
293: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and

Line 313: , JTF_TASK_ASSIGNMENTS tska

309: jtfnb.jtf_note_id
310: FROM
311: JTF_NOTES_B jtfnb
312: , CSF_DEBRIEF_HEADERS dbfh
313: , JTF_TASK_ASSIGNMENTS tska
314: , JTF_TASKS_B tskt
315: , JTF_OBJECT_PURGE_PARAM_TMP tmp
316: WHERE
317: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and

Line 344: , JTF_TASK_ASSIGNMENTS tska

340: dbfl.debrief_line_id
341: FROM
342: CSF_DEBRIEF_LINES dbfl
343: , CSF_DEBRIEF_HEADERS dbfh
344: , JTF_TASK_ASSIGNMENTS tska
345: , JTF_TASKS_B tskt
346: , JTF_OBJECT_PURGE_PARAM_TMP tmp
347: WHERE
348: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and

Line 371: , JTF_TASK_ASSIGNMENTS tska

367: SELECT /*+ no_unnest no_semijoin cardinality(10) */
368: dbfh.debrief_header_id
369: FROM
370: CSF_DEBRIEF_HEADERS dbfh
371: , JTF_TASK_ASSIGNMENTS tska
372: , JTF_TASKS_B tskt
373: , JTF_OBJECT_PURGE_PARAM_TMP tmp
374: WHERE
375: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and

Line 713: , jtf_Task_assignments jtt

709: from
710: cac_sr_object_capacity cac
711: , JTF_TASKS_B tskt
712: , JTF_OBJECT_PURGE_PARAM_TMP tmp
713: , jtf_Task_assignments jtt
714: , jtf_task_statuses_b jtfts
715: WHERE
716: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
717: nvl(tmp.purge_status, 'S') <> 'E' and

Line 728: jtf_Task_assignments jtts, jtf_task_statuses_b jtsts

724: nvl(jtfts.completed_flag,'N') = 'Y' or
725: nvl(jtfts.cancelled_flag,'N') = 'Y') and
726: cac.end_date_time < sysdate and
727: not exists (select 1 from
728: jtf_Task_assignments jtts, jtf_task_statuses_b jtsts
729: where
730: jtts.object_capacity_id = cac.object_capacity_id and
731: jtts.task_id <> jtt.task_id and
732: jtt.assignment_status_id = jtfts.task_status_id and

Line 748: FROM jtf_task_assignments ta

744: SUM(NVL(csf_util_pvt.convert_to_minutes(
745: ta.sched_travel_duration
746: , ta.sched_travel_duration_uom
747: ), 0)) /(24*60)
748: FROM jtf_task_assignments ta
749: WHERE ta.object_capacity_id = cac.object_capacity_id
750: )
751: where cac.start_date_time > sysdate and
752: cac.object_capacity_id in

Line 758: , jtf_Task_assignments jtt

754: from
755: cac_sr_object_capacity cac
756: , JTF_TASKS_B tskt
757: , JTF_OBJECT_PURGE_PARAM_TMP tmp
758: , jtf_Task_assignments jtt
759: , jtf_task_statuses_b jtfts
760: WHERE
761: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
762: nvl(tmp.purge_status, 'S') <> 'E' and