SELECT PE.NAME , APS.NAME , PEA.EFFECTIVE_START_DATE , PEA.EFFECTIVE_END_DATE , PE.ENTITY_ID , APS.ACCOUNT_POSITION_SET_ID , PE.LAST_UPDATE_DATE , PE.LAST_UPDATED_BY , PE.CREATED_BY , PE.CREATION_DATE FROM PSB_ENTITY PE , PSB_ENTITY_ASSIGNMENT PEA , PSB_ACCOUNT_POSITION_SETS APS , PSB_SET_RELATIONS SR WHERE PE.ENTITY_ID = PEA.ENTITY_ID AND PE.ENTITY_TYPE = 'CONSTRAINT' AND APS.ACCOUNT_OR_POSITION_TYPE = 'A' AND SR.ACCOUNT_POSITION_SET_ID = APS.ACCOUNT_POSITION_SET_ID AND SR.CONSTRAINT_ID = PE.ENTITY_ID WITH READ ONLY