{"id":302,"date":"2009-07-07T09:37:15","date_gmt":"2009-07-07T07:37:15","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=302"},"modified":"2012-03-12T12:49:58","modified_gmt":"2012-03-12T10:49:58","slug":"select-do-transakcji-zwiazanych-ze-zleceniem-produkcyjnym","status":"publish","type":"post","link":"https:\/\/oracle.malin.pl\/?p=302","title":{"rendered":"select do transakcji zwi\u0105zanych ze zleceniem produkcyjnym"},"content":{"rendered":"<p>select pokazuj\u0105cy transakcje zwi\u0105zane ze zleceniem produkcyjnym<\/p>\n<pre lang=\"oracle11\"> select gg.batch_id,\r\n       gg.batch_no,\r\n       m.plan_qty,\r\n       iim.item_no,\r\n       iim.item_desc1,\r\n       pp.*<\/pre>\n<p><!--more--><\/p>\n<pre lang=\"oracle11\">   from apps.gme_batch_header gg,\r\n       apps.gme_material_details m,\r\n       apps.ic_tran_vw1 pp,\r\n       apps.ic_item_mst iim\r\n where gg.batch_id = m.batch_id\r\n   and m.material_detail_id = pp.LINE_ID\r\n   and pp.item_id = iim.item_id\r\n   and pp.DOC_TYPE = 'PROD'\r\n   and pp.COMPLETED_IND = 1\r\n   and pp.ORGN_CODE = 'XX1'\r\n   and gg.batch_no = '2009009999'<\/pre>\n<p>s\u0142owa kluczowe: zlecenie produkcyjne, PROD, OPM<\/p>\n","protected":false},"excerpt":{"rendered":"<p>select pokazuj\u0105cy transakcje zwi\u0105zane ze zleceniem produkcyjnym select gg.batch_id, gg.batch_no, m.plan_qty, iim.item_no, iim.item_desc1, pp.*<\/p>\n","protected":false},"author":20,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[42,97],"tags":[225,226],"_links":{"self":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/302"}],"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=302"}],"version-history":[{"count":5,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/302\/revisions"}],"predecessor-version":[{"id":649,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/302\/revisions\/649"}],"wp:attachment":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=302"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=302"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=302"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}