--查询界面的权限具体对应哪一个

SELECT t0.FID "菜单ID", t0.FALIAS "菜单别名",t0.FNAME_L2 "菜单名称",t1.FID "权限项ID",t1.FALIAS_L2 "权限项别名",t1.FNUMBER "权限项编码",t1.FISLEAF "是否叶子节点" ,t2.FURL "权限项url" ,t2.FACTION "操作描述" FROM 

t_bs_service t0

inner join t_pm_permitem t1 on t0.FPERMISSIONID = t1.FID 

inner join t_pm_permitemurl t2 on t1.FID = t2.FPARENTID 

where t0.FID = 'serviceId替换'

or t2.FURL like '%uipk替换%'

8.6sp1版本及以上版本：

SELECT t0.FID "菜单ID", t0.FALIAS_L2 "菜单别名",t0.FNAME_L2 "菜单名称",t1.FID "权限项ID",t1.FALIAS_L2 "权限项别名",t1.FNUMBER "权限项编码",t1.FISLEAF "是否叶子节点" ,t2.FURL "权限项url" ,t2.FACTION "操作描述" FROM 

t_bs_service t0

inner join t_pm_permitem t1 on t0.FPERMISSIONID = t1.FID 

inner join t_pm_permitemurl t2 on t1.FID = t2.FPARENTID 

where t0.FID = 'serviceId替换'

or t2.FURL like '%uipk替换%'