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_REASONS_B

Line 74: 'jtf_ih_reasons_b reason '||

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(+) ';
78:

Line 409: -- and result_id that exist in the jtf_ih_reasons_b table

405: nCnt := nCnt + 1;
406: end if;
407:
408: -- add all valid active reasons for the current outcome_id
409: -- and result_id that exist in the jtf_ih_reasons_b table
410: for curResRea in (select rr.reason_id
411: from jtf_ih_result_reasons rr, jtf_ih_reasons_b rea
412: where rr.result_id = curOutRes.result_id and
413: rr.reason_id = rea.reason_id and

Line 411: from jtf_ih_result_reasons rr, jtf_ih_reasons_b rea

407:
408: -- add all valid active reasons for the current outcome_id
409: -- and result_id that exist in the jtf_ih_reasons_b table
410: for curResRea in (select rr.reason_id
411: from jtf_ih_result_reasons rr, jtf_ih_reasons_b rea
412: where rr.result_id = curOutRes.result_id and
413: rr.reason_id = rea.reason_id and
414: ( rea.active <> 'N' or rea.active is null)) loop
415:

Line 498: -- result_id that exist in the jtf_ih_reasons_b table

494: nCnt := nCnt + 1;
495: end if;
496:
497: -- add all valid active reasons for the current outcome_id and
498: -- result_id that exist in the jtf_ih_reasons_b table
499: for curResRea in (select rr.reason_id from jtf_ih_result_reasons rr,
500: jtf_ih_reasons_b rea
501: where rr.result_id = curOutRes.result_id and
502: rr.reason_id = rea.reason_id and

Line 500: jtf_ih_reasons_b rea

496:
497: -- add all valid active reasons for the current outcome_id and
498: -- result_id that exist in the jtf_ih_reasons_b table
499: for curResRea in (select rr.reason_id from jtf_ih_result_reasons rr,
500: jtf_ih_reasons_b rea
501: where rr.result_id = curOutRes.result_id and
502: rr.reason_id = rea.reason_id and
503: (rea.active <> 'N' or rea.active is null)) loop
504: ttWrpUps(nCnt).Outcome_Id := curOut.outcome_id;

Line 650: UPDATE jtf_ih_reasons_b SET active='Y' WHERE active IS NULL;

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;
654: