[Home] [Help] [Dependency Information]

VIEW: APPS.HRFV_ASSIGNMENT_COSTS

Object Details

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

View Type

A Business Intelligence System view

This view shows assignment level costing information for current employee
assignments.

[View Source]

Columns

Query Text

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

SELECT BUSINESS_GROUP_NAME
,      PERSON_NAME
,      ASSIGNMENT_NUMBER
,      COSTING_PROPORTION
,      COSTING_DATE_FROM
,      COSTING_DATE_TO
,      ORGANIZATION_NAME
,      JOB_NAME
,      POSITION_NAME
,      GRADE_NAME
,      LOCATION_NAME
,      EMPLOYEE_NUMBER
,      _KF:COST_CODE
,      ASSIGNMENT_ID
,      BUSINESS_GROUP_ID
,      PERSON_ID
FROM APPS.HRFV_ASSIGNMENT_COSTS;

Dependencies

[top of page]

APPS

HR_ALL_ORGANIZATION_UNITS_TL

HR_ALL_POSITIONS_F_TL

HR_BIS - show dependent code

HR_DISCOVERER - show dependent code

HR_GENERAL - show dependent code

HR_LOCATIONS_ALL_TL

HR_PERSON_NAME - show dependent code

HR_SECURITY - show dependent code

PAY_COST_ALLOCATIONS_F

PAY_COST_ALLOCATION_KEYFLEX

PER_ASSIGNMENTS_X

PER_GRADES_TL

PER_JOBS_TL

PER_PEOPLE_X

PUBLIC

HRFV_ASSIGNMENT_COSTS