SELECT PRLA.RESOURCE_LIST_ASSIGNMENT_ID , PRLA.RESOURCE_LIST_ID , PRLA.PROJECT_ID , PRLA.LAST_UPDATE_DATE , PRLA.LAST_UPDATED_BY , PRLA.CREATION_DATE , PRLA.CREATED_BY FROM PA_RESOURCE_LIST_ASSIGNMENTS PRLA , PA_PROJECTS_ALL PPA WHERE PRLA.PROJECT_ID = PPA.PROJECT_ID AND '_SEC:PPA.ORG_ID' IS NOT NULL WITH READ ONLY