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