{"id":2144,"date":"2014-10-30T15:03:23","date_gmt":"2014-10-30T18:03:23","guid":{"rendered":"http:\/\/www.juniovitor.com\/?p=2144"},"modified":"2024-10-30T16:57:48","modified_gmt":"2024-10-30T19:57:48","slug":"resumo-tabelas-views-do-inventario-inv","status":"publish","type":"post","link":"https:\/\/www.juniovitor.com\/?p=2144","title":{"rendered":"Resumo Tabelas\/Views do Invent\u00e1rio (INV)"},"content":{"rendered":"<p>Boa tarde!<\/p>\n<p>Segue breve resumo da lista tabelas Invent\u00e1rio:<\/p>\n<p><strong>ORG_ORGANIZATION_DEFINITIONS<\/strong><br \/>\n * Organiza\u00e7\u00e3o de Invent\u00e1rio por Entidade Legal e Unidade Operacional.<\/p>\n<p><strong>HR_LOCATIONS_V<\/strong><br \/>\n * Locais por Organiza\u00e7\u00e3o de Invent\u00e1rio.<\/p>\n<p><strong>MTL_CROSS_REFERENCES_V<\/strong><br \/>\n * Refer\u00eancia Cruzada por Item e Organiza\u00e7\u00e3o de Invent\u00e1rio.<\/p>\n<p><strong>MTL_ITEM_CATEGORIES_V<\/strong><br \/>\n * Combina\u00e7\u00e3o de Categoria por Item e Organiza\u00e7\u00e3o de Invent\u00e1rio.<\/p>\n<p><strong>MTL_ITEM_ORG_CATEG_V<\/strong><br \/>\n * Combina\u00e7\u00e3o de Categoria por Item, Organiza\u00e7\u00e3o de Invent\u00e1rio e Organiza\u00e7\u00e3o Mestre.<\/p>\n<p><strong>MTL_ITEM_LOCATIONS_KFV<\/strong><br \/>\n * Almoxarifado e Endere\u00e7o de Estoque por Organiza\u00e7\u00e3o de Invent\u00e1rio.<\/p>\n<p><strong>MTL_UNITS_OF_MEASURE_VV<\/strong><br \/>\n * Unidades de Medida por Classe.<\/p>\n<p><strong>MTL_SYSTEM_ITEMS_B_KFV<\/strong><br \/>\n * Item por Organiza\u00e7\u00e3o de Invent\u00e1rio.<\/p>\n<p><strong>MTL_TRANSACTIONS_INTERFACE_V<\/strong><br \/>\n * Interface Aberta de Movimenta\u00e7\u00e3o de Estoque.<\/p>\n<p><strong>MTL_MATERIAL_TXNS_VAL_V<\/strong><br \/>\n * Movimenta\u00e7\u00e3o de Estoque.<\/p>\n<p><strong>MTL_TRANSACTION_LOT_VAL_V<\/strong><br \/>\n * N\u00famero de Lote Utilizado na Movimenta\u00e7\u00e3o de Estoque.<\/p>\n<p><strong>MTL_UNIT_TRANSACTIONS_ALL_V<\/strong><br \/>\n * Numero de S\u00e9rie Utilizado na Movimenta\u00e7\u00e3o de Estoque.<\/p>\n<p><strong>CST_INV_DISTRIBUTION_V<\/strong><br \/>\n * Distribui\u00e7\u00e3o Cont\u00e1bil Gerada na Movimenta\u00e7\u00e3o de Estoque.<\/p>\n<p><strong>GL_CODE_COMBINATIONS_KFV<\/strong><br \/>\n * Combina\u00e7\u00f5es Cont\u00e1beis por Char Of Accounts.<\/p>\n<p><strong>CST_ITEM_COST_TYPE_V<\/strong><br \/>\n * M\u00e9todo de Custeio e Custo do Item por Organiza\u00e7\u00e3o de Invent\u00e1rio.<\/p>\n<p><strong>MTL_ONHAND_ITEMS_V<\/strong><br \/>\n * Saldo em Estoque por Item e Organiza\u00e7\u00e3o de Invent\u00e1rio.<\/p>\n<p><strong>MTL_ONHAND_SUB_V<\/strong><br \/>\n * Saldo em Estoque por Item, Organiza\u00e7\u00e3o de Invent\u00e1rio e Almoxarifado.<\/p>\n<p><strong>MTL_ONHAND_LOCATOR_V<\/strong><br \/>\n * Saldo em Estoque por Item, Organiza\u00e7\u00e3o de Invent\u00e1rio, Almoxarifado e Endere\u00e7o de Estoque.<\/p>\n<p><strong>MTL_ONHAND_TOTAL_V<\/strong><br \/>\n * Saldo em Estoque por Item, Organiza\u00e7\u00e3o de Invent\u00e1rio, Almoxarifado, Endere\u00e7o de Estoque, Lote e N\u00famero de S\u00e9rie.<\/p>\n<p>Abs,<br \/>\nJunio Vitor<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Boa tarde! Segue breve resumo da lista tabelas Invent\u00e1rio: ORG_ORGANIZATION_DEFINITIONS * Organiza\u00e7\u00e3o de Invent\u00e1rio por Entidade Legal e Unidade Operacional. HR_LOCATIONS_V * [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[877,879,885,883,882,887,878,880,884,876,886,881],"class_list":["post-2144","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-inv-tables","tag-inventario","tag-inventory-tables-description","tag-iv-oracle","tag-oracle-inv","tag-oracle-inventario","tag-oracle-inventory","tag-oracle-tables","tag-overvire-tables-inv","tag-resumo-tabelas-views-do-inventario-inv","tag-tabelas-inventario","tag-tables-oracle"],"_links":{"self":[{"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/posts\/2144"}],"collection":[{"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2144"}],"version-history":[{"count":1,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/posts\/2144\/revisions"}],"predecessor-version":[{"id":2145,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/posts\/2144\/revisions\/2145"}],"wp:attachment":[{"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2144"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2144"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2144"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}