Oracle Web ADI Integrator - Layout - Mapping - Content Query

-----------Integrtor-----------
select integrator_code, application_short_name
  from apps.bne_integrators_vl  bnv
      ,apps.fnd_application_vl  fav
 where bnv.user_name like 'XX Patty Cash AP Invoice%'
   and fav.application_id = bnv.application_id;


---------layout------------
select layout_code,user_name
  from apps.bne_layouts_vl
 where user_name like 'XX Patty Cash AP Invoice%'
 ;   -- XXPATTYCASHAPINVOICELAYOUT


---------Mapping---------
 select mapping_code
  from apps.bne_mappings_vl
 where integrator_code = 'XXAPINV4_XINTG';

-----------Content -------------
 select content_code
   from apps.bne_contents_vl
  where integrator_code = 'XXAPINV4_XINTG';