eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.BSC_USER_RESPONSIBILITY_V

Source

View Text - Preformatted


SELECT FUR.USER_ID, FUR.RESPONSIBILITY_ID FROM FND_USER FU, FND_RESPONSIBILITY_VL FR, FND_USER_RESP_GROUPS FUR WHERE FU.USER_ID = FUR.USER_ID AND FR.RESPONSIBILITY_ID = FUR.RESPONSIBILITY_ID AND FR.APPLICATION_ID = FUR.RESPONSIBILITY_APPLICATION_ID AND FR.APPLICATION_ID = 271 AND SYSDATE BETWEEN FU.START_DATE AND NVL(FU.END_DATE, SYSDATE) AND SYSDATE BETWEEN FR.START_DATE AND NVL(FR.END_DATE, SYSDATE)

View Text - HTML Formatted

SELECT FUR.USER_ID
, FUR.RESPONSIBILITY_ID
FROM FND_USER FU
, FND_RESPONSIBILITY_VL FR
, FND_USER_RESP_GROUPS FUR
WHERE FU.USER_ID = FUR.USER_ID
AND FR.RESPONSIBILITY_ID = FUR.RESPONSIBILITY_ID
AND FR.APPLICATION_ID = FUR.RESPONSIBILITY_APPLICATION_ID
AND FR.APPLICATION_ID = 271
AND SYSDATE BETWEEN FU.START_DATE
AND NVL(FU.END_DATE
, SYSDATE)
AND SYSDATE BETWEEN FR.START_DATE
AND NVL(FR.END_DATE
, SYSDATE)