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_TASKS_B

Line 144: jtf_tasks_b jtftk

140: (
141: select
142: tmp.object_id
143: from
144: jtf_tasks_b jtftk
145: , jtf_task_statuses_b jtfts
146: , jtf_task_types_b jttp
147: , JTF_OBJECT_PURGE_PARAM_TMP tmp
148: where

Line 264: , JTF_TASKS_B tskt

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
268: nvl(tmp.purge_status, 'S') <> 'E' and

Line 290: , JTF_TASKS_B tskt

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
294: nvl(tmp.purge_status, 'S') <> 'E' and

Line 314: , JTF_TASKS_B tskt

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
318: nvl(tmp.purge_status, 'S') <> 'E' and

Line 345: , JTF_TASKS_B tskt

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
349: nvl(tmp.purge_status, 'S') <> 'E' and

Line 372: , JTF_TASKS_B tskt

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
376: nvl(tmp.purge_status, 'S') <> 'E' and

Line 398: , JTF_TASKS_B tskt

394: FROM
395: CSP_REQ_LINE_DETAILS csprdt
396: , CSP_REQUIREMENT_LINES csprl
397: , CSP_REQUIREMENT_HEADERS csprh
398: , JTF_TASKS_B tskt
399: , JTF_OBJECT_PURGE_PARAM_TMP tmp
400: WHERE
401: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
402: nvl(tmp.purge_status, 'S') <> 'E' and

Line 421: , JTF_TASKS_B tskt

417: csprl.requirement_line_id
418: FROM
419: CSP_REQUIREMENT_LINES csprl
420: , CSP_REQUIREMENT_HEADERS csprh
421: , JTF_TASKS_B tskt
422: , JTF_OBJECT_PURGE_PARAM_TMP tmp
423: WHERE
424: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
425: nvl(tmp.purge_status, 'S') <> 'E' and

Line 443: , JTF_TASKS_B tskt

439: SELECT /*+ no_unnest no_semijoin cardinality(10) */
440: csprh.requirement_header_id
441: FROM
442: CSP_REQUIREMENT_HEADERS csprh
443: , JTF_TASKS_B tskt
444: , JTF_OBJECT_PURGE_PARAM_TMP tmp
445: WHERE
446: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
447: nvl(tmp.purge_status, 'S') <> 'E' and

Line 467: , JTF_TASKS_B tskt

463: SELECT /*+ no_unnest no_semijoin cardinality(10) */
464: csfsk.required_skill_id
465: FROM
466: CSF_REQUIRED_SKILLS_B csfsk
467: , JTF_TASKS_B tskt
468: , JTF_OBJECT_PURGE_PARAM_TMP tmp
469: WHERE
470: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
471: nvl(tmp.purge_status, 'S') <> 'E' and

Line 491: , JTF_TASKS_B tskt

487: SELECT /*+ no_unnest no_semijoin cardinality(10) */
488: csacc.task_id
489: FROM
490: CSF_ACCESS_HOURS_B csacc
491: , JTF_TASKS_B tskt
492: , JTF_OBJECT_PURGE_PARAM_TMP tmp
493: WHERE
494: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
495: nvl(tmp.purge_status, 'S') <> 'E' and

Line 510: , JTF_TASKS_B tskt

506: SELECT /*+ no_unnest no_semijoin cardinality(10) */
507: csacc.access_hour_id
508: FROM
509: CSF_ACCESS_HOURS_B csacc
510: , JTF_TASKS_B tskt
511: , JTF_OBJECT_PURGE_PARAM_TMP tmp
512: WHERE
513: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
514: nvl(tmp.purge_status, 'S') <> 'E' and

Line 535: , JTF_TASKS_B tskt

531: csactl.plan_option_id
532: FROM
533: CSF_R_PLAN_OPTIONS csactl
534: , CSF_R_PLAN_OPTION_TASKS csacc
535: , JTF_TASKS_B tskt
536: , JTF_OBJECT_PURGE_PARAM_TMP tmp
537: WHERE
538: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
539: nvl(tmp.purge_status, 'S') <> 'E' and

Line 555: , JTF_TASKS_B tskt

551: SELECT /*+ no_unnest no_semijoin cardinality(10) */
552: csacc.task_id
553: FROM
554: CSF_R_PLAN_OPTION_TASKS csacc
555: , JTF_TASKS_B tskt
556: , JTF_OBJECT_PURGE_PARAM_TMP tmp
557: WHERE
558: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
559: nvl(tmp.purge_status, 'S') <> 'E' and

Line 580: , JTF_TASKS_B tskt

576: csactl.SCHED_REQUEST_ID
577: FROM
578: CSF_R_SCHED_REQUESTS csactl
579: , CSF_R_REQUEST_TASKS csacc
580: , JTF_TASKS_B tskt
581: , JTF_OBJECT_PURGE_PARAM_TMP tmp
582: WHERE
583: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
584: nvl(tmp.purge_status, 'S') <> 'E' and

Line 600: , JTF_TASKS_B tskt

596: SELECT /*+ no_unnest no_semijoin cardinality(10) */
597: csacc.REQUEST_TASK_ID
598: FROM
599: CSF_R_REQUEST_TASKS csacc
600: , JTF_TASKS_B tskt
601: , JTF_OBJECT_PURGE_PARAM_TMP tmp
602: WHERE
603: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
604: nvl(tmp.purge_status, 'S') <> 'E' and

Line 624: , JTF_TASKS_B tskt

620: csactl.RESOURCE_RESULT_ID
621: FROM
622: CSF_R_SPARES_OPTIONS csactl
623: , CSF_R_RESOURCE_RESULTS csacc
624: , JTF_TASKS_B tskt
625: , JTF_OBJECT_PURGE_PARAM_TMP tmp
626: WHERE
627: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
628: nvl(tmp.purge_status, 'S') <> 'E' and

Line 644: , JTF_TASKS_B tskt

640: SELECT /*+ no_unnest no_semijoin cardinality(10) */
641: csacc.REQUEST_TASK_ID
642: FROM
643: CSF_R_RESOURCE_RESULTS csacc
644: , JTF_TASKS_B tskt
645: , JTF_OBJECT_PURGE_PARAM_TMP tmp
646: WHERE
647: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
648: nvl(tmp.purge_status, 'S') <> 'E' and

Line 670: , JTF_TASKS_B tskt

666: csactl.MESSAGE_ID
667: FROM
668: CSF_R_MESSAGE_TOKENS csactl
669: , CSF_R_MESSAGES csacc
670: , JTF_TASKS_B tskt
671: , JTF_OBJECT_PURGE_PARAM_TMP tmp
672: WHERE
673: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
674: nvl(tmp.purge_status, 'S') <> 'E' and

Line 690: , JTF_TASKS_B tskt

686: SELECT /*+ no_unnest no_semijoin cardinality(10) */
687: csacc.REQUEST_TASK_ID
688: FROM
689: CSF_R_MESSAGES csacc
690: , JTF_TASKS_B tskt
691: , JTF_OBJECT_PURGE_PARAM_TMP tmp
692: WHERE
693: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
694: nvl(tmp.purge_status, 'S') <> 'E' and

Line 711: , JTF_TASKS_B tskt

707: where object_capacity_id in
708: (select cac.object_capacity_id
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

Line 756: , JTF_TASKS_B tskt

752: cac.object_capacity_id in
753: (select cac.object_capacity_id
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