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
0 comments:
Post a Comment