View: HRFV_TRANSFERS_OUT

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

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PPF.FULL_NAME PERSON_NAME
, HR_BIS.BIS_DECODE_LOOKUP('BUDGET_MEASUREMENT_TYPE'
, HRL.LOOKUP_CODE) BUDGET_MEASUREMENT_TYPE
, HRL.LOOKUP_CODE BUDGET_MEASUREMENT_CODE
, HR_DISCOVERER.CHECK_END_DATE(PAF.EFFECTIVE_END_DATE) TRANSFER_OUT_DATE
, PAF.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, PPF.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, PPTT.USER_PERSON_TYPE PERSON_TYPE
, HR_BIS.BIS_DECODE_LOOKUP('EMP_CAT'
, PAF.EMPLOYMENT_CATEGORY) EMPLOYMENT_CATEGORY
, ORG2T.NAME NEW_ORGANIZATION_NAME
, HOUT.NAME ORGANIZATION_NAME
, PG.NAME GRADE_NAME
, PJ.NAME JOB_NAME
, PP.NAME POSITION_NAME
, HLT.LOCATION_CODE LOCATION_NAME
, PAF.ASSIGNMENT_ID ASSIGNMENT_ID
, PAF.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PG.GRADE_ID GRADE_ID
, PJ.JOB_ID JOB_ID
, PAF.ORGANIZATION_ID ORGANIZATION_ID
, PAF.PERSON_ID PERSON_ID
, PP.POSITION_ID POSITION_ID
, PAF2.ORGANIZATION_ID TRANSFER_ORGANIZATION_ID
, PPT.PERSON_TYPE_ID PERSON_TYPE_ID
FROM HR_ALL_ORGANIZATION_UNITS_TL BGRT
, HR_ALL_ORGANIZATION_UNITS_TL HOUT
, PER_GRADES PG
, PER_JOBS PJ
, PER_ALL_POSITIONS PP
, PER_ASSIGNMENT_STATUS_TYPES PAST
, HR_LOCATIONS_ALL_TL HLT
, PER_PERSON_TYPE_USAGES_F PTU
, PER_PERSON_TYPES PPT
, PER_PERSON_TYPES_TL PPTT
, PER_PEOPLE_F PPF
, HR_ALL_ORGANIZATION_UNITS_TL ORG2T
, PER_ALL_ASSIGNMENTS_F PAF
, PER_ALL_ASSIGNMENTS_F PAF2
, HR_LOOKUPS HRL
WHERE PAF.PERSON_ID = PPF.PERSON_ID
AND PAF.EFFECTIVE_START_DATE BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE
AND PPF.PERSON_ID = PTU.PERSON_ID
AND PAF.EFFECTIVE_START_DATE BETWEEN PTU.EFFECTIVE_START_DATE
AND PTU.EFFECTIVE_END_DATE
AND PTU.PERSON_TYPE_ID = PPT.PERSON_TYPE_ID
AND PPT.SYSTEM_PERSON_TYPE = 'EMP'
AND PPT.PERSON_TYPE_ID = PPTT.PERSON_TYPE_ID
AND PPTT.LANGUAGE = USERENV('LANG')
AND PAF2.ASSIGNMENT_STATUS_TYPE_ID = PAST.ASSIGNMENT_STATUS_TYPE_ID
AND PAST.PER_SYSTEM_STATUS <> 'TERM_ASSIGN'
AND PAF.ORGANIZATION_ID = HOUT.ORGANIZATION_ID
AND HOUT.LANGUAGE = USERENV('LANG')
AND PAF.GRADE_ID = PG.GRADE_ID(+)
AND PAF.JOB_ID = PJ.JOB_ID(+)
AND PAF.POSITION_ID = PP.POSITION_ID(+)
AND PAF.LOCATION_ID = HLT.LOCATION_ID(+)
AND HLT.LANGUAGE (+) = USERENV('LANG')
AND PAF.ASSIGNMENT_TYPE = 'E'
AND PAF.PRIMARY_FLAG = 'Y'
AND PAF.ASSIGNMENT_ID = PAF2.ASSIGNMENT_ID
AND PAF.EFFECTIVE_END_DATE+1 = PAF2.EFFECTIVE_START_DATE
AND PAF.ORGANIZATION_ID <> PAF2.ORGANIZATION_ID
AND PAF2.ORGANIZATION_ID = ORG2T.ORGANIZATION_ID
AND ORG2T.LANGUAGE = USERENV('LANG')
AND PAF2.ASSIGNMENT_TYPE = 'E'
AND PAF2.PRIMARY_FLAG = 'Y'
AND PAF.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND HRL.LOOKUP_TYPE = 'BUDGET_MEASUREMENT_TYPE'
AND PAF.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PAF.BUSINESS_GROUP_ID) WITH READ ONLY

Columns