/* 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;