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

Pages

» » Query to Get Application Details

Monday, 30 May 2016

Query to Get Application Details

Posted by at Labels:
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. Unknown28 February 2019 at 21:27

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

    ReplyDelete
  2. Smith10 February 2020 at 22:52

    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

Subscribe to: Post Comments (Atom)