View: PER_MM_ASSIGNMENTS_V

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

View Text

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

Columns