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 127: ,jtf_object_usages oue

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
131: and role2.object1_id1 = p_to_fk_id;

Line 230: ,jtf_object_usages oue

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

Line 245: ,jtf_object_usages oue

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

Line 322: ,jtf_object_usages oue

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

Line 348: -- ,jtf_object_usages oue

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

Line 476: ,jtf_object_usages oue

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

Line 595: ,jtf_object_usages oue

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

Line 712: ,jtf_object_usages oue

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

Line 829: ,jtf_object_usages oue

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

Line 943: ,jtf_object_usages oue

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

Line 953: -- ,jtf_object_usages oue

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