View: PA_USER_RESP_V

Product:	PA - Projects
Description:	This view displays all the Applications responsibilites for a given User
Implementation/DBA Data:	APPS.PA_USER_RESP_V

View Text

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))

Columns