测试用的存储过程

朴灿烈づ我的快乐病毒、 2022-07-12 14:51 113阅读 0赞

USE \[Duplo\_T\]  
GO  
/\*\*\*\*\*\* Object:  StoredProcedure \[dbo\].\[FAN\_TEST\]    Script Date: 08/13/2010 12:31:26 \*\*\*\*\*\*/  
SET ANSI\_NULLS ON  
GO  
SET QUOTED\_IDENTIFIER OFF  
GO

ALTER   PROCEDURE \[dbo\].\[FAN\_TEST\]  
@ORDER\_NO CHAR(12)='',    --default :空白(全て検索)  
@TABLE\_FLG CHAR(6)='1',   --default :1 (T受注,T受注明細 )  
@IN\_OUT\_BKN CHAR(2)='OD'  -----default:OD (受注)  
AS

PRINT '-- ============================================='  
PRINT '--    引数１：受注番号または仮受注番号'  
PRINT '--    引数２：テーブルの区分====以下詳細==========='  
PRINT '--           1 T受注 t\_order　と　T受注明細 t\_order\_detail'  
PRINT '--           2 T仮受注 t\_tmp\_order　と　T仮受注明細 t\_tmp\_order\_details'  
PRINT '--           3 M製品在庫 m\_prod\_stk　と　T製品入出庫 t\_prod\_in\_out '  
PRINT '--           4 T出荷 t\_ship'  
PRINT '--           5 T出荷明細機番t\_ship\_detail\_mac'  
PRINT '--           6 T消耗品受払t\_spl\_receive\_and\_pay'  
PRINT '--           7 T売上t\_sale'  
PRINT '--           x M採番情報 m\_auto\_no'  
PRINT '--           y T機番　t\_mac'  
PRINT '--    引数３：製品入出庫区分：受注:OD 仮受注:TO 出荷番号:SJ'  
\--PRINT '--    4 '  
\--PRINT '--    7 '  
\--PRINT '-- 　8 '  
\--PRINT '-- 　9 '  
\--PRINT '--  a'   
\--PRINT '--  b'  
\--PRINT '--  c'  
\--PRINT '--  d'  
\--PRINT '--  e'  
\--PRINT '--  f'  
\--PRINT '--  g'  
\--PRINT '--  h'  
\--PRINT '--  i'  
PRINT '-- ============================================='  
PRINT [  BEGIN  
     SELECT \*  
     FROM t\_order  
     WHERE ORDER\_NO = @ORDER\_NO  
     order by ORDER\_NO desc  
     SELECT \*  
     FROM t\_order\_detail  
     WHERE ORDER\_NO = @ORDER\_NO  
     order by ORDER\_NO desc, line  
     --SELECT \*  
     --FROM t\_order\_detail\_mac  
     --WHERE ORDER\_NO = @ORDER\_NO  
     --order by ORDER\_NO desc, line    
  END  
    IF @TEMP = '2'  
  BEGIN  
      ---------------T受注------------  
     IF SUBSTRING(@ORDER\_NO,0,3) = 'OD'  
     BEGIN  
    select distinct t4.\* from (select t1.\* from t\_tmp\_order\_details as t1  LEFT join t\_order\_detail as t2  
    on t1.line = t2.tmp\_order\_line and  
    t1.tmp\_order\_no = t2.tmp\_order\_no  
    where ][BEGIN _ SELECT _ _ FROM t_order _ WHERE ORDER_NO _ _ORDER_NO _ order by ORDER_NO desc _ SELECT _ _ FROM t_order_detail _ WHERE ORDER_NO _ _ORDER_NO _ order by ORDER_NO desc_ line _ --SELECT _ _ --FROM t_order_detail_mac _ --WHERE ORDER_NO _ _ORDER_NO _ --order by ORDER_NO desc_ line_ _END _ IF _TEMP _ _2_ _BEGIN _ _---------------T_------------ _ IF SUBSTRING_ORDER_NO_0_3_ _ _OD_ _ BEGIN _select distinct t4._ from _select t1._ from t_tmp_order_details as t1_ LEFT join t_order_detail as t2 _on t1.line _ t2.tmp_order_line and _t1.tmp_order_no _ t2.tmp_order_no _where][order\_no=@ORDER\_NO][order_no_ORDER_NO]) as t3  
    left join t\_tmp\_order as t4  
    on t3.tmp\_order\_no = t4.tmp\_order\_no

