{
	"name": "query/manager/product/production_order/work_in_progress_sql.json",
	"table": [
		{
			"record_type": [""],
			"table": "production_order"
		}
	],
	"from": "production_order",
	"join_table": "product",
	"join_type": "LEFT OUTER JOIN",
	"join_where": [
		["pr.work_number", "=", "pro.json_data.work__position_num_id"]
	],
	"query": ["pro.production_order_state", "in", ["EK", "KU", "AL", "PY"]],
	"select": [
		"pro.json_data.work__position_num_id",
		"pr.product_group",
		"pro.drawing_number",
		"pr.name",
		"pro.production_lot",
		"pro.json_data.creation_date",
		"pro.json_data.material_actual_arrival_date",
		"pr.production_control_type",
		"pro.started_amount",
		"pro.remaining_amount",
		"pro.failed_amount",
		"pro.json_data.sales_price__unit"
	]
}