EBS: FND查询用户使用FORM情况

-- 用户登陆使用的 FORM功能 (有些客户化的FORM没有记录使用情况，原因：FORM里没有设置)
SELECT * FROM "APPLSYS"."FND_LOGIN_RESP_FORMS" -- 268030
WHERE LOGIN_ID = 43975916 ;

-- 此查询不足之处，客户化FORM有些没有登陆日志
-- 用户登陆日志 -- 661723
SELECT FU.USER_ID,
FU.USER_NAME, FU.DESCRIPTION AS "USER_DESCRIPTION", -- 用户说明 
FR.RESPONSIBILITY_ID,
FR.RESPONSIBILITY_KEY, -- 职责关键字
FR.RESPONSIBILITY_NAME, -- 职责名称
FF.FORM_ID,
FF.FORM_NAME , -- 窗体名称
FF.USER_FORM_NAME, -- 用户窗体名称
FF.DESCRIPTION AS FORM_DESCRIPTION, -- 窗体说明
FLR.START_TIME
FROM APPLSYS.FND_LOGINS FL
INNER JOIN APPLSYS.FND_LOGIN_RESPONSIBILITIES FLR ON FL.LOGIN_ID = FLR.LOGIN_ID -- 登陆职责日志表
INNER JOIN APPLSYS.FND_USER FU ON FU.USER_ID =FL.USER_ID -- 用户
INNER JOIN APPS.FND_RESPONSIBILITY_VL FR ON FR.RESPONSIBILITY_ID = FLR.RESPONSIBILITY_ID -- 职责
INNER JOIN APPLSYS.FND_LOGIN_RESP_FORMS FLRF ON FLRF.LOGIN_ID = FLR.LOGIN_ID AND FLRF.LOGIN_RESP_ID= FLR.LOGIN_RESP_ID --登陆功能日志
INNER JOIN APPS.FND_FORM_VL FF ON FLRF.FORM_ID = FF.FORM_ID AND FF.APPLICATION_ID = FLRF.FORM_APPL_ID -- 功能
WHERE 1=1 --
--AND FL.USER_ID = 3554
AND FL.START_TIME>= TO_DATE('2026-06-01','YYYY-MM-DD')
-- AND FL.LOGIN_ID = 44004800
-- AND FU.USER_NAME LIKE 'DG%'
AND FF.FORM_NAME LIKE 'CUX%' ;