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

104: SELECT 1
105: FROM okc_k_party_roles_b kpr
106: WHERE kpr.jtot_object1_code IN (SELECT ojt.object_code
107: FROM jtf_objects_b ojt
108: ,jtf_object_usages oue
109: WHERE ojt.object_code = oue.object_code
110: AND oue.object_user_code = b_object_use
111: )
112: AND kpr.object1_id1 IN (SELECT to_char(cme.duplicate_id)

Line 128: ,jtf_object_usages oue

124: SELECT 1
125: FROM okc_rules_b rle
126: WHERE rle.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 = b_object_use
131: )
132: AND rle.object1_id1 IN (SELECT to_char(cme.duplicate_id)

Line 145: ,jtf_object_usages oue

141: SELECT 1
142: FROM okc_rules_b rle
143: WHERE rle.jtot_object2_code IN (SELECT ojt.object_code
144: FROM jtf_objects_b ojt
145: ,jtf_object_usages oue
146: WHERE ojt.object_code = oue.object_code
147: AND oue.object_user_code = b_object_use
148: )
149: AND rle.object2_id1 IN (SELECT to_char(cme.duplicate_id)

Line 162: ,jtf_object_usages oue

158: SELECT 1
159: FROM okc_rules_b rle
160: WHERE rle.jtot_object3_code IN (SELECT ojt.object_code
161: FROM jtf_objects_b ojt
162: ,jtf_object_usages oue
163: WHERE ojt.object_code = oue.object_code
164: AND oue.object_user_code = b_object_use
165: )
166: AND rle.object3_id1 IN (SELECT to_char(cme.duplicate_id)

Line 179: ,jtf_object_usages oue

175: SELECT 1
176: FROM okc_k_items cim
177: WHERE cim.jtot_object1_code IN (SELECT ojt.object_code
178: FROM jtf_objects_b ojt
179: ,jtf_object_usages oue
180: WHERE ojt.object_code = oue.object_code
181: AND oue.object_user_code = b_object_use
182: )
183: AND cim.object1_id1 IN (SELECT to_char(cme.duplicate_id)

Line 288: ,jtf_object_usages oue

284: SELECT kpr.dnz_chr_id
285: FROM okc_k_party_roles_b kpr
286: WHERE kpr.jtot_object1_code IN (SELECT ojt.object_code
287: FROM jtf_objects_b ojt
288: ,jtf_object_usages oue
289: WHERE ojt.object_code = oue.object_code
290: AND oue.object_user_code = c_party
291: )
292: AND kpr.object1_id1 = to_char(b_party_id)

Line 647: ,jtf_object_usages oue

643: AND rcm.request_id = req_id
644: AND rcm.set_number = set_number)
645: AND kpr.jtot_object1_code IN (SELECT ojt.object_code
646: FROM jtf_objects_b ojt
647: ,jtf_object_usages oue
648: WHERE ojt.object_code = oue.object_code
649: AND oue.object_user_code = c_account);
650: End If;
651:

Line 672: ,jtf_object_usages oue

668: AND rcm.request_id = req_id
669: AND rcm.set_number = set_number)
670: AND kpr.jtot_object1_code IN (SELECT ojt.object_code
671: FROM jtf_objects_b ojt
672: ,jtf_object_usages oue
673: WHERE ojt.object_code = oue.object_code
674: AND oue.object_user_code = c_account)
675: ;
676: l_count := sql%rowcount;

Line 724: ,jtf_object_usages oue

720: AND rcm.request_id = req_id
721: AND rcm.set_number = set_number)
722: AND rle.jtot_object1_code IN (SELECT ojt.object_code
723: FROM jtf_objects_b ojt
724: ,jtf_object_usages oue
725: WHERE ojt.object_code = oue.object_code
726: AND oue.object_user_code = c_account);
727: End If;
728:

Line 749: ,jtf_object_usages oue

745: AND rcm.request_id = req_id
746: AND rcm.set_number = set_number)
747: AND rle.jtot_object1_code IN (SELECT ojt.object_code
748: FROM jtf_objects_b ojt
749: ,jtf_object_usages oue
750: WHERE ojt.object_code = oue.object_code
751: AND oue.object_user_code = c_account)
752: ;
753: l_count := sql%rowcount;

