{"id":11364,"date":"2016-06-21T02:11:58","date_gmt":"2016-06-21T01:11:58","guid":{"rendered":"http:\/\/orabr.com\/?p=11364"},"modified":"2016-06-20T22:19:05","modified_gmt":"2016-06-21T01:19:05","slug":"DUVIDA-LIVRO-DE-REGISTRO-DE-INVENTARIO-P7","status":"publish","type":"post","link":"https:\/\/orabr.virttus.com\/?p=11364","title":{"rendered":"D\u00daVIDA: LIVRO DE REGISTRO DE INVENT\u00c1RIO &#8211; P7"},"content":{"rendered":"<p><HTML><HTML><\/p>\n<div>  <span style=\"display:none\">&nbsp;<\/span><!--~-|**|PrettyHtmlStartT|**|-~-->  <\/p>\n<div id=\"ygrp-mlmsg\" style=\"position:relative;\">\n<div id=\"ygrp-msg\" style=\"z-index: 1;\"><!--~-|**|PrettyHtmlEndT|**|-~-->  <\/p>\n<div id=\"ygrp-text\">\n<div dir=\"ltr\">Ol\u00e1 pessoALL,  <\/p>\n<div>  <\/div>\n<div>Estou com o seguinte cen\u00e1rio em um cliente:<\/div>\n<div>  <\/div>\n<div>Vers\u00e3o do Oracle EBS: 11.5.1<\/div>\n<div>Parceiro fiscal: Synchro<\/div>\n<div>  <\/div>\n<div>O consultor Synchro disse que est\u00e1 tentando buscar as informa\u00e7\u00f5es de saldo de estoque na seguinte view:<\/div>\n<div>CAIBR_MTL_PER_CLOSE_DTLS_V<\/div>\n<div>  <\/div>\n<div>Essa view \u00e9 originada de uma \u00fanica tabela: MTL_PER_CLOSE_DTLS.<\/div>\n<div>  <\/div>\n<div>Acontece que essa tabela Oracle est\u00e1 vazia, consequentemente a view tamb\u00e9m est\u00e1 vazia.<\/div>\n<div>  <\/div>\n<div>  <\/div>\n<div>Pergunta: essa \u00e9 a tabela (e a view) correta para buscar essa informa\u00e7\u00e3o? Considerando que o custo utilizado pelo cliente \u00e9 o custo m\u00e9dio transacional (n\u00e3o usa o PAC).<\/div>\n<div>  <\/div>\n<div>Qualquer ajuda ser\u00e1 bem vinda.<\/div>\n<div>  <\/div>\n<div>  <\/div>\n<div>Obrigado,<\/div>\n<div>  <\/div>\n<div>  <\/div>\n<div>Valdemar Soares<\/div>\n<div>(11)96090-5591<\/div>\n<div>Skype: valdemar_soares<\/div>\n<div id=\"DDB4FAA8-2DD7-40BB-A1B8-4E2AA1F9FDF2\">  <\/p>\n<table style=\"border-top: 1px solid #D3D4DE;\">\n<tbody>\n<tr>\n<td style=\"width: 55px;\"><a href=\"https:\/\/www.avast.com\/sig-email?utm_medium=email&amp;utm_source=link&amp;utm_campaign=sig-email&amp;utm_content=webmail\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/ipmcdn.avast.com\/images\/2016\/icons\/icon-envelope-tick-round-orange_184x116-v1.png\" width=\"46\" height=\"29\" style=\"width: 46px;height: 29px;\"><\/a><\/td>\n<td style=\"width: 470px;color: #41424e;font-size: 13px;font-family: Arial, Helvetica, sans-serif;\">  Livre de v\u00edrus. <a href=\"https:\/\/www.avast.com\/sig-email?utm_medium=email&amp;utm_source=link&amp;utm_campaign=sig-email&amp;utm_content=webmail\" target=\"_blank\" style=\"color: #4453ea;\">  www.avast.com<\/a>. <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>  <a href=\"#DDB4FAA8-2DD7-40BB-A1B8-4E2AA1F9FDF2\" width=\"1\" height=\"1\"><\/a><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<p>  <\/HTML><\/HTML><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Ol\u00e1 pessoALL, Estou com o seguinte cen\u00e1rio em um cliente: Vers\u00e3o do Oracle EBS: 11.5.1 Parceiro fiscal: Synchro O consultor Synchro disse que est\u00e1&hellip; <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[56],"tags":[],"class_list":["post-11364","post","type-post","status-publish","format-standard","hentry","category-oracle"],"_links":{"self":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/11364","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=11364"}],"version-history":[{"count":0,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/11364\/revisions"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=11364"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=11364"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=11364"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}