WEBADI Queries

WEBADI Queries 

Integrators-

select integrator_code, application_short_name
  from apps.bne_integrators_vl  bnv
      ,apps.fnd_application_vl  fav
 where bnv.user_name = &integrator_name
   and fav.application_id = bnv.application_id;

Layouts -

select layout_code
 where user_name = &integrator_name;

  from apps.bne_layouts_vl;

Mappings-

select mapping_code
 where integrator_code = &integrator_code

  from apps.bne_mappings_vl;

Contents -

select content_code
  where integrator_code = &integrator_code

   from apps.bne_contents_vl;