select distinct t1.\* from t\_tmp\_order\_details as t1  LEFT join t\_order\_detail as t2  
    on t1.line = t2.tmp\_order\_line and  
    t1.tmp\_order\_no = t2.tmp\_order\_no  
    where [order\_no=@ORDER\_NO][order_no_ORDER_NO]  
     END  
      
     ---------------T仮受注------------  
     IF SUBSTRING(@ORDER\_NO,0,3) = 'TO'  
      BEGIN  
      SELECT \*  
      FROM t\_tmp\_order  
      WHERE tmp\_order\_no = @ORDER\_NO  
      order by tmp\_order\_no desc  
      SELECT \*  
      FROM t\_tmp\_order\_details  
      WHERE tmp\_order\_no = @ORDER\_NO  
      order by tmp\_order\_no desc,line  
     END  
  END  
  IF @TEMP = '3'  
  BEGIN  
      ---------------T受注------------  
      IF @IN\_OUT\_BKN = 'OD'  
      BEGIN  
      --  M製品在庫 m\_prod\_stk  
     select t2.\* from  
    (select prod\_cd1,prod\_cd2,whouse1,whouse2 from t\_order\_detail  
     where order\_no = @ORDER\_NO  
     group by prod\_cd1,prod\_cd2,whouse1,whouse2)  as t1  
     left join m\_prod\_stk as t2  
     on  t1.prod\_cd1 = t2.prod\_cd1  
     and t1.prod\_cd2 = t2.prod\_cd2  
     and t1.whouse1 = t2.whouse1  
     and t1.whouse2 = t2.whouse2  
     WHERE 1=1  
        order by prod\_cd1,prod\_cd2,whouse1,whouse2  
         
     --T製品入出庫 t\_prod\_in\_out  
     select t2.\* from t\_prod\_in\_out as t2  
     where 1=1 and  
     t2.slip\_no = @ORDER\_NO  
     order by t2.in\_out\_no desc,t2.line  
     END  
      
     IF @IN\_OUT\_BKN = 'TO'  
      BEGIN

---------------T仮受注------------  
    --  M製品在庫 m\_prod\_stk  
     select t2.\* from  
    (select prod\_cd1,prod\_cd2,whouse1,whouse2 from t\_tmp\_order\_details  
     where tmp\_order\_no = @ORDER\_NO  
     group by prod\_cd1,prod\_cd2,whouse1,whouse2)  as t1  
     left join m\_prod\_stk as t2  
     on  t1.prod\_cd1 = t2.prod\_cd1  
     and t1.prod\_cd2 = t2.prod\_cd2  
     and t1.whouse1 = t2.whouse1  
     and t1.whouse2 = t2.whouse2  
     WHERE 1=1  
        order by prod\_cd1,prod\_cd2,whouse1,whouse2  
         
     --T製品入出庫 t\_prod\_in\_out  
     select t2.\* from t\_prod\_in\_out as t2  
     where 1=1 and  
     t2.slip\_no = @ORDER\_NO  
     order by t2.in\_out\_no desc,t2.line  
     END  
      
     ---------------T出荷------------  
      IF @IN\_OUT\_BKN = 'SJ'  
      BEGIN  
      --  M製品在庫 m\_prod\_stk  
     select t2.\* from  
    (select prod\_cd1,prod\_cd2,whouse1,whouse2 from t\_order\_detail  
     where order\_no = @ORDER\_NO  
     group by prod\_cd1,prod\_cd2,whouse1,whouse2)  as t1  
     left join m\_prod\_stk as t2  
     on  t1.prod\_cd1 = t2.prod\_cd1  
     and t1.prod\_cd2 = t2.prod\_cd2  
     and t1.whouse1 = t2.whouse1  
     and t1.whouse2 = t2.whouse2  
     WHERE 1=1  
        order by prod\_cd1,prod\_cd2,whouse1,whouse2  
         
     --T製品入出庫 t\_prod\_in\_out  
     select t2.\* from t\_prod\_in\_out as t2  
     where 1=1 and  
     t2.slip\_no in  
     (  
      --T出荷 t\_ship  
    select t1.ship\_no from t\_ship as t1     
    LEFT join(  
    SELECT \*  
    FROM t\_order\_detail  
    ) as t2  
    on t1.ship\_no = t2.ship\_no  
    WHERE t2.ORDER\_NO = @ORDER\_NO  
     )  
     order by t2.in\_out\_no desc,t2.line  
     END  
  END  
  IF @TEMP = '4'  
  BEGIN  
    --T出荷 t\_ship  
    select t1.\* from t\_ship as t1     
    LEFT join(  
    SELECT \*  
    FROM t\_order\_detail  
    ) as t2  
    on t1.ship\_no = t2.ship\_no  
    and t1.order\_line = t2.line  
    WHERE t2.ORDER\_NO = @ORDER\_NO  
    order by t1.ship\_no desc, line  
  END  
  IF @TEMP = '5'  
  BEGIN  
   --T出荷明細機番 t\_ship\_detail\_mac  
   select \*  
   from t\_ship\_detail\_mac  
   where  ship\_no in (  
     
    --T出荷 t\_ship  
    select t1.ship\_no from t\_ship as t1     
    LEFT join(  
    SELECT \*  
    FROM t\_order\_detail  
    ) as t2  
    on t1.ship\_no = t2.ship\_no  
    and t1.order\_line = t2.line  
    WHERE t2.ORDER\_NO = @ORDER\_NO)  
    order by ship\_no desc, line  
  END  
  IF @TEMP = '6'  
  BEGIN  
   --T消耗品受払  
