Lists all products and their Installation Status SELECT fat . application_name , fa . application_id , fpi . patch_level , Decode ( fpi . status , 'I' , 'Licensed' , 'N' , 'Not Licensed' , 'S' , 'Shared' , 'Undetermined' ) STATUS FROM fnd_product_installations fpi , fnd_application fa , fnd_application_tl fat WHERE fpi . application_id = fa . application_id AND fat . application_id = fa . application_id AND fat . language = 'US' ; Query to find the Short Name for a Particular Application SELECT application_short_name , application_id FROM fnd_application_vl WHERE application_name LIKE '%Payables%' Query to find Installation Status of a Particular Product SELECT fat . appl