Como obter um valor total em uma ordem de compra padr\u00e3o?<\/p>\n
A Oracle fornece algumas API para obter o valor total em uma ordem de compra padr\u00e3o. Usando esta API, voc\u00ea n\u00e3o precisa se preocupar com o c\u00e1lculo da Quantidade x Pre\u00e7o da Unidade e o que precisa ser exclu\u00eddo do c\u00e1lculo.<\/p>\n
Para obter o montante total da revis\u00e3o atual da Ordem de Compra Padr\u00e3o<\/p>\n
—–
\nDECLARE
\nl_total\u00a0 NUMBER := 0;
\nBEGIN
\nl_total := po_core_s.get_total(‘H’, :p_po_header_id);
\ndbms_output.put_line(‘PO Total Amount:’||l_total);
\nEND;
\n—–<\/p>\n
Para obter o montante total de quaisquer revis\u00f5es anteriores da Ordem de Compra Padr\u00e3o, use a seguinte API.
\n—–
\nDECLARE
\nl_total\u00a0\u00a0 NUMBER := 0;
\nBEGIN
\nl_total := po_core_s.get_archive_total_for_any_rev
\n(:p_po_header_id,– PO Header Id<\/p>\n
‘H’,\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 — Standard Header
\n‘PO’,\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 — Document Type
\n‘STANDARD’,\u00a0\u00a0\u00a0\u00a0 — Document Sub Type
\n0,\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 — Revision Num
\n‘Y’);\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 — Base Currency
\ndbms_output.put_line(‘PO Total Amount:’||l_total);
\nEND;
\n—–<\/HTML><\/HTML><\/p>\n","protected":false},"excerpt":{"rendered":"
Como obter um valor total em uma ordem de compra padr\u00e3o? A Oracle fornece algumas API para obter o valor total em uma ordem de… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29,127,124,121],"tags":[],"class_list":["post-15677","post","type-post","status-publish","format-standard","hentry","category-base-de-conhecimentos","category-applications","category-database","category-oracle_ebs_tecnico"],"_links":{"self":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/15677","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=15677"}],"version-history":[{"count":1,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/15677\/revisions"}],"predecessor-version":[{"id":15678,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/15677\/revisions\/15678"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=15677"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=15677"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=15677"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}