select \* from t\_spl\_receive\_and\_pay  
where reference\_slip\_no =  
(--T出荷 t\_ship  
    select t1.ship\_no from t\_ship as t1     
    LEFT join(  
    SELECT \*  
    FROM t\_order\_detail  
    ) as t2  
    on t1.ship\_no = t2.ship\_no  
    and t1.order\_line = t2.line  
    WHERE t2.ORDER\_NO = @ORDER\_NO)  
   order by acceptandpay\_no desc

END  
  IF @TEMP = '7'  
  BEGIN  
   --T売上  
select \* from t\_sale  
where ship\_no =  
(--T出荷 t\_ship  
    select t1.ship\_no from t\_ship as t1     
    LEFT join(  
    SELECT \*  
    FROM t\_order\_detail  
    ) as t2  
    on t1.ship\_no = t2.ship\_no  
    and t1.order\_line = t2.line  
    WHERE t2.ORDER\_NO = @ORDER\_NO)  
   order by sale\_no desc, sale\_line  
  END  
  IF @TEMP = 'x'  
  BEGIN  
      --  M採番情報 m\_auto\_no  
     select \* from m\_auto\_no  
     order by auto\_kbn  
  END  
    
  IF @TEMP = 'y'  
  BEGIN  
      --  T機番  
   select \* from t\_mac where mac in (select mac from t\_order\_detail\_mac where [order\_no=@ORDER\_NO][order_no_ORDER_NO])  
  END  
  --  IF @TEMP = '4'  
  --BEGIN  
  ----加工発注管理  
  --    SELECT \*  
  --    FROM PROCESSHACCYUMNG  
  --    WHERE REFERENCE\_ORDER\_NO = @ORDER\_NO  
  ----加工発注明細  
  --    SELECT \*  
  --    FROM PROCESSHACCYUDETAIL  
  --    WHERE PROCESSHACCYU\_NO =  
  --       (SELECT PROCESSHACCYU\_NO  
  --          FROM PROCESSHACCYUMNG  
  --         WHERE REFERENCE\_ORDER\_NO = @ORDER\_NO)  
  --END  
  --  IF @TEMP = '5'  
  --BEGIN  
  -- --加工指示管理  
  --    SELECT \*  
  --    FROM PROCESSINDICATEMNG  
  --    WHERE REFERENCE\_ORDER\_NO = @ORDER\_NO  
  -- --加工指示明細  
  --    SELECT \*  
  --    FROM PROCESSINDICATEDETAIL T1,(SELECT PROCESSINDICATE\_NO  
  --          FROM PROCESSINDICATEMNG  
  --         WHERE REFERENCE\_ORDER\_NO = @ORDER\_NO) T2  
  --    WHERE T1.PROCESSINDICATE\_NO = T2.PROCESSINDICATE\_NO  
  --END  
  -- IF @TEMP = '6'  
  --BEGIN  
  -- --積送管理  
  --    SELECT \*  
  --    FROM SHIPMENTMNG  
  --    WHERE IN\_ORDER\_NO = @ORDER\_NO  
  --END  
  -- IF @TEMP = '7'  
  --BEGIN  
  -- --付加情報管理  
  --    SELECT \*  
  --    FROM ADDITIONMNG  
  --    WHERE REFERENCE\_ORDER\_NO = @ORDER\_NO

