Oracle EBS 查询用户访问次数SQL

Oracle EBS 查询用户访问次数SQL

--查询用户访问次数
  SELECT PEO.PERSON_ID,
        PEO.FULL_NAME,
        FU.USER_ID,
        FU.USER_NAME,
        HL.LOCATION_CODE,
        HL.DESCRIPTION,
        COUNT (FL.USER_ID) AS LOGIN_TIMES
    FROM FND_USER FU,
        PER_ALL_PEOPLE_F PEO,
        PER_ALL_ASSIGNMENTS_F ASS,
        HR_LOCATIONS HL,
        FND_LOGINS FL
  WHERE    FU.EMPLOYEE_ID = PEO.PERSON_ID
        AND ASS.PERSON_ID = PEO.PERSON_ID
        AND ASS.LOCATION_ID = HL.LOCATION_ID
        AND FL.USER_ID(+) = FU.USER_ID
        AND FU.USER_NAME = :USER_NAME
GROUP BY PEO.PERSON_ID,
        PEO.FULL_NAME,
        FU.USER_ID,
        FU.USER_NAME,
        HL.LOCATION_CODE,
        HL.DESCRIPTION;

--刘轶鹤转

http://www.cnblogs.com/quanweiru/p/4869697.html