SELECT AAR.CREATION_DATE , AAR.CREATED_BY , AAR.LAST_UPDATE_DATE , AAR.LAST_UPDATED_BY , AAR.LAST_UPDATE_LOGIN , AAR.OBJECT_APPROVAL_ID , AAR.OAM_RULE_ID , AMR.DESCRIPTION , AMA.DESCRIPTION FROM ASO_APR_RULES AAR , AME_RULES AMR , AME_ACTIONS AMA WHERE AAR.OAM_RULE_ID = AMR.RULE_ID AND AMR.ACTION_ID = AMA.ACTION_ID AND (AMR.END_DATE IS NULL OR SYSDATE < AMR.END_DATE) AND (AMA.END_DATE IS NULL OR SYSDATE < AMA.END_DATE)