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.OKC_PARTY_MERGE_PUB dependencies on JTF_OBJECTS_B

Line 127: FROM jtf_objects_b ojt

123: where role1.cle_id = role2.cle_id
124: and role1.rle_code = role2.rle_code
125: and role1.jtot_object1_code = role2.jtot_object1_code
126: and role1.jtot_object1_code IN (SELECT ojt.object_code
127: FROM jtf_objects_b ojt
128: ,jtf_object_usages oue
129: WHERE ojt.object_code = oue.object_code
130: AND oue.object_user_code = l_object_user_code)
131: and role1.object1_id1 = to_char( p_from_fk_id) /*added to_char() for bug7655288*/

Line 230: FROM jtf_objects_b ojt

226: from okc_k_party_roles_b kpr
227: where kpr.object1_id1 = to_char(p_from_fk_id)
228: AND kpr.jtot_object1_code IN
229: (SELECT ojt.object_code
230: FROM jtf_objects_b ojt
231: ,jtf_object_usages oue
232: WHERE ojt.object_code = oue.object_code
233: AND oue.object_user_code = l_object_user_code)));
234: --

Line 245: FROM jtf_objects_b ojt

241: WHERE chr_id IN (select dnz_chr_id
242: from okc_k_party_roles_b kpr
243: where kpr.object1_id1 = to_char(p_from_fk_id) -- added for Bug 3611998
244: AND kpr.jtot_object1_code IN (SELECT ojt.object_code
245: FROM jtf_objects_b ojt
246: ,jtf_object_usages oue
247: WHERE ojt.object_code = oue.object_code
248: AND oue.object_user_code = l_object_user_code));
249:

Line 322: FROM jtf_objects_b ojt

318: ,kpr.last_updated_by = nvl(fnd_global.user_id, -1)
319: ,kpr.last_update_login = fnd_global.conc_login_id
320: WHERE kpr.object1_id1 = to_char(p_from_fk_id)
321: AND kpr.jtot_object1_code IN (SELECT ojt.object_code
322: FROM jtf_objects_b ojt
323: ,jtf_object_usages oue
324: WHERE ojt.object_code = oue.object_code
325: AND oue.object_user_code = l_object_user_code) ;
326:

Line 348: -- FROM jtf_objects_b ojt

344: -- Following where clause removed after update from TCA (02/09/2001)
345: --
346: -- WHERE kpr.object1_id1 = p_from_fk_id
347: -- AND kpr.jtot_object1_code IN (SELECT ojt.object_code
348: -- FROM jtf_objects_b ojt
349: -- ,jtf_object_usages oue
350: -- WHERE ojt.object_code = oue.object_code
351: -- AND oue.object_user_code = l_object_user_code)
352: --

Line 490: FROM jtf_objects_b ojt

486: ,rle.last_update_login = fnd_global.conc_login_id
487: -- WHERE rle.object1_id1 = p_from_fk_id
488: WHERE rle.object1_id1 = to_char(p_from_fk_id) -- for Bug# 6896186
489: AND rle.jtot_object1_code IN (SELECT ojt.object_code
490: FROM jtf_objects_b ojt
491: ,jtf_object_usages oue
492: WHERE ojt.object_code = oue.object_code
493: AND oue.object_user_code = l_object_user_code)
494: ;

Line 609: FROM jtf_objects_b ojt

605: ,rle.last_update_login = fnd_global.conc_login_id
606: -- WHERE rle.object2_id1 = p_from_fk_id
607: WHERE rle.object2_id1 = to_char(p_from_fk_id) -- For Bug# 6896186
608: AND rle.jtot_object2_code IN (SELECT ojt.object_code
609: FROM jtf_objects_b ojt
610: ,jtf_object_usages oue
611: WHERE ojt.object_code = oue.object_code
612: AND oue.object_user_code = l_object_user_code)
613: ;

Line 726: FROM jtf_objects_b ojt

722: ,rle.last_update_login = fnd_global.conc_login_id
723: -- WHERE rle.object3_id1 = p_from_fk_id
724: WHERE rle.object3_id1 = to_char(p_from_fk_id) -- For Bug# 6896186
725: AND rle.jtot_object3_code IN (SELECT ojt.object_code
726: FROM jtf_objects_b ojt
727: ,jtf_object_usages oue
728: WHERE ojt.object_code = oue.object_code
729: AND oue.object_user_code = l_object_user_code)
730: ;

Line 843: FROM jtf_objects_b ojt

839: ,cim.last_updated_by = nvl(fnd_global.user_id, -1)
840: ,cim.last_update_login = fnd_global.conc_login_id
841: WHERE cim.object1_id1 = p_from_fk_id
842: AND cim.jtot_object1_code IN (SELECT ojt.object_code
843: FROM jtf_objects_b ojt
844: ,jtf_object_usages oue
845: WHERE ojt.object_code = oue.object_code
846: AND oue.object_user_code = l_object_user_code)
847: ;

Line 957: FROM jtf_objects_b ojt

953: ,ctc.last_updated_by = nvl(fnd_global.user_id, -1)
954: ,ctc.last_update_login = fnd_global.conc_login_id
955: WHERE ctc.object1_id1 = to_char(p_from_fk_id)
956: AND ctc.jtot_object1_code IN (SELECT ojt.object_code
957: FROM jtf_objects_b ojt
958: ,jtf_object_usages oue
959: WHERE ojt.object_code = oue.object_code
960: AND oue.object_user_code = l_object_user_code)
961: ;

Line 967: -- FROM jtf_objects_b ojt

963: -- Following where clause removed after update from TCA (02/09/2001)
964: --
965: --WHERE ctc.object1_id1 = p_from_fk_id
966: --AND ctc.jtot_object1_code IN (SELECT ojt.object_code
967: -- FROM jtf_objects_b ojt
968: -- ,jtf_object_usages oue
969: -- WHERE ojt.object_code = oue.object_code
970: -- AND oue.object_user_code = l_object_user_code)
971: --