----付加情報明細  
  --    SELECT \*  
  --    FROM ADDITIONDETAIL T1,       (SELECT ADDITION\_NO  
  --          FROM ADDITIONMNG  
  --         WHERE REFERENCE\_ORDER\_NO = @ORDER\_NO) T2  
  --    WHERE T1.ADDITION\_NO = T2.ADDITION\_NO

--END  
  -- IF @TEMP = '8'  
  --BEGIN  
  -- --製品在庫  
  --    SELECT \*  
  --    FROM productStock  
  --    WHERE order\_no = @ORDER\_NO

----製品入出庫履歴  
  --    SELECT \*  
  --    FROM productStockLog T1,       (    SELECT product\_stock\_no  
  --    FROM productStock  
  --    WHERE order\_no = @ORDER\_NO) T2  
  --    WHERE T1.product\_stock\_no = T2.product\_stock\_no

--END

-- IF @TEMP = '9'  
  --BEGIN

-- --購買品在庫  
  --    SELECT \*  
  --    FROM materialStock  
  ----    WHERE order\_no = @ORDER\_NO

----購買品入出庫履歴  
  --    SELECT \*  
  --    FROM materialStockLog T1,       (    SELECT material\_stock\_no  
  --    FROM materialStock) T2  
  --    WHERE T1.material\_stock\_no = T2.material\_stock\_no  
  --END  
  -- IF @TEMP = 'a'  
  --BEGIN  
  -- --出荷指示管理shippingMng

--    SELECT \*

--    FROM shippingMng  
  --    WHERE order\_no = @ORDER\_NO

----出荷指示明細shippingdetail  
  --    SELECT \*

--    FROM shippingdetail T1,       (    SELECT shipping\_no  
  --    FROM shippingMng WHERE order\_no = @ORDER\_NO) T2  
  --    WHERE T1.shipping\_no = T2.shipping\_no  
  --END  
  -- IF @TEMP = 'b'  
  --BEGIN  
  -- --追加売上管理addsalesMng  
  --        SELECT \*  
  --    FROM addsalesMng t1,  (     SELECT tt1.shipping\_no, tt1.shipping\_seq  
  --    FROM shippingdetail tt1, (SELECT shipping\_no  
  --    FROM shippingMng WHERE order\_no [=@ORDER\_NO][ORDER_NO] ) tt2  
  --where tt1.shipping\_no = tt2.shipping\_no  
  --) t2  
  --    WHERE t1.shipping\_no = t2.shipping\_no  
  --    and t1.shipping\_seq = t2.shipping\_seq

----追加売上明細addsalesDetail  
  --    SELECT \*  
  --    FROM addsalesDetail T1,       (            SELECT addsales\_no  
  --    FROM addsalesMng t1,  (     SELECT tt1.shipping\_no, tt1.shipping\_seq  
  --    FROM shippingdetail tt1, (SELECT shipping\_no  
  --    FROM shippingMng WHERE order\_no [=@ORDER\_NO][ORDER_NO] ) tt2  
  --where tt1.shipping\_no = tt2.shipping\_no  
  --) t2  
  --    WHERE t1.shipping\_no = t2.shipping\_no  
  --    and t1.shipping\_seq = t2.shipping\_seq) T2  
  --    WHERE T1.addsales\_no = T2.addsales\_no  
  --END  
  -- IF @TEMP = 'c'  
  --BEGIN  
  -- --出荷実績管理ship\_resultMng

--select \* from ship\_resultMng t1,  
  --(  
  --    SELECT t1.shipping\_no, t1.shipping\_seq  
  --    FROM shippingdetail T1,       (    SELECT shipping\_no  
  --    FROM shippingMng WHERE order\_no = @ORDER\_NO) T2  
  --    WHERE T1.shipping\_no = T2.shipping\_no) t2  
  --where t1.shipping\_no = t2.shipping\_no  
  --and t1.shipping\_seq=t2.shipping\_seq

