SELECT ACC.SALESFORCE_ID RESOURCE_ID , ACC.SALES_LEAD_ID SALES_LEAD_ID , ACC.OBJECT_CREATION_DATE CREATION_DATE , LEAD.STATUS_CODE STATUS_CODE FROM AS_ACCESSES_ALL ACC , AS_SALES_LEADS LEAD WHERE ACC.SALES_LEAD_ID IS NOT NULL AND ACC.OPEN_FLAG = 'Y' AND ACC.SALES_LEAD_ID = LEAD.SALES_LEAD_ID