Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Monday, 30 May 2016

Query to Get Application Details

SELECT fa.application_name       "Application Name"
,      fa.application_short_name "Application Code"
,      fa.application_id         "Application ID"
,      fa.basepath               "Basepath"
,      fa.product_code           "Product Code"
,      usr1.user_name                                        "Created By"
,      fa.creation_date                                      "Creation Date"
,      usr2.user_name                                        xonly_last_updated_by
,      fa.last_update_date                                   xonly_last_update_date
FROM   fnd_application_vl     fa
,      fnd_user usr1
,      fnd_user usr2
WHERE fa.created_by      = usr1.user_id
--AND fa.application_short_name LIKE 'XX%'
AND    fa.last_updated_by = usr2.user_id
ORDER BY 1
,        2
Share this article :

2 comments:

  1. Thanks and Regards. Oracle Apps R12 Training Videos at affordable cost. please check oracleappstechnical.com

    ReplyDelete
  2. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.

    ReplyDelete