/* Shows the Oracle Application modules installed          */
/* and the versions of the modules                         */
/* Status:                                                 */
/*  I ..... installed                                      */
/*  N ..... not installed                                  */
/*  S ..... shared                                         */
 
spool app_modules_oracle.rslt 
 
SET linesize 100;
SET pagesize 1000;
SET LONG 50;
SET echo off;
SET feedback off;
break ON "Status" ON "Short Name" ON "App"; 
 
SELECT status                                                       "Status",
       SUBSTR(B.APPLICATION_SHORT_NAME, 1, 10)                  "Short Name",
       SUBSTR(B.APPLICATION_ABBREV, 1, 3)                         "App",
       SUBSTR(B.DESCRIPTION, 1, 30)                                "Desc",
       SUBSTR(B.APPLICATION_PREFIX, 1, 6)                           "Prefix",
       SUBSTR(A.PRODUCT_VERSION, 1, 8)                             "Version",
       SUBSTR(TO_CHAR(A.CREATION_DATE, 'YYYY-MON-DD'), 1, 12)     "Installed",
       SUBSTR(TO_CHAR(A.LAST_UPDATE_DATE, 'YYYY-MON-DD'), 1, 12)     "Updated"
       FROM applsys.fnd_product_installations  A,
     applsys.fnd_application            B
WHERE A.APPLICATION_ID = B.APPLICATION_ID
ORDER BY 1, 2, 3;
 
SET echo ON;
SET feedback ON;
spool off;
SET LONG 80;
COMMIT;