Query to find Custom Layouts for Oracle WebADI

--Query to get WebADI Custom layouts
SELECT bl.application_id
      ,(select APPLICATION_NAME
          from fnd_application_vl
         where application_id = bl.application_id) lay_app_name
      ,bl.layout_code
      ,bl.user_name layout_name
      ,bl.integrator_app_id
      ,(select APPLICATION_NAME
          from fnd_application_vl
         where application_id = bl.integrator_app_id) intg_app_name
      ,bl.integrator_code
      ,(select user_name from fnd_user where user_id = bl.created_by) lay_created_by
      ,creation_date
  FROM bne_layouts_vl bl
 WHERE bl.created_by > 2
   AND EXISTS
       (select 1
          from fnd_user
         where user_id = bl.created_by)


--Query to get all the Fields/Columns included/selected for the specific WebADI Layout Code
SELECT blc.prompt_left
      ,blc.interface_col_name
      ,blc.user_hint
      ,blc.required_flag
      ,blc.display_flag
      ,blc.read_only_flag
      ,blc.val_type
      ,blc.val_id_col
      ,blc.val_obj_name
      ,blc.lov_type
    FROM bne_layout_cols_v blc
   WHERE blc.layout_code = :P_LAYPUT_CODE --Get custom layout code from above query output
ORDER BY block_id
        ,sequence_num