【正文】 if pro_insqty。 count:=pro_get+pro_in。begin select stiqty into pro_get from where proid=pro_id。pro_get number(10)。end。||)。||||39。||||39。(39。未完成訂單:39。/create or replace procedure wip_finishascursor a_wip_is_finishisselect wipid,proid,w_qty from where is_finish=0。end loop。 o_qty:39。 proid:39。ordid:39。)。beginfor n_ord_is_delivery in a_ord_is_deliveryloop (39。,1)。,39。insert into WIP(ProID,w_qty,is_finish)values(39。8039。539。,1)。,39。insert into WIP(ProID,w_qty,is_finish)values(39。6039。539。,1)。,39。insert into WIP(ProID,w_qty,is_finish)values(39。30039。439。,1)。,39。insert into WIP(ProID,w_qty,is_finish)values(39。1539。439。,1)。,39。insert into WIP(ProID,w_qty,is_finish)values(39。15039。439。,1)。,39。insert into WIP(ProID,w_qty,is_finish)values(39。8039。339。,1)。,39。insert into WIP(ProID,w_qty,is_finish)values(39。6039。339。,1)。,39。insert into WIP(ProID,w_qty,is_finish)values(39。30039。239。,1)。,39。insert into WIP(ProID,w_qty,is_finish)values(39。1539。239。,1)。,39。insert into WIP(ProID,w_qty,is_finish)values(39。15039。239。,1)。,39。insert into WIP(ProID,w_qty,is_finish)values(39。8039。139。,1)。,39。insert into WIP(ProID,w_qty,is_finish)values(39。6039。139。,1)。,39。wip:insert into WIP(ProID,w_qty,is_finish)values(39。539。539。)。,39。insert into Invoice (ordid,proid)values(39。339。339。)。,39。insert into Invoice (ordid,proid)values(39。139。139。,0)。,39。,39。insert into Delivery (proid,ordid,carno,is_invoice)values(39。A1111139。2439。539。,0)。,39。,39。insert into Delivery (proid,ordid,carno,is_invoice)values(39。A1111139。2239。539。,0)。,39。,39。insert into Delivery (proid,ordid,carno,is_invoice)values(39。A1111139。2039。439。,0)。,39。,39。insert into Delivery (proid,ordid,carno,is_invoice)values(39。A1111139。1839。439。,0)。,39。,39。insert into Delivery (proid,ordid,carno,is_invoice)values(39。A1111139。1639。439。,0)。,39。,39。insert into Delivery (proid,ordid,carno,is_invoice)values(39。A1111139。1439。339。,0)。,39。,39。insert into Delivery (proid,ordid,carno,is_invoice)values(39。A1111139。1239。339。,0)。,39。,39。insert into Delivery (proid,ordid,carno,is_invoice)values(39。A1111139。1039。239。,0)。,39。,39。insert into Delivery (proid,ordid,carno,is_invoice)values(39。A1111139。839。239。,0)。,39。,39。insert into Delivery (proid,ordid,carno,is_invoice)values(39。A1111139。639。239。,1)。,39。,39。insert into Delivery (proid,ordid,carno,is_invoice)values(39。A1111139。439。139。,1)。,39。,39。insert into Delivery (proid,ordid,carno,is_invoice)values(39。A1111139。239。139。,1)。,39。,39。delivery:insert into Delivery (proid,ordid,carno,is_invoice)values(39。dd/mm/yy39。18/04/9239。dd/mm/yy39。03/04/9239。10039。2539。539。),0,1)。,39。),to_date(39。,39。,to_date(39。,39。,39。insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values(39。dd/mm/yy39。16/03/9239。dd/mm/yy39。02/03/9239。5039。2339。539。),0,1)。,39。),to_date(39。,39。,to_date(39。,39。,39。insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values(39。dd/mm/yy39。20/02/9239。dd/mm/yy39。10/02/9239。3039。2139。539。),0,1)。,39。),to_date(39。,39。,to_date(39。,39。,39。insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values(39。dd/mm/yy39。22/06/9239。dd/mm/yy39。11/06/9239。20039。1939。439。),0,1)。,39。),to_date(39。,39。,to_date(39。,39。,39。insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values(39。dd/mm/yy39。28/05/9239。dd/mm/yy39。16/05/9239。3039。1739。439。),0,1)。,39。),to_date(39。,39。,to_date(39。,39。,39。insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values(39。dd/mm/yy39。18/04/9239。dd/mm/yy39。03/04/9239。10039。1539。339。),0,1)。,39。),to_date(39。,39。,to_date(39。,39。,39。insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values(39。dd/mm/yy39。16/03/9239。dd/mm/yy39。02/03/9239。5039。1339。339。),0,1)。,39。),to_date(39。,39。,to_date(39。,39。,39。insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values(39。dd/mm/yy39。20/02/9239。dd/mm/yy39。10/02/9239。3039。1139。339。),0,1)。,39。),to_date(39。,39。,to_date(39。,39。,39。insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values(39。dd/mm/yy39。22/06/9239。dd/mm/yy39。11/06/9239。20039。939。239。),0,1)。,39。),to_date(39。,39。,to_date(39。,39。,39。insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values(39。dd/mm/yy39。28/05/9239。dd/mm/yy39。16/05/9239。3039。739。239。),0,1)。,39。),to_date(39。,39。,to_date(39。,39。,39。insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values(39。dd/mm/yy39。18/04/9239。dd/mm/yy39。03/04/9239。10039。539。139。),1,1)。,39。),to_date(39。,39。,to_date(39。,39。,39。insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values(39。dd/mm/yy39。16/03/9239。dd/mm/yy39。02/03/9239。5039。339。139。),1,1)。,39。),to_date(39。,39。,to_date(39。,39。,39。insert into Ord (ProID,CustID,o_Qty,OrdDate,D_Date,is_invoice,is_delivery) values(39。dd/mm/yy39。20/02/9239。dd/mm/yy39。10/02/9239。3039。139。139。)。,39。,39。,39。Insert INTO Customer(custname,custadd,custphone,custfax) values (39。(020)11111239。(020)11111139。廣州市人民路39。柏圖電子股份有限公司39。)。,39。,39。,39。Insert INTO Customer(custname,custadd,custphone,custfax) values (39。(021)1111339。(021)1111239。上海市南京路39。聯(lián)銘電子股份有限公司39。)。,39。,39。,39。Insert INTO Customer(custname,custadd,custphone,custfax) values (39。(020)11111339。(020)11111239。廣州市中山路39。南穎電子股份有限公司39。)。,39。,39。,39。Insert INTO Customer(custname,custadd,custphone,custfax) values (39。(021)11111339。(021)11111239。南京市六合區(qū)39。銘圖電子股份有限公司39。)。,39。,39。,39。Insert INTO Customer(custname,custadd,custphone,custfax) values (39。(021)1111239。(031)1111139。石家莊市人民路39。旭聯(lián)電子股份有限公司39。)。,39。,39。,39。Insert INTO Customer(custname,custadd,custphone,custfax) values (39。(037)11111239。(037)11111139。鄭州市人民路39。群聯(lián)電子股份有限公司39。)。,39。,39。,39。Insert INTO Customer(custname,custadd,custphone,custfax) values (39。(021)11111239。(021)11111239。上海市四川路39。華欣電子股份有限公司39。)。,39。,39。,39。insert into customer(custname,custadd,custphone,custfax) values(39。(020)11111339。(020)11111239。廣州市中山路39。定穎電子股份有限公司39。)。,39。,39。,39。insert into customer(custname,custadd,custphone,custfax) values(39。(022)11111339。(022)11111239。南京市六合區(qū)39。銘望電子股份有限公司39。)。,39。,39。,39。insert into customer(custname,custadd,custphone,custfax) values(39。(031)11111239。(031)11111139。石家莊市人民路39。旭德電子股份有限公司39。)。,39。,39。,39。insert into customer(custname,custadd,custphone,custfax) values(39。(037)11111239。(037)11111139。鄭州市人民路39。群策電子股份有限公司39。)。,39。,39。,39。insert into customer(custname,custadd,custphone,custfax) values(39。(021)11111239。(021)11111139。上海市四川路39。華通電子股份有限公司39。)。,39。,39。,39。customer:insert into customer(custname