Follow us: Subscribe via RSS Feed 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 :

0 comments:

Post a Comment