Product: | AS - Sales Foundation |
---|---|
Description: | Reporting managers view |
Implementation/DBA Data: | Not implemented in this database |
SELECT RM.ROWID
, RM.PERSON_ID
, RM.MANAGER_PERSON_ID
, P.FIRST_NAME
, P.LAST_NAME
, RM.LAST_UPDATE_DATE
, RM.LAST_UPDATED_BY
, RM.CREATION_DATE
, RM.CREATED_BY
, RM.LAST_UPDATE_LOGIN
, RM.REPORTS_TO_FLAG
, RM.ATTRIBUTE_CATEGORY
, RM.ATTRIBUTE1
, RM.ATTRIBUTE2
, RM.ATTRIBUTE3
, RM.ATTRIBUTE4
, RM.ATTRIBUTE5
, RM.ATTRIBUTE6
, RM.ATTRIBUTE7
, RM.ATTRIBUTE8
, RM.ATTRIBUTE9
, RM.ATTRIBUTE10
, RM.ATTRIBUTE11
, RM.ATTRIBUTE12
, RM.ATTRIBUTE13
, RM.ATTRIBUTE14
, RM.ATTRIBUTE15
FROM AS_REPORTING_MANAGERS RM
, PER_ALL_PEOPLE_F P
WHERE MANAGER_PERSON_ID = P.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE
AND P.EFFECTIVE_END_DATE