Oracle WebADI (R12) Examine Configuration of WebADI Layouts and Codes

This SQL statement was used to support the creation of custom menu items for custom WebADI layouts.

SELECT biv.integrator_code,
  biv.user_name,
  fa.application_id,
  fa.application_short_name
  ,biv.language
  , bl.layout_code
FROM bne_integrators_tl biv,
  fnd_application fa,
  fnd_application_tl fat,
  BNE_LAYOUTS_B bl
WHERE biv.application_id = fa.application_id
AND fa.application_id    = fat.application_id
  /* The next few line can be commented or changed to suit*/
AND fa.application_short_name = 'PA'
and biv.integrator_code = 'PAXTTRXB'
and biv.integrator_code = bl.integrator_code
AND fat.language              = 'US'            
and biv.language = fat.language
ORDER BY fa.application_short_name,
  biv.user_name;

Leave a Reply