eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PER_MM_POSITIONS_V

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

View Text

SELECT MMPOS.ROWID
, MMPOS.MASS_MOVE_ID
, MMPOS.DEACTIVATE_OLD_POSITION
, MMPOS.DEFAULT_FROM
, MMPOS.NEW_POSITION_ID
, MMPOS.NEW_POSITION_DEFINITION_ID
, HR_GENERAL.DECODE_POSITION_LATEST_NAME(MMPOS.NEW_POSITION_ID)
, MMPOS.TARGET_JOB_ID
, MMPOS.OBJECT_VERSION_NUMBER
, MMPOS.POSITION_ID
, HR_GENERAL.DECODE_POSITION_LATEST_NAME(MMPOS.POSITION_ID)
, HR_GENERAL.DECODE_LATEST_POSITION_DEF_ID(MMPOS.POSITION_ID)
, MMPOS.POSITION_MOVED
, MMPOS.SELECT_POSITION
, JOB.JOB_ID
, JBT.NAME
, JOB.JOB_DEFINITION_ID
, ORG.ORGANIZATION_ID
, ORG.NAME
, NEWORG.NAME
, MMPOS.SEGMENT1
, MMPOS.SEGMENT2
, MMPOS.SEGMENT3
, MMPOS.SEGMENT4
, MMPOS.SEGMENT5
, MMPOS.SEGMENT6
, MMPOS.SEGMENT7
, MMPOS.SEGMENT8
, MMPOS.SEGMENT9
, MMPOS.SEGMENT10
, MMPOS.SEGMENT11
, MMPOS.SEGMENT12
, MMPOS.SEGMENT13
, MMPOS.SEGMENT14
, MMPOS.SEGMENT15
, MMPOS.SEGMENT16
, MMPOS.SEGMENT17
, MMPOS.SEGMENT18
, MMPOS.SEGMENT19
, MMPOS.SEGMENT20
, MMPOS.SEGMENT21
, MMPOS.SEGMENT22
, MMPOS.SEGMENT23
, MMPOS.SEGMENT24
, MMPOS.SEGMENT25
, MMPOS.SEGMENT26
, MMPOS.SEGMENT27
, MMPOS.SEGMENT28
, MMPOS.SEGMENT29
, MMPOS.SEGMENT30
FROM PER_MM_POSITIONS MMPOS
, PER_MM_ASSIGNMENTS MMASG
, PER_MASS_MOVES MM
, HR_POSITIONS POS
, PER_JOBS JOB
, PER_JOBS_TL JBT
, HR_ORGANIZATION_UNITS ORG
, HR_ORGANIZATION_UNITS NEWORG
WHERE MMPOS.POSITION_ID = MMASG.POSITION_ID (+)
AND MMPOS.POSITION_ID = POS.POSITION_ID
AND MMPOS.MASS_MOVE_ID = MM.MASS_MOVE_ID
AND MM.NEW_ORGANIZATION_ID = NEWORG.ORGANIZATION_ID
AND POS.EFFECTIVE_END_DATE = TO_DATE('31124712'
, 'DDMMYYYY')
AND POS.JOB_ID = JOB.JOB_ID
AND JOB.JOB_ID = JBT.JOB_ID
AND JBT.LANGUAGE = USERENV('LANG')
AND POS.ORGANIZATION_ID = ORG.ORGANIZATION_ID GROUP BY MMPOS.ROWID
, MMPOS.DEACTIVATE_OLD_POSITION
, MMPOS.DEFAULT_FROM
, MMPOS.MASS_MOVE_ID
, MMPOS.NEW_POSITION_ID
, 7
, MMPOS.NEW_POSITION_DEFINITION_ID
, MMPOS.TARGET_JOB_ID
, MMPOS.OBJECT_VERSION_NUMBER
, MMPOS.POSITION_ID
, 11
, 12
, MMPOS.POSITION_MOVED
, MMPOS.SELECT_POSITION
, JOB.JOB_ID
, JBT.NAME
, JOB.JOB_DEFINITION_ID
, ORG.ORGANIZATION_ID
, ORG.NAME
, NEWORG.NAME
, MMPOS.SEGMENT1
, MMPOS.SEGMENT2
, MMPOS.SEGMENT3
, MMPOS.SEGMENT4
, MMPOS.SEGMENT5
, MMPOS.SEGMENT6
, MMPOS.SEGMENT7
, MMPOS.SEGMENT8
, MMPOS.SEGMENT9
, MMPOS.SEGMENT10
, MMPOS.SEGMENT11
, MMPOS.SEGMENT12
, MMPOS.SEGMENT13
, MMPOS.SEGMENT14
, MMPOS.SEGMENT15
, MMPOS.SEGMENT16
, MMPOS.SEGMENT17
, MMPOS.SEGMENT18
, MMPOS.SEGMENT19
, MMPOS.SEGMENT20
, MMPOS.SEGMENT21
, MMPOS.SEGMENT22
, MMPOS.SEGMENT23
, MMPOS.SEGMENT24
, MMPOS.SEGMENT25
, MMPOS.SEGMENT26
, MMPOS.SEGMENT27
, MMPOS.SEGMENT28
, MMPOS.SEGMENT29
, MMPOS.SEGMENT30

Columns

Name
ROW_ID
MASS_MOVE_ID
DEACTIVATE_OLD_POSITION
DEFAULT_FROM
NEW_POSITION_ID
NEW_POSITION_DEFINITION_ID
NEW_POSITION_NAME
TARGET_JOB_ID
OBJECT_VERSION_NUMBER
POSITION_ID
POSITION_NAME
POSITION_DEFINITION_ID
POSITION_MOVED
SELECT_POSITION
JOB_ID
JOB_NAME
JOB_DEFINITION_ID
ORGANIZATION_ID
ORGANIZATION_NAME
NEW_ORGANIZATION_NAME
SEGMENT1
SEGMENT2
SEGMENT3
SEGMENT4
SEGMENT5
SEGMENT6
SEGMENT7
SEGMENT8
SEGMENT9
SEGMENT10
SEGMENT11
SEGMENT12
SEGMENT13
SEGMENT14
SEGMENT15
SEGMENT16
SEGMENT17
SEGMENT18
SEGMENT19
SEGMENT20
SEGMENT21
SEGMENT22
SEGMENT23
SEGMENT24
SEGMENT25
SEGMENT26
SEGMENT27
SEGMENT28
SEGMENT29
SEGMENT30