Line 801: ,jtf_object_usages oue

797: AND rcm.request_id = req_id
798: AND rcm.set_number = set_number)
799: AND rle.jtot_object2_code IN (SELECT ojt.object_code
800: FROM jtf_objects_b ojt
801: ,jtf_object_usages oue
802: WHERE ojt.object_code = oue.object_code
803: AND oue.object_user_code = c_account);
804: End If;
805:

Line 826: ,jtf_object_usages oue

822: AND rcm.request_id = req_id
823: AND rcm.set_number = set_number)
824: AND rle.jtot_object2_code IN (SELECT ojt.object_code
825: FROM jtf_objects_b ojt
826: ,jtf_object_usages oue
827: WHERE ojt.object_code = oue.object_code
828: AND oue.object_user_code = c_account)
829: ;
830: l_count := sql%rowcount;

Line 878: ,jtf_object_usages oue

874: AND rcm.request_id = req_id
875: AND rcm.set_number = set_number)
876: AND rle.jtot_object3_code IN (SELECT ojt.object_code
877: FROM jtf_objects_b ojt
878: ,jtf_object_usages oue
879: WHERE ojt.object_code = oue.object_code
880: AND oue.object_user_code = c_account);
881: End If;
882:

Line 903: ,jtf_object_usages oue

899: AND rcm.request_id = req_id
900: AND rcm.set_number = set_number)
901: AND rle.jtot_object3_code IN (SELECT ojt.object_code
902: FROM jtf_objects_b ojt
903: ,jtf_object_usages oue
904: WHERE ojt.object_code = oue.object_code
905: AND oue.object_user_code = c_account)
906: ;
907: l_count := sql%rowcount;

Line 1177: ,jtf_object_usages oue

1173: AND rcm.request_id = req_id
1174: AND rcm.set_number = set_number)
1175: AND cim.jtot_object1_code IN (SELECT ojt.object_code
1176: FROM jtf_objects_b ojt
1177: ,jtf_object_usages oue
1178: WHERE ojt.object_code = oue.object_code
1179: AND oue.object_user_code = c_account);
1180: End If;
1181:

Line 1202: ,jtf_object_usages oue

1198: AND rcm.request_id = req_id
1199: AND rcm.set_number = set_number)
1200: AND cim.jtot_object1_code IN (SELECT ojt.object_code
1201: FROM jtf_objects_b ojt
1202: ,jtf_object_usages oue
1203: WHERE ojt.object_code = oue.object_code
1204: AND oue.object_user_code = c_account)
1205: ;
1206: l_count := sql%rowcount;

Line 1340: ,jtf_object_usages oue

1336: AND rcm.request_id = req_id
1337: AND rcm.set_number = set_number)
1338: AND rle.jtot_object1_code IN (SELECT ojt.object_code
1339: FROM jtf_objects_b ojt
1340: ,jtf_object_usages oue
1341: WHERE ojt.object_code = oue.object_code
1342: AND oue.object_user_code = c_c_site);
1343: End If;
1344:

Line 1366: ,jtf_object_usages oue

1362: AND rcm.request_id = req_id
1363: AND rcm.set_number = set_number)
1364: AND rle.jtot_object1_code IN (SELECT ojt.object_code
1365: FROM jtf_objects_b ojt
1366: ,jtf_object_usages oue
1367: WHERE ojt.object_code = oue.object_code
1368: AND oue.object_user_code = c_c_site)
1369: ;
1370: l_count := sql%rowcount;

Line 1418: ,jtf_object_usages oue

