From 2d9d19b9ac5097f2fcd975efce0b126e1fda7fde Mon Sep 17 00:00:00 2001 From: miker Date: Fri, 4 Mar 2011 14:25:20 +0000 Subject: [PATCH] correct the MOBTS view with regard to reservation additions (only affects reporting) git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_1_6@19579 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/500.view.cross-schema.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/500.view.cross-schema.sql b/Open-ILS/src/sql/Pg/500.view.cross-schema.sql index 4909e8219b..2dc82e28b2 100644 --- a/Open-ILS/src/sql/Pg/500.view.cross-schema.sql +++ b/Open-ILS/src/sql/Pg/500.view.cross-schema.sql @@ -37,7 +37,7 @@ CREATE OR REPLACE VIEW money.open_billable_xact_summary AS JOIN pg_class p ON (xact.tableoid = p.oid) LEFT JOIN "action".circulation circ ON (circ.id = xact.id) LEFT JOIN money.grocery groc ON (groc.id = xact.id) - LEFT JOIN booking.reservation res ON (groc.id = xact.id) + LEFT JOIN booking.reservation res ON (res.id = xact.id) LEFT JOIN ( SELECT billing.xact, billing.voided, -- 2.11.0