View: PER_DEPLOYMENT_FACTORS_V

Product:	PER - Human Resources
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PER_DEPLOYMENT_FACTORS_V

View Text

SELECT PDF.DEPLOYMENT_FACTOR_ID
, PDF.POSITION_ID
, PDF.PERSON_ID
, PDF.JOB_ID
, PDF.BUSINESS_GROUP_ID
, PDF.WORK_ANY_COUNTRY
, PDF.WORK_ANY_LOCATION
, PDF.RELOCATE_DOMESTICALLY
, PDF.RELOCATE_INTERNATIONALLY
, PDF.TRAVEL_REQUIRED
, PDF.COUNTRY1
, TER1.TERRITORY_SHORT_NAME COUNTRY1_MEANING
, PDF.COUNTRY2
, TER2.TERRITORY_SHORT_NAME COUNTRY2_MEANING
, PDF.COUNTRY3
, TER3.TERRITORY_SHORT_NAME COUNTRY3_MEANING
, PDF.WORK_DURATION
, HR1.MEANING WORK_DURATION_MEANING
, PDF.WORK_SCHEDULE
, HR2.MEANING WORK_SCHEDULE_MEANING
, PDF.WORK_HOURS
, HR3.MEANING WORK_HOURS_MEANING
, PDF.FTE_CAPACITY
, HR4.MEANING FTE_CAPACITY_MEANING
, PDF.VISIT_INTERNATIONALLY
, PDF.ONLY_CURRENT_LOCATION
, PDF.NO_COUNTRY1
, TER4.TERRITORY_SHORT_NAME NO_COUNTRY1_MEANING
, PDF.NO_COUNTRY2
, TER5.TERRITORY_SHORT_NAME NO_COUNTRY2_MEANING
, PDF.NO_COUNTRY3
, TER6.TERRITORY_SHORT_NAME NO_COUNTRY3_MEANING
, PDF.COMMENTS
, PDF.EARLIEST_AVAILABLE_DATE
, PDF.AVAILABLE_FOR_TRANSFER
, PDF.RELOCATION_PREFERENCE
, HR5.MEANING RELOCATION_PREFERENCE_MEANING
, PDF.RELOCATION_REQUIRED
, PDF.PASSPORT_REQUIRED
, PDF.LOCATION1
, HRL1TL.LOCATION_CODE LOCATION1_MEANING
, PDF.LOCATION2
, HRL2TL.LOCATION_CODE LOCATION2_MEANING
, PDF.LOCATION3
, HRL3TL.LOCATION_CODE LOCATION3_MEANING
, PDF.OTHER_REQUIREMENTS
, PDF.SERVICE_MINIMUM
, HR6.MEANING SERVICE_MINIMUM_MEANING
, PDF.OBJECT_VERSION_NUMBER
, PDF.ATTRIBUTE_CATEGORY
, PDF.ATTRIBUTE1
, PDF.ATTRIBUTE2
, PDF.ATTRIBUTE3
, PDF.ATTRIBUTE4
, PDF.ATTRIBUTE5
, PDF.ATTRIBUTE6
, PDF.ATTRIBUTE7
, PDF.ATTRIBUTE8
, PDF.ATTRIBUTE9
, PDF.ATTRIBUTE10
, PDF.ATTRIBUTE11
, PDF.ATTRIBUTE12
, PDF.ATTRIBUTE13
, PDF.ATTRIBUTE14
, PDF.ATTRIBUTE15
, PDF.ATTRIBUTE16
, PDF.ATTRIBUTE17
, PDF.ATTRIBUTE18
, PDF.ATTRIBUTE19
, PDF.ATTRIBUTE20
, PDF.LAST_UPDATE_DATE
, PDF.LAST_UPDATED_BY
, PDF.LAST_UPDATE_LOGIN
, PDF.CREATED_BY
, PDF.CREATION_DATE
FROM PER_DEPLOYMENT_FACTORS PDF
, 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_LOOKUPS HR1
, HR_LOOKUPS HR2
, HR_LOOKUPS HR3
, HR_LOOKUPS HR4
, HR_LOOKUPS HR5
, HR_LOOKUPS HR6
, HR_LOCATIONS_NO_JOIN HRL1
, HR_LOCATIONS_NO_JOIN HRL2
, HR_LOCATIONS_NO_JOIN HRL3
, 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 HR1.LOOKUP_TYPE (+) = 'PER_TIME_SCALES'
AND HR1.LOOKUP_CODE (+) = PDF.WORK_DURATION
AND HR2.LOOKUP_TYPE (+) = 'PER_WORK_SCHEDULE'
AND HR2.LOOKUP_CODE (+) = PDF.WORK_SCHEDULE
AND HR3.LOOKUP_TYPE (+) = 'PER_WORK_HOURS'
AND HR3.LOOKUP_CODE (+) = PDF.WORK_HOURS
AND HR4.LOOKUP_TYPE (+) = 'PER_FTE_CAPACITY'
AND HR4.LOOKUP_CODE (+) = PDF.FTE_CAPACITY
AND HR5.LOOKUP_TYPE (+) = 'PER_RELOCATION_PREFERENCES'
AND HR5.LOOKUP_CODE (+) = PDF.RELOCATION_PREFERENCE
AND HR6.LOOKUP_TYPE (+) = 'PER_LENGTHS_OF_SERVICE'
AND HR6.LOOKUP_CODE (+) = PDF.SERVICE_MINIMUM
AND HRL1.LOCATION_ID (+) = PDF.LOCATION1
AND HRL2.LOCATION_ID (+) = PDF.LOCATION2
AND HRL3.LOCATION_ID (+) = PDF.LOCATION3
AND HRL1.LOCATION_ID = HRL1TL.LOCATION_ID (+)
AND HRL2.LOCATION_ID = HRL2TL.LOCATION_ID (+)
AND HRL3.LOCATION_ID = HRL3TL.LOCATION_ID (+)
AND DECODE(HRL1TL.LOCATION_ID
, NULL
, '1'
, HRL1TL.LANGUAGE) = DECODE(HRL1TL.LOCATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND DECODE(HRL2TL.LOCATION_ID
, NULL
, '1'
, HRL2TL.LANGUAGE) = DECODE(HRL2TL.LOCATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND DECODE(HRL3TL.LOCATION_ID
, NULL
, '1'
, HRL3TL.LANGUAGE) = DECODE(HRL3TL.LOCATION_ID
, NULL
, '1'
, USERENV('LANG'))

Columns