Product: | AS - Sales Foundation |
---|---|
Description: | This view shows the sales reporting hierarchy information for manager |
Implementation/DBA Data: | APPS.AS_RPT_MANAGERS_V |
SELECT MGR.PERSON_ID
, MGR.RESOURCE_ID
, MGR.MANAGER_PERSON_ID
, MGR.GROUP_ID
, MGR.LAST_UPDATE_DATE
, MGR.LAST_UPDATED_BY
, MGR.CREATION_DATE
, MGR.CREATED_BY
, MGR.LAST_UPDATE_LOGIN
, MGR.REPORTS_TO_FLAG
, MGR.HIERARCHY_TYPE
, MGR.START_DATE_ACTIVE
, MGR.END_DATE_ACTIVE
, MGR.ATTRIBUTE_CATEGORY
, MGR.ATTRIBUTE1
, MGR.ATTRIBUTE2
, MGR.ATTRIBUTE3
, MGR.ATTRIBUTE4
, MGR.ATTRIBUTE5
, MGR.ATTRIBUTE6
, MGR.ATTRIBUTE7
, MGR.ATTRIBUTE8
, MGR.ATTRIBUTE9
, MGR.ATTRIBUTE10
, MGR.ATTRIBUTE11
, MGR.ATTRIBUTE12
, MGR.ATTRIBUTE13
, MGR.ATTRIBUTE14
, MGR.ATTRIBUTE15
, MGR.PARENT_RESOURCE_ID
FROM JTF_RS_REP_MANAGERS MGR
, JTF_RS_GROUP_USAGES U
WHERE U.USAGE IN ('SALES'
, 'PRM')
AND U.GROUP_ID = MGR.GROUP_ID
AND MGR.HIERARCHY_TYPE IN ('MGR_TO_MGR'
, 'MGR_TO_REP'
, 'REP_TO_REP'
, 'MGR_TO_ADMIN')