{"id":186,"date":"2007-05-14T15:22:55","date_gmt":"2007-05-14T13:22:55","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=186"},"modified":"2012-03-09T16:52:51","modified_gmt":"2012-03-09T14:52:51","slug":"selekt-do-wyciagania-klas-ksiegowania-pwt","status":"publish","type":"post","link":"https:\/\/oracle.malin.pl\/?p=186","title":{"rendered":"selekt do wyci\u0105gania klas ksi\u0119gowania PWT"},"content":{"rendered":"<p>Klasy ksi\u0119gowania PWT.<\/p>\n<p><strong><span style=\"color: #ff0000;\">UWAGA &#8211; po zmianie definicji klasy ksi\u0119gowania PWT, na zleceniach pozostaj\u0105 stare konta !!!<\/span><\/strong><\/p>\n<p><strong><span style=\"color: #ff0000;\">Aby u\u017cy\u0107 nowych kont, nale\u017cy utworzy\u0107 nowe zlecenie. <\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">tak musi by\u0107, aby generator kont (RW) i menad\u017cer koszt\u00f3w (dostawy bezpo\u015brednie) pobiera\u0142y odpowiednie konta.<\/span><!--more--><\/p>\n<pre lang=\"PLSQL\">select wa.class_code,\r\n       wa.description,\r\n       gc1.segment1 || '-' || gc1.segment2 || '-' || gc1.segment3 || '-' ||\r\n       gc1.segment4 || '-' || gc1.segment5 || '-' || gc1.segment6 || '-' ||\r\n       gc1.segment7 || '-' || gc1.segment8 || '-' || gc1.segment9 us\u0142ugi,\r\n       gc2.segment1 || '-' || gc2.segment2 || '-' || gc2.segment3 || '-' ||\r\n       gc2.segment4 || '-' || gc2.segment5 || '-' || gc2.segment6 || '-' ||\r\n       gc2.segment7 || '-' || gc2.segment8 || '-' || gc2.segment9 us\u0142ugi_odchylenia,\r\n       gc3.segment1 || '-' || gc3.segment2 || '-' || gc3.segment3 || '-' ||\r\n       gc3.segment4 || '-' || gc3.segment5 || '-' || gc3.segment6 || '-' ||\r\n       gc3.segment7 || '-' || gc3.segment8 || '-' || gc3.segment9 us\u0142ugi_koszty_og\u00f3lne,\r\n       gc4.segment1 || '-' || gc4.segment2 || '-' || gc4.segment3 || '-' ||\r\n       gc4.segment4 || '-' || gc4.segment5 || '-' || gc4.segment6 || '-' ||\r\n       gc4.segment7 || '-' || gc4.segment8 || '-' || gc4.segment9 zasoby,\r\n       gc5.segment1 || '-' || gc5.segment2 || '-' || gc5.segment3 || '-' ||\r\n       gc5.segment4 || '-' || gc5.segment5 || '-' || gc5.segment6 || '-' ||\r\n       gc5.segment7 || '-' || gc5.segment8 || '-' || gc5.segment9 zasoby_odchylenia,\r\n       gc6.segment1 || '-' || gc6.segment2 || '-' || gc6.segment3 || '-' ||\r\n       gc6.segment4 || '-' || gc6.segment5 || '-' || gc6.segment6 || '-' ||\r\n       gc6.segment7 || '-' || gc6.segment8 || '-' || gc6.segment9 materia\u0142y,\r\n       gc7.segment1 || '-' || gc7.segment2 || '-' || gc7.segment3 || '-' ||\r\n       gc7.segment4 || '-' || gc7.segment5 || '-' || gc7.segment6 || '-' ||\r\n       gc7.segment7 || '-' || gc7.segment8 || '-' || gc7.segment9 materia\u0142y_odchylenia,\r\n       gc8.segment1 || '-' || gc8.segment2 || '-' || gc8.segment3 || '-' ||\r\n       gc8.segment4 || '-' || gc8.segment5 || '-' || gc8.segment6 || '-' ||\r\n       gc8.segment7 || '-' || gc8.segment8 || '-' || gc8.segment9 koszty_og\u00f3lne,\r\n       gc9.segment1 || '-' || gc9.segment2 || '-' || gc9.segment3 || '-' ||\r\n       gc9.segment4 || '-' || gc9.segment5 || '-' || gc9.segment6 || '-' ||\r\n       gc9.segment7 || '-' || gc9.segment8 || '-' || gc9.segment9 koszty_og\u00f3lne_odchylenia\r\n  from wip.WIP_ACCOUNTING_CLASSES wa -- klasy ksi\u0119gowania PWT\r\n\r\n      ,apps.gl_code_combinations gc1 -- konta\r\n      ,apps.gl_code_combinations gc2\r\n      ,apps.gl_code_combinations gc3\r\n      ,apps.gl_code_combinations gc4\r\n      ,apps.gl_code_combinations gc5\r\n      ,apps.gl_code_combinations gc6\r\n      ,apps.gl_code_combinations gc7\r\n      ,apps.gl_code_combinations gc8\r\n      ,apps.gl_code_combinations gc9\r\n\r\n where 1 = 1\r\n  and wa.organization_id =(select organization_id\r\n                            from apps.mtl_parameters mp\r\n                           where mp.organization_code = upper('&amp;kod_magazynu'))\r\n\r\n   and wa.material_account = gc1.code_combination_id\r\n   and wa.material_variance_account = gc2.code_combination_id\r\n   and wa.material_overhead_account = gc3.code_combination_id\r\n   and wa.resource_account = gc4.code_combination_id\r\n   and wa.resource_variance_account = gc5.code_combination_id\r\n   and wa.outside_processing_account = gc6.code_combination_id\r\n   and wa.outside_proc_variance_account = gc7.code_combination_id\r\n   and wa.overhead_account = gc8.code_combination_id\r\n   and wa.overhead_variance_account = gc9.code_combination_id\r\n   and wa.disable_date is null -- eliminuje konta wy\u0142\u0105czone<\/pre>\n<p><strong><br \/>\n<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Klasy ksi\u0119gowania PWT. UWAGA &#8211; po zmianie definicji klasy ksi\u0119gowania PWT, na zleceniach pozostaj\u0105 stare konta !!! Aby u\u017cy\u0107 nowych kont, nale\u017cy utworzy\u0107 nowe zlecenie. tak musi by\u0107, aby generator kont (RW) i menad\u017cer koszt\u00f3w (dostawy bezpo\u015brednie) pobiera\u0142y odpowiednie konta.<\/p>\n","protected":false},"author":20,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[10],"tags":[225,226],"_links":{"self":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/186"}],"collection":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/users\/20"}],"replies":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=186"}],"version-history":[{"count":3,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/186\/revisions"}],"predecessor-version":[{"id":616,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/186\/revisions\/616"}],"wp:attachment":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=186"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=186"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=186"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}