Users with role 'sn_esm_agent' are not able to see all the records in ast_contract table.
All Available releases
An out of the box business rule called "Contract query for agents" is preventing the sn_esm_agent users to access all the records.
The business rule would run only if the users have sn_esm_agent role as per the condition. Users can modify the business rule or modify the user roles for enabling them to view all the records in ast_contract table.