spool app_modules_psoft.rslt 

set linesize 100;
set pagesize 1000;
set long 50;
set echo off;
set feedback off;
break on "Status" on "Short Name" on "App"; 
 
/* ******************************************************* */
/*                                                         */
/* Owner: R.Kupcunas                                       */
/* Date: 01-may-95                                         */
/*                                                         */
/* Query to show the PSOFT Application modules installed  */
/*   and the versions of the said modules                  */
/*                                                         */
/* Note: usually all modules are installed but only a few  */
/*   are leveraged - some the existance of a module does   */
/*   not necessarly indicate that it is being used         */
/*                                                         */
/* Status:                                                 */
/*  I ..... installed                                      */
/*  N ..... not installed                                  */
/*  S ..... shared                                         */
/*                                                         */
/* ******************************************************* */
    
select * from sysadmn.psrelease;
select * from sysadm.ps_installation;
         
select COMPANY ,
 decode(HR, 'Y', 'Yes', 'N', 'No', '???')				"HR?",
 decode(AM, 'Y', 'Yes', 'N', 'No', '???')				"AM?",
 decode(AP, 'Y', 'Yes', 'N', 'No', '???')				"AP?",
 decode(AR, 'Y', 'Yes', 'N', 'No', '???') 				"AR?",
 decode(GL, 'Y', 'Yes', 'N', 'No', '???')  				"GL?",
 decode(BD, 'Y', 'Yes', 'N', 'No', '???')				"BD?",
 decode(PC, 'Y', 'Yes', 'N', 'No', '???') 				"PC?",
 decode(PO, 'Y', 'Yes', 'N', 'No', '???')  				"PO?",
 decode(INV, 'Y', 'Yes', 'N', 'No', '???')				"INV?",
 decode(BI, 'Y', 'Yes', 'N', 'No', '???') 				"BI?",
 decode(OM, 'Y', 'Yes', 'N', 'No', '???')  				"OM?",
 decode(PUBLIC_SECTOR, 'Y', 'Yes', 'N', 'No', '???')            	"Pub Sec?",
 decode(TL, 'Y', 'Yes', 'N', 'No', '???')              		"TL?",
 decode(AUTO_EE_TAX, 'Y', 'Yes', 'N', 'No', '???')            				"EE Tax?",
 decode(FMLA_ADMINISTRN, 'Y', 'Yes', 'N', 'No', '???')        				"FMLA?",
 decode(PA, 'Y', 'Yes', 'N', 'No', '???')                     				"PA?"
from sysadm.ps_installation;


set echo on;
set feedback on;
spool off;
set long 80;
commit;










