Add index on T_LOCATIONS.LOCT_CODE. Rename views to emphasise that they are part of the PSQ schema.
Create a separate PSR context for each PSR schema.