VIEW: APPS.PER_ASSIGNMENTS_V10

Source

View Text - Preformatted

SELECT asg.person_id ,asg.assignment_id ,asg.primary_flag ,asg.contract_id ,asg.assignment_status_type_id ,asg.location_id ,asg.organization_id ,asg.assignment_number ,asg.payroll_id ,asg.employment_category ,jbt.name ,job.job_id ,job.job_definition_id ,pft.name ,pos.position_id ,pos.position_definition_id ,gdt.name ,gra.grade_id ,gra.grade_definition_id ,ppg.group_name ,ppg.people_group_id ,asg.business_group_id FROM per_assignments_f asg ,fnd_sessions ses ,per_jobs job ,per_positions pos ,per_grades gra ,per_jobs_tl jbt ,hr_all_positions_f_tl pft ,per_grades_tl gdt ,pay_people_groups ppg WHERE asg.job_id = job.job_id (+) AND asg.job_id = jbt.job_id (+) AND jbt.language (+) = userenv('LANG') AND asg.position_id = pos.position_id (+) AND asg.position_id = pft.position_id (+) AND pft.language (+) = userenv('LANG') AND asg.grade_id = gra.grade_id (+) AND asg.grade_id = gdt.grade_id (+) AND gdt.language (+) = userenv('LANG') AND asg.people_group_id = ppg.people_group_id (+) AND ses.session_id = USERENV('sessionid') AND ses.effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date AND asg.assignment_type in ('A','E')

View Text - HTML Formatted

SELECT ASG.PERSON_ID
, ASG.ASSIGNMENT_ID
, ASG.PRIMARY_FLAG
, ASG.CONTRACT_ID
, ASG.ASSIGNMENT_STATUS_TYPE_ID
, ASG.LOCATION_ID
, ASG.ORGANIZATION_ID
, ASG.ASSIGNMENT_NUMBER
, ASG.PAYROLL_ID
, ASG.EMPLOYMENT_CATEGORY
, JBT.NAME
, JOB.JOB_ID
, JOB.JOB_DEFINITION_ID
, PFT.NAME
, POS.POSITION_ID
, POS.POSITION_DEFINITION_ID
, GDT.NAME
, GRA.GRADE_ID
, GRA.GRADE_DEFINITION_ID
, PPG.GROUP_NAME
, PPG.PEOPLE_GROUP_ID
, ASG.BUSINESS_GROUP_ID
FROM PER_ASSIGNMENTS_F ASG
, FND_SESSIONS SES
, PER_JOBS JOB
, PER_POSITIONS POS
, PER_GRADES GRA
, PER_JOBS_TL JBT
, HR_ALL_POSITIONS_F_TL PFT
, PER_GRADES_TL GDT
, PAY_PEOPLE_GROUPS PPG
WHERE ASG.JOB_ID = JOB.JOB_ID (+)
AND ASG.JOB_ID = JBT.JOB_ID (+)
AND JBT.LANGUAGE (+) = USERENV('LANG')
AND ASG.POSITION_ID = POS.POSITION_ID (+)
AND ASG.POSITION_ID = PFT.POSITION_ID (+)
AND PFT.LANGUAGE (+) = USERENV('LANG')
AND ASG.GRADE_ID = GRA.GRADE_ID (+)
AND ASG.GRADE_ID = GDT.GRADE_ID (+)
AND GDT.LANGUAGE (+) = USERENV('LANG')
AND ASG.PEOPLE_GROUP_ID = PPG.PEOPLE_GROUP_ID (+)
AND SES.SESSION_ID = USERENV('SESSIONID')
AND SES.EFFECTIVE_DATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND ASG.ASSIGNMENT_TYPE IN ('A'
, 'E')