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.PER_DEPLOYMENT_FACTORS_V

Source

View Text - Preformatted


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'))

View Text - HTML Formatted

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'))