Tuesday, September 13, 2016

Discoverer Report Last Run By Stats Query

SELECT qs_doc_name disc_rpt_name,
         qs_doc_owner disc_rpt_owner,
         (SELECT user_name
            FROM fnd_user
           WHERE '#' || user_id = qs_created_by)
            disc_rpt_run_by,
         qs_created_date disc_rpt_run_date
    FROM disprd.eul5_qpp_stats
   WHERE qs_doc_name = 'XX Disc Report Name'
ORDER BY qs_created_date DESC

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...