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 CSF_DEBRIEF_HEADERS

Line 276: JTF_NOTES_B JTFNB , CSF_DEBRIEF_HEADERS DBFH , JTF_TASK_ASSIGNMENTS TSKA ,

272: DELETE /*+ index(jnc) */ FROM JTF_NOTE_CONTEXTS JNC
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

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 326: CSF_DEBRIEF_HEADERS DBFH ,

322: WHERE DEBRIEF_LINE_ID IN
323: ( SELECT /*+ LEADING(TMP) cardinality(TMP, 10)*/
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

Line 344: DELETE /+ index(cdh) / FROM CSF_DEBRIEF_HEADERS CDH

340: END IF;
341:
342:
343: /* Step 3 - Delete relevant debrief headers*/
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 ,

Line 347: DBFH.DEBRIEF_HEADER_ID FROM CSF_DEBRIEF_HEADERS

343: /* Step 3 - Delete relevant debrief headers*/
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 =