PeopleSoft: PL/SQL to fetch the details of the objects included in an AppDesigner project

Select projectname, DECODE(OBJECTTYPE,
'0','Record',
'1','Index',
'2','Field',
'3','Field Formats',
'4','Translate',
'5','Page',
'6','Menus',
'7','Component',
'8','RecordPC',
'9','Menu People Code',
'10','Query',
'11','Tree Structures',
'12','Trees',
'13','Access Groups',
'14','Colors',
'15','Styles',
'16','Business Process Map',
'17','Business Process',
'18','Activities',
'19','Role',
'20','Process Definition',
'21', 'Server Definition',
'22' , 'Process Type Definition',
'23','Job Defination',
'24','Recurrence Definition',
'25','Message Catalog',
'26','Dimensions',
'27','Cube Definitions',
'28','Cube Instance Definitions',
'29','Business Interlinks',
'30','SQL',
'31','File Layout',
'32','Component Interface',
'33','AE Program',
'34','AE Sections',
'35','Message Nodes',
'36','Message Channel',
'37','Message',
'38','Approval Rule Set',
'39','Message Peoplecode',
'40','Subscription PeopleCode',
'41','Channel PeopleCode',
'42','Comp Interface People Code',
'43', 'AE Peoplecode',
'44','Page PC',
'45','Page Field PeopleCode',
'46','Component Peoplecode',
'47','Component Record PeopleCode',
'48','Component Record PC',
'49','Image',
'50','Style Sheets',
'51','HTML',
'52','File Reference',
'53','Permission List',
'54','Portal Registry Definition',
'55','Portal Registry',
'56','URL',
'57','Application Packages',
'58','Application Package PC',
'59','Portal Registry User homepage',
'60','Problem type definition',
'61','Archieve templates',
'62','XSLT','63','Portal Registry User Favorite',
'64','MobilePages',
'65','Relationships',
'66','Component Interface Property PeopleCode',
'67','Optimization Models',
'68','File Reference',
'69','File Reference Type Codes',
'70','Archive Object Definition',
'71','Archive Template',
'72','Diagnostic Plug-In',
'73','Analytic Models',
'79','Services',
'80','Service Operations',
'81','Service Operation Handlers',
'82','Service Operation Versions',
'83','Service Operation Routings',
'84','IB Queues',
'85','XMLP Template Definition',
'86','XMLP Report Definition',
'87','XMLP File Definition',
'88','XMLP Data Source Definition',objecttype) OBJECT
, OBJECTVALUE1||'-->'||OBJECTVALUE2||'-->'||OBJECTVALUE3||'-->'||OBJECTVALUE4 KEY
, DECODE(SOURCESTATUS,'0','Unknown','1','Absent','2','Changed','3','Unchanged','4','*Changed','6','Same', SOURCESTATUS) SOURCE
, DECODE(TARGETSTATUS,'0','Unknown','1','Absent','2','Changed','3','Unchanged', '4','*Changed','6','Same',targetstatus) TARGET
, DECODE(UPGRADEACTION,'0','Copy','1','1','2','None','3','CopyProp',UPGRADEACTION) ACTION
, DECODE(TAKEACTION,'0','No','1','Yes', takeaction)UPGRADE
, DECODE(COPYDONE,'0','No','1','Yes', COPYDONE) COPY
From psprojectitem
Where projectname like 'PROJECT_NAME%';