SQL To get query security tree navigation based on record name/node name  :

select a.tree_name
        ||'-->'||(select B.parent_node_name from PSTREENODE B where B.TREE_NODE=(select C.parent_node_name from PSTREENODE C where C.TREE_NODE=(select C1.parent_node_name from PSTREENODE C1 where C1.TREE_NODE=D.parent_node_name and C1.tree_name=D.tree_name and rownum=1 ) and C.tree_name=D.tree_name and rownum=1 ) and B.tree_name=A.tree_name and rownum=1 )
       ||'-->'||(select C.parent_node_name from PSTREENODE C where C.TREE_NODE=(select C1.parent_node_name from PSTREENODE C1 where C1.TREE_NODE=D.parent_node_name and C1.tree_name=D.tree_name and rownum=1 ) and C.tree_name=D.tree_name and rownum=1 )
       ||'-->'||(select C1.parent_node_name from PSTREENODE C1 where C1.TREE_NODE=D.parent_node_name and C1.tree_name=D.tree_name and rownum=1 )
       ||'-->'||(select B.parent_node_name from PSTREENODE B where B.TREE_NODE=A.parent_node_name and B.tree_name=A.tree_name and rownum=1 )
        ||'-->'||A.parent_node_name
        ||'-->'||A.TREE_NODE
        from PSTREENODE A,PSTREENODE D where
        D.TREE_NODE=A.parent_node_name AND a.tree_name=D.TREE_NAME AND
      
        A.TREE_NODE='Reocrd-name'

To  Hide  Page Title tab

 in your component if you have only one page and you want hide tab name so uncheck below check in component level


 then you can use HTML for page Title

To get project information based on object name :

SELECT A.OBJECTVALUE1,A.PROJECTNAME,B.LASTUPDDTTM,B.LASTUPDOPRID FROM PSPROJECTITEM A,PSPROJECTDEFN B

WHERE A.OBJECTVALUE1='Object Name' AND B.PROJECTNAME=A.PROJECTNAME

To get Component interface information

Use below SQL to get CI assigned permission list

SELECT * FROM PSAUTHBUSCOMP WHERE BCNAME='CI Name'

To get object migrated from which project

SELECT A.OBJECTVALUE1,A.PROJECTNAME,B.LASTUPDDTTM,B.LASTUPDOPRID FROM PSPROJECTITEM A,PSPROJECTDEFN B WHERE A.OBJECTVALUE1='Object Name' AND B.PROJECTNAME=A.PROJECTNAME

Multiple SQL statements in one single Application Engine SQL Action

%Execute([/])
statment1{; | /}
statment2{; | /}
statment3{; | /}

ex:

%Execute(/)
statment1
/
statement2
/
statement3
/

How to find PeopleSoft current bundle number

use below Sql in DESCR place you can get bundle number info

SELECT A.UPDATE_ID, A.DESCR, A.DTTM_IMPORTED, A.FIXOPRID, A.APPLYOPRID, A.PRODUCT_LINE, A.RELEASEDTTM, A.RELEASELABEL, A.MAINTLOGTYPE, A.DESCRLONG FROM PS_MAINTENANCE_LOG A WHERE upper(A.DESCRLONG) like '%BUNDLE%' ORDER BY 3 DESC

Some good peoplesoft blogs :

http://peoplesofthrms.blogspot.in