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_HZ_MERGE_PUB dependencies on JTF_OBJECT_USAGES

Line 101: ,jtf_object_usages oue

97: SELECT 1
98: FROM okc_k_party_roles_b kpr
99: WHERE kpr.jtot_object1_code IN (SELECT ojt.object_code
100: FROM jtf_objects_b ojt
101: ,jtf_object_usages oue
102: WHERE ojt.object_code = oue.object_code
103: AND oue.object_user_code = b_object_use
104: )
105: AND kpr.object1_id1 IN (SELECT to_char(cme.duplicate_id)

Line 121: ,jtf_object_usages oue

117: SELECT 1
118: FROM okc_rules_b rle
119: WHERE rle.jtot_object1_code IN (SELECT ojt.object_code
120: FROM jtf_objects_b ojt
121: ,jtf_object_usages oue
122: WHERE ojt.object_code = oue.object_code
123: AND oue.object_user_code = b_object_use
124: )
125: AND rle.object1_id1 IN (SELECT to_char(cme.duplicate_id)

Line 138: ,jtf_object_usages oue

134: SELECT 1
135: FROM okc_rules_b rle
136: WHERE rle.jtot_object2_code IN (SELECT ojt.object_code
137: FROM jtf_objects_b ojt
138: ,jtf_object_usages oue
139: WHERE ojt.object_code = oue.object_code
140: AND oue.object_user_code = b_object_use
141: )
142: AND rle.object2_id1 IN (SELECT to_char(cme.duplicate_id)

Line 155: ,jtf_object_usages oue

151: SELECT 1
152: FROM okc_rules_b rle
153: WHERE rle.jtot_object3_code IN (SELECT ojt.object_code
154: FROM jtf_objects_b ojt
155: ,jtf_object_usages oue
156: WHERE ojt.object_code = oue.object_code
157: AND oue.object_user_code = b_object_use
158: )
159: AND rle.object3_id1 IN (SELECT to_char(cme.duplicate_id)

Line 172: ,jtf_object_usages oue

168: SELECT 1
169: FROM okc_k_items cim
170: WHERE cim.jtot_object1_code IN (SELECT ojt.object_code
171: FROM jtf_objects_b ojt
172: ,jtf_object_usages oue
173: WHERE ojt.object_code = oue.object_code
174: AND oue.object_user_code = b_object_use
175: )
176: AND cim.object1_id1 IN (SELECT to_char(cme.duplicate_id)

Line 281: ,jtf_object_usages oue

277: SELECT kpr.dnz_chr_id
278: FROM okc_k_party_roles_b kpr
279: WHERE kpr.jtot_object1_code IN (SELECT ojt.object_code
280: FROM jtf_objects_b ojt
281: ,jtf_object_usages oue
282: WHERE ojt.object_code = oue.object_code
283: AND oue.object_user_code = c_party
284: )
285: AND kpr.object1_id1 = to_char(b_party_id)

Line 626: ,jtf_object_usages oue

622: AND rcm.request_id = req_id
623: AND rcm.set_number = set_number)
624: AND kpr.jtot_object1_code IN (SELECT ojt.object_code
625: FROM jtf_objects_b ojt
626: ,jtf_object_usages oue
627: WHERE ojt.object_code = oue.object_code
628: AND oue.object_user_code = c_account);
629: End If;
630:

Line 651: ,jtf_object_usages oue

647: AND rcm.request_id = req_id
648: AND rcm.set_number = set_number)
649: AND kpr.jtot_object1_code IN (SELECT ojt.object_code
650: FROM jtf_objects_b ojt
651: ,jtf_object_usages oue
652: WHERE ojt.object_code = oue.object_code
653: AND oue.object_user_code = c_account)
654: ;
655: l_count := sql%rowcount;

Line 702: ,jtf_object_usages oue

698: AND rcm.request_id = req_id
699: AND rcm.set_number = set_number)
700: AND rle.jtot_object1_code IN (SELECT ojt.object_code
701: FROM jtf_objects_b ojt
702: ,jtf_object_usages oue
703: WHERE ojt.object_code = oue.object_code
704: AND oue.object_user_code = c_account);
705: End If;
706:

Line 727: ,jtf_object_usages oue

723: AND rcm.request_id = req_id
724: AND rcm.set_number = set_number)
725: AND rle.jtot_object1_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 = c_account)
730: ;
731: l_count := sql%rowcount;

