[Home] [Help] [Dependency Information]

VIEW: APPS.HRFV_SUBJECTS

Object Details

Object Name:	HRFV_SUBJECTS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.HRFV_SUBJECTS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This view shows the subjects a person has taken as part of a qualification.

[View Source]

Columns

Query Text

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

SELECT BUSINESS_GROUP_NAME
,      PERSON_NAME
,      SUBJECT
,      MAJOR
,      SUBJECT_STATUS
,      SUBJECT_GRADE_ATTAINED
,      SUBJECT_START_DATE
,      SUBJECT_END_DATE
,      QUALIFICATION_TYPE
,      QUALIFICATION_TITLE
,      SCHOOL_OR_COLLEGE_NAME
,      QUALIFICATION_START_DATE
,      QUALIFICATION_END_DATE
,      BUSINESS_GROUP_ID
,      PERSON_ID
,      QUALIFICATION_ID
FROM APPS.HRFV_SUBJECTS;

Dependencies

[top of page]

APPS

HR_ALL_ORGANIZATION_UNITS_TL

HR_BIS - show dependent code

HR_GENERAL - show dependent code

HR_PERSON_NAME - show dependent code

HR_SECURITY - show dependent code

PER_ESTABLISHMENTS

PER_ESTABLISHMENT_ATTENDANCES

PER_PEOPLE_X

PER_QUALIFICATIONS

PER_QUALIFICATIONS_TL

PER_QUALIFICATION_TYPES_TL

PER_SUBJECTS_TAKEN

PER_SUBJECTS_TAKEN_TL

PUBLIC

HRFV_SUBJECTS