{"id":961,"date":"2013-02-01T17:39:27","date_gmt":"2013-02-01T17:39:27","guid":{"rendered":"http:\/\/www.juniovitor.com\/?p=961"},"modified":"2013-02-01T17:40:25","modified_gmt":"2013-02-01T17:40:25","slug":"961","status":"publish","type":"post","link":"https:\/\/www.juniovitor.com\/?p=961","title":{"rendered":"Checando Periodos Oracle"},"content":{"rendered":"<p>Pessoal,<\/p>\n<p>T\u00f4 passando somente pra deixar um exemplo de como checar status dos Per\u00edodos do Oracle EBS.<\/p>\n<p>Segue:<\/p>\n<pre class=\"brush:sql\">\r\n SELECT GS.PERIOD_NAME,\r\n        FA.APPLICATION_NAME,\r\n        GS.CLOSING_STATUS,\r\n        GS.SET_OF_BOOKS_ID,\r\n        DECODE(GS.CLOSING_STATUS,\r\n               'C',\r\n               'Closed',\r\n               'O',\r\n               'Open',\r\n               'F',\r\n               'Future',\r\n               'W',\r\n               'Closed Pending',\r\n               'N',\r\n               'Never Opened',\r\n               'P',\r\n               'Permanently Closed') \"PERIOD_CLOSING_STATUS\"\r\n   FROM GL.GL_PERIOD_STATUSES GS, APPS.FND_APPLICATION_TL FA\r\n  WHERE FA.APPLICATION_ID = GS.APPLICATION_ID\r\n    AND FA.APPLICATION_NAME IN\r\n        ('Payables', 'Receivables', 'General Ledger')\r\n    AND GS.SET_OF_BOOKS_ID = 5       -- ID DO LIVRO\r\n    AND GS.PERIOD_NAME IN ('JAN-13') -- NOME PERIODO\r\n    AND CLOSING_STATUS IN ('O', 'W', 'C')\r\n  GROUP BY PERIOD_NAME, APPLICATION_NAME, GS.CLOSING_STATUS,GS.SET_OF_BOOKS_ID\r\n  ORDER BY PERIOD_NAME DESC;\r\n<\/pre>\n<p>Abs,<br \/>\nJ\u00fanio Vitor<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pessoal, T\u00f4 passando somente pra deixar um exemplo de como checar status dos Per\u00edodos do Oracle EBS. Segue: SELECT GS.PERIOD_NAME, FA.APPLICATION_NAME, GS.CLOSING_STATUS, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[622,161,162],"class_list":["post-961","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oracle","tag-periodo","tag-sql"],"_links":{"self":[{"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/posts\/961"}],"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=961"}],"version-history":[{"count":3,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/posts\/961\/revisions"}],"predecessor-version":[{"id":1814,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/posts\/961\/revisions\/1814"}],"wp:attachment":[{"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=961"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=961"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=961"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}