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_OBJECT_USAGES

Line 54: -- Following JTF object usages are only applicable if its a Customer Merge

50: --
51: -- OKX_CONTACTS This object is based on a view which returns
52: -- site_use_id as id1.
53: --
54: -- Following JTF object usages are only applicable if its a Customer Merge
55: --
56: -- OKX_ACCOUNT This object is based on a view which returns
57: -- cust_account_id as id1.
58: -- OKX_C_SITE This object is based on a view which returns

Line 128: ,jtf_object_usages oue

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*/
132: and role2.object1_id1 =to_char( p_to_fk_id);

Line 231: ,jtf_object_usages oue

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: --
235: UPDATE okc_k_vers_numbers ver

Line 246: ,jtf_object_usages oue

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:
250: --npalepu added on 10-feb-2006 for bug # 5005475

Line 323: ,jtf_object_usages oue

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:
327: l_count := sql%rowcount;

Line 349: -- ,jtf_object_usages oue

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: --
353: -- Reason: TCA calling routine will pass on the p_from_id as a parameter that holds the

Line 491: ,jtf_object_usages oue

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

Line 610: ,jtf_object_usages oue

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

Line 727: ,jtf_object_usages oue

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

Line 844: ,jtf_object_usages oue

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

Line 958: ,jtf_object_usages oue

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

Line 968: -- ,jtf_object_usages oue

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: --
972: l_count := sql%rowcount;