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


VIEW: APPS.HRFV_SUPERVISORS

Object Details
Object Name: HRFV_SUPERVISORS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.HRFV_SUPERVISORS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This view shows current employees, together with the information about their
supervisors. It includes employees who do not currently have a
supervisor.


[View Source]

Columns
Name Datatype Length Mandatory Comments
BUSINESS_GROUP_NAME VARCHAR2 (240) Yes
PERSON_NAME VARCHAR2 (240)

ASSIGNMENT_NUMBER VARCHAR2 (30)

EMPLOYEE_NUMBER VARCHAR2 (30)

ORGANIZATION_NAME VARCHAR2 (240) Yes
JOB_NAME VARCHAR2 (700)
Translated Job name, concatenated from the keyflex structure.
GRADE_NAME VARCHAR2 (240)
Grade name.
POSITION_NAME VARCHAR2 (240)
Translated Position Name
LOCATION_NAME VARCHAR2 (60)

SUPERVISOR_NAME VARCHAR2 (240)

SUPERVISOR_EMPLOYEE_NUMBER VARCHAR2 (30)
SUPERVISOR_TITLE VARCHAR2 (30)
SUPERVISOR_MIDDLE_NAMES VARCHAR2 (60)
SUPERVISOR_PREFERRED_NAME VARCHAR2 (80)
SUPERVISOR_FIRST_NAME VARCHAR2 (150)
SUPERVISOR_LAST_NAME VARCHAR2 (150)
SUPERVISOR_PREFIX VARCHAR2 (30)
SUPERVISOR_SUFFIX VARCHAR2 (30)
SUPERVISOR_CURRENT_EMP_FLAG VARCHAR2 (4000)

SUPERVISOR_INTERNAL_LOCATION VARCHAR2 (45)

SUPERVISOR_MAILSTOP VARCHAR2 (45)

SUPERVISOR_EMAIL_ADDRESS VARCHAR2 (240)

SUPERVISOR_ORGANIZATION_NAME VARCHAR2 (240)
SUPERVISOR_JOB_NAME VARCHAR2 (700)
SUPERVISOR_GRADE_NAME VARCHAR2 (240)
SUPERVISOR_POSITION_NAME VARCHAR2 (240)
SUPERVISOR_LOCATION_NAME VARCHAR2 (60)
_DF:PER CHAR (22)
_DF:SUP CHAR (22)
ASSIGNMENT_ID NUMBER (10) Yes
BUSINESS_GROUP_ID NUMBER (15) Yes
PERSON_ID NUMBER (10) Yes
SUPERVISOR_ID NUMBER (10)

EMP_ORGANIZATION_ID NUMBER (15) Yes
EMP_JOB_ID NUMBER (15)
EMP_GRADE_ID NUMBER (15)
EMP_POSITION_ID NUMBER (15)
EMP_LOCATION_ID NUMBER (15)
SUP_ORGANIZATION_ID NUMBER (15)
SUP_JOB_ID NUMBER (15)
SUP_GRADE_ID NUMBER (15)
SUP_POSITION_ID NUMBER (15)
SUP_LOCATION_ID NUMBER (15)
Query Text

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


SELECT BUSINESS_GROUP_NAME
,      PERSON_NAME
,      ASSIGNMENT_NUMBER
,      EMPLOYEE_NUMBER
,      ORGANIZATION_NAME
,      JOB_NAME
,      GRADE_NAME
,      POSITION_NAME
,      LOCATION_NAME
,      SUPERVISOR_NAME
,      SUPERVISOR_EMPLOYEE_NUMBER
,      SUPERVISOR_TITLE
,      SUPERVISOR_MIDDLE_NAMES
,      SUPERVISOR_PREFERRED_NAME
,      SUPERVISOR_FIRST_NAME
,      SUPERVISOR_LAST_NAME
,      SUPERVISOR_PREFIX
,      SUPERVISOR_SUFFIX
,      SUPERVISOR_CURRENT_EMP_FLAG
,      SUPERVISOR_INTERNAL_LOCATION
,      SUPERVISOR_MAILSTOP
,      SUPERVISOR_EMAIL_ADDRESS
,      SUPERVISOR_ORGANIZATION_NAME
,      SUPERVISOR_JOB_NAME
,      SUPERVISOR_GRADE_NAME
,      SUPERVISOR_POSITION_NAME
,      SUPERVISOR_LOCATION_NAME
,      _DF:PER
,      _DF:SUP
,      ASSIGNMENT_ID
,      BUSINESS_GROUP_ID
,      PERSON_ID
,      SUPERVISOR_ID
,      EMP_ORGANIZATION_ID
,      EMP_JOB_ID
,      EMP_GRADE_ID
,      EMP_POSITION_ID
,      EMP_LOCATION_ID
,      SUP_ORGANIZATION_ID
,      SUP_JOB_ID
,      SUP_GRADE_ID
,      SUP_POSITION_ID
,      SUP_LOCATION_ID
FROM APPS.HRFV_SUPERVISORS;

Dependencies

[top of page]

APPS.HRFV_SUPERVISORS references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymHR_ALL_POSITIONS_F_TL
PL/SQL PackageHR_BIS - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
SynonymHR_LOCATIONS_ALL_TL
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPER_ALL_ASSIGNMENTS_F
SynonymPER_ALL_PEOPLE_F
ViewPER_ASSIGNMENTS_X
SynonymPER_GRADES_TL
SynonymPER_JOBS_TL
ViewPER_PEOPLE_X

APPS.HRFV_SUPERVISORS is not referenced by any database object