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
Thanks and Regards. Oracle Apps R12 Training Videos at affordable cost. please check oracleappstechnical.com
ReplyDeleteOracle 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