ATLAS PAGES. Role 'L' (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 = 'L' 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 = 'L'
          )
order by category_id,trim(cif_name)