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.

VIEW: APPS.HRFV_DEPLOYMENT_FACTORS

Source

View Text - Preformatted


SELECT bgrT.name business_group_name , hr_bis.bis_decode_lookup('YES_NO',PDF.WORK_ANY_COUNTRY) work_any_country , hr_bis.bis_decode_lookup('YES_NO',PDF.WORK_ANY_LOCATION) work_any_location , hr_bis.bis_decode_lookup('YES_NO',PDF.RELOCATE_DOMESTICALLY) relocate_domestically , hr_bis.bis_decode_lookup('YES_NO',PDF.RELOCATE_INTERNATIONALLY) relocate_internationally , hr_bis.bis_decode_lookup('YES_NO',PDF.TRAVEL_REQUIRED) travel_required , ter1.territory_short_name preferred_country1 , ter2.territory_short_name preferred_country2 , ter3.territory_short_name preferred_country3 , hr_bis.bis_decode_lookup('PER_TIME_SCALES',PDF.WORK_DURATION) work_duration , hr_bis.bis_decode_lookup('PER_WORK_SCHEDULE', PDF.WORK_SCHEDULE) work_schedule , hr_bis.bis_decode_lookup('PER_WORK_HOURS', PDF.WORK_HOURS) work_hours , hr_bis.bis_decode_lookup('PER_FTE_CAPACITY' ,PDF.FTE_CAPACITY) fte_capacity , hr_bis.bis_decode_lookup('YES_NO',PDF.VISIT_INTERNATIONALLY) visit_internationally , hr_bis.bis_decode_lookup('YES_NO',PDF.ONLY_CURRENT_LOCATION) only_current_location , ter4.territory_short_name avoid_country1 , ter5.territory_short_name avoid_country2 , ter6.territory_short_name avoid_country3 , pdf.comments comments , pdf.earliest_available_date earliest_available_date , hr_bis.bis_decode_lookup('YES_NO', PDF.AVAILABLE_FOR_TRANSFER) available_for_transfer , hr_bis.bis_decode_lookup('PER_RELOCATION_PREFERENCES', PDF.RELOCATION_PREFERENCE) relocation_preference , hr_bis.bis_decode_lookup('YES_NO',PDF.RELOCATION_REQUIRED) relocation_required , hr_bis.bis_decode_lookup('YES_NO',PDF.PASSPORT_REQUIRED) passport_required , hrl1tl.location_code preferred_location1 , hrl2tl.location_code preferred_location2 , hrl3tl.location_code preferred_location3 , pdf.other_requirements other_requirements , hr_bis.bis_decode_lookup('PER_LENGTHS_OF_SERVICE', PDF.SERVICE_MINIMUM) service_minimum , peo.full_name person_name , pft.name position_name , jbt.name job_name , '_DF:PER:PER_DEPLOYMENT_FACTORS:pdf' , pdf.position_id position_id , pdf.person_id person_id , pdf.job_id job_id , PDF.DEPLOYMENT_FACTOR_ID deployment_factor_id , pdf.business_group_id business_group_id FROM per_deployment_factors pdf ,hr_all_organization_units_tl bgrT ,hr_all_positions_f_tl pft ,per_people_x peo ,per_jobs_tl jbt ,fnd_territories_vl ter1 ,fnd_territories_vl ter2 ,fnd_territories_vl ter3 ,fnd_territories_vl ter4 ,fnd_territories_vl ter5 ,fnd_territories_vl ter6 ,hr_locations_all_tl hrl1tl ,hr_locations_all_tl hrl2tl ,hr_locations_all_tl hrl3tl WHERE TER1.TERRITORY_CODE (+) = PDF.COUNTRY1 AND TER2.TERRITORY_CODE (+) = PDF.COUNTRY2 AND TER3.TERRITORY_CODE (+) = PDF.COUNTRY3 AND TER4.TERRITORY_CODE (+) = PDF.NO_COUNTRY1 AND TER5.TERRITORY_CODE (+) = PDF.NO_COUNTRY2 AND TER6.TERRITORY_CODE (+) = PDF.NO_COUNTRY3 AND PDF.LOCATION1 = HRL1TL.LOCATION_ID (+) AND PDF.LOCATION2 = HRL2TL.LOCATION_ID (+) AND PDF.LOCATION3 = HRL3TL.LOCATION_ID (+) AND PDF.business_group_id = bgrT.organization_id AND bgrT.language = userenv('LANG') AND pdf.business_group_id = NVL(hr_bis.get_sec_profile_bg_id,pdf.business_group_id) AND PDF.position_id = pft.position_id(+) AND pft.language(+) = userenv('LANG') AND pdf.person_id = peo.person_id(+) AND pdf.job_id = jbt.job_id(+) AND jbt.language(+) = userenv('LANG') AND HRL1TL.LANGUAGE (+) = userenv('LANG') AND HRL2TL.LANGUAGE (+) = userenv('LANG') AND HRL3TL.LANGUAGE (+) = userenv('LANG') AND SYSDATE BETWEEN peo.effective_start_date(+) AND peo.effective_end_date (+) WITH READ ONLY

