SELECT CASE A.OBJECTTYPE
when 0 then '00- Record'
when 1 then '01- Index'
when 2 then '02- Field'
when 3 then '03- Format Definition'
when 4 then '04- Translate values'
when 5 then '05- Pages'
when 6 then '06- Menus'
when 7 then '07- Components'
when 8 then '08- Record PeopleCode'
when 9 then '09- Menu PeopleCode'
when 10 then '10- Queries'
when 11 then '11- Tree structures'
when 12 then '12- Trees'
when 13 then '13- Access groups'
when 14 then '14- Colors'
when 15 then '15- Styles'
when 16 then '16- Not used'
when 17 then '17- Business Processes'
when 18 then '18- Activities'
when 19 then '19- Roles'
when 20 then '20- Process Definitions'
when 21 then '21- Process servers'
when 22 then '22- Process types'
when 23 then '23- Process jobs'
when 24 then '24- Process recurrences'
when 25 then '25- Message catalog entries'
when 26 then '26- Dimensions'
when 27 then '27- Cube definitions'
when 28 then '28- Cube instance definitions'
when 29 then '29- Business interlinks'
when 30 then '30- SQL definitions'
when 31 then '31- File layout definitions'
when 32 then '32- Component interfaces'
when 33 then '33- Appication Engine programs'
when 34 then '34- Application Engine sections'
when 35 then '35- Message nodes'
when 36 then '36- Message channels'
when 37 then '37- Message definitions'
when 38 then '38- Approval rule sets'
when 39 then '39- Message PeopleCode'
when 40 then '40- Subscription PeopleCode'
when 41 then '41- Not Used'
when 42 then '42- Component interface PeopleCode'
when 43 then '43- Application engine PeopleCode'
when 44 then '44- Page PeopleCode'
when 45 then '45- Page Field PeopleCode'
when 46 then '46- Component PeopleCode'
when 47 then '47- Component record PeopleCode'
when 48 then '48- Component record field PeopleCode'
when 49 then '49- Images'
when 50 then '50- Style sheets'
when 51 then '51- HTML'
when 52 then '52- Not Used'
when 53 then '53- Permission lists'
when 54 then '54- Portal registry definitions'
when 55 then '55- Portal registry structures'
when 56 then '56- URL definitions'
when 57 then '57- Application Packages'
when 58 then '58- Application Package PeopleCode'
when 59 then '59- Portal Registry User homepages'
when 60 then '60- Problem type definitions'
when 61 then '61- Archive templates (deprecated in PeopleTools release 8.44 and above)'
when 62 then '62- XSLT'
when 63 then '63- Portal Registry User Favorites'
when 64 then '64- Mobile Pages'
when 65 then '65- Relationships'
when 66 then '66- CI Property PeopleCode'
when 67 then '67- Optimization Model'
when 68 then '68- File Reference'
when 69 then '69- File Reference Type Code'
when 70 then '70- Archive Object Definitions'
when 71 then '71- Archive Templates (Type 2)'
when 72 then '72- Diagnostic Plug-Ins'
when 73 then 'Analytic Models'
when 74 then '74- Not Used'
when 75 then 'Java Portlet User Preferences'
when 76 then 'WSRP Remote Producers'
when 77 then 'WSRP Remote Portlets'
when 78 then 'WSRP Cloned Portlet Handles'
when 79 then 'Services'
when 80 then 'Service Operations'
when 81 then 'Service Operation Handlers'
when 82 then 'Service Operation Version'
when 83 then 'Service Operation Routings'
when 84 then 'IB Queues'
when 85 then 'BIP Template Definitions'
when 86 then 'BIP Report Definitions'
when 87 then 'BIP File Definitions'
when 88 then 'BIP Data Source Definitions'
when 89 then 'WSDL'
when 90 then 'Message Schemas'
when 91 then 'Connected Query Definitions'
when 92 then 'Logical Schemas'
when 93 then 'XML Schemas'
when 94 then 'Relational Schemas'
when 95 then 'Dependency Documents'
when 96 then 'Document Schema'
when 97 then 'Essbase Cube Dimensions'
when 98 then 'Essbase Cube Outlines'
when 99 then 'Essbase Cube Connections'
when 100 then 'Essbase Cube Templates'
when 101 then 'Delimited Schemas'
when 102 then 'Positional Schemas'
when 103 then 'Application Data Set Definitions'
when 104 then 'Test Defintions'
when 105 then 'Test Framework Test Cases'
when 106 then 'Application Data Set Bindings'
when 107 then 'Feed Definitions'
when 108 then 'Feed Categories'
when 109 then 'Feed Data Type'
when 110 then 'JSON Documents'
when 111 then 'Related Content Definition'
when 112 then 'Related Content Services'
when 113 then 'Related Content Configurations'
when 114 then 'Related Content Layouts'
when 115 then 'Search Attributes'
when 116 then 'Search Definitions'
when 117 then 'Search Categories'
when 118 then 'Search Contexts'
when 119 then 'Integration Groups'
when 120 then 'HTML Documents'
when 121 then 'MAP Layouts'
when 122 then 'MAP Templates'
when 123 then 'Composite Query'
when 124 then 'MAP PeopleCode'
when 125 then 'MAP Admin Manager'
ELSE TO_CHAR(A.OBJECTTYPE) End OBJECTTYPE
, A.OBJECTVALUE1
,A.OBJECTVALUE2
,A.OBJECTVALUE3
,A.OBJECTVALUE4
,CASE A.sourcestatus
when 0 then 'Unknown'
when 1 then 'Absent'
when 2 then 'Changed'
when 3 then 'Unchanged'
when 4 then '*Changed'
when 5 then '*Unchanged'
when 6 then 'Same'
ELSE TO_CHAR(A.sourcestatus) End SOURCE
,CASE A.targetstatus
when 0 then 'Unknown'
when 1 then 'Absent'
when 2 then 'Changed'
when 3 then 'Unchanged'
when 4 then '*Changed'
when 5 then '*Unchanged'
when 6 then 'Same'
ELSE TO_CHAR(A.targetstatus) End TARGET,
CASE A.upgradeaction
when 0 then 'Copy'
when 1 then 'Delete'
when 2 then 'None'
when 3 then 'Copy Prop'
ELSE TO_CHAR(A.upgradeaction) End Upgrade,
CASE A.TAKEACTION
when 1 then 'YES'
When 0 Then 'NO'
end TAKEACTION
FROM SYSADM.PSPROJECTITEM A
where PROJECTNAME ='CS92UPG_MASTER';
No comments:
Post a Comment