获取Process、Component 和 Page 的导航路径

-- Navigation based off Process


SELECT PRCSPNL.PRCSNAME, MENUGROUP || ' > ' || MENULABEL || ' > ' || BARLABEL || ' > ' || ITEMLABEL "Path"
FROM PSMENUITEM MENU, PS_PRCSDEFNPNL PRCSPNL, PSMENUDEFN MNUDFN
WHERE MENU.PNLGRPNAME = PRCSPNL.PNLGRPNAME
AND MNUDFN.MENUNAME = MENU.MENUNAME
AND PRCSPNL.PRCSNAME LIKE 'PY026%'
-- SQR Name starts with "PY026"

-- Navigation based off Panel


SELECT MENU.PNLGRPNAME, PNLGRP.MARKET, PNLGRP.ITEMNAME, PNLGRP.PNLNAME, MENUGROUP || ' > ' || MENULABEL || ' > ' || MENU.BARLABEL || ' > ' || MENU.ITEMLABEL "Path"
FROM PSMENUITEM MENU, PSMENUDEFN MNUDFN, PSPNLGROUP PNLGRP
WHERE MNUDFN.MENUNAME = MENU.MENUNAME
AND MENU.PNLGRPNAME = PNLGRP.PNLGRPNAME
AND PNLGRP.PNLNAME LIKE 'BANK_TABLE_1'
-- Page Name ="BANK_TABLE_1"

-- Navigation based off PanelGroup


SELECT MENU.PNLGRPNAME, MENUGROUP || ' > ' || MENULABEL || ' > ' || BARLABEL || ' > ' || ITEMLABEL "Path"
FROM PSMENUITEM MENU, PSMENUDEFN MNUDFN
WHERE MNUDFN.MENUNAME = MENU.MENUNAME
AND MENU.PNLGRPNAME = 'BANK_TABLE'
-- Component Name ="BANK_TABLE"