----出荷実績明細ship\_resultdetail  
  --select  \* from ship\_resultdetail t1,  
  --(select t1.shipping\_result\_no from ship\_resultMng t1,  
  --(  
  --    SELECT t1.shipping\_no, t1.shipping\_seq  
  --    FROM shippingdetail T1,       (    SELECT shipping\_no  
  --    FROM shippingMng WHERE order\_no = @ORDER\_NO) T2  
  --    WHERE T1.shipping\_no = T2.shipping\_no) t2  
  --where t1.shipping\_no = t2.shipping\_no  
  --and t1.shipping\_seq=t2.shipping\_seq) t2  
  --where  
  --t1.shipping\_result\_no = t2.shipping\_result\_no  
  --END  
  --IF @TEMP = 'd'  
  --BEGIN  
  -- --売上管理SalesMng

--select \* from SalesMng t1,  
  --(  
  --    SELECT t1.shipping\_no, t1.shipping\_seq  
  --    FROM shippingdetail T1,       (    SELECT shipping\_no  
  --    FROM shippingMng WHERE order\_no = @ORDER\_NO) T2  
  --    WHERE T1.shipping\_no = T2.shipping\_no) t2  
  --where t1.shipping\_no = t2.shipping\_no  
  --and t1.shipping\_seq=t2.shipping\_seq

----売上明細SalesDetail  
  --select  \* from Salesdetail t1,  
  --(  
  --select t1.sales\_no from SalesMng t1,  
  --(  
  --    SELECT t1.shipping\_no, t1.shipping\_seq  
  --    FROM shippingdetail T1,       (    SELECT shipping\_no  
  --    FROM shippingMng WHERE order\_no =  @ORDER\_NO) T2  
  --    WHERE T1.shipping\_no = T2.shipping\_no) t2  
  --where t1.shipping\_no = t2.shipping\_no  
  --and t1.shipping\_seq=t2.shipping\_seq  
  --) t2  
  --where  
  --t1.sales\_no = t2.sales\_no  
  --END  
  --IF @TEMP = 'e'  
  --BEGIN  
  ----入金管理paymentMng  
  --select \* from paymentMng where payment\_no = @payment\_no

----入金明細paymentDetail  
  --select \* from paymentDetail  
  --where payment\_no = @payment\_no  
  ----受取手形billReceivable  
  --select \* from billReceivable t3,  
  --(  
  --select payment\_no,payment\_seq from paymentDetail  
  --where payment\_no = @payment\_no  
  --)t4  
  --where t3.payment\_no = t4.payment\_no  
  --and t3.payment\_seq = t4.payment\_seq  
  --END

--IF @TEMP = 'f'  
  --BEGIN

----作業実績管理mn\_resultMng  
  --select \* from mn\_resultMng t1, (  
  --    SELECT t1.addition\_no,t1.addition\_seq  
  --    FROM ADDITIONDETAIL T1, (SELECT ADDITION\_NO  
  --          FROM ADDITIONMNG  
  --         WHERE REFERENCE\_ORDER\_NO = @ORDER\_NO) T2  
  --    WHERE T1.ADDITION\_NO = T2.ADDITION\_NO  
  --) t2  
  --where  
  --t1.addition\_no = t2.addition\_no and  
  --t1.addition\_seq = t2.addition\_seq

----作業実績明細mn\_resultdetail  
  --select \* from mn\_resultdetail t3,(  
  --select t1.result\_no,t2.addition\_no,t2.addition\_seq from mn\_resultMng t1, (  
  --    SELECT t1.addition\_no,t1.addition\_seq  
  --    FROM ADDITIONDETAIL T1, (SELECT ADDITION\_NO  
  --          FROM ADDITIONMNG  
  --         WHERE REFERENCE\_ORDER\_NO = @ORDER\_NO) T2  
  --    WHERE T1.ADDITION\_NO = T2.ADDITION\_NO  
  --) t2  
  --where  
  --t1.addition\_no = t2.addition\_no and  
  --t1.addition\_seq = t2.addition\_seq  
  --) t4  
  --where t3.result\_no = t4.result\_no  
  --END

--IF @TEMP = 'g'  
  --BEGIN

