SELECT ORGANIZATION_ID , 'ORGANIZATION' , RESPONSIBILITY_ID FROM BIS_SECURED_INV_ORGS1_V UNION SELECT ORGANIZATION_ID , 'HR_ORGANIZATION' , RESPONSIBILITY_ID FROM BIS_SECURED_HR_ORGS1_V UNION SELECT ORGANIZATION_ID , 'OPERATING_UNIT' , RESPONSIBILITY_ID FROM BIS_SECURED_OPERATING_UNITS1_V UNION SELECT ORGANIZATION_ID , 'BUSINESS_GROUP' , RESPONSIBILITY_ID FROM BIS_SECURED_BUSINESS_GROUPS1_V UNION SELECT ORGANIZATION_ID , 'LEGAL_ENTITY' , RESPONSIBILITY_ID FROM BIS_SECURED_LEGAL_ENTITIES1_V