View Text - HTML Formatted

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PDF.WORK_ANY_COUNTRY) WORK_ANY_COUNTRY
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PDF.WORK_ANY_LOCATION) WORK_ANY_LOCATION
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PDF.RELOCATE_DOMESTICALLY) RELOCATE_DOMESTICALLY
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PDF.RELOCATE_INTERNATIONALLY) RELOCATE_INTERNATIONALLY
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PDF.TRAVEL_REQUIRED) TRAVEL_REQUIRED
, TER1.TERRITORY_SHORT_NAME PREFERRED_COUNTRY1
, TER2.TERRITORY_SHORT_NAME PREFERRED_COUNTRY2
, TER3.TERRITORY_SHORT_NAME PREFERRED_COUNTRY3
, HR_BIS.BIS_DECODE_LOOKUP('PER_TIME_SCALES'
, PDF.WORK_DURATION) WORK_DURATION
, HR_BIS.BIS_DECODE_LOOKUP('PER_WORK_SCHEDULE'
, PDF.WORK_SCHEDULE) WORK_SCHEDULE
, HR_BIS.BIS_DECODE_LOOKUP('PER_WORK_HOURS'
, PDF.WORK_HOURS) WORK_HOURS
, HR_BIS.BIS_DECODE_LOOKUP('PER_FTE_CAPACITY'
, PDF.FTE_CAPACITY) FTE_CAPACITY
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PDF.VISIT_INTERNATIONALLY) VISIT_INTERNATIONALLY
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PDF.ONLY_CURRENT_LOCATION) ONLY_CURRENT_LOCATION
, TER4.TERRITORY_SHORT_NAME AVOID_COUNTRY1
, TER5.TERRITORY_SHORT_NAME AVOID_COUNTRY2
, TER6.TERRITORY_SHORT_NAME AVOID_COUNTRY3
, PDF.COMMENTS COMMENTS
, PDF.EARLIEST_AVAILABLE_DATE EARLIEST_AVAILABLE_DATE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PDF.AVAILABLE_FOR_TRANSFER) AVAILABLE_FOR_TRANSFER
, HR_BIS.BIS_DECODE_LOOKUP('PER_RELOCATION_PREFERENCES'
, PDF.RELOCATION_PREFERENCE) RELOCATION_PREFERENCE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PDF.RELOCATION_REQUIRED) RELOCATION_REQUIRED
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PDF.PASSPORT_REQUIRED) PASSPORT_REQUIRED
, HRL1TL.LOCATION_CODE PREFERRED_LOCATION1
, HRL2TL.LOCATION_CODE PREFERRED_LOCATION2
, HRL3TL.LOCATION_CODE PREFERRED_LOCATION3
, PDF.OTHER_REQUIREMENTS OTHER_REQUIREMENTS
, HR_BIS.BIS_DECODE_LOOKUP('PER_LENGTHS_OF_SERVICE'
, PDF.SERVICE_MINIMUM) SERVICE_MINIMUM
, PEO.FULL_NAME PERSON_NAME
, PFT.NAME POSITION_NAME
, JBT.NAME JOB_NAME
, '_DF:PER:PER_DEPLOYMENT_FACTORS:PDF'
, PDF.POSITION_ID POSITION_ID
, PDF.PERSON_ID PERSON_ID
, PDF.JOB_ID JOB_ID
, PDF.DEPLOYMENT_FACTOR_ID DEPLOYMENT_FACTOR_ID
, PDF.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
FROM PER_DEPLOYMENT_FACTORS PDF
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, HR_ALL_POSITIONS_F_TL PFT
, PER_PEOPLE_X PEO
, PER_JOBS_TL JBT
, FND_TERRITORIES_VL TER1
, FND_TERRITORIES_VL TER2
, FND_TERRITORIES_VL TER3
, FND_TERRITORIES_VL TER4
, FND_TERRITORIES_VL TER5
, FND_TERRITORIES_VL TER6
, HR_LOCATIONS_ALL_TL HRL1TL
, HR_LOCATIONS_ALL_TL HRL2TL
, HR_LOCATIONS_ALL_TL HRL3TL
WHERE TER1.TERRITORY_CODE (+) = PDF.COUNTRY1
AND TER2.TERRITORY_CODE (+) = PDF.COUNTRY2
AND TER3.TERRITORY_CODE (+) = PDF.COUNTRY3
AND TER4.TERRITORY_CODE (+) = PDF.NO_COUNTRY1
AND TER5.TERRITORY_CODE (+) = PDF.NO_COUNTRY2
AND TER6.TERRITORY_CODE (+) = PDF.NO_COUNTRY3
AND PDF.LOCATION1 = HRL1TL.LOCATION_ID (+)
AND PDF.LOCATION2 = HRL2TL.LOCATION_ID (+)
AND PDF.LOCATION3 = HRL3TL.LOCATION_ID (+)
AND PDF.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND PDF.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PDF.BUSINESS_GROUP_ID)
AND PDF.POSITION_ID = PFT.POSITION_ID(+)
AND PFT.LANGUAGE(+) = USERENV('LANG')
AND PDF.PERSON_ID = PEO.PERSON_ID(+)
AND PDF.JOB_ID = JBT.JOB_ID(+)
AND JBT.LANGUAGE(+) = USERENV('LANG')
AND HRL1TL.LANGUAGE (+) = USERENV('LANG')
AND HRL2TL.LANGUAGE (+) = USERENV('LANG')
AND HRL3TL.LANGUAGE (+) = USERENV('LANG')
AND SYSDATE BETWEEN PEO.EFFECTIVE_START_DATE(+)
AND PEO.EFFECTIVE_END_DATE (+) WITH READ ONLY