{"id":192,"date":"2007-05-21T14:04:30","date_gmt":"2007-05-21T12:04:30","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=192"},"modified":"2007-05-21T14:05:53","modified_gmt":"2007-05-21T12:05:53","slug":"zle-statusy-na-wysylce-dla-zs","status":"publish","type":"post","link":"http:\/\/oracle.malin.pl\/?p=192","title":{"rendered":"Z\u0142e statusy na wysy\u0142ce dla ZS"},"content":{"rendered":"

Rozwi\u0105zanie dla przypadku:<\/o><\/span><\/p>\n

Zosta\u0142a wykonana wysy\u0142ka dla danego ZS( kilka linii – kolej). ZS trafi\u0142o do interfejsu w nale\u017cno\u015bciach oraz stan magazynowy zosta\u0142 zdj\u0119ty. Pomimo tego dla pewnych linii status jest „Gotowe do wysy\u0142ki\/potwierdzona kompletacja”, a nie „Przekazane”.<\/o><\/span><\/p>\n

Nale\u017cy wykona\u0107 nast\u0119puj\u0105cy update.<\/o><\/span><\/p>\n

update<\/span> wsh_delivery_details<\/o><\/span><\/p>\n

<\/span> <\/span>set<\/span> released_status<\/span> <\/span>= ’C’<\/span>,<\/span><\/p>\n

<\/span> <\/span>src_requested_quantity = <\/span>49.16<\/span>, <\/span>— ilo\u015b\u0107 ca\u0142ej wysy\u0142ki dla ZS<\/span><\/em><\/o><\/span><\/p>\n

<\/span> <\/span>shipped_quantity<\/span> <\/span>= 24.28<\/span>, <\/span>— ilo\u015b\u0107 w linii spedycji<\/span> <\/span>oe_interfaced_flag = 'Y’,<\/em><\/o><\/span><\/p>\n

<\/span> <\/span>inv_interfaced_flag <\/span>= ’Y’<\/span>,<\/o><\/span><\/p>\n

<\/span> <\/span>last_update_date<\/span> <\/span>= sysdate<\/span>, <\/span>— tego nie musimy aktualizowa\u0107<\/span><\/em><\/o><\/span><\/p>\n

<\/span> <\/span>last_updated_by <\/span>= –5236864<\/span> <\/span>— tego nie musimy aktualizowa\u0107<\/span><\/em><\/o><\/span><\/p>\n

<\/span> <\/span>where<\/span> delivery_detail_id = <\/span>47677<\/span>; <\/span>— numer linii w OeBS to pole nazywa si\u0119 „Szczeg\u00f3\u0142y”<\/span><\/em><\/p>\n

 <\/p>\n

Zapytanie sprawdzaj\u0105ce powy\u017csze przypadki:<\/p>\n

select wdd.source_header_number, wdd.source_line_id,
\nwdd.delivery_detail_id,wdd.released_status,wdd.creation_date
\nfrom wsh_delivery_details wdd
\nwhere wdd.source_code = 'OE’
\nand wdd.oe_interfaced_flag = 'N’
\nand wdd.released_status <> 'D'\nand exists ( select 'x'\nfrom wsh_delivery_details wdd1\nwhere wdd1.source_code = 'OE'\nand wdd.source_line_id = wdd1.source_line_id\nand wdd1.oe_interfaced_flag = 'Y')\norder by 1,2,3;<\/p>\n","protected":false},"excerpt":{"rendered":"

Rozwi\u0105zanie dla przypadku: Zosta\u0142a wykonana wysy\u0142ka dla danego ZS( kilka linii – kolej). ZS trafi\u0142o do interfejsu w nale\u017cno\u015bciach oraz stan magazynowy zosta\u0142 zdj\u0119ty. Pomimo tego dla pewnych linii status jest „Gotowe do wysy\u0142ki\/potwierdzona kompletacja”, a nie „Przekazane”. Nale\u017cy wykona\u0107 … Czytaj dalej →<\/span><\/a><\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[5,3],"tags":[225,226],"_links":{"self":[{"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/192"}],"collection":[{"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=192"}],"version-history":[{"count":0,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/192\/revisions"}],"wp:attachment":[{"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=192"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=192"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=192"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}