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.JTF_IH_TOOLS dependencies on JTF_IH_RESULTS_B

Line 73: 'jtf_ih_results_b result, '||

69: END IF;
70: --DBMS_OUTPUT.put_line('p_Wrap_Up_Level '|| p_Wrap_Up_Level);
71:
72: l_Sql := l_Sql||'jtf_ih_outcomes_b outc, '||
73: 'jtf_ih_results_b result, '||
74: 'jtf_ih_reasons_b reason '||
75: 'WHERE tbl.outcome_id = outc.outcome_id AND '||
76: 'tbl.result_id = result.result_id(+) AND '||
77: 'tbl.reason_id = reason.reason_id(+) ';

Line 385: -- in jtf_ih_results_b and is active for the outcome.

381: nCnt := nCnt + 1;
382: end if;
383:
384: -- get all the valid Outcome-Result pairs where the exists
385: -- in jtf_ih_results_b and is active for the outcome.
386: -- loop through the results to create more wrap-ups for this id
387: for curOutRes in (select outres.result_id, res.result_required
388: from jtf_ih_outcome_results outres, jtf_ih_results_b res
389: where outres.outcome_id = curOut.outcome_id and

Line 388: from jtf_ih_outcome_results outres, jtf_ih_results_b res

384: -- get all the valid Outcome-Result pairs where the exists
385: -- in jtf_ih_results_b and is active for the outcome.
386: -- loop through the results to create more wrap-ups for this id
387: for curOutRes in (select outres.result_id, res.result_required
388: from jtf_ih_outcome_results outres, jtf_ih_results_b res
389: where outres.outcome_id = curOut.outcome_id and
390: outres.result_id = res.result_id and
391: (res.active <> 'N' or res.active is null)) loop
392:

Line 474: -- in jtf_ih_results_b and is active for the outcome.

470: nCnt := nCnt + 1;
471: end if;
472:
473: -- get all the valid Outcome-Result pairs where the exists
474: -- in jtf_ih_results_b and is active for the outcome.
475: -- loop through the results to create more wrap-ups for this id
476: for curOutRes in (select outr.result_id, res.result_required
477: from jtf_ih_outcome_results outr, jtf_ih_results_b res
478: where outr.outcome_id = curOut.outcome_id and

Line 477: from jtf_ih_outcome_results outr, jtf_ih_results_b res

473: -- get all the valid Outcome-Result pairs where the exists
474: -- in jtf_ih_results_b and is active for the outcome.
475: -- loop through the results to create more wrap-ups for this id
476: for curOutRes in (select outr.result_id, res.result_required
477: from jtf_ih_outcome_results outr, jtf_ih_results_b res
478: where outr.outcome_id = curOut.outcome_id and
479: outr.result_id = res.result_id and
480: (res.active <> 'N' or res.active is null)) loop
481:

Line 649: UPDATE jtf_ih_results_b SET active='Y' WHERE active IS NULL;

645: dbms_sql.close_cursor(iCursor);
646:
647: -- Enh# 3519691
648: UPDATE jtf_ih_outcomes_b SET active='Y' WHERE active IS NULL;
649: UPDATE jtf_ih_results_b SET active='Y' WHERE active IS NULL;
650: UPDATE jtf_ih_reasons_b SET active='Y' WHERE active IS NULL;
651: UPDATE JTF_IH_OUTCOMES_B set RESULT_REQUIRED = 'N' WHERE RESULT_REQUIRED is NULL;
652: UPDATE JTF_IH_RESULTS_B set RESULT_REQUIRED = 'N' WHERE RESULT_REQUIRED is NULL;
653: COMMIT;

Line 652: UPDATE JTF_IH_RESULTS_B set RESULT_REQUIRED = 'N' WHERE RESULT_REQUIRED is NULL;

648: UPDATE jtf_ih_outcomes_b SET active='Y' WHERE active IS NULL;
649: UPDATE jtf_ih_results_b SET active='Y' WHERE active IS NULL;
650: UPDATE jtf_ih_reasons_b SET active='Y' WHERE active IS NULL;
651: UPDATE JTF_IH_OUTCOMES_B set RESULT_REQUIRED = 'N' WHERE RESULT_REQUIRED is NULL;
652: UPDATE JTF_IH_RESULTS_B set RESULT_REQUIRED = 'N' WHERE RESULT_REQUIRED is NULL;
653: COMMIT;
654:
655: JTF_IH_TOOLS.MIGRATE_IH_WRAPUPS('INTERACTION'); -- Add unique combinations based on jtf_ih_interactions table
656: JTF_IH_TOOLS.MIGRATE_IH_WRAPUPS('ACTIVITY'); -- Add unique combinations based on jtf_ih_activities table