|
|
編輯
|
複製
|
刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 1474 AND `vw_customer_quote_project`.`company_name` = '铠爱分析仪器(上海)有限公司' AND `vw_customer_quote_project`.`quotation_id` = 52 AND `vw_customer_quote_project`.`quote_no` = 'Q26-006-H002' AND `vw_customer_quote_project`.`quotation_status` = 'draft' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 6250.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
|
1474 |
铠爱分析仪器(上海)有限公司 |
52 |
Q26-006-H002 |
draft |
6250.00 |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
|
編輯
|
複製
|
刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 20 AND `vw_customer_quote_project`.`company_name` = '台灣檢驗科技股份有限公司' AND `vw_customer_quote_project`.`quotation_id` = 31 AND `vw_customer_quote_project`.`quote_no` = 'Q26-006-H001' AND `vw_customer_quote_project`.`quotation_status` = 'sent' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 31500.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
|
20 |
台灣檢驗科技股份有限公司 |
31 |
Q26-006-H001 |
sent |
31500.00 |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
|
編輯
|
複製
|
刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 1475 AND `vw_customer_quote_project`.`company_name` = '旭誼工程股份有限公司' AND `vw_customer_quote_project`.`quotation_id` = 72 AND `vw_customer_quote_project`.`quote_no` = 'Q26-006-E004' AND `vw_customer_quote_project`.`quotation_status` = 'draft' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 2943675.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
|
1475 |
旭誼工程股份有限公司 |
72 |
Q26-006-E004 |
draft |
2943675.00 |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
|
編輯
|
複製
|
刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 722 AND `vw_customer_quote_project`.`company_name` = '洽隆 CHIAHLUANG ENTERPRISE CO., LTD' AND `vw_customer_quote_project`.`quotation_id` = 50 AND `vw_customer_quote_project`.`quote_no` = 'Q26-006-E003' AND `vw_customer_quote_project`.`quotation_status` = 'draft' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 34650.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
|
722 |
洽隆 CHIAHLUANG ENTERPRISE CO., LTD |
50 |
Q26-006-E003 |
draft |
34650.00 |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
|
編輯
|
複製
|
刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 1473 AND `vw_customer_quote_project`.`company_name` = '帆宣系統科技股份有限公司' AND `vw_customer_quote_project`.`quotation_id` = 48 AND `vw_customer_quote_project`.`quote_no` = 'Q26-006-E002' AND `vw_customer_quote_project`.`quotation_status` = 'draft' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 15225.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
|
1473 |
帆宣系統科技股份有限公司 |
48 |
Q26-006-E002 |
draft |
15225.00 |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
|
編輯
|
複製
|
刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 20 AND `vw_customer_quote_project`.`company_name` = '台灣檢驗科技股份有限公司' AND `vw_customer_quote_project`.`quotation_id` = 21 AND `vw_customer_quote_project`.`quote_no` = 'Q26-006-E001' AND `vw_customer_quote_project`.`quotation_status` = 'draft' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 5250.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
|
20 |
台灣檢驗科技股份有限公司 |
21 |
Q26-006-E001 |
draft |
5250.00 |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
|
編輯
|
複製
|
刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 408 AND `vw_customer_quote_project`.`company_name` = '工業技術研究院' AND `vw_customer_quote_project`.`quotation_id` = 99 AND `vw_customer_quote_project`.`quote_no` = 'Q26-005-E003' AND `vw_customer_quote_project`.`quotation_status` = 'draft' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 18585.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
|
408 |
工業技術研究院 |
99 |
Q26-005-E003 |
draft |
18585.00 |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
|
編輯
|
複製
|
刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 408 AND `vw_customer_quote_project`.`company_name` = '工業技術研究院' AND `vw_customer_quote_project`.`quotation_id` = 96 AND `vw_customer_quote_project`.`quote_no` = 'Q26-005-E002' AND `vw_customer_quote_project`.`quotation_status` = 'draft' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 14910.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
|
408 |
工業技術研究院 |
96 |
Q26-005-E002 |
draft |
14910.00 |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
|
編輯
|
複製
|
刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 408 AND `vw_customer_quote_project`.`company_name` = '工業技術研究院' AND `vw_customer_quote_project`.`quotation_id` = 75 AND `vw_customer_quote_project`.`quote_no` = 'Q26-005-E001' AND `vw_customer_quote_project`.`quotation_status` = 'draft' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 89775.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
|
408 |
工業技術研究院 |
75 |
Q26-005-E001 |
draft |
89775.00 |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
|
編輯
|
複製
|
刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 1475 AND `vw_customer_quote_project`.`company_name` = '旭誼工程股份有限公司' AND `vw_customer_quote_project`.`quotation_id` = 89 AND `vw_customer_quote_project`.`quote_no` = 'Q26-004-H001' AND `vw_customer_quote_project`.`quotation_status` = 'sent' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 788700.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
|
1475 |
旭誼工程股份有限公司 |
89 |
Q26-004-H001 |
sent |
788700.00 |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
|
編輯
|
複製
|
刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 876 AND `vw_customer_quote_project`.`company_name` = '洽隆企業有限公司' AND `vw_customer_quote_project`.`quotation_id` = 95 AND `vw_customer_quote_project`.`quote_no` = 'Q26-004-E001' AND `vw_customer_quote_project`.`quotation_status` = 'draft' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 86100.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
|
876 |
洽隆企業有限公司 |
95 |
Q26-004-E001 |
draft |
86100.00 |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
|
編輯
|
複製
|
刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 1475 AND `vw_customer_quote_project`.`company_name` = '旭誼工程股份有限公司' AND `vw_customer_quote_project`.`quotation_id` = 81 AND `vw_customer_quote_project`.`quote_no` = 'Q26-003-H001' AND `vw_customer_quote_project`.`quotation_status` = 'draft' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 12345000.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
|
1475 |
旭誼工程股份有限公司 |
81 |
Q26-003-H001 |
draft |
12345000.00 |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
|
編輯
|
複製
|
刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 45 AND `vw_customer_quote_project`.`company_name` = 'SERMAX Cryogenics Sdn. Bhd.' AND `vw_customer_quote_project`.`quotation_id` = 80 AND `vw_customer_quote_project`.`quote_no` = 'Q26-002-J031-V1' AND `vw_customer_quote_project`.`quotation_status` = 'draft' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 296000.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
|
45 |
SERMAX Cryogenics Sdn. Bhd. |
80 |
Q26-002-J031-V1 |
draft |
296000.00 |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
|
編輯
|
複製
|
刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 45 AND `vw_customer_quote_project`.`company_name` = 'SERMAX Cryogenics Sdn. Bhd.' AND `vw_customer_quote_project`.`quotation_id` = 58 AND `vw_customer_quote_project`.`quote_no` = 'Q26-002-J031' AND `vw_customer_quote_project`.`quotation_status` = 'replaced' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 176000.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
|
45 |
SERMAX Cryogenics Sdn. Bhd. |
58 |
Q26-002-J031 |
replaced |
176000.00 |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
|
編輯
|
複製
|
刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 17 AND `vw_customer_quote_project`.`company_name` = '工業技術研究院' AND `vw_customer_quote_project`.`quotation_id` = 33 AND `vw_customer_quote_project`.`quote_no` = 'Q26-002-J030' AND `vw_customer_quote_project`.`quotation_status` = 'draft' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 6678000.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
|
17 |
工業技術研究院 |
33 |
Q26-002-J030 |
draft |
6678000.00 |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
|
編輯
|
複製
|
刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 18 AND `vw_customer_quote_project`.`company_name` = '永鈦氣體工業股份有限公司' AND `vw_customer_quote_project`.`quotation_id` = 20 AND `vw_customer_quote_project`.`quote_no` = 'Q26-002-J026' AND `vw_customer_quote_project`.`quotation_status` = 'sent' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 2016000.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
|
18 |
永鈦氣體工業股份有限公司 |
20 |
Q26-002-J026 |
sent |
2016000.00 |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
|
編輯
|
複製
|
刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 7 AND `vw_customer_quote_project`.`company_name` = '國倫科技' AND `vw_customer_quote_project`.`quotation_id` = 56 AND `vw_customer_quote_project`.`quote_no` = 'Q26-002-H009' AND `vw_customer_quote_project`.`quotation_status` = 'draft' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 220500.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
|
7 |
國倫科技 |
56 |
Q26-002-H009 |
draft |
220500.00 |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
|
編輯
|
複製
|
刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 7 AND `vw_customer_quote_project`.`company_name` = '國倫科技' AND `vw_customer_quote_project`.`quotation_id` = 51 AND `vw_customer_quote_project`.`quote_no` = 'Q26-002-H008-V1' AND `vw_customer_quote_project`.`quotation_status` = 'sent' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 288000.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
|
7 |
國倫科技 |
51 |
Q26-002-H008-V1 |
sent |
288000.00 |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
|
編輯
|
複製
|
刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 7 AND `vw_customer_quote_project`.`company_name` = '國倫科技' AND `vw_customer_quote_project`.`quotation_id` = 49 AND `vw_customer_quote_project`.`quote_no` = 'Q26-002-H008' AND `vw_customer_quote_project`.`quotation_status` = 'replaced' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 350000.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
|
7 |
國倫科技 |
49 |
Q26-002-H008 |
replaced |
350000.00 |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
|
編輯
|
複製
|
刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 7 AND `vw_customer_quote_project`.`company_name` = '國倫科技' AND `vw_customer_quote_project`.`quotation_id` = 43 AND `vw_customer_quote_project`.`quote_no` = 'Q26-002-H007' AND `vw_customer_quote_project`.`quotation_status` = 'sent' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 357000.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
|
7 |
國倫科技 |
43 |
Q26-002-H007 |
sent |
357000.00 |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
|
編輯
|
複製
|
刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 1471 AND `vw_customer_quote_project`.`company_name` = 'APP SYSTEMS SERVICES PTE LTD' AND `vw_customer_quote_project`.`quotation_id` = 32 AND `vw_customer_quote_project`.`quote_no` = 'Q26-002-H006' AND `vw_customer_quote_project`.`quotation_status` = 'draft' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 6560.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
|
1471 |
APP SYSTEMS SERVICES PTE LTD |
32 |
Q26-002-H006 |
draft |
6560.00 |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
|
編輯
|
複製
|
刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 7 AND `vw_customer_quote_project`.`company_name` = '國倫科技' AND `vw_customer_quote_project`.`quotation_id` = 14 AND `vw_customer_quote_project`.`quote_no` = 'Q26-002-H005' AND `vw_customer_quote_project`.`quotation_status` = 'draft' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 180600.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
|
7 |
國倫科技 |
14 |
Q26-002-H005 |
draft |
180600.00 |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
|
編輯
|
複製
|
刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 14 AND `vw_customer_quote_project`.`company_name` = '台灣積體電路製造股份有限公司' AND `vw_customer_quote_project`.`quotation_id` = 13 AND `vw_customer_quote_project`.`quote_no` = 'Q26-002-H004' AND `vw_customer_quote_project`.`quotation_status` = 'sent' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 142800.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
|
14 |
台灣積體電路製造股份有限公司 |
13 |
Q26-002-H004 |
sent |
142800.00 |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
|
編輯
|
複製
|
刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 11 AND `vw_customer_quote_project`.`company_name` = '台灣日酸系統科技股份有限公司' AND `vw_customer_quote_project`.`quotation_id` = 8 AND `vw_customer_quote_project`.`quote_no` = 'Q26-002-H003' AND `vw_customer_quote_project`.`quotation_status` = 'sent' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 5997600.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
|
11 |
台灣日酸系統科技股份有限公司 |
8 |
Q26-002-H003 |
sent |
5997600.00 |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
|
編輯
|
複製
|
刪除
DELETE FROM vw_customer_quote_project WHERE `vw_customer_quote_project`.`customer_id` = 9 AND `vw_customer_quote_project`.`company_name` = '亞洲巴萊斯股份有限公司' AND `vw_customer_quote_project`.`quotation_id` = 6 AND `vw_customer_quote_project`.`quote_no` = 'Q26-002-H002' AND `vw_customer_quote_project`.`quotation_status` = 'sent' AND CONCAT(`vw_customer_quote_project`.`quotation_amount`) = 115500.00 AND `vw_customer_quote_project`.`project_id` IS NULL AND `vw_customer_quote_project`.`project_no` IS NULL AND `vw_customer_quote_project`.`project_name` IS NULL AND `vw_customer_quote_project`.`project_status` IS NULL AND CONCAT(`vw_customer_quote_project`.`order_amount`) IS NULL LIMIT 1
|
9 |
亞洲巴萊斯股份有限公司 |
6 |
Q26-002-H002 |
sent |
115500.00 |
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|