View: HRFV_DEPLOYMENT_FACTORS

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

View Text

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
, POS.NAME POSITION_NAME
, JOB.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
, PER_ALL_POSITIONS POS
, PER_PEOPLE_X PEO
, PER_JOBS JOB
, 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 = POS.POSITION_ID(+)
AND PDF.PERSON_ID = PEO.PERSON_ID(+)
AND PDF.JOB_ID = JOB.JOB_ID(+)
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

Columns