----半製品在庫halfproductStock  
  --select \* from halfproductStock t1,(  
  --select result\_no from mn\_resultMng t1, (  
  --    SELECT t1.addition\_no,t1.addition\_seq  
  --    FROM ADDITIONDETAIL T1, (SELECT ADDITION\_NO  
  --          FROM ADDITIONMNG  
  --         WHERE REFERENCE\_ORDER\_NO = @ORDER\_NO) T2  
  --    WHERE T1.ADDITION\_NO = T2.ADDITION\_NO  
  --) t2  
  --where  
  --t1.addition\_no = t2.addition\_no and  
  --t1.addition\_seq = t2.addition\_seq  
  --) t2  
  --where  
  --t1.result\_no = t2.result\_no

----半製品入出庫履歴halfproductStockLog  
  --select \* from halfproductStockLog t3,  
  --(  
  --select result\_no from mn\_resultMng t1, (  
  --    SELECT t1.addition\_no,t1.addition\_seq  
  --    FROM ADDITIONDETAIL T1, (SELECT ADDITION\_NO  
  --          FROM ADDITIONMNG  
  --         WHERE REFERENCE\_ORDER\_NO = @ORDER\_NO) T2  
  --    WHERE T1.ADDITION\_NO = T2.ADDITION\_NO  
  --) t2  
  --where  
  --t1.addition\_no = t2.addition\_no and  
  --t1.addition\_seq = t2.addition\_seq  
  --) t4  
  --where  
  --t3.result\_no = t4.result\_no  
  --END

--IF @TEMP = 'h'  
  --BEGIN

----作業投入管理mn\_resultthrowinitemMng  
  --select \* from mn\_resultthrowinitemMng t1,(  
  --select t3.result\_no, t3.result\_seq from mn\_resultdetail t3,(  
  --select t1.result\_no,t2.addition\_no,t2.addition\_seq from mn\_resultMng t1, (  
  --    SELECT t1.addition\_no,t1.addition\_seq  
  --    FROM ADDITIONDETAIL T1, (SELECT ADDITION\_NO  
  --          FROM ADDITIONMNG  
  --         WHERE REFERENCE\_ORDER\_NO = @ORDER\_NO) T2  
  --    WHERE T1.ADDITION\_NO = T2.ADDITION\_NO  
  --) t2  
  --where  
  --t1.addition\_no = t2.addition\_no and  
  --t1.addition\_seq = t2.addition\_seq  
  --) t4  
  --where t3.result\_no = t4.result\_no  
  --) t2  
  --where t1.result\_no = t2.result\_no  
  --and t1.result\_seq = t2.result\_seq

----作業投入明細mn\_resultthrowinitemdetail  
  --select \* from mn\_resultthrowinitemdetail t3,  
  --(  
  --select resultthrowin\_no from mn\_resultthrowinitemMng t1,(  
  --select t3.result\_no, t3.result\_seq from mn\_resultdetail t3,(  
  --select t1.result\_no,t2.addition\_no,t2.addition\_seq from mn\_resultMng t1, (  
  --    SELECT t1.addition\_no,t1.addition\_seq  
  --    FROM ADDITIONDETAIL T1, (SELECT ADDITION\_NO  
  --          FROM ADDITIONMNG  
  --         WHERE REFERENCE\_ORDER\_NO = @ORDER\_NO) T2  
  --    WHERE T1.ADDITION\_NO = T2.ADDITION\_NO  
  --) t2  
  --where  
  --t1.addition\_no = t2.addition\_no and  
  --t1.addition\_seq = t2.addition\_seq  
  --) t4  
  --where t3.result\_no = t4.result\_no  
  --) t2  
  --where t1.result\_no = t2.result\_no  
  --and t1.result\_seq = t2.result\_seq

--) t4  
  --where  
  --t3.resultthrowin\_no = t4.resultthrowin\_no  
  --END

--IF @TEMP = 'i'  
  --BEGIN  
  ----投入品管理throwinitemMng  
  --select \* from throwinitemMng t1, (  
  --    SELECT t1.addition\_no,t1.addition\_seq  
  --    FROM ADDITIONDETAIL T1, (SELECT ADDITION\_NO  
  --          FROM ADDITIONMNG  
  --         WHERE REFERENCE\_ORDER\_NO = @ORDER\_NO) T2  
  --    WHERE T1.ADDITION\_NO = T2.ADDITION\_NO  
  --) t2  
  --where t1.addition\_no = t2.addition\_no  
  --and t1.addition\_seq = t2.addition\_seq

