Thursday, April 3, 2025

SQL Query to Find Oracle Web ADI Importer Package Procedure Name

 SELECT ba.attribute2     wed_adi_package_procedure_name
  FROM apps.bne_attributes      ba,
       apps.bne_param_lists_b   bplb,
       apps.bne_interfaces_b    bib,
       apps.bne_integrators_tl  bit
 WHERE     bib.upload_param_list_code = bplb.param_list_code
       AND bib.integrator_code = bit.integrator_code
       AND ba.attribute_code = bplb.attribute_code
       AND bit.user_name = :Integrator_name
       AND bit.language = 'US';

SQL Query to Find Oracle Web ADI Importer Package Procedure Name

 SELECT ba.attribute2     wed_adi_package_procedure_name   FROM apps.bne_attributes      ba,        apps.bne_param_lists_b   bplb,        ap...