All Product info & Patchset Level

All Product info & Patchset Level

SELECT distinct substr(APPLICATION_SHORT_NAME,1,8) product,application_name,
substr(PRODUCT_VERSION,1,14) version,substr(PATCH_LEVEL,1,11) patch_level
FROM fnd_application a, fnd_product_installations p,fnd_application_tl t
WHERE a.application_id = p.application_id and p.application_id=t.application_id ORDER BY 1 ;

Application Release Version Check

SELECT RELEASE_NAME FROM FND_PRODUCT_GROUPS;