----投入品明細明細throwinitemDetail  
  --select \* from throwinitemDetail t3,(  
  --select throwinitem\_no from throwinitemMng t1, (  
  --    SELECT t1.addition\_no,t1.addition\_seq  
  --    FROM ADDITIONDETAIL T1, (SELECT ADDITION\_NO  
  --          FROM ADDITIONMNG  
  --         WHERE REFERENCE\_ORDER\_NO = @ORDER\_NO) T2  
  --    WHERE T1.ADDITION\_NO = T2.ADDITION\_NO  
  --) t2  
  --where t1.addition\_no = t2.addition\_no  
  --and t1.addition\_seq = t2.addition\_seq  
  --) t4  
  --where t3.throwinitem\_no = t4.throwinitem\_no

--END  
 END  
END  
ELSE  
BEGIN  
 WHILE(@I <= LEN(@TABLE\_FLG))  
 BEGIN

SET @TEMP = SUBSTRING(@TABLE\_FLG,@I,1)  
    SET @I = @I + 1

IF @TEMP = '1'  
  BEGIN  
     SELECT \*  
     FROM t\_order  
     order by order\_no desc  
     SELECT \*  
     FROM t\_order\_detail  
     order by order\_no desc,line  
     --SELECT \* FROM t\_order\_detail\_mac order by order\_no,line,mac\_seq  
  END  
    IF @TEMP = '2'  
  BEGIN  
     SELECT \*  
     FROM t\_tmp\_order  
     order by tmp\_order\_no desc  
     SELECT \*  
     FROM t\_tmp\_order\_details  
     order by tmp\_order\_no desc,line  
  END  
    IF @TEMP = '3'  
  BEGIN  
      --  M製品在庫 m\_prod\_stk  
     select \* from m\_prod\_stk  
     WHERE 1=1  
        order by prod\_cd1,prod\_cd2,whouse1,whouse2  
      
     --T製品入出庫 t\_prod\_in\_out  
     select \* from t\_prod\_in\_out  
     WHERE 1=1  
     order by in\_out\_no desc,line  
  END  
    IF @TEMP = '4'  
  BEGIN  
    --T出荷 t\_ship  
    select t1.\* from t\_ship as t1  
    order by t1.ship\_no desc, line  
  END  
  IF @TEMP = '5'  
  BEGIN  
   --T出荷明細機番 t\_ship\_detail\_mac  
   select \*  
   from t\_ship\_detail\_mac  
   order by ship\_no desc, line  
  END  
  IF @TEMP = '6'  
  BEGIN  
   --T消耗品受払  
   select \*  
   from t\_spl\_receive\_and\_pay  
  END  
  IF @TEMP = '7'  
  BEGIN  
   --T売上  
   select \*  
   from t\_sale  
   order by sale\_no desc, sale\_line  
  END  
  IF @TEMP = 'x'  
  BEGIN  
      --  M採番情報 m\_auto\_no  
     select \* from m\_auto\_no  
     order by auto\_kbn  
  END  
    
  IF @TEMP = 'y'  
  BEGIN  
   --  T機番  
   select \* from t\_mac order by mac ,model\_cd1, model\_cd2  
  END  
 END  
END

[BEGIN _ SELECT _ _ FROM t_order _ WHERE ORDER_NO _ _ORDER_NO _ order by ORDER_NO desc _ SELECT _ _ FROM t_order_detail _ WHERE ORDER_NO _ _ORDER_NO _ order by ORDER_NO desc_ line _ --SELECT _ _ --FROM t_order_detail_mac _ --WHERE ORDER_NO _ _ORDER_NO _ --order by ORDER_NO desc_ line_ _END _ IF _TEMP _ _2_ _BEGIN _ _---------------T_------------ _ IF SUBSTRING_ORDER_NO_0_3_ _ _OD_ _ BEGIN _select distinct t4._ from _select t1._ from t_tmp_order_details as t1_ LEFT join t_order_detail as t2 _on t1.line _ t2.tmp_order_line and _t1.tmp_order_no _ t2.tmp_order_no _where]: mailto:'%20rel=
[order_no_ORDER_NO]: mailto:order_no=@ORDER_NO
[ORDER_NO]: mailto:=@ORDER_NO