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

VIEW: APPS.PJI_DIS_SUP_HRCHY_V

Object Details
Object Name: PJI_DIS_SUP_HRCHY_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPJI.PJI_DIS_SUP_HRCHY_V
Subobject Name:
Status: VALID

View Type

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


The manager hierarchy refers to the HR supervisor hierarchy. This hierarchy is date effective based on the HR primary active assignment for a person. This is a 2 level 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
SUP_PERSON_ID NUMBER (15) Yes Identifier for supervisor person.
SUB_PERSON_ID NUMBER (15) Yes Identifier for subordinate person.
SUP_ASSIGNMENT_ID NUMBER (15) Yes Identifier for supervisor assignment.
SUB_ASSIGNMENT_ID NUMBER (15) Yes Identifier for subordinate assignment.
SUP_NAME VARCHAR2 (240)
Supervisor name
SUB_NAME VARCHAR2 (240)
Subordinate name
EFFECTIVE_START_DATE DATE
Yes Effective start date
EFFECTIVE_END_DATE DATE
Yes 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
,      SUP_PERSON_ID
,      SUB_PERSON_ID
,      SUP_ASSIGNMENT_ID
,      SUB_ASSIGNMENT_ID
,      SUP_NAME
,      SUB_NAME
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
FROM APPS.PJI_DIS_SUP_HRCHY_V;

Dependencies

[top of page]

APPS.PJI_DIS_SUP_HRCHY_V references the following:

SchemaAPPS
ViewHRI_CS_SUPH_V
SynonymPER_ALL_PEOPLE_F

APPS.PJI_DIS_SUP_HRCHY_V is not referenced by any database object