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;
天聖經:神的心不僅在神的聖言當中,也在神所創造的萬物之中,天涯海角每一處都有神的心
Related Posts Plugin for WordPress, Blogger...