PS Query and magic of OPRID

OPRID is one of the "magic fields" that Query (and PeopleSoft) knows and treats specially. 

If you join in a record that has OPRID as a key but it is NEITHER a Search nor List Box then Query will automatically add the criteria of "(<record>.OPRID = <current user) AND " 

To see this in action, look at any of the operator preference tables (e.g. OPR_DEF_TBL_FS) and then look at the SQL it generated. Compare it to PSOPRDEFN where this criteria is NOT added.