EXCHANGE WITH RCSB. ROLE 'O' (The mapping)

Select Cif_name,Sql_expression,From_the_object 

from
          (select  '   '||mmcif_item Cif_name,sqlexpr sql_expression,ci.object_name from_the_object, mmcif_catgy category_id
           from    object_info @msdrep6d oi,column_info@msdrep6d ci 
           where oi.object_name = ci.object_name and oi.attrib_group = ci.attrib_group
               and oi.entity_type = ci.entity_type and oi.role = ci.role
               and oi.role = 'O' and ci.mmcif_item is not null
          

           union

           select  mmcif_catgy Cif_name,null sql_expression,null from_the_object, mmcif_catgy category_id
           from    object_info@msdrep6d 
           where  role = 'O'
          )
order by category_id,trim(cif_name)