컨베이어 라인 공정 시스템 개편 - 출하지시서 입력 - 작업 소요 시간 추가 - 제한 수량 변경 "SELECT un.ItemCode,un.ItemName,pk.ProdCount,ifnull(pd.FaceShot,-1),ifnull(pd.EyeShot ,-1),un.ProdCode FROM jomtTesterDB.jomtPKCodeTbl AS pk INNER JOIN (SELECT ItemCode,ProdCode,ItemName FROM jomtTesterDB.jomtProdList UNION SELECT ItemCode,ProdCode,ItemName FROM jomtTesterDB.jomtComponentTbl) AS un ON pk.ProdCode = un.ItemCode LEFT JOIN jomtTesterDB.jomtProdList AS pd ON pk.ProdCode = pd.ItemCode WHERE pk.PKCode = 'PK001-0270'" "select it.code,it.name,io.expected_out_count,io.id from order_details od join items it on it.id = od.item_id join order_sheets os on os.id = od.order_sheet_id join item_outflows io on io.order_detail_id = od.id where os.code = 'ORD240821-0191' and od.deleted_at is null and io.state = 'registered';" select it.code,it.name,io.expected_out_count,io.id from order_details od join items it on it.id = od.item_id join order_sheets os on os.id = od.order_sheet_id join item_outflows io on io.order_detail_id = od.id where os.code = 'ORD240821-0191' and od.deleted_at is null and io.state = 'registered'; gbInvoice lbInv txbInv 312312445190 ORD240821-0191 312406202122 312406198126 312406276129 312406374128 312406101124 312406751122 312406542127 312406966127 312406724127 312406016128 124029114145