VIEW: APPS.PER_EXPANDED_ANALYSES_VIEW2

Source

View Text - Preformatted

SELECT /*+ RULE */ N.PERSON_ID , N.FULL_NAME , N.PERSON_TYPE_ID /* , PTL.USER_PERSON_TYPE */ , hr_person_type_usage_info.get_user_person_type(n.effective_end_date,n.person_id) , N.EMPLOYEE_NUMBER , N.APPLICANT_NUMBER , A.PERSON_ANALYSIS_ID , A.ANALYSIS_CRITERIA_ID , A.BUSINESS_GROUP_ID , A.COMMENTS , A.DATE_FROM , A.DATE_TO , A.ATTRIBUTE_CATEGORY , A.ATTRIBUTE1 , A.ATTRIBUTE2 , A.ATTRIBUTE3 , A.ATTRIBUTE4 , A.ATTRIBUTE5 , A.ATTRIBUTE6 , A.ATTRIBUTE7 , A.ATTRIBUTE8 , A.ATTRIBUTE9 , A.ATTRIBUTE10 , A.ATTRIBUTE11 , A.ATTRIBUTE12 , A.ATTRIBUTE13 , A.ATTRIBUTE14 , A.ATTRIBUTE15 , A.ATTRIBUTE16 , A.ATTRIBUTE17 , A.ATTRIBUTE18 , A.ATTRIBUTE19 , A.ATTRIBUTE20 , C.ID_FLEX_NUM , C.ENABLED_FLAG , C.SUMMARY_FLAG , A.LAST_UPDATE_DATE , A.LAST_UPDATED_BY , A.LAST_UPDATE_LOGIN , A.CREATED_BY , A.CREATION_DATE , C.END_DATE_ACTIVE , C.START_DATE_ACTIVE , C.SEGMENT1 , C.SEGMENT2 , C.SEGMENT3 , C.SEGMENT4 , C.SEGMENT5 , C.SEGMENT6 , C.SEGMENT7 , C.SEGMENT8 , C.SEGMENT9 , C.SEGMENT10 , C.SEGMENT11 , C.SEGMENT12 , C.SEGMENT13 , C.SEGMENT14 , C.SEGMENT15 , C.SEGMENT16 , C.SEGMENT17 , C.SEGMENT18 , C.SEGMENT19 , C.SEGMENT20 , C.SEGMENT21 , C.SEGMENT22 , C.SEGMENT23 , C.SEGMENT24 , C.SEGMENT25 , C.SEGMENT26 , C.SEGMENT27 , C.SEGMENT28 , C.SEGMENT29 , C.SEGMENT30 , N.NPW_NUMBER FROM PER_PERSON_TYPES P , PER_PERSON_TYPES_TL PTL , PER_PEOPLE N , PER_PERSON_ANALYSES A , PER_ANALYSIS_CRITERIA C WHERE N.PERSON_ID = A.PERSON_ID AND A.ANALYSIS_CRITERIA_ID = C.ANALYSIS_CRITERIA_ID AND N.PERSON_TYPE_ID = P.PERSON_TYPE_ID AND P.person_type_id = PTL.person_type_id AND PTL.language = userenv('LANG')

View Text - HTML Formatted

SELECT /*+ RULE */ N.PERSON_ID
, N.FULL_NAME
, N.PERSON_TYPE_ID /*
, PTL.USER_PERSON_TYPE */
, HR_PERSON_TYPE_USAGE_INFO.GET_USER_PERSON_TYPE(N.EFFECTIVE_END_DATE
, N.PERSON_ID)
, N.EMPLOYEE_NUMBER
, N.APPLICANT_NUMBER
, A.PERSON_ANALYSIS_ID
, A.ANALYSIS_CRITERIA_ID
, A.BUSINESS_GROUP_ID
, A.COMMENTS
, A.DATE_FROM
, A.DATE_TO
, A.ATTRIBUTE_CATEGORY
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
, A.ATTRIBUTE16
, A.ATTRIBUTE17
, A.ATTRIBUTE18
, A.ATTRIBUTE19
, A.ATTRIBUTE20
, C.ID_FLEX_NUM
, C.ENABLED_FLAG
, C.SUMMARY_FLAG
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_LOGIN
, A.CREATED_BY
, A.CREATION_DATE
, C.END_DATE_ACTIVE
, C.START_DATE_ACTIVE
, C.SEGMENT1
, C.SEGMENT2
, C.SEGMENT3
, C.SEGMENT4
, C.SEGMENT5
, C.SEGMENT6
, C.SEGMENT7
, C.SEGMENT8
, C.SEGMENT9
, C.SEGMENT10
, C.SEGMENT11
, C.SEGMENT12
, C.SEGMENT13
, C.SEGMENT14
, C.SEGMENT15
, C.SEGMENT16
, C.SEGMENT17
, C.SEGMENT18
, C.SEGMENT19
, C.SEGMENT20
, C.SEGMENT21
, C.SEGMENT22
, C.SEGMENT23
, C.SEGMENT24
, C.SEGMENT25
, C.SEGMENT26
, C.SEGMENT27
, C.SEGMENT28
, C.SEGMENT29
, C.SEGMENT30
, N.NPW_NUMBER
FROM PER_PERSON_TYPES P
, PER_PERSON_TYPES_TL PTL
, PER_PEOPLE N
, PER_PERSON_ANALYSES A
, PER_ANALYSIS_CRITERIA C
WHERE N.PERSON_ID = A.PERSON_ID
AND A.ANALYSIS_CRITERIA_ID = C.ANALYSIS_CRITERIA_ID
AND N.PERSON_TYPE_ID = P.PERSON_TYPE_ID
AND P.PERSON_TYPE_ID = PTL.PERSON_TYPE_ID
AND PTL.LANGUAGE = USERENV('LANG')