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_DEPLOYMENT_FACTORS

Object Details

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

View Type

A Business Intelligence System view

This view shows work choices made by people, or required for jobs and positions

[View Source]

Columns

Name	Datatype	Length	Mandatory
BUSINESS_GROUP_NAME	VARCHAR2	(240)	Yes
WORK_ANY_COUNTRY	VARCHAR2	(4000)
WORK_ANY_LOCATION	VARCHAR2	(4000)
RELOCATE_DOMESTICALLY	VARCHAR2	(4000)
RELOCATE_INTERNATIONALLY	VARCHAR2	(4000)
TRAVEL_REQUIRED	VARCHAR2	(4000)
PREFERRED_COUNTRY1	VARCHAR2	(80)
PREFERRED_COUNTRY2	VARCHAR2	(80)
PREFERRED_COUNTRY3	VARCHAR2	(80)
WORK_DURATION	VARCHAR2	(4000)
WORK_SCHEDULE	VARCHAR2	(4000)
WORK_HOURS	VARCHAR2	(4000)
FTE_CAPACITY	VARCHAR2	(4000)
VISIT_INTERNATIONALLY	VARCHAR2	(4000)
ONLY_CURRENT_LOCATION	VARCHAR2	(4000)
AVOID_COUNTRY1	VARCHAR2	(80)
AVOID_COUNTRY2	VARCHAR2	(80)
AVOID_COUNTRY3	VARCHAR2	(80)
COMMENTS	VARCHAR2	(2000)
EARLIEST_AVAILABLE_DATE	DATE
AVAILABLE_FOR_TRANSFER	VARCHAR2	(4000)
RELOCATION_PREFERENCE	VARCHAR2	(4000)
RELOCATION_REQUIRED	VARCHAR2	(4000)
PASSPORT_REQUIRED	VARCHAR2	(4000)
PREFERRED_LOCATION1	VARCHAR2	(60)
PREFERRED_LOCATION2	VARCHAR2	(60)
PREFERRED_LOCATION3	VARCHAR2	(60)
OTHER_REQUIREMENTS	VARCHAR2	(2000)
MINIMUM_LENGTH_OF_SERVICE	VARCHAR2	(4000)
PERSON_NAME	VARCHAR2	(240)
POSITION_NAME	VARCHAR2	(240)
JOB_NAME	VARCHAR2	(700)
_DF	CHAR	(34)
POSITION_ID	NUMBER	(15)
PERSON_ID	NUMBER	(10)
JOB_ID	NUMBER	(9)
DEPLOYMENT_FACTOR_ID	NUMBER	(9)	Yes
BUSINESS_GROUP_ID	NUMBER	(15)	Yes

Query Text

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


SELECT BUSINESS_GROUP_NAME
,      WORK_ANY_COUNTRY
,      WORK_ANY_LOCATION
,      RELOCATE_DOMESTICALLY
,      RELOCATE_INTERNATIONALLY
,      TRAVEL_REQUIRED
,      PREFERRED_COUNTRY1
,      PREFERRED_COUNTRY2
,      PREFERRED_COUNTRY3
,      WORK_DURATION
,      WORK_SCHEDULE
,      WORK_HOURS
,      FTE_CAPACITY
,      VISIT_INTERNATIONALLY
,      ONLY_CURRENT_LOCATION
,      AVOID_COUNTRY1
,      AVOID_COUNTRY2
,      AVOID_COUNTRY3
,      COMMENTS
,      EARLIEST_AVAILABLE_DATE
,      AVAILABLE_FOR_TRANSFER
,      RELOCATION_PREFERENCE
,      RELOCATION_REQUIRED
,      PASSPORT_REQUIRED
,      PREFERRED_LOCATION1
,      PREFERRED_LOCATION2
,      PREFERRED_LOCATION3
,      OTHER_REQUIREMENTS
,      MINIMUM_LENGTH_OF_SERVICE
,      PERSON_NAME
,      POSITION_NAME
,      JOB_NAME
,      _DF
,      POSITION_ID
,      PERSON_ID
,      JOB_ID
,      DEPLOYMENT_FACTOR_ID
,      BUSINESS_GROUP_ID
FROM APPS.HRFV_DEPLOYMENT_FACTORS;

Dependencies

[top of page]

APPS.HRFV_DEPLOYMENT_FACTORS references the following:

APPS: FND_TERRITORIES_VL; HR_ALL_ORGANIZATION_UNITS_TL; HR_ALL_POSITIONS_F_TL; HR_BIS - show dependent code; HR_GENERAL - show dependent code; HR_LOCATIONS_ALL_TL; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; PER_DEPLOYMENT_FACTORS; PER_JOBS_TL; PER_PEOPLE_X

APPS.HRFV_DEPLOYMENT_FACTORS is referenced by following:

PUBLIC: HRFV_DEPLOYMENT_FACTORS