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.HRFV_DETAILED_SPECIAL_INFO

Object Details

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

View Type

A Business Intelligence System view

This view shows a detailed listing of special information held for people in your
enterprise. Effective dates for the special information are shown if
they have been entered.

[View Source]

Columns

Name	Datatype	Length	Mandatory
BUSINESS_GROUP_NAME	VARCHAR2	(240)	Yes
PERSON_NAME	VARCHAR2	(240)
EMPLOYEE_NUMBER	VARCHAR2	(30)
APPLICANT_NUMBER	VARCHAR2	(30)
DATE_FROM	DATE
DATE_TO	DATE
DATE_FROM_NN	DATE
DATE_TO_NN	DATE
COMMENTS	LONG	(0)
SEGMENT_NAME	VARCHAR2	(30)	Yes
SEGMENT_DETAILS	VARCHAR2	(4000)
CURRENT_EMPLOYEE_FLAG	VARCHAR2	(4000)
CURRENT_APPLICANT_FLAG	VARCHAR2	(4000)
PERSON_TYPE	VARCHAR2	(80)	Yes
EMPLOYEE_PERSON_TYPE	VARCHAR2	(4000)
APPLICANT_PERSON_TYPE	VARCHAR2	(4000)
USER_CONCAT_PERSON_TYPE	VARCHAR2	(4000)
INFORMATION_TYPE	VARCHAR2	(30)	Yes
CURRENT_EMPLOYEE_FLAG_CODE	VARCHAR2	(30)
CURRENT_APPLICANT_FLAG_CODE	VARCHAR2	(30)
ANALYSIS_CRITERIA_ID	NUMBER	(15)	Yes
BUSINESS_GROUP_ID	NUMBER	(15)	Yes
ID_FLEX_NUM	NUMBER	(15)	Yes
PERSON_ID	NUMBER	(10)	Yes
PERSON_ANALYSIS_ID	NUMBER	(15)	Yes
SEGMENT_NUM	NUMBER	(3)	Yes
PERSON_TYPE_ID	NUMBER	(15)	Yes

Query Text

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


SELECT BUSINESS_GROUP_NAME
,      PERSON_NAME
,      EMPLOYEE_NUMBER
,      APPLICANT_NUMBER
,      DATE_FROM
,      DATE_TO
,      DATE_FROM_NN
,      DATE_TO_NN
,      COMMENTS
,      SEGMENT_NAME
,      SEGMENT_DETAILS
,      CURRENT_EMPLOYEE_FLAG
,      CURRENT_APPLICANT_FLAG
,      PERSON_TYPE
,      EMPLOYEE_PERSON_TYPE
,      APPLICANT_PERSON_TYPE
,      USER_CONCAT_PERSON_TYPE
,      INFORMATION_TYPE
,      CURRENT_EMPLOYEE_FLAG_CODE
,      CURRENT_APPLICANT_FLAG_CODE
,      ANALYSIS_CRITERIA_ID
,      BUSINESS_GROUP_ID
,      ID_FLEX_NUM
,      PERSON_ID
,      PERSON_ANALYSIS_ID
,      SEGMENT_NUM
,      PERSON_TYPE_ID
FROM APPS.HRFV_DETAILED_SPECIAL_INFO;

Dependencies

[top of page]

APPS.HRFV_DETAILED_SPECIAL_INFO references the following:

APPS: FND_ID_FLEX_SEGMENTS_VL; FND_ID_FLEX_STRUCTURES_VL; HRI_BPL_PERSON_TYPE - show dependent code; 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_ANALYSIS_CRITERIA; PER_PEOPLE_X; PER_PERSON_ANALYSES; PER_PERSON_TYPES_TL

APPS.HRFV_DETAILED_SPECIAL_INFO is referenced by following:

PUBLIC: HRFV_DETAILED_SPECIAL_INFO