Line 779: ,jtf_object_usages oue

775: AND rcm.request_id = req_id
776: AND rcm.set_number = set_number)
777: AND rle.jtot_object2_code IN (SELECT ojt.object_code
778: FROM jtf_objects_b ojt
779: ,jtf_object_usages oue
780: WHERE ojt.object_code = oue.object_code
781: AND oue.object_user_code = c_account);
782: End If;
783:

Line 804: ,jtf_object_usages oue

800: AND rcm.request_id = req_id
801: AND rcm.set_number = set_number)
802: AND rle.jtot_object2_code IN (SELECT ojt.object_code
803: FROM jtf_objects_b ojt
804: ,jtf_object_usages oue
805: WHERE ojt.object_code = oue.object_code
806: AND oue.object_user_code = c_account)
807: ;
808: l_count := sql%rowcount;

Line 856: ,jtf_object_usages oue

852: AND rcm.request_id = req_id
853: AND rcm.set_number = set_number)
854: AND rle.jtot_object3_code IN (SELECT ojt.object_code
855: FROM jtf_objects_b ojt
856: ,jtf_object_usages oue
857: WHERE ojt.object_code = oue.object_code
858: AND oue.object_user_code = c_account);
859: End If;
860:

Line 881: ,jtf_object_usages oue

877: AND rcm.request_id = req_id
878: AND rcm.set_number = set_number)
879: AND rle.jtot_object3_code IN (SELECT ojt.object_code
880: FROM jtf_objects_b ojt
881: ,jtf_object_usages oue
882: WHERE ojt.object_code = oue.object_code
883: AND oue.object_user_code = c_account)
884: ;
885: l_count := sql%rowcount;

Line 1144: ,jtf_object_usages oue

1140: AND rcm.request_id = req_id
1141: AND rcm.set_number = set_number)
1142: AND cim.jtot_object1_code IN (SELECT ojt.object_code
1143: FROM jtf_objects_b ojt
1144: ,jtf_object_usages oue
1145: WHERE ojt.object_code = oue.object_code
1146: AND oue.object_user_code = c_account);
1147: End If;
1148:

Line 1169: ,jtf_object_usages oue

1165: AND rcm.request_id = req_id
1166: AND rcm.set_number = set_number)
1167: AND cim.jtot_object1_code IN (SELECT ojt.object_code
1168: FROM jtf_objects_b ojt
1169: ,jtf_object_usages oue
1170: WHERE ojt.object_code = oue.object_code
1171: AND oue.object_user_code = c_account)
1172: ;
1173: l_count := sql%rowcount;

Line 1243: ,jtf_object_usages oue

1239: AND rcm.request_id = req_id
1240: AND rcm.set_number = set_number)
1241: AND rle.jtot_object1_code IN (SELECT ojt.object_code
1242: FROM jtf_objects_b ojt
1243: ,jtf_object_usages oue
1244: WHERE ojt.object_code = oue.object_code
1245: AND oue.object_user_code = c_c_site);
1246: End If;
1247:

Line 1269: ,jtf_object_usages oue

1265: AND rcm.request_id = req_id
1266: AND rcm.set_number = set_number)
1267: AND rle.jtot_object1_code IN (SELECT ojt.object_code
1268: FROM jtf_objects_b ojt
1269: ,jtf_object_usages oue
1270: WHERE ojt.object_code = oue.object_code
1271: AND oue.object_user_code = c_c_site)
1272: ;
1273: l_count := sql%rowcount;

Line 1321: ,jtf_object_usages oue

