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 126: FROM jtf_objects_b ojt

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

Line 229: FROM jtf_objects_b ojt

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

Line 244: FROM jtf_objects_b ojt

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

Line 321: FROM jtf_objects_b ojt

317: ,kpr.last_updated_by = arp_standard.profile.user_id
318: ,kpr.last_update_login = arp_standard.profile.last_update_login
319: WHERE kpr.object1_id1 = to_char(p_from_fk_id)
320: AND kpr.jtot_object1_code IN (SELECT ojt.object_code
321: FROM jtf_objects_b ojt
322: ,jtf_object_usages oue
323: WHERE ojt.object_code = oue.object_code
324: AND oue.object_user_code = l_object_user_code) ;
325:

Line 347: -- FROM jtf_objects_b ojt

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

Line 475: FROM jtf_objects_b ojt

471: ,rle.last_update_login = arp_standard.profile.last_update_login
472: -- WHERE rle.object1_id1 = p_from_fk_id
473: WHERE rle.object1_id1 = to_char(p_from_fk_id) -- for Bug# 6896186
474: AND rle.jtot_object1_code IN (SELECT ojt.object_code
475: FROM jtf_objects_b ojt
476: ,jtf_object_usages oue
477: WHERE ojt.object_code = oue.object_code
478: AND oue.object_user_code = l_object_user_code)
479: ;

Line 594: FROM jtf_objects_b ojt

590: ,rle.last_update_login = arp_standard.profile.last_update_login
591: -- WHERE rle.object2_id1 = p_from_fk_id
592: WHERE rle.object2_id1 = to_char(p_from_fk_id) -- For Bug# 6896186
593: AND rle.jtot_object2_code IN (SELECT ojt.object_code
594: FROM jtf_objects_b ojt
595: ,jtf_object_usages oue
596: WHERE ojt.object_code = oue.object_code
597: AND oue.object_user_code = l_object_user_code)
598: ;

Line 711: FROM jtf_objects_b ojt

707: ,rle.last_update_login = arp_standard.profile.last_update_login
708: -- WHERE rle.object3_id1 = p_from_fk_id
709: WHERE rle.object3_id1 = to_char(p_from_fk_id) -- For Bug# 6896186
710: AND rle.jtot_object3_code IN (SELECT ojt.object_code
711: FROM jtf_objects_b ojt
712: ,jtf_object_usages oue
713: WHERE ojt.object_code = oue.object_code
714: AND oue.object_user_code = l_object_user_code)
715: ;

Line 828: FROM jtf_objects_b ojt

824: ,cim.last_updated_by = arp_standard.profile.user_id
825: ,cim.last_update_login = arp_standard.profile.last_update_login
826: WHERE cim.object1_id1 = p_from_fk_id
827: AND cim.jtot_object1_code IN (SELECT ojt.object_code
828: FROM jtf_objects_b ojt
829: ,jtf_object_usages oue
830: WHERE ojt.object_code = oue.object_code
831: AND oue.object_user_code = l_object_user_code)
832: ;

Line 942: FROM jtf_objects_b ojt

938: ,ctc.last_updated_by = arp_standard.profile.user_id
939: ,ctc.last_update_login = arp_standard.profile.last_update_login
940: WHERE ctc.object1_id1 = to_char(p_from_fk_id)
941: AND ctc.jtot_object1_code IN (SELECT ojt.object_code
942: FROM jtf_objects_b ojt
943: ,jtf_object_usages oue
944: WHERE ojt.object_code = oue.object_code
945: AND oue.object_user_code = l_object_user_code)
946: ;

Line 952: -- FROM jtf_objects_b ojt

948: -- Following where clause removed after update from TCA (02/09/2001)
949: --
950: --WHERE ctc.object1_id1 = p_from_fk_id
951: --AND ctc.jtot_object1_code IN (SELECT ojt.object_code
952: -- FROM jtf_objects_b ojt
953: -- ,jtf_object_usages oue
954: -- WHERE ojt.object_code = oue.object_code
955: -- AND oue.object_user_code = l_object_user_code)
956: --