View: JTF_RS_REP_MANAGERS_VL

Product:	JTF - CRM Foundation
Description:	This view shows the member to manager and admin hierarchy across groups
Implementation/DBA Data:	APPS.JTF_RS_REP_MANAGERS_VL

View Text

SELECT MGR.DENORM_MGR_ID DENORM_MGR_ID
, MGR.PERSON_ID PERSON_ID
, MGR.RESOURCE_ID RESOURCE_ID
, MGR.CATEGORY CATEGORY
, MGR.MANAGER_PERSON_ID MANAGER_PERSON_ID
, MGR.GROUP_ID GROUP_ID
, MGR.REPORTS_TO_FLAG REPORTS_TO_FLAG
, MGR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, MGR.LAST_UPDATED_BY LAST_UPDATED_BY
, MGR.CREATION_DATE CREATION_DATE
, MGR.CREATED_BY CREATED_BY
, MGR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, MGR.START_DATE_ACTIVE START_DATE_ACTIVE
, MGR.END_DATE_ACTIVE END_DATE_ACTIVE
, MGR.HIERARCHY_TYPE HIERARCHY_TYPE
, MGR.ATTRIBUTE_CATEGORY 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.DENORM_LEVEL
FROM JTF_RS_REP_MANAGERS MGR

Columns