1317: AND rcm.request_id = req_id
1318: AND rcm.set_number = set_number)
1319: AND rle.jtot_object2_code IN (SELECT ojt.object_code
1320: FROM jtf_objects_b ojt
1321: ,jtf_object_usages oue
1322: WHERE ojt.object_code = oue.object_code
1323: AND oue.object_user_code = c_c_site);
1324: End If;
1325:

Line 1347: ,jtf_object_usages oue

1343: AND rcm.request_id = req_id
1344: AND rcm.set_number = set_number)
1345: AND rle.jtot_object2_code IN (SELECT ojt.object_code
1346: FROM jtf_objects_b ojt
1347: ,jtf_object_usages oue
1348: WHERE ojt.object_code = oue.object_code
1349: AND oue.object_user_code = c_c_site)
1350: ;
1351: l_count := sql%rowcount;

Line 1398: ,jtf_object_usages oue

1394: AND rcm.request_id = req_id
1395: AND rcm.set_number = set_number)
1396: AND rle.jtot_object3_code IN (SELECT ojt.object_code
1397: FROM jtf_objects_b ojt
1398: ,jtf_object_usages oue
1399: WHERE ojt.object_code = oue.object_code
1400: AND oue.object_user_code = c_c_site);
1401: End If;
1402:

Line 1424: ,jtf_object_usages oue

1420: AND rcm.request_id = req_id
1421: AND rcm.set_number = set_number)
1422: AND rle.jtot_object3_code IN (SELECT ojt.object_code
1423: FROM jtf_objects_b ojt
1424: ,jtf_object_usages oue
1425: WHERE ojt.object_code = oue.object_code
1426: AND oue.object_user_code = c_c_site)
1427: ;
1428: l_count := sql%rowcount;

Line 1478: ,jtf_object_usages oue

1474: AND rcm.request_id = req_id
1475: AND rcm.set_number = set_number)
1476: AND cim.jtot_object1_code IN (SELECT ojt.object_code
1477: FROM jtf_objects_b ojt
1478: ,jtf_object_usages oue
1479: WHERE ojt.object_code = oue.object_code
1480: AND oue.object_user_code = c_c_site);
1481: End If;
1482:

Line 1504: ,jtf_object_usages oue

1500: AND rcm.request_id = req_id
1501: AND rcm.set_number = set_number)
1502: AND cim.jtot_object1_code IN (SELECT ojt.object_code
1503: FROM jtf_objects_b ojt
1504: ,jtf_object_usages oue
1505: WHERE ojt.object_code = oue.object_code
1506: AND oue.object_user_code = c_c_site)
1507: ;
1508: l_count := sql%rowcount;

Line 1565: ,jtf_object_usages oue

1561: AND rcm.request_id = req_id
1562: AND rcm.set_number = set_number)
1563: AND rle.jtot_object1_code IN (SELECT ojt.object_code
1564: FROM jtf_objects_b ojt
1565: ,jtf_object_usages oue
1566: WHERE ojt.object_code = oue.object_code
1567: AND oue.object_user_code = c_c_site_use);
1568: End If;
1569:

Line 1592: FROM jtf_objects_b ojt,jtf_object_usages oue

1588: WHERE rcm.process_flag = 'N'
1589: AND rcm.request_id = req_id
1590: AND rcm.set_number = set_number)
1591: AND rle.jtot_object1_code IN (SELECT ojt.object_code
1592: FROM jtf_objects_b ojt,jtf_object_usages oue
1593: WHERE ojt.object_code =oue.object_code
1594: AND oue.object_user_code = c_c_site_use)
1595: AND rle.dnz_chr_id in (select k_header_id from oke_k_headers);
1596:

Line 1658: ,jtf_object_usages oue

1654: AND rcm.request_id = req_id
1655: AND rcm.set_number = set_number)
1656: AND rle.jtot_object1_code IN (SELECT ojt.object_code
1657: FROM jtf_objects_b ojt
1658: ,jtf_object_usages oue
1659: WHERE ojt.object_code = oue.object_code
1660: AND oue.object_user_code = c_c_site_use);
1661: End If;
1662:

Line 1683: ,jtf_object_usages oue

