Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select patronorg.shortname "patron home",circorg.shortname "circ org",copyorg.shortname "copy org",callorg.shortname "call number org",ac.id,ac.usr,mmbxs.balance_owed from action.circulation ac,
- money.materialized_billable_xact_summary mmbxs,
- actor.usr au,
- actor.org_unit circorg,
- actor.org_unit patronorg,
- actor.org_unit copyorg,
- actor.org_unit callorg,
- asset.copy acopy,
- asset.call_number acn
- where
- ac.id=mmbxs.id and
- au.id=ac.usr and
- circorg.id=ac.circ_lib and
- patronorg.id=au.home_ou and
- copyorg.id=acopy.circ_lib and
- callorg.id=acn.owning_lib and
- acopy.id=ac.target_copy and
- acn.id=acopy.call_number and
- mmbxs.usr in(select id from actor.usr where home_ou in
- (
- 114
- )) and balance_owed>0
- order by circorg.id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement