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_R_REQUEST_TASKS

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 519: CSACTL , CSF_R_RESOURCE_RESULTS CSRR ,CSF_R_REQUEST_TASKS

515: DELETE /*+ index(crso) */ FROM CSF_R_SPARES_OPTIONS CRSO
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 =

Line 531: CSACC.REQUEST_TASK_ID FROM CSF_R_RESOURCE_RESULTS CSRR ,CSF_R_REQUEST_TASKS

527:
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

Line 556: CSF_R_MESSAGES CSRM, CSF_R_REQUEST_TASKS CSACC , CSF_R_SCHED_REQUESTS CSCHR

552: DELETE /*+ index(crmt) */ FROM CSF_R_MESSAGE_TOKENS CRMT
553: WHERE
554: MESSAGE_ID IN ( SELECT /*+ LEADING(TMP) cardinality(TMP, 10) */
555: CSACTL.MESSAGE_ID FROM CSF_R_MESSAGE_TOKENS CSACTL ,
556: CSF_R_MESSAGES CSRM, CSF_R_REQUEST_TASKS CSACC , CSF_R_SCHED_REQUESTS CSCHR
557: WHERE CSCHR.SCHED_REQUEST_ID IN (SELECT T.COLUMN_VALUE FROM TABLE(CAST(L_TAB_SCHED_REQ_ID AS JTF_NUMBER_TABLE)) T) AND
558: --WHERE CSCHR.SCHED_REQUEST_ID = l_tab_sched_req_id(i) AND
559: CSCHR.SCHED_REQUEST_ID = CSACC.SCHED_REQUEST_ID AND
560: CSACC.REQUEST_TASK_ID=CSRM.REQUEST_TASK_ID AND

Line 568: CSF_R_REQUEST_TASKS CSACC , CSF_R_SCHED_REQUESTS CSCHR

564: DELETE /*+ index(crm) */ FROM CSF_R_MESSAGES CRM
565: WHERE
566: REQUEST_TASK_ID IN ( SELECT /*+ LEADING(TMP) cardinality(TMP, 10) */
567: CSACC.REQUEST_TASK_ID FROM CSF_R_MESSAGES CSRM ,
568: CSF_R_REQUEST_TASKS CSACC , CSF_R_SCHED_REQUESTS CSCHR
569: WHERE CSCHR.SCHED_REQUEST_ID IN (SELECT T.COLUMN_VALUE FROM TABLE(CAST(L_TAB_SCHED_REQ_ID AS JTF_NUMBER_TABLE)) T) AND
570: --WHERE CSCHR.SCHED_REQUEST_ID = l_tab_sched_req_id(i) AND
571: CSCHR.SCHED_REQUEST_ID = CSACC.SCHED_REQUEST_ID AND
572: CSACC.REQUEST_TASK_ID=CSRM.REQUEST_TASK_ID);

Line 580: DELETE /+ index(crrt) / FROM CSF_R_REQUEST_TASKS CRRT

576: END IF;
577:
578: /* Step 12 - Delete Request Task */
579: --FORALL i in l_tab_sched_req_id.first..l_tab_sched_req_id.last
580: DELETE /*+ index(crrt) */ FROM CSF_R_REQUEST_TASKS CRRT
581: WHERE
582: REQUEST_TASK_ID IN ( SELECT /*+ LEADING(TMP) cardinality(TMP, 10) */
583: CSACC.REQUEST_TASK_ID FROM CSF_R_REQUEST_TASKS
584: CSACC , CSF_R_SCHED_REQUESTS CSCHR

Line 583: CSACC.REQUEST_TASK_ID FROM CSF_R_REQUEST_TASKS

579: --FORALL i in l_tab_sched_req_id.first..l_tab_sched_req_id.last
580: DELETE /*+ index(crrt) */ FROM CSF_R_REQUEST_TASKS CRRT
581: WHERE
582: REQUEST_TASK_ID IN ( SELECT /*+ LEADING(TMP) cardinality(TMP, 10) */
583: CSACC.REQUEST_TASK_ID FROM CSF_R_REQUEST_TASKS
584: CSACC , CSF_R_SCHED_REQUESTS CSCHR
585: WHERE CSCHR.SCHED_REQUEST_ID IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(l_tab_sched_req_id AS JTF_NUMBER_TABLE)) t) AND
586: --WHERE CSCHR.SCHED_REQUEST_ID = l_tab_sched_req_id(i) AND
587: CSCHR.SCHED_REQUEST_ID = CSACC.SCHED_REQUEST_ID);