View: BSC_APPS_USERS_V

Product:	BSC - Balanced Scorecard
Description:	View of FND_USER and FND_RESPONSIBILITY_VL
Implementation/DBA Data:	APPS.BSC_APPS_USERS_V

View Text

SELECT DISTINCT FU.USER_ID
, FU.USER_NAME
, P.FULL_NAME
, FU.ENCRYPTED_USER_PASSWORD
, FU.EMAIL_ADDRESS
, FU.LAST_UPDATE_DATE
, FU.LAST_UPDATED_BY
, FU.CREATION_DATE
, FU.CREATED_BY
, FU.LAST_UPDATE_LOGIN
, DECODE(BR.BSC_COUNT
, NULL
, 0
, 1) BSC_VALID_FLAG
FROM FND_USER FU
, PER_PEOPLE_F P
, (SELECT FUR.USER_ID USER_ID
, COUNT(*) BSC_COUNT 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) GROUP BY FUR.USER_ID ) BR
WHERE FU.EMPLOYEE_ID = P.PERSON_ID(+)
AND FU.USER_ID =BR.USER_ID (+)

Columns