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


VIEW: APPS.HRFV_REVIEWERS

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

View Type

A Business Intelligence System view


This view shows employees who have acted as reviewers in employee reviews, or
are scheduled to act as reviewers in the future.


[View Source]

Columns
Name Datatype Length Mandatory Comments
BUSINESS_GROUP_NAME VARCHAR2 (240) Yes
REVIEWEE_NAME VARCHAR2 (240)
REVIEWEE_EMPLOYEE_NUMBER VARCHAR2 (30)
REVIEWEE_ASSIGNMENT_NUMBER VARCHAR2 (30)
REVIEW_TYPE VARCHAR2 (4000)
PLANNED_REVIEW_DATE DATE
Yes
REVIEWEE_CURRENT_EMPLOYEE_FLAG VARCHAR2 (4000)
REVIEWER_NAME VARCHAR2 (240)
REVIEWER_EMPLOYEE_NUMBER VARCHAR2 (30)
_DF CHAR (24)
BUSINESS_GROUP_ID NUMBER (15)

EMPLOYEE_REVIEW_ID NUMBER (15) Yes
EMPLOYEE_REVIEWER_ID NUMBER (15) Yes
REVIEWEE_ASSIGNMENT_ID NUMBER (10)

REVIEWEE_PERSON_ID NUMBER (10) Yes
REVIEWER_PERSON_ID NUMBER (10) Yes
Query Text

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


SELECT BUSINESS_GROUP_NAME
,      REVIEWEE_NAME
,      REVIEWEE_EMPLOYEE_NUMBER
,      REVIEWEE_ASSIGNMENT_NUMBER
,      REVIEW_TYPE
,      PLANNED_REVIEW_DATE
,      REVIEWEE_CURRENT_EMPLOYEE_FLAG
,      REVIEWER_NAME
,      REVIEWER_EMPLOYEE_NUMBER
,      _DF
,      BUSINESS_GROUP_ID
,      EMPLOYEE_REVIEW_ID
,      EMPLOYEE_REVIEWER_ID
,      REVIEWEE_ASSIGNMENT_ID
,      REVIEWEE_PERSON_ID
,      REVIEWER_PERSON_ID
FROM APPS.HRFV_REVIEWERS;

Dependencies

[top of page]

APPS.HRFV_REVIEWERS references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_BIS - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPER_ALL_ASSIGNMENTS_F
SynonymPER_ALL_PEOPLE_F
SynonymPER_BOOKINGS
SynonymPER_EVENTS
ViewPER_PEOPLE_X

APPS.HRFV_REVIEWERS is not referenced by any database object