VIEW: APPS.PER_MM_POSITIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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