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.

VIEW: APPS.PER_JP_SPECIAL_INFORMATION

Source

View Text - Preformatted


SELECT ST.ID_FLEX_STRUCTURE_NAME , PA.PERSON_ID , PA.DATE_FROM , PA.DATE_TO , AC.ROWID ROW_ID , AC.ANALYSIS_CRITERIA_ID , AC.ID_FLEX_NUM , AC.SEGMENT1 , AC.SEGMENT2 , AC.SEGMENT3 , AC.SEGMENT4 , AC.SEGMENT5 , AC.SEGMENT6 , AC.SEGMENT7 , AC.SEGMENT8 , AC.SEGMENT9 , AC.SEGMENT10 , AC.SEGMENT11 , AC.SEGMENT12 , AC.SEGMENT13 , AC.SEGMENT14 , AC.SEGMENT15 , AC.SEGMENT16 , AC.SEGMENT17 , AC.SEGMENT18 , AC.SEGMENT19 , AC.SEGMENT20 , AC.SEGMENT21 , AC.SEGMENT22 , AC.SEGMENT23 , AC.SEGMENT24 , AC.SEGMENT25 , AC.SEGMENT26 , AC.SEGMENT27 , AC.SEGMENT28 , AC.SEGMENT29 , AC.SEGMENT30 , AC.REQUEST_ID , AC.PROGRAM_APPLICATION_ID , AC.PROGRAM_ID , AC.PROGRAM_UPDATE_DATE , AC.SUMMARY_FLAG , AC.ENABLED_FLAG , AC.START_DATE_ACTIVE , AC.END_DATE_ACTIVE , AC.LAST_UPDATE_DATE , AC.LAST_UPDATED_BY , AC.LAST_UPDATE_LOGIN , AC.CREATED_BY , AC.CREATION_DATE FROM PER_ANALYSIS_CRITERIA AC, PER_PERSON_ANALYSES PA, FND_ID_FLEX_STRUCTURES_VL ST, FND_SESSIONS FND WHERE PA.ANALYSIS_CRITERIA_ID = AC.ANALYSIS_CRITERIA_ID AND ST.ID_FLEX_CODE = 'PEA' AND PA.ID_FLEX_NUM = ST.ID_FLEX_NUM AND USERENV('sessionid') = FND.SESSION_ID AND FND.EFFECTIVE_DATE BETWEEN PA.DATE_FROM AND NVL(PA.DATE_TO,FND.EFFECTIVE_DATE)

View Text - HTML Formatted

SELECT ST.ID_FLEX_STRUCTURE_NAME
, PA.PERSON_ID
, PA.DATE_FROM
, PA.DATE_TO
, AC.ROWID ROW_ID
, AC.ANALYSIS_CRITERIA_ID
, AC.ID_FLEX_NUM
, AC.SEGMENT1
, AC.SEGMENT2
, AC.SEGMENT3
, AC.SEGMENT4
, AC.SEGMENT5
, AC.SEGMENT6
, AC.SEGMENT7
, AC.SEGMENT8
, AC.SEGMENT9
, AC.SEGMENT10
, AC.SEGMENT11
, AC.SEGMENT12
, AC.SEGMENT13
, AC.SEGMENT14
, AC.SEGMENT15
, AC.SEGMENT16
, AC.SEGMENT17
, AC.SEGMENT18
, AC.SEGMENT19
, AC.SEGMENT20
, AC.SEGMENT21
, AC.SEGMENT22
, AC.SEGMENT23
, AC.SEGMENT24
, AC.SEGMENT25
, AC.SEGMENT26
, AC.SEGMENT27
, AC.SEGMENT28
, AC.SEGMENT29
, AC.SEGMENT30
, AC.REQUEST_ID
, AC.PROGRAM_APPLICATION_ID
, AC.PROGRAM_ID
, AC.PROGRAM_UPDATE_DATE
, AC.SUMMARY_FLAG
, AC.ENABLED_FLAG
, AC.START_DATE_ACTIVE
, AC.END_DATE_ACTIVE
, AC.LAST_UPDATE_DATE
, AC.LAST_UPDATED_BY
, AC.LAST_UPDATE_LOGIN
, AC.CREATED_BY
, AC.CREATION_DATE
FROM PER_ANALYSIS_CRITERIA AC
, PER_PERSON_ANALYSES PA
, FND_ID_FLEX_STRUCTURES_VL ST
, FND_SESSIONS FND
WHERE PA.ANALYSIS_CRITERIA_ID = AC.ANALYSIS_CRITERIA_ID
AND ST.ID_FLEX_CODE = 'PEA'
AND PA.ID_FLEX_NUM = ST.ID_FLEX_NUM
AND USERENV('SESSIONID') = FND.SESSION_ID
AND FND.EFFECTIVE_DATE BETWEEN PA.DATE_FROM
AND NVL(PA.DATE_TO
, FND.EFFECTIVE_DATE)