1414: AND rcm.request_id = req_id
1415: AND rcm.set_number = set_number)
1416: AND rle.jtot_object2_code IN (SELECT ojt.object_code
1417: FROM jtf_objects_b ojt
1418: ,jtf_object_usages oue
1419: WHERE ojt.object_code = oue.object_code
1420: AND oue.object_user_code = c_c_site);
1421: End If;
1422:

Line 1444: ,jtf_object_usages oue

1440: AND rcm.request_id = req_id
1441: AND rcm.set_number = set_number)
1442: AND rle.jtot_object2_code IN (SELECT ojt.object_code
1443: FROM jtf_objects_b ojt
1444: ,jtf_object_usages oue
1445: WHERE ojt.object_code = oue.object_code
1446: AND oue.object_user_code = c_c_site)
1447: ;
1448: l_count := sql%rowcount;

Line 1495: ,jtf_object_usages oue

1491: AND rcm.request_id = req_id
1492: AND rcm.set_number = set_number)
1493: AND rle.jtot_object3_code IN (SELECT ojt.object_code
1494: FROM jtf_objects_b ojt
1495: ,jtf_object_usages oue
1496: WHERE ojt.object_code = oue.object_code
1497: AND oue.object_user_code = c_c_site);
1498: End If;
1499:

Line 1521: ,jtf_object_usages oue

1517: AND rcm.request_id = req_id
1518: AND rcm.set_number = set_number)
1519: AND rle.jtot_object3_code IN (SELECT ojt.object_code
1520: FROM jtf_objects_b ojt
1521: ,jtf_object_usages oue
1522: WHERE ojt.object_code = oue.object_code
1523: AND oue.object_user_code = c_c_site)
1524: ;
1525: l_count := sql%rowcount;

Line 1575: ,jtf_object_usages oue

1571: AND rcm.request_id = req_id
1572: AND rcm.set_number = set_number)
1573: AND cim.jtot_object1_code IN (SELECT ojt.object_code
1574: FROM jtf_objects_b ojt
1575: ,jtf_object_usages oue
1576: WHERE ojt.object_code = oue.object_code
1577: AND oue.object_user_code = c_c_site);
1578: End If;
1579:

Line 1601: ,jtf_object_usages oue

1597: AND rcm.request_id = req_id
1598: AND rcm.set_number = set_number)
1599: AND cim.jtot_object1_code IN (SELECT ojt.object_code
1600: FROM jtf_objects_b ojt
1601: ,jtf_object_usages oue
1602: WHERE ojt.object_code = oue.object_code
1603: AND oue.object_user_code = c_c_site)
1604: ;
1605: l_count := sql%rowcount;

Line 1662: ,jtf_object_usages oue

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

Line 1689: FROM jtf_objects_b ojt,jtf_object_usages oue

1685: WHERE rcm.process_flag = 'N'
1686: AND rcm.request_id = req_id
1687: AND rcm.set_number = set_number)
1688: AND rle.jtot_object1_code IN (SELECT ojt.object_code
1689: FROM jtf_objects_b ojt,jtf_object_usages oue
1690: WHERE ojt.object_code =oue.object_code
1691: AND oue.object_user_code = c_c_site_use)
1692: AND rle.dnz_chr_id in (select k_header_id from oke_k_headers);
1693:

Line 1755: ,jtf_object_usages oue

1751: AND rcm.request_id = req_id
1752: AND rcm.set_number = set_number)
1753: AND rle.jtot_object1_code IN (SELECT ojt.object_code
1754: FROM jtf_objects_b ojt
1755: ,jtf_object_usages oue
1756: WHERE ojt.object_code = oue.object_code
1757: AND oue.object_user_code = c_c_site_use);
1758: End If;
1759:

Line 1780: ,jtf_object_usages oue

1776: AND rcm.request_id = req_id
1777: AND rcm.set_number = set_number)
1778: AND rle.jtot_object1_code IN (SELECT ojt.object_code
1779: FROM jtf_objects_b ojt
1780: ,jtf_object_usages oue
1781: WHERE ojt.object_code = oue.object_code
1782: AND oue.object_user_code = c_c_site_use)
1783: ;
1784: l_count := sql%rowcount;

