{
	"name": "query/manager/order/order_row/purchase/work_in_progress_material_sql.json",
	"table": [{
		"record_type": [""],
		"table": "order_row"
	}],
	"from": "order_row",
	"join_table": "production_order",
	"join_type": "LEFT OUTER JOIN",
	"join_where": [
		["pro.production_lot", "=", "ordr.production_lot"]
	],
	"query": [
		["ordr.json_data.order_type", "=", "RA"], "and", ["ordr.delivery_state", "in", ["OT", "LT"]], "and", ["pro.production_order_state", "in", ["EK", "KU", "AL", "PY"]]
	],
	"select": ["ordr.price_without_vat"]
}