ITPub博客

--PTO的訂單誤CANCELLED後，要重撈的處理 。 --PTO 撈單畫面中發放號的LOV select * from ( select distinct pra.release_num ,to_char(pra.CREATION_DATE,'yyyy-mm-dd hh24:mi:ss') release_date from po_line_locations_all plla,po_releases_all pra where 1=1 AND TO_CHAR(PRA.CREATION_DATE,'YYYYMM')>='200706' and not exists(select 1 from otc_po_lines_all opla,oe_order_lines_all oola where oola.ORIG_SYS_LINE_REF=opla.orig_sys_line_ref and oola.ORIG_SYS_document_R