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 212: CSACTL , CSF_R_REQUEST_TASKS CSACC , JTF_TASKS_B TSKT ,

208:
209: CURSOR c_fetch_sched_req_id IS
210: (( SELECT /*+ LEADING(TMP) cardinality(TMP, 10) */
211: CSACTL.SCHED_REQUEST_ID FROM CSF_R_SCHED_REQUESTS
212: CSACTL , CSF_R_REQUEST_TASKS CSACC , JTF_TASKS_B TSKT ,
213: JTF_OBJECT_PURGE_PARAM_TMP TMP WHERE TMP.PROCESSING_SET_ID = P_PROCESSING_SET_ID AND
214: NVL(TMP.PURGE_STATUS, 'S') <> 'E' AND TMP.OBJECT_ID = TSKT.SOURCE_OBJECT_ID
215: AND TMP.OBJECT_TYPE = TSKT.SOURCE_OBJECT_TYPE_CODE AND TSKT.TASK_ID =
216: CSACC.TASK_ID AND CSACC.SCHED_REQUEST_ID = CSACTL.SCHED_REQUEST_ID )

Line 219: CSACTL , CSF_R_REQUEST_TASKS CSACC , JTF_TASKS_B TSKT ,

215: AND TMP.OBJECT_TYPE = TSKT.SOURCE_OBJECT_TYPE_CODE AND TSKT.TASK_ID =
216: CSACC.TASK_ID AND CSACC.SCHED_REQUEST_ID = CSACTL.SCHED_REQUEST_ID )
217: UNION ALL(SELECT /*+ LEADING(TMP) cardinality(TMP, 10) */
218: CSACTL.PARENT_REQUEST_ID FROM CSF_R_SCHED_REQUESTS
219: CSACTL , CSF_R_REQUEST_TASKS CSACC , JTF_TASKS_B TSKT ,
220: JTF_OBJECT_PURGE_PARAM_TMP TMP WHERE TMP.PROCESSING_SET_ID = P_PROCESSING_SET_ID AND
221: NVL(TMP.PURGE_STATUS, 'S') <> 'E' AND TMP.OBJECT_ID = TSKT.SOURCE_OBJECT_ID
222: AND TMP.OBJECT_TYPE = TSKT.SOURCE_OBJECT_TYPE_CODE AND TSKT.TASK_ID =
223: CSACC.TASK_ID AND CSACC.SCHED_REQUEST_ID = CSACTL.SCHED_REQUEST_ID));

Line 277: JTF_TASKS_B TSKT , JTF_OBJECT_PURGE_PARAM_TMP TMP WHERE

