View: PER_EXPANDED_ANALYSES_VIEW2

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

View Text

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

Columns