VIEW: APPS.GHR_PERSON_SUMMARY_V

Source

View Text - Preformatted

SELECT per.rowid row_id ,per.person_id ,per.full_name ,per.national_identifier ,per.date_of_birth ,per.employee_number ,per.applicant_number ,per.sex ,hl_sex.meaning d_sex ,per.business_group_id ,per.npw_number ,per.person_type_id ,asg.assignment_id ,ast.per_system_status ,ast.user_status ,asg.position_id ,asg.location_id ,asg.job_id FROM hr_lookups hl_sex ,per_assignment_status_types ast ,per_assignments_f asg ,per_people_f per ,fnd_sessions ses WHERE userenv('sessionid') = ses.session_id AND hl_sex.LOOKUP_TYPE (+) = 'SEX' AND per.sex = HL_sex.LOOKUP_CODE (+) AND ses.effective_date BETWEEN per.effective_start_date AND per.effective_end_date AND asg.person_id = per.person_id AND ses.effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date AND ast.assignment_status_type_id = asg.assignment_status_type_id AND ast.per_system_status IN ('ACTIVE_ASSIGN','SUSP_ASSIGN', 'ACTIVE_CWK') AND asg.primary_flag = 'Y' AND asg.assignment_type in ('E','C')

View Text - HTML Formatted

SELECT PER.ROWID ROW_ID
, PER.PERSON_ID
, PER.FULL_NAME
, PER.NATIONAL_IDENTIFIER
, PER.DATE_OF_BIRTH
, PER.EMPLOYEE_NUMBER
, PER.APPLICANT_NUMBER
, PER.SEX
, HL_SEX.MEANING D_SEX
, PER.BUSINESS_GROUP_ID
, PER.NPW_NUMBER
, PER.PERSON_TYPE_ID
, ASG.ASSIGNMENT_ID
, AST.PER_SYSTEM_STATUS
, AST.USER_STATUS
, ASG.POSITION_ID
, ASG.LOCATION_ID
, ASG.JOB_ID
FROM HR_LOOKUPS HL_SEX
, PER_ASSIGNMENT_STATUS_TYPES AST
, PER_ASSIGNMENTS_F ASG
, PER_PEOPLE_F PER
, FND_SESSIONS SES
WHERE USERENV('SESSIONID') = SES.SESSION_ID
AND HL_SEX.LOOKUP_TYPE (+) = 'SEX'
AND PER.SEX = HL_SEX.LOOKUP_CODE (+)
AND SES.EFFECTIVE_DATE BETWEEN PER.EFFECTIVE_START_DATE
AND PER.EFFECTIVE_END_DATE
AND ASG.PERSON_ID = PER.PERSON_ID
AND SES.EFFECTIVE_DATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND AST.ASSIGNMENT_STATUS_TYPE_ID = ASG.ASSIGNMENT_STATUS_TYPE_ID
AND AST.PER_SYSTEM_STATUS IN ('ACTIVE_ASSIGN'
, 'SUSP_ASSIGN'
, 'ACTIVE_CWK')
AND ASG.PRIMARY_FLAG = 'Y'
AND ASG.ASSIGNMENT_TYPE IN ('E'
, 'C')