high level project compare report through SQL
select A.PROJECTNAME AS "CONFLICT-PROJECTS", C.PROJECTDESCR AS "CONFLICT-PROJECTS-DESC ",C.LASTUPDOPRID , B.PROJECTNAME "SCHEDULED-PROJECTS", Decode(a.objecttype,0, 'Record',1,'Index',2,'Field',3,'Field Format',4,'Translate' ,5,'Page',6,'Menu',7,'Component',8,'Record PeopleCode',9,'Menu PeopleCode',10,'Query' ,11,'Tree Structure',12,'Tree',13,'Access Group',14,'Color',15,'Style',16,'Business Process Map' ,17,'Business Process',18,'Activity',19,'Role',20,'Process Definition',21,'Server Definition' ,22,'Process Type Definition',23,'Job Definition',24,'Recurrence Definition',25,'Message Catalog Entry' ,26,'Dimension',27,'Cube Definition',28,'Cube Instance Definition',29,'Business Interlink' ,30,'SQL Object',31,'File Layout Definition',32,'Component Interface',33,'Process Engine Program' ,34,'Process Engine Section',35,'Message Node',36,'Message Channel',37,'Message' ,38,'Approval Rule Set',39,'Message PeopleCode',40,'Subscription PeopleCode' ,41,'Channel PeopleCode',42,'Component Interface PeopleCode',43,'Application Engine PeopleCode' ,44,'Page PeopleCode',45,'Page Field PeopleCode',46,'Component PeopleCode' ,47,'Component Record PeopleCode',48,'Component Record Field PeopleCode',49,'Image' ,50,'Style Sheet',51,'HTML',52,'File Reference',53,'Permission List',54,'Portal Registry Definition' ,55,'Portal Registry Structure',56,'URL Definition',57,'Application Package' ,58,'Application Package PeopleCode',59,'n/a (59)',60,'Problem Type',61,'n/a (61)',62,'XSLT' ,63,'Portal Registry User Favorites',64,'Mobile Page',65,'Relationship',a.objecttype) "Object Type DESC", a.objecttype,A.OBJECTVALUE1, A.OBJECTVALUE2, A.OBJECTVALUE3, A.OBJECTVALUE4,c.LASTUPDDTTM "LASTUPDDTTM NON-SCHED-PROJ", DBMS_LOB.SUBSTR(c.descrlong,4000) as "CONFLICT-PROJ-LONGDESC" FROM PSPROJECTITEM A, PSPROJECTITEM B, PSPROJECTDEFN C --,PSOPRDEFN D WHERE A.OBJECTTYPE = B.OBJECTTYPE AND A.OBJECTVALUE1 = B.OBJECTVALUE1 AND A.OBJECTVALUE2 = B.OBJECTVALUE2 AND A.OBJECTVALUE3 = B.OBJECTVALUE3 AND A.OBJECTVALUE4 = B.OBJECTVALUE4 AND B.PROJECTNAME LIKE 'CS%' and A.PROJECTNAME <> B.PROJECTNAME AND A.PROJECTNAME=C.PROJECTNAME AND A.PROJECTNAME LIKE 'CS%' order by c.LASTUPDDTTM desc ,b.PROJECTNAME,a.PROJECTNAME
