[Home] [Help]
View: BSC_APPS_USERS_V
Product: | BSC - Balanced Scorecard (Obsolete) |
Description: | View of FND_USER and FND_RESPONSIBILITY_VL |
Implementation/DBA Data: |
Not implemented in this database
|
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
Name |
USER_ID |
USER_NAME |
FULL_NAME |
ENCRYPTED_USER_PASSWORD |
EMAIL_ADDRESS |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
BSC_VALID_FLAG |