Query Manager: system automatically WHERE ( A.OPRID = 'PS')
Hi Expert
Currently, we are using Peoplesoft HCM 9.2 with PUM 18, PeopleTool 8.55.07.
When I create new query using record: PSUSEREMAIL, the system automatically (which I did not explicitly specify it) append this where clause: WHERE ( A.OPRID = 'PS') as shown below(note: PS is current login user id):
May I know how to get rid of ‘WHERE ( A.OPRID = 'PS')’ as I intend to query all result.