Oracle ERP 線上人員在某個 Responsibility 中開啟哪些 Form

在 Oracle ERP 中, 可用下面語法得知 "線上人員在某個 Responsibility 中開啟哪些 Form" :

 程式碼

SELECT FF.USER_FORM_NAME
     , A.TIME
  FROM (SELECT FORM_ID
             , TIME
          FROM FND_SIGNON_AUDIT_VIEW
         WHERE RESPONSIBILITY_ID = &RESPONSIBILITY_ID
           AND USER_ID = &USER_ID
       ) A
     , FND_FORM_TL FF
 WHERE A.FORM_ID = FF.FORM_ID(+)
 ORDER BY FF.USER_FORM_NAME;