VIEW: APPS.PA_USER_RESP_V

Source

View Text - Preformatted

SELECT FU.USER_ID , FU.USER_NAME , FUR.RESPONSIBILITY_ID , FR.RESPONSIBILITY_NAME FROM FND_USER FU, FND_USER_RESP_GROUPS FUR, FND_RESPONSIBILITY_VL FR WHERE FU.USER_ID = FUR.USER_ID AND FUR.RESPONSIBILITY_APPLICATION_ID = 275 AND FR.APPLICATION_ID = FUR.RESPONSIBILITY_APPLICATION_ID AND FR.RESPONSIBILITY_ID = FUR.RESPONSIBILITY_ID AND TRUNC(SYSDATE) BETWEEN TRUNC(FR.START_DATE) AND TRUNC( NVL(( FR.END_DATE - 1 ) , SYSDATE )) AND TRUNC(SYSDATE) BETWEEN TRUNC(FUR.START_DATE) AND TRUNC(NVL((FUR.END_DATE - 1), SYSDATE))

View Text - HTML Formatted

SELECT FU.USER_ID
, FU.USER_NAME
, FUR.RESPONSIBILITY_ID
, FR.RESPONSIBILITY_NAME
FROM FND_USER FU
, FND_USER_RESP_GROUPS FUR
, FND_RESPONSIBILITY_VL FR
WHERE FU.USER_ID = FUR.USER_ID
AND FUR.RESPONSIBILITY_APPLICATION_ID = 275
AND FR.APPLICATION_ID = FUR.RESPONSIBILITY_APPLICATION_ID
AND FR.RESPONSIBILITY_ID = FUR.RESPONSIBILITY_ID
AND TRUNC(SYSDATE) BETWEEN TRUNC(FR.START_DATE)
AND TRUNC( NVL(( FR.END_DATE - 1 )
, SYSDATE ))
AND TRUNC(SYSDATE) BETWEEN TRUNC(FUR.START_DATE)
AND TRUNC(NVL((FUR.END_DATE - 1)
, SYSDATE))