273: WHERE
274: JTF_NOTE_ID IN ( SELECT /*+ LEADING(TMP) cardinality(TMP, 10) */
275: JTFNL.JTF_NOTE_ID FROM JTF_NOTE_CONTEXTS JTFNL ,
276: JTF_NOTES_B JTFNB , CSF_DEBRIEF_HEADERS DBFH , JTF_TASK_ASSIGNMENTS TSKA ,
277: JTF_TASKS_B TSKT , JTF_OBJECT_PURGE_PARAM_TMP TMP WHERE
278: TMP.PROCESSING_SET_ID = P_PROCESSING_SET_ID AND NVL(TMP.PURGE_STATUS, 'S') <> 'E' AND
279: TMP.OBJECT_ID = TSKT.SOURCE_OBJECT_ID AND TMP.OBJECT_TYPE =
280: TSKT.SOURCE_OBJECT_TYPE_CODE AND TSKT.TASK_ID = TSKA.TASK_ID AND
281: TSKA.TASK_ASSIGNMENT_ID = DBFH.TASK_ASSIGNMENT_ID AND

Line 291: CSF_DEBRIEF_HEADERS DBFH , JTF_TASK_ASSIGNMENTS TSKA , JTF_TASKS_B TSKT ,

287: DELETE /*+ index(jnt)*/ FROM JTF_NOTES_TL JNT
288: WHERE
289: JTF_NOTE_ID IN ( SELECT /*+ LEADING(TMP) cardinality(TMP, 10) */
290: JTFNB.JTF_NOTE_ID FROM JTF_NOTES_B JTFNB ,
291: CSF_DEBRIEF_HEADERS DBFH , JTF_TASK_ASSIGNMENTS TSKA , JTF_TASKS_B TSKT ,
292: JTF_OBJECT_PURGE_PARAM_TMP TMP WHERE TMP.PROCESSING_SET_ID = P_PROCESSING_SET_ID AND
293: NVL(TMP.PURGE_STATUS, 'S') <> 'E' AND TMP.OBJECT_ID = TSKT.SOURCE_OBJECT_ID
294: AND TMP.OBJECT_TYPE = TSKT.SOURCE_OBJECT_TYPE_CODE AND TSKT.TASK_ID =
295: TSKA.TASK_ID AND TSKA.TASK_ASSIGNMENT_ID = DBFH.TASK_ASSIGNMENT_ID AND

Line 304: CSF_DEBRIEF_HEADERS DBFH , JTF_TASK_ASSIGNMENTS TSKA , JTF_TASKS_B TSKT ,

300: DELETE /*+ index(jnb)*/ FROM JTF_NOTES_B JNB
301: WHERE
302: JTF_NOTE_ID IN ( SELECT /*+ LEADING(TMP) cardinality(TMP, 10) */
303: JTFNB.JTF_NOTE_ID FROM JTF_NOTES_B JTFNB ,
304: CSF_DEBRIEF_HEADERS DBFH , JTF_TASK_ASSIGNMENTS TSKA , JTF_TASKS_B TSKT ,
305: JTF_OBJECT_PURGE_PARAM_TMP TMP WHERE TMP.PROCESSING_SET_ID = P_PROCESSING_SET_ID AND
306: NVL(TMP.PURGE_STATUS, 'S') <> 'E' AND TMP.OBJECT_ID = TSKT.SOURCE_OBJECT_ID
307: AND TMP.OBJECT_TYPE = TSKT.SOURCE_OBJECT_TYPE_CODE AND TSKT.TASK_ID =
308: TSKA.TASK_ID AND TSKA.TASK_ASSIGNMENT_ID = DBFH.TASK_ASSIGNMENT_ID AND

Line 328: JTF_TASKS_B TSKT ,

324: DBFL.DEBRIEF_LINE_ID
325: FROM CSF_DEBRIEF_LINES DBFL ,
326: CSF_DEBRIEF_HEADERS DBFH ,
327: JTF_TASK_ASSIGNMENTS TSKA ,
328: JTF_TASKS_B TSKT ,
329: JTF_OBJECT_PURGE_PARAM_TMP TMP
330: WHERE TMP.PROCESSING_SET_ID = p_processing_set_id
331: AND NVL ( TMP.PURGE_STATUS , 'S' ) <> 'E'
332: AND TMP.OBJECT_ID = TSKT.SOURCE_OBJECT_ID

Line 348: DBFH , JTF_TASK_ASSIGNMENTS TSKA , JTF_TASKS_B TSKT ,

344: DELETE /*+ index(cdh) */ FROM CSF_DEBRIEF_HEADERS CDH
345: WHERE
346: DEBRIEF_HEADER_ID IN ( SELECT /*+ LEADING(TMP) cardinality(TMP, 10) */
347: DBFH.DEBRIEF_HEADER_ID FROM CSF_DEBRIEF_HEADERS
348: DBFH , JTF_TASK_ASSIGNMENTS TSKA , JTF_TASKS_B TSKT ,
349: JTF_OBJECT_PURGE_PARAM_TMP TMP WHERE TMP.PROCESSING_SET_ID = P_PROCESSING_SET_ID AND
350: NVL(TMP.PURGE_STATUS, 'S') <> 'E' AND TMP.OBJECT_ID = TSKT.SOURCE_OBJECT_ID
351: AND TMP.OBJECT_TYPE = TSKT.SOURCE_OBJECT_TYPE_CODE AND TSKT.TASK_ID =
352: TSKA.TASK_ID AND TSKA.TASK_ASSIGNMENT_ID = DBFH.TASK_ASSIGNMENT_ID );

Line 369: , JTF_TASKS_B tskt

365: FROM
366: CSP_REQ_LINE_DETAILS csprdt
367: , CSP_REQUIREMENT_LINES csprl
368: , CSP_REQUIREMENT_HEADERS csprh
369: , JTF_TASKS_B tskt
370: , JTF_OBJECT_PURGE_PARAM_TMP tmp
371: WHERE
372: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
373: nvl(tmp.purge_status, 'S') <> 'E' and

Line 392: , JTF_TASKS_B tskt

388: csprl.requirement_line_id
389: FROM
390: CSP_REQUIREMENT_LINES csprl
391: , CSP_REQUIREMENT_HEADERS csprh
392: , JTF_TASKS_B tskt
393: , JTF_OBJECT_PURGE_PARAM_TMP tmp
394: WHERE
395: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
396: nvl(tmp.purge_status, 'S') <> 'E' and

Line 414: , JTF_TASKS_B tskt

410: SELECT /*+ cardinality(TMP, 10) */
411: csprh.requirement_header_id
412: FROM
413: CSP_REQUIREMENT_HEADERS csprh
414: , JTF_TASKS_B tskt
415: , JTF_OBJECT_PURGE_PARAM_TMP tmp
416: WHERE
417: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
418: nvl(tmp.purge_status, 'S') <> 'E' and

Line 434: CSFSK , JTF_TASKS_B TSKT , JTF_OBJECT_PURGE_PARAM_TMP TMP WHERE

430: DELETE /*+ index(crsb) */ FROM CSF_REQUIRED_SKILLS_B CRSB
431: WHERE
432: REQUIRED_SKILL_ID IN ( SELECT /*+ LEADING(TMP) cardinality(TMP, 10) */
433: CSFSK.REQUIRED_SKILL_ID FROM CSF_REQUIRED_SKILLS_B
434: CSFSK , JTF_TASKS_B TSKT , JTF_OBJECT_PURGE_PARAM_TMP TMP WHERE
435: TMP.PROCESSING_SET_ID = P_PROCESSING_SET_ID AND NVL(TMP.PURGE_STATUS, 'S') <> 'E' AND
436: TMP.OBJECT_ID = TSKT.SOURCE_OBJECT_ID AND TMP.OBJECT_TYPE =
437: TSKT.SOURCE_OBJECT_TYPE_CODE AND TSKT.TASK_ID = CSFSK.HAS_SKILL_ID AND
438: CSFSK.HAS_SKILL_TYPE = 'TASK' );

Line 454: , JTF_TASKS_B tskt

450: 10) */
451: csacc.access_hour_id
452: FROM
453: CSF_ACCESS_HOURS_B csacc
454: , JTF_TASKS_B tskt
455: , JTF_OBJECT_PURGE_PARAM_TMP tmp
456: WHERE
457: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
458: nvl(tmp.purge_status, 'S') <> 'E' and

Line 472: , JTF_TASKS_B tskt

468: SELECT /*+ cardinality(TMP, 10) */
469: csacc.task_id
470: FROM
471: CSF_ACCESS_HOURS_B csacc
472: , JTF_TASKS_B tskt
473: , JTF_OBJECT_PURGE_PARAM_TMP tmp
474: WHERE
475: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
476: nvl(tmp.purge_status, 'S') <> 'E' and

Line 493: CSACTL , CSF_R_PLAN_OPTION_TASKS CSACC , JTF_TASKS_B TSKT ,

489: DELETE /*+ index(crpo) */ FROM CSF_R_PLAN_OPTIONS CRPO
490: WHERE
491: PLAN_OPTION_ID IN ( SELECT /*+ LEADING(TMP) cardinality(TMP, 10) */
492: CSACTL.PLAN_OPTION_ID FROM CSF_R_PLAN_OPTIONS
493: CSACTL , CSF_R_PLAN_OPTION_TASKS CSACC , JTF_TASKS_B TSKT ,
494: JTF_OBJECT_PURGE_PARAM_TMP TMP WHERE TMP.PROCESSING_SET_ID = P_PROCESSING_SET_ID AND
495: NVL(TMP.PURGE_STATUS, 'S') <> 'E' AND TMP.OBJECT_ID = TSKT.SOURCE_OBJECT_ID
496: AND TMP.OBJECT_TYPE = TSKT.SOURCE_OBJECT_TYPE_CODE AND TSKT.TASK_ID =
497: CSACC.TASK_ID AND CSACC.PLAN_OPTION_ID = CSACTL.PLAN_OPTION_ID );

Line 503: CSACC.TASK_ID FROM CSF_R_PLAN_OPTION_TASKS CSACC , JTF_TASKS_B TSKT ,

499:
500: DELETE /*+ index(crpot) */ FROM CSF_R_PLAN_OPTION_TASKS CRPOT
501: WHERE
502: TASK_ID IN ( SELECT /*+ LEADING(TMP) cardinality(TMP, 10) */
503: CSACC.TASK_ID FROM CSF_R_PLAN_OPTION_TASKS CSACC , JTF_TASKS_B TSKT ,
504: JTF_OBJECT_PURGE_PARAM_TMP TMP WHERE TMP.PROCESSING_SET_ID = P_PROCESSING_SET_ID AND
505: NVL(TMP.PURGE_STATUS, 'S') <> 'E' AND TMP.OBJECT_ID = TSKT.SOURCE_OBJECT_ID
506: AND TMP.OBJECT_TYPE = TSKT.SOURCE_OBJECT_TYPE_CODE AND TSKT.TASK_ID =
507: CSACC.TASK_ID );

Line 520: CSACC, JTF_TASKS_B TSKT ,JTF_OBJECT_PURGE_PARAM_TMP TMP WHERE

516: WHERE
517: RESOURCE_RESULT_ID IN (SELECT /*+ LEADING(TMP) cardinality(TMP, 10) */
518: CSACTL.RESOURCE_RESULT_ID FROM CSF_R_SPARES_OPTIONS
519: CSACTL , CSF_R_RESOURCE_RESULTS CSRR ,CSF_R_REQUEST_TASKS
520: CSACC, JTF_TASKS_B TSKT ,JTF_OBJECT_PURGE_PARAM_TMP TMP WHERE
521: TMP.PROCESSING_SET_ID = P_PROCESSING_SET_ID AND
522: NVL(TMP.PURGE_STATUS, 'S') <> 'E' AND TMP.OBJECT_ID = TSKT.SOURCE_OBJECT_ID
523: AND TMP.OBJECT_TYPE = TSKT.SOURCE_OBJECT_TYPE_CODE AND TSKT.TASK_ID =
524: CSACC.TASK_ID AND CSACC.REQUEST_TASK_ID=CSRR.REQUEST_TASK_ID

Line 532: CSACC , JTF_TASKS_B TSKT , JTF_OBJECT_PURGE_PARAM_TMP TMP WHERE

528: DELETE /*+ index(crrr) */ FROM CSF_R_RESOURCE_RESULTS CRRR
529: WHERE
530: REQUEST_TASK_ID IN ( SELECT /*+ LEADING(TMP) cardinality(TMP, 10) */
531: CSACC.REQUEST_TASK_ID FROM CSF_R_RESOURCE_RESULTS CSRR ,CSF_R_REQUEST_TASKS
532: CSACC , JTF_TASKS_B TSKT , JTF_OBJECT_PURGE_PARAM_TMP TMP WHERE
533: TMP.PROCESSING_SET_ID = P_PROCESSING_SET_ID AND NVL(TMP.PURGE_STATUS, 'S') <> 'E' AND
534: TMP.OBJECT_ID = TSKT.SOURCE_OBJECT_ID AND TMP.OBJECT_TYPE =
535: TSKT.SOURCE_OBJECT_TYPE_CODE AND TSKT.TASK_ID = CSACC.TASK_ID AND
536: CSACC.REQUEST_TASK_ID=CSRR.REQUEST_TASK_ID);

Line 610: , JTF_TASKS_B tskt

606: where object_capacity_id in
607: (select cac.object_capacity_id
608: from
609: cac_sr_object_capacity cac
610: , JTF_TASKS_B tskt
611: , JTF_OBJECT_PURGE_PARAM_TMP tmp
612: , jtf_Task_assignments jtt
613: , jtf_task_statuses_b jtfts
614: WHERE

Line 655: , JTF_TASKS_B tskt

651: cac.object_capacity_id in
652: (select cac.object_capacity_id
653: from
654: cac_sr_object_capacity cac
655: , JTF_TASKS_B tskt
656: , JTF_OBJECT_PURGE_PARAM_TMP tmp
657: , jtf_Task_assignments jtt
658: , jtf_task_statuses_b jtfts
659: WHERE