VIEW: APPS.PER_EVENTS_V2

Source

View Text - Preformatted

SELECT PE.ROWID ROW_ID , PE.EVENT_ID , PE.BUSINESS_GROUP_ID , HR.MEANING , HLTL.LOCATION_CODE , HR.LOOKUP_TYPE , HOTL.NAME , PAP.FULL_NAME , NVL(PAP.EMPLOYEE_NUMBER, PAP.NPW_NUMBER) EMPLOYEE_NUMBER , PE.LOCATION_ID , PE.INTERNAL_CONTACT_PERSON_ID , PE.ORGANIZATION_RUN_BY_ID , PE.ASSIGNMENT_ID , PE.DATE_START , PE.TYPE , PE.COMMENTS , PE.CONTACT_TELEPHONE_NUMBER , PE.DATE_END , PE.EMP_OR_APL , PE.EVENT_OR_INTERVIEW , PE.EXTERNAL_CONTACT , PE.TIME_END , PE.TIME_START , PE.REQUEST_ID , PE.PROGRAM_APPLICATION_ID , PE.PROGRAM_ID , PE.PROGRAM_UPDATE_DATE , PE.ATTRIBUTE_CATEGORY , PE.ATTRIBUTE1 , PE.ATTRIBUTE2 , PE.ATTRIBUTE3 , PE.ATTRIBUTE4 , PE.ATTRIBUTE5 , PE.ATTRIBUTE6 , PE.ATTRIBUTE7 , PE.ATTRIBUTE8 , PE.ATTRIBUTE9 , PE.ATTRIBUTE10 , PE.ATTRIBUTE11 , PE.ATTRIBUTE12 , PE.ATTRIBUTE13 , PE.ATTRIBUTE14 , PE.ATTRIBUTE15 , PE.ATTRIBUTE16 , PE.ATTRIBUTE17 , PE.ATTRIBUTE18 , PE.ATTRIBUTE19 , PE.ATTRIBUTE20 , PE.LAST_UPDATE_DATE , PE.LAST_UPDATED_BY , PE.LAST_UPDATE_LOGIN , PE.CREATED_BY , PE.CREATION_DATE , HL.TIMEZONE_CODE FROM PER_EVENTS PE, PER_ALL_PEOPLE_F PAP, HR_LOOKUPS HR, HR_LOCATIONS_ALL_TL HLTL, HR_LOCATIONS_NO_JOIN HL, HR_ALL_ORGANIZATION_UNITS HO, HR_ALL_ORGANIZATION_UNITS_TL HOTL WHERE HO.organization_id = HOTL.organization_id (+) AND PE.ORGANIZATION_RUN_BY_ID = HO.ORGANIZATION_ID (+) AND PE.EVENT_OR_INTERVIEW = 'E' AND PE.TYPE = HR.LOOKUP_CODE AND HR.LOOKUP_TYPE = decode(pe.emp_or_apl,'E','EMP_EVENT_TYPE','A','APL_EVENT_TYPE') AND PE.LOCATION_ID = HL.LOCATION_ID (+) AND PE.INTERNAL_CONTACT_PERSON_ID = PAP.PERSON_ID (+) AND PE.DATE_START BETWEEN NVL(PAP.EFFECTIVE_START_DATE,PE.DATE_START) AND NVL(PAP.EFFECTIVE_END_DATE,PE.DATE_START) AND decode (hotl.organization_id, null, '1', HOTL.language) = decode( hotl.organization_id, null, '1', userenv('LANG')) AND HL.LOCATION_ID = HLTL.LOCATION_ID (+) AND decode (hltl.location_id,null,'1',hltl.language) = decode(hltl.location_id,null,'1',userenv('LANG'))

View Text - HTML Formatted

SELECT PE.ROWID ROW_ID
, PE.EVENT_ID
, PE.BUSINESS_GROUP_ID
, HR.MEANING
, HLTL.LOCATION_CODE
, HR.LOOKUP_TYPE
, HOTL.NAME
, PAP.FULL_NAME
, NVL(PAP.EMPLOYEE_NUMBER
, PAP.NPW_NUMBER) EMPLOYEE_NUMBER
, PE.LOCATION_ID
, PE.INTERNAL_CONTACT_PERSON_ID
, PE.ORGANIZATION_RUN_BY_ID
, PE.ASSIGNMENT_ID
, PE.DATE_START
, PE.TYPE
, PE.COMMENTS
, PE.CONTACT_TELEPHONE_NUMBER
, PE.DATE_END
, PE.EMP_OR_APL
, PE.EVENT_OR_INTERVIEW
, PE.EXTERNAL_CONTACT
, PE.TIME_END
, PE.TIME_START
, PE.REQUEST_ID
, PE.PROGRAM_APPLICATION_ID
, PE.PROGRAM_ID
, PE.PROGRAM_UPDATE_DATE
, PE.ATTRIBUTE_CATEGORY
, PE.ATTRIBUTE1
, PE.ATTRIBUTE2
, PE.ATTRIBUTE3
, PE.ATTRIBUTE4
, PE.ATTRIBUTE5
, PE.ATTRIBUTE6
, PE.ATTRIBUTE7
, PE.ATTRIBUTE8
, PE.ATTRIBUTE9
, PE.ATTRIBUTE10
, PE.ATTRIBUTE11
, PE.ATTRIBUTE12
, PE.ATTRIBUTE13
, PE.ATTRIBUTE14
, PE.ATTRIBUTE15
, PE.ATTRIBUTE16
, PE.ATTRIBUTE17
, PE.ATTRIBUTE18
, PE.ATTRIBUTE19
, PE.ATTRIBUTE20
, PE.LAST_UPDATE_DATE
, PE.LAST_UPDATED_BY
, PE.LAST_UPDATE_LOGIN
, PE.CREATED_BY
, PE.CREATION_DATE
, HL.TIMEZONE_CODE
FROM PER_EVENTS PE
, PER_ALL_PEOPLE_F PAP
, HR_LOOKUPS HR
, HR_LOCATIONS_ALL_TL HLTL
, HR_LOCATIONS_NO_JOIN HL
, HR_ALL_ORGANIZATION_UNITS HO
, HR_ALL_ORGANIZATION_UNITS_TL HOTL
WHERE HO.ORGANIZATION_ID = HOTL.ORGANIZATION_ID (+)
AND PE.ORGANIZATION_RUN_BY_ID = HO.ORGANIZATION_ID (+)
AND PE.EVENT_OR_INTERVIEW = 'E'
AND PE.TYPE = HR.LOOKUP_CODE
AND HR.LOOKUP_TYPE = DECODE(PE.EMP_OR_APL
, 'E'
, 'EMP_EVENT_TYPE'
, 'A'
, 'APL_EVENT_TYPE')
AND PE.LOCATION_ID = HL.LOCATION_ID (+)
AND PE.INTERNAL_CONTACT_PERSON_ID = PAP.PERSON_ID (+)
AND PE.DATE_START BETWEEN NVL(PAP.EFFECTIVE_START_DATE
, PE.DATE_START)
AND NVL(PAP.EFFECTIVE_END_DATE
, PE.DATE_START)
AND DECODE (HOTL.ORGANIZATION_ID
, NULL
, '1'
, HOTL.LANGUAGE) = DECODE( HOTL.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND HL.LOCATION_ID = HLTL.LOCATION_ID (+)
AND DECODE (HLTL.LOCATION_ID
, NULL
, '1'
, HLTL.LANGUAGE) = DECODE(HLTL.LOCATION_ID
, NULL
, '1'
, USERENV('LANG'))