Line 1831: ,jtf_object_usages oue

1827: AND rcm.request_id = req_id
1828: AND rcm.set_number = set_number)
1829: AND rle.jtot_object2_code IN (SELECT ojt.object_code
1830: FROM jtf_objects_b ojt
1831: ,jtf_object_usages oue
1832: WHERE ojt.object_code = oue.object_code
1833: AND oue.object_user_code = c_c_site_use);
1834: End If;
1835:

Line 1856: ,jtf_object_usages oue

1852: AND rcm.request_id = req_id
1853: AND rcm.set_number = set_number)
1854: AND rle.jtot_object2_code IN (SELECT ojt.object_code
1855: FROM jtf_objects_b ojt
1856: ,jtf_object_usages oue
1857: WHERE ojt.object_code = oue.object_code
1858: AND oue.object_user_code = c_c_site_use)
1859: ;
1860: l_count := sql%rowcount;

Line 1908: ,jtf_object_usages oue

1904: AND rcm.request_id = req_id
1905: AND rcm.set_number = set_number)
1906: AND rle.jtot_object3_code IN (SELECT ojt.object_code
1907: FROM jtf_objects_b ojt
1908: ,jtf_object_usages oue
1909: WHERE ojt.object_code = oue.object_code
1910: AND oue.object_user_code = c_c_site_use);
1911: End If;
1912:

Line 1933: ,jtf_object_usages oue

1929: AND rcm.request_id = req_id
1930: AND rcm.set_number = set_number)
1931: AND rle.jtot_object3_code IN (SELECT ojt.object_code
1932: FROM jtf_objects_b ojt
1933: ,jtf_object_usages oue
1934: WHERE ojt.object_code = oue.object_code
1935: AND oue.object_user_code = c_c_site_use)
1936: ;
1937: l_count := sql%rowcount;

Line 2345: ,jtf_object_usages oue

2341: AND rcm.request_id = req_id
2342: AND rcm.set_number = set_number)
2343: AND cim.jtot_object1_code IN (SELECT ojt.object_code
2344: FROM jtf_objects_b ojt
2345: ,jtf_object_usages oue
2346: WHERE ojt.object_code = oue.object_code
2347: AND oue.object_user_code = c_c_site_use);
2348: End If;
2349:

Line 2370: ,jtf_object_usages oue

2366: AND rcm.request_id = req_id
2367: AND rcm.set_number = set_number)
2368: AND cim.jtot_object1_code IN (SELECT ojt.object_code
2369: FROM jtf_objects_b ojt
2370: ,jtf_object_usages oue
2371: WHERE ojt.object_code = oue.object_code
2372: AND oue.object_user_code = c_c_site_use)
2373: ;
2374: l_count := sql%rowcount;

Line 2474: ,jtf_object_usages oue

2470: SELECT kpr.dnz_chr_id
2471: FROM okc_k_party_roles_b kpr
2472: WHERE kpr.jtot_object1_code IN (SELECT ojt.object_code
2473: FROM jtf_objects_b ojt
2474: ,jtf_object_usages oue
2475: WHERE ojt.object_code = oue.object_code
2476: AND oue.object_user_code = c_party
2477: )
2478: AND kpr.object1_id1 = to_char(b_party_id)

Line 2489: ,jtf_object_usages oue

2485: SELECT cim.dnz_chr_id
2486: FROM okc_k_items cim
2487: WHERE cim.jtot_object1_code IN (SELECT ojt.object_code
2488: FROM jtf_objects_b ojt
2489: ,jtf_object_usages oue
2490: WHERE ojt.object_code = oue.object_code
2491: AND oue.object_user_code = c_party
2492: )
2493: AND cim.object1_id1 = to_char(b_party_id)