Peoplesoft Query - How to know the navigation for a particular oracle peoplesoft component or oracle peoplesoft page
How to know the navigation for a particular Oracle PeopleSoft Component or Oracle Peoplesoft Page For knowing the navigation of any page in peoplesoft. Just get the name of its component and place it in the query's last parameter (Component Name) and execute. Then follow the given navigation on PIA to access the Page. SELECT DISTINCT 'Root > '||DECODE(LTRIM(RTRIM(A.PT_IQLEVEL1_LBL)),'','', A.PT_IQLEVEL1_LBL||' > ')||DECODE(LTRIM(RTRIM(A.PT_IQLEVEL2_LBL )),'','', A.PT_IQLEVEL2_LBL||' > ')|| DECODE(LTRIM(RTRIM(A.PT_IQLEVEL3_LBL)),'','',A .PT_IQLEVEL3_LBL||' > ')||DECODE(LTRIM(RTRIM(A.PT_IQLEVEL4_LBL)),'', '',A.PT_IQLEVEL4_LBL|| ' > ')|| DECODE(LTRIM(RTRIM(A.PORTAL_LABEL)),'','',A.PO RTAL_LABEL||' > ')||DECODE(LTRIM(RTRIM(B.PT_IQLEVEL1_LBL)),'', '',B.PT_IQLEVEL1_LBL||' > ')|| DECODE(LTRIM(RTRIM(B.PT_IQ...