Oracle E-Business Suite Daily SQL Statements

Oracle E-Business Suite Daily SQL:
Current version:
SELECT RELEASE_NAME FROM APPS.FND_PRODUCT_GROUPS;
Find out application server information from database server: 
column name format a20
SELECT NAME, NODE_ID, SERVER_TYPE FROM APPS.FND_APP_SERVERS;
NAME                                     NODE_ID       SERVER_TYPE
--------------------                      ----------          ------------------------------
<hostname>_EBSDEV_APPS      10113            APPS
<hostname>_EBSDEV_DB          10112            DB
Find out Oracle E-Business Suite Shared products:
set pagesize 0
column applicaiton_name format a500
column status format a200
SELECT at.application_name || '      ' ||
   decode(pi.STATUS,'I','Licensed', 'N','Not Licensed','S','Shared','Unknown') STATUS
   FROM APPLSYS.fnd_product_installations pi
       ,APPLSYS.fnd_application a
       ,APPLSYS.fnd_application_tl at
  WHERE pi.application_id = a.application_id
    AND at.application_id = a.application_id
    AND at.LANGUAGE = 'US'
 AND pi.status='S' order by application_name;
Find out Oracle E-Business Suite Licensed products:
set pagesize 0
column applicaiton_name format a500
column status format a200
SELECT at.application_name || '      ' ||
   decode(pi.STATUS,'I','Licensed', 'N','Not Licensed','S','Shared','Unknown') STATUS
   FROM APPLSYS.fnd_product_installations pi
       ,APPLSYS.fnd_application a
       ,APPLSYS.fnd_application_tl at
  WHERE pi.application_id = a.application_id
    AND at.application_id = a.application_id
    AND at.LANGUAGE = 'US'
 AND pi.status='I' order by application_name;