eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.PJI_DIS_SUP_ROHRCHY_V

Object Details

Object Name:	PJI_DIS_SUP_ROHRCHY_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PJI.PJI_DIS_SUP_ROHRCHY_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

The manager hierarchy is a 3-level hierarchy that is based on the manager hierarchy.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SUP_ABSOLUTE_LEVEL	NUMBER	(15)	Yes	Supervisor level
SUB_ABSOLUTE_LEVEL	NUMBER	(15)	Yes	Subordinate level
SUB_RELATIVE_LEVEL	NUMBER		Yes	Subordinate relative level
SUBRO_ABSOLUTE_LEVEL	NUMBER	(15)	Yes	Subordinate rollup absolute level
SUBRO_SUP_RELATIVE_LEVEL	NUMBER		Yes	Subordinate rollup supervisor relative level
SUBRO_SUB_RELATIVE_LEVEL	NUMBER			Subordinate rollup subordinate relative level
SUP_PERSON_ID	NUMBER	(15)	Yes	Identifier for supervisor person
SUB_PERSON_ID	NUMBER	(15)	Yes	Identifier for subordinate person
SUBRO_PERSON_ID	NUMBER	(15)	Yes	Identifier for subordinate rollup person
SUP_ASSIGNMENT_ID	NUMBER	(15)	Yes	Identifier for supervisor assignment .
SUB_ASSIGNMENT_ID	NUMBER	(15)	Yes	Identifier for subordinate assignment.
SUBRO_ASSIGNMENT_ID	NUMBER	(15)	Yes	Identifier for subordinate rollup assignment.
SUP_NAME	VARCHAR2	(240)		Supervisor name
SUB_NAME	VARCHAR2	(240)		Subordinate name
SUBRO_NAME	VARCHAR2	(240)		Subordinate rollup name
EFFECTIVE_START_DATE	DATE			Effective start date
EFFECTIVE_END_DATE	DATE			Effective end date

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SUP_ABSOLUTE_LEVEL
,      SUB_ABSOLUTE_LEVEL
,      SUB_RELATIVE_LEVEL
,      SUBRO_ABSOLUTE_LEVEL
,      SUBRO_SUP_RELATIVE_LEVEL
,      SUBRO_SUB_RELATIVE_LEVEL
,      SUP_PERSON_ID
,      SUB_PERSON_ID
,      SUBRO_PERSON_ID
,      SUP_ASSIGNMENT_ID
,      SUB_ASSIGNMENT_ID
,      SUBRO_ASSIGNMENT_ID
,      SUP_NAME
,      SUB_NAME
,      SUBRO_NAME
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
FROM APPS.PJI_DIS_SUP_ROHRCHY_V;

Dependencies

[top of page]

APPS.PJI_DIS_SUP_ROHRCHY_V references the following:

APPS: HRI_CS_SUPHRO_V; PER_ALL_PEOPLE_F

APPS.PJI_DIS_SUP_ROHRCHY_V is not referenced by any database object