1679: AND rcm.request_id = req_id
1680: AND rcm.set_number = set_number)
1681: AND rle.jtot_object1_code IN (SELECT ojt.object_code
1682: FROM jtf_objects_b ojt
1683: ,jtf_object_usages oue
1684: WHERE ojt.object_code = oue.object_code
1685: AND oue.object_user_code = c_c_site_use)
1686: ;
1687: l_count := sql%rowcount;

Line 1734: ,jtf_object_usages oue

1730: AND rcm.request_id = req_id
1731: AND rcm.set_number = set_number)
1732: AND rle.jtot_object2_code IN (SELECT ojt.object_code
1733: FROM jtf_objects_b ojt
1734: ,jtf_object_usages oue
1735: WHERE ojt.object_code = oue.object_code
1736: AND oue.object_user_code = c_c_site_use);
1737: End If;
1738:

Line 1759: ,jtf_object_usages oue

1755: AND rcm.request_id = req_id
1756: AND rcm.set_number = set_number)
1757: AND rle.jtot_object2_code IN (SELECT ojt.object_code
1758: FROM jtf_objects_b ojt
1759: ,jtf_object_usages oue
1760: WHERE ojt.object_code = oue.object_code
1761: AND oue.object_user_code = c_c_site_use)
1762: ;
1763: l_count := sql%rowcount;

Line 1811: ,jtf_object_usages oue

1807: AND rcm.request_id = req_id
1808: AND rcm.set_number = set_number)
1809: AND rle.jtot_object3_code IN (SELECT ojt.object_code
1810: FROM jtf_objects_b ojt
1811: ,jtf_object_usages oue
1812: WHERE ojt.object_code = oue.object_code
1813: AND oue.object_user_code = c_c_site_use);
1814: End If;
1815:

Line 1836: ,jtf_object_usages oue

1832: AND rcm.request_id = req_id
1833: AND rcm.set_number = set_number)
1834: AND rle.jtot_object3_code IN (SELECT ojt.object_code
1835: FROM jtf_objects_b ojt
1836: ,jtf_object_usages oue
1837: WHERE ojt.object_code = oue.object_code
1838: AND oue.object_user_code = c_c_site_use)
1839: ;
1840: l_count := sql%rowcount;

Line 2235: ,jtf_object_usages oue

2231: AND rcm.request_id = req_id
2232: AND rcm.set_number = set_number)
2233: AND cim.jtot_object1_code IN (SELECT ojt.object_code
2234: FROM jtf_objects_b ojt
2235: ,jtf_object_usages oue
2236: WHERE ojt.object_code = oue.object_code
2237: AND oue.object_user_code = c_c_site_use);
2238: End If;
2239:

Line 2260: ,jtf_object_usages oue

2256: AND rcm.request_id = req_id
2257: AND rcm.set_number = set_number)
2258: AND cim.jtot_object1_code IN (SELECT ojt.object_code
2259: FROM jtf_objects_b ojt
2260: ,jtf_object_usages oue
2261: WHERE ojt.object_code = oue.object_code
2262: AND oue.object_user_code = c_c_site_use)
2263: ;
2264: l_count := sql%rowcount;

Line 2323: ,jtf_object_usages oue

2319: SELECT kpr.dnz_chr_id
2320: FROM okc_k_party_roles_b kpr
2321: WHERE kpr.jtot_object1_code IN (SELECT ojt.object_code
2322: FROM jtf_objects_b ojt
2323: ,jtf_object_usages oue
2324: WHERE ojt.object_code = oue.object_code
2325: AND oue.object_user_code = c_party
2326: )
2327: AND kpr.object1_id1 = to_char(b_party_id)

Line 2338: ,jtf_object_usages oue

2334: SELECT cim.dnz_chr_id
2335: FROM okc_k_items cim
2336: WHERE cim.jtot_object1_code IN (SELECT ojt.object_code
2337: FROM jtf_objects_b ojt
2338: ,jtf_object_usages oue
2339: WHERE ojt.object_code = oue.object_code
2340: AND oue.object_user_code = c_party
2341: )
2342: AND cim.object1_id1 = to_char(b_party_id)