tag:blogger.com,1999:blog-4007772006737635792.post8165469988912290408..comments2024-03-27T16:11:52.332+05:30Comments on Shyam's Blog | Oracle Cloud, Peoplesoft, Workday: Finding the Navigation of PeopleSoft Components - Part 1 - SQL Query to find navigation of PS ComponentShyamhttp://www.blogger.com/profile/08146888311621138779noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-4007772006737635792.post-49119616954558194642014-03-08T03:43:29.966+05:302014-03-08T03:43:29.966+05:30Here is a version I wrote for HR 9.0
SELECT E.PRC...Here is a version I wrote for HR 9.0 <br />SELECT E.PRCSTYPE, E.PRCSNAME, F.DESCR, DECODE( H.PORTAL_LABEL,' ','','','','Root','Root ','Root > ' || H.PORTAL_LABEL) || ' > ' || G.PORTAL_LABEL || ' > ' || C.PORTAL_LABEL || ' > ' || B.PORTAL_LABEL || ' > ' || A.PORTAL_LABEL || ' > ' || D.PORTAL_LABEL , D.DESCR254, E.PNLGRPNAME,D.PORTAL_NAME,D.PORTAL_REFTYPE,D.PORTAL_OBJNAME,F.PRCSTYPE,F.PRCSNAME<br /> FROM PSPRSMDEFN D, PS_PRCSDEFNPNL E, PS_PRCSDEFN F, PSPRSMDEFN A, PSPRSMDEFN B, PSPRSMDEFN C, PSPRSMDEFN G, PSPRSMDEFN H<br /> WHERE E.PNLGRPNAME = D.PORTAL_URI_SEG2<br /> AND E.PRCSTYPE = F.PRCSTYPE<br /> AND E.PRCSNAME = F.PRCSNAME<br /> AND D.PORTAL_NAME = 'EMPLOYEE'<br /> AND D.PORTAL_REFTYPE = 'C'<br /> AND E.PNLGRPNAME > ' '<br /> AND A.PORTAL_NAME = 'EMPLOYEE'<br /> AND A.PORTAL_OBJNAME = D.PORTAL_PRNTOBJNAME<br /> AND B.PORTAL_NAME = 'EMPLOYEE'<br /> AND B.PORTAL_OBJNAME = A.PORTAL_PRNTOBJNAME<br /> AND C.PORTAL_NAME (+) = 'EMPLOYEE'<br /> AND C.PORTAL_OBJNAME(+) = B.PORTAL_PRNTOBJNAME<br /> AND G.PORTAL_NAME(+) = 'EMPLOYEE'<br /> AND G.PORTAL_OBJNAME(+) = C.PORTAL_PRNTOBJNAME<br /> AND H.PORTAL_NAME(+) = 'EMPLOYEE'<br /> AND H.PORTAL_OBJNAME(+) = G.PORTAL_PRNTOBJNAME<br /> ORDER BY 1, 2, 4Anonymoushttps://www.blogger.com/profile/13629118826361571532noreply@blogger.comtag:blogger.com,1999:blog-4007772006737635792.post-75297491262916705582013-11-07T21:33:32.243+05:302013-11-07T21:33:32.243+05:30Your first query worked great, and was easy enough...Your first query worked great, and was easy enough to replicate in PSQuery. Thanks much!Anonymoushttps://www.blogger.com/profile/06025822546480958008noreply@blogger.comtag:blogger.com,1999:blog-4007772006737635792.post-8387955834144349262013-02-02T02:30:20.496+05:302013-02-02T02:30:20.496+05:30Useful once againUseful once againAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-4007772006737635792.post-91177483594477445852013-01-21T11:14:04.691+05:302013-01-21T11:14:04.691+05:30Hi,
Replace 'NAME_OF_THE_PS_COMPONENT' in ...Hi,<br />Replace 'NAME_OF_THE_PS_COMPONENT' in the qery with your required PeopleSoft component<br /><br />ShyamShyamhttps://www.blogger.com/profile/08146888311621138779noreply@blogger.comtag:blogger.com,1999:blog-4007772006737635792.post-16808115594579304542013-01-20T23:57:03.432+05:302013-01-20T23:57:03.432+05:30Hi ,
Can you plz let me know what are the paramet...Hi ,<br /><br />Can you plz let me know what are the parameters I have to pass exactly for the 2nd query.<br /><br />Thanks,<br />PriyankaAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-4007772006737635792.post-82365337980649455092012-02-16T23:55:58.641+05:302012-02-16T23:55:58.641+05:30Excellent - Thanks So muchExcellent - Thanks So muchAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-4007772006737635792.post-79754789247436262242011-10-18T19:26:34.366+05:302011-10-18T19:26:34.366+05:30excellent.. this is very helpful :)excellent.. this is very helpful :)Anonymousnoreply@blogger.com