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_OBJECTS_B

Line 107: FROM jtf_objects_b ojt

103: CURSOR c_lock_kpr(b_object_use VARCHAR2) IS
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: )

Line 127: FROM jtf_objects_b ojt

123: CURSOR c_lock_rle1(b_object_use VARCHAR2) IS
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: )

Line 144: FROM jtf_objects_b ojt

140: CURSOR c_lock_rle2(b_object_use VARCHAR2) IS
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: )

Line 161: FROM jtf_objects_b ojt

157: CURSOR c_lock_rle3(b_object_use VARCHAR2) IS
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: )

Line 178: FROM jtf_objects_b ojt

174: CURSOR c_lock_cim(b_object_use VARCHAR2) IS
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: )

Line 287: FROM jtf_objects_b ojt

283: CURSOR c_cpr (b_party_id NUMBER) IS
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: )

Line 646: FROM jtf_objects_b ojt

642: WHERE rcm.process_flag = 'N'
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;

Line 671: FROM jtf_objects_b ojt

667: WHERE rcm.process_flag = 'N'
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: ;

Line 723: FROM jtf_objects_b ojt

719: WHERE rcm.process_flag = 'N'
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;

Line 748: FROM jtf_objects_b ojt

744: WHERE rcm.process_flag = 'N'
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: ;

Line 800: FROM jtf_objects_b ojt

796: WHERE rcm.process_flag = 'N'
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;

Line 825: FROM jtf_objects_b ojt

821: WHERE rcm.process_flag = 'N'
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: ;

Line 877: FROM jtf_objects_b ojt

873: WHERE rcm.process_flag = 'N'
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;

Line 902: FROM jtf_objects_b ojt

898: WHERE rcm.process_flag = 'N'
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: ;

Line 1176: FROM jtf_objects_b ojt

1172: WHERE rcm.process_flag = 'N'
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;

Line 1201: FROM jtf_objects_b ojt

1197: WHERE rcm.process_flag = 'N'
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: ;

Line 1339: FROM jtf_objects_b ojt

1335: WHERE rcm.process_flag = 'N'
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;

Line 1365: FROM jtf_objects_b ojt

1361: WHERE rcm.process_flag = 'N'
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: ;

Line 1417: FROM jtf_objects_b ojt

1413: WHERE rcm.process_flag = 'N'
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;

Line 1443: FROM jtf_objects_b ojt

1439: WHERE rcm.process_flag = 'N'
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: ;

Line 1494: FROM jtf_objects_b ojt

1490: WHERE rcm.process_flag = 'N'
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;

Line 1520: FROM jtf_objects_b ojt

1516: WHERE rcm.process_flag = 'N'
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: ;

Line 1574: FROM jtf_objects_b ojt

1570: WHERE rcm.process_flag = 'N'
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;

Line 1600: FROM jtf_objects_b ojt

1596: WHERE rcm.process_flag = 'N'
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: ;

Line 1661: FROM jtf_objects_b ojt

1657: WHERE rcm.process_flag = 'N'
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;

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

1750: WHERE rcm.process_flag = 'N'
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;

Line 1779: FROM jtf_objects_b ojt

1775: WHERE rcm.process_flag = 'N'
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: ;

Line 1830: FROM jtf_objects_b ojt

1826: WHERE rcm.process_flag = 'N'
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;

Line 1855: FROM jtf_objects_b ojt

1851: WHERE rcm.process_flag = 'N'
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: ;

Line 1907: FROM jtf_objects_b ojt

1903: WHERE rcm.process_flag = 'N'
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;

Line 1932: FROM jtf_objects_b ojt

1928: WHERE rcm.process_flag = 'N'
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: ;

Line 2344: FROM jtf_objects_b ojt

2340: WHERE rcm.process_flag = 'N'
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;

Line 2369: FROM jtf_objects_b ojt

2365: WHERE rcm.process_flag = 'N'
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: ;

Line 2473: FROM jtf_objects_b ojt

2469: CURSOR c_cpr (b_party_id NUMBER) IS
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: )

Line 2488: FROM jtf_objects_b ojt

2484: CURSOR c_cim (b_party_id NUMBER) IS
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: )