VIEW: APPS.PER_MM_ASSIGNMENTS_V

Source

View Text - Preformatted

SELECT MMASG.ROWID , MMASG.ASSIGNMENT_ID , MMASG.ASSIGNMENT_MOVED , MMASG.DEFAULT_FROM , MMASG.MASS_MOVE_ID , MMASG.OBJECT_VERSION_NUMBER , MMASG.POSITION_ID , MMASG.SELECT_ASSIGNMENT , PER.FULL_NAME , LOCTL.LOCATION_CODE , MMASG.GRADE_ID , GDT.NAME , ASTTL.USER_STATUS /* , PETTL.USER_PERSON_TYPE */ , hr_person_type_usage_info.get_user_person_type(mm.effective_date,per.person_id) , MMASG.TAX_UNIT_ID , TAX.NAME , ASG. ASSIGNMENT_TYPE FROM PER_ASSIGNMENTS_F ASG, PER_PEOPLE_F PER, PER_MM_ASSIGNMENTS MMASG, PER_MM_POSITIONS MMPOS, HR_LOCATIONS_ALL_TL LOCTL, HR_LOCATIONS_NO_JOIN LOC, PER_GRADES_TL GDT, PER_MASS_MOVES MM, PER_ASSIGNMENT_STATUS_TYPES AST, PER_ASSIGNMENT_STATUS_TYPES_TL ASTTL, PER_PERSON_TYPES PET, PER_PERSON_TYPES_TL PETTL, HR_TAX_UNITS_V TAX WHERE ASG.ASSIGNMENT_ID = MMASG.ASSIGNMENT_ID AND ASG.PERSON_ID = PER.PERSON_ID AND PER.PERSON_TYPE_ID = PET.PERSON_TYPE_ID AND ASG.LOCATION_ID = LOC.LOCATION_ID (+) AND MMASG.GRADE_ID = GDT.GRADE_ID (+) AND GDT.LANGUAGE(+) = userenv('LANG') AND MMASG.TAX_UNIT_ID = TAX.TAX_UNIT_ID (+) AND ASG.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID AND MMASG.MASS_MOVE_ID = MM.MASS_MOVE_ID AND MMASG.POSITION_ID = MMPOS.POSITION_ID AND MMPOS.MASS_MOVE_ID = MM.MASS_MOVE_ID AND MM.EFFECTIVE_DATE BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE AND MM.EFFECTIVE_DATE BETWEEN PER.EFFECTIVE_START_DATE AND PER.EFFECTIVE_END_DATE AND PET.PERSON_TYPE_ID = PETTL.PERSON_TYPE_ID AND AST.ASSIGNMENT_STATUS_TYPE_ID = ASTTL.ASSIGNMENT_STATUS_TYPE_ID AND PETTL.LANGUAGE = userenv('LANG') AND ASTTL.LANGUAGE = userenv('LANG') AND loc.location_id = loctl.location_id (+) AND decode(loctl.location_id,null,'1',loctl.language) = decode(loctl.location_id,null,'1',userenv('LANG'))

View Text - HTML Formatted

SELECT MMASG.ROWID
, MMASG.ASSIGNMENT_ID
, MMASG.ASSIGNMENT_MOVED
, MMASG.DEFAULT_FROM
, MMASG.MASS_MOVE_ID
, MMASG.OBJECT_VERSION_NUMBER
, MMASG.POSITION_ID
, MMASG.SELECT_ASSIGNMENT
, PER.FULL_NAME
, LOCTL.LOCATION_CODE
, MMASG.GRADE_ID
, GDT.NAME
, ASTTL.USER_STATUS /*
, PETTL.USER_PERSON_TYPE */
, HR_PERSON_TYPE_USAGE_INFO.GET_USER_PERSON_TYPE(MM.EFFECTIVE_DATE
, PER.PERSON_ID)
, MMASG.TAX_UNIT_ID
, TAX.NAME
, ASG. ASSIGNMENT_TYPE
FROM PER_ASSIGNMENTS_F ASG
, PER_PEOPLE_F PER
, PER_MM_ASSIGNMENTS MMASG
, PER_MM_POSITIONS MMPOS
, HR_LOCATIONS_ALL_TL LOCTL
, HR_LOCATIONS_NO_JOIN LOC
, PER_GRADES_TL GDT
, PER_MASS_MOVES MM
, PER_ASSIGNMENT_STATUS_TYPES AST
, PER_ASSIGNMENT_STATUS_TYPES_TL ASTTL
, PER_PERSON_TYPES PET
, PER_PERSON_TYPES_TL PETTL
, HR_TAX_UNITS_V TAX
WHERE ASG.ASSIGNMENT_ID = MMASG.ASSIGNMENT_ID
AND ASG.PERSON_ID = PER.PERSON_ID
AND PER.PERSON_TYPE_ID = PET.PERSON_TYPE_ID
AND ASG.LOCATION_ID = LOC.LOCATION_ID (+)
AND MMASG.GRADE_ID = GDT.GRADE_ID (+)
AND GDT.LANGUAGE(+) = USERENV('LANG')
AND MMASG.TAX_UNIT_ID = TAX.TAX_UNIT_ID (+)
AND ASG.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID
AND MMASG.MASS_MOVE_ID = MM.MASS_MOVE_ID
AND MMASG.POSITION_ID = MMPOS.POSITION_ID
AND MMPOS.MASS_MOVE_ID = MM.MASS_MOVE_ID
AND MM.EFFECTIVE_DATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND MM.EFFECTIVE_DATE BETWEEN PER.EFFECTIVE_START_DATE
AND PER.EFFECTIVE_END_DATE
AND PET.PERSON_TYPE_ID = PETTL.PERSON_TYPE_ID
AND AST.ASSIGNMENT_STATUS_TYPE_ID = ASTTL.ASSIGNMENT_STATUS_TYPE_ID
AND PETTL.LANGUAGE = USERENV('LANG')
AND ASTTL.LANGUAGE = USERENV('LANG')
AND LOC.LOCATION_ID = LOCTL.LOCATION_ID (+)
AND DECODE(LOCTL.LOCATION_ID
, NULL
, '1'
, LOCTL.LANGUAGE) = DECODE(LOCTL.LOCATION_ID
, NULL
, '1'
, USERENV('LANG'))