{"id":298,"date":"2009-05-06T12:10:44","date_gmt":"2009-05-06T10:10:44","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=298"},"modified":"2009-05-21T13:45:13","modified_gmt":"2009-05-21T11:45:13","slug":"problem-z-roznymi-opisami-indeksow-na-formatce-i-raporcie","status":"publish","type":"post","link":"https:\/\/oracle.malin.pl\/?p=298","title":{"rendered":"Problem z r\u00f3\u017cnymi opisami indeks\u00f3w na formatce i raporcie"},"content":{"rendered":"<p>Wyst\u0119puj\u0105 rozjazdy opisow pomi\u0119dzy tabelami mtl_system_items_b. a tabel\u0105 mtl_system_items_tl.<br \/>\nFormatki pokazuja opisy w z tabel lokalizacyjnych, natomiast raport z mtl_system_items_b.<br \/>\nAktualizacja opisu na formatce rozwi\u0105zuje problem.<\/p>\n<p>Jak powstaj\u0105 rozjazdy&#8230;. na razie nie wiemy.<!--more--><\/p>\n<p>Uwaga na indeksy OPM &#8211; nale\u017cy updatowa\u0107 w OPM z odpowiednim dost\u0119pem do magazyn\u00f3w !!!<\/p>\n<pre lang=\"sql\">select distinct bb.segment1, bb.description \"items_b wrong\", t.description \"items_tl OK\", t.language\r\n\r\n\t\u00a0 from inv.mtl_system_items_b bb, inv.mtl_system_items_tl t\r\n\r\n\t\u00a0where 1=1\r\n\r\n\t\u00a0and bb.description != t.description\r\n\r\n\t\u00a0  and bb.inventory_item_id = t.inventory_item_id\r\n\r\n\t\u00a0  and bb.organization_id = t.organization_id\r\n\r\n\t\u00a0  and t.language in ('PL', 'RO')\r\n\r\nand bb.segment1 in ('73181699-G85-10001042', '73181589-G85-10000822', '73181589-G85-10000539')<\/pre>\n<pre lang=\"sql\"><\/pre>\n<p lang=\"sql\"><font color=\"#999999\">s\u0142owa kluczowe: indeks, index, opis indeksu, pozycja, opis pozycji, opisy indeks\u00f3w <\/font><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Wyst\u0119puj\u0105 rozjazdy opisow pomi\u0119dzy tabelami mtl_system_items_b. a tabel\u0105 mtl_system_items_tl. Formatki pokazuja opisy w z tabel lokalizacyjnych, natomiast raport z mtl_system_items_b. Aktualizacja opisu na formatce rozwi\u0105zuje problem. Jak powstaj\u0105 rozjazdy&#8230;. na razie nie wiemy.<\/p>\n","protected":false},"author":20,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[4,9],"tags":[225,226],"_links":{"self":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/298"}],"collection":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/users\/20"}],"replies":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=298"}],"version-history":[{"count":0,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/298\/revisions"}],"wp:attachment":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=298"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=298"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=298"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}