View: HRFV_ASSIGNMENT_COSTS

Product:	PER - Human Resources
Description:	Business view template from which the flexfield view is generated.
Implementation/DBA Data:	APPS.HRFV_ASSIGNMENT_COSTS

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, ASS.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, COST.PROPORTION COSTING_PROPORTION
, COST.EFFECTIVE_START_DATE COSTING_DATE_FROM
, HR_DISCOVERER.CHECK_END_DATE( COST.EFFECTIVE_END_DATE) COSTING_DATE_TO
, ORGT.NAME ORGANIZATION_NAME
, JOB.NAME JOB_NAME
, POS.NAME POS_NAME
, GRD.NAME GRADE_NAME
, LOCT.LOCATION_CODE LOCATION_NAME
, PEO.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, '_KF:PAY:COST:CKEY'
, COST.ASSIGNMENT_ID ASSIGNMENT_ID
, ASS.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PEO.PERSON_ID PERSON_ID
FROM PAY_COST_ALLOCATION_KEYFLEX CKEY
, HR_ALL_ORGANIZATION_UNITS_TL ORGT
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_JOBS JOB
, PER_ALL_POSITIONS POS
, PER_GRADES GRD
, HR_LOCATIONS_ALL_TL LOCT
, PER_PEOPLE_X PEO
, PAY_COST_ALLOCATIONS_F COST
, PER_ASSIGNMENTS_X ASS
WHERE COST.COST_ALLOCATION_KEYFLEX_ID = CKEY.COST_ALLOCATION_KEYFLEX_ID
AND ASS.ASSIGNMENT_ID = COST.ASSIGNMENT_ID
AND ASS.ORGANIZATION_ID = ORGT.ORGANIZATION_ID
AND ORGT.LANGUAGE = USERENV('LANG')
AND ASS.JOB_ID = JOB.JOB_ID(+)
AND ASS.POSITION_ID = POS.POSITION_ID(+)
AND ASS.GRADE_ID = GRD.GRADE_ID(+)
AND ASS.LOCATION_ID = LOCT.LOCATION_ID(+)
AND LOCT.LANGUAGE (+) = USERENV('LANG')
AND ASS.PERSON_ID = PEO.PERSON_ID
AND ASS.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND ASS.ASSIGNMENT_TYPE = 'E'
AND ASS.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ASS.BUSINESS_GROUP_ID) WITH READ ONLY

Columns