{"id":20693,"date":"2020-07-27T17:52:31","date_gmt":"2020-07-27T20:52:31","guid":{"rendered":"https:\/\/orabr.com\/?p=20693"},"modified":"2020-07-27T17:52:35","modified_gmt":"2020-07-27T20:52:35","slug":"oracle-ebs-apps-criar-nota-no-ap-via-open-interface","status":"publish","type":"post","link":"https:\/\/orabr.virttus.com\/?p=20693","title":{"rendered":"Oracle EBS\/APPS – CRIAR NOTA NO AP VIA OPEN INTERFACE"},"content":{"rendered":"\n

\n\n\n\nselect ap_invoices_interface_s.nextval from dual;\nNEXTVAL\n-------------\n132277\ninsert into AP_INVOICES_INTERFACE (\n            invoice_id,\n            invoice_num,\n            vendor_id,\n            vendor_site_id,\n            invoice_amount,\n            INVOICE_CURRENCY_CODE,\n            invoice_date,\n            DESCRIPTION,\n            PAY_GROUP_LOOKUP_CODE,\n            source,\n            org_id\n                )\nvalues (\n            132277,\n            'INV100',\n            '7124',\n            '11792',\n            1200.00,\n            'USD',\n            to_date('01-31-2010','mm-dd-yyyy'),\n            'This Invoice is created for test purpose',\n            'WUFS SUPPLIER',\n            'Manual Invoice Entry',\n            81\n);\ninsert into AP_INVOICE_LINES_INTERFACE (\n            invoice_id,\n            line_number,\n            line_type_lookup_code,\n            amount\n            )\nvalues     (\n            132277,\n            1,\n            'ITEM',\n            1200.00\n);\n\n\nRODAR O CONCORRENTE:   \u201cPayables Open Interface Import\u201d <\/code><\/pre>\n<\/HTML>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29],"tags":[],"class_list":["post-20693","post","type-post","status-publish","format-standard","hentry","category-base-de-conhecimentos"],"_links":{"self":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/20693","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=20693"}],"version-history":[{"count":1,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/20693\/revisions"}],"predecessor-version":[{"id":20694,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/20693\/revisions\/20694"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=20693"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=20693"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=20693"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}