SELECT  d.object_id, e.access_name, f.access_name
  FROM  ibe_dsp_obj_lgl_ctnt d,
        ibe_dsp_context_b    e,
        jtf_amv_items_b     f
 WHERE  d.item_id           = f.item_id
   AND  d.object_type       = 'I'
   AND  e.context_type_code = 'MEDIA'
   AND  d.context_id        = e.context_id
   AND  d.object_id IN ( SELECT a.inventory_item_id
                         FROM   ibe_dsp_section_items a,
                                ibe_dsp_sections_b b,
                                ibe_dsp_msite_sct_items c
                         WHERE  a.section_item_id   = c.section_item_id
                         AND    a.section_id        = b.section_id
                         AND    b.section_type_code = 'F'
                         AND    c.mini_site_id      = 10022)