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.HRFV_DETAILED_SPECIAL_INFO

Source

View Text - Preformatted


SELECT bgrT.name business_group_name ,peo.full_name person_name ,peo.employee_number employee_number ,peo.applicant_number applicant_number ,jr.date_from date_from ,jr.date_to date_to ,nvl(jr.date_from,hr_general.start_of_time) date_from_nn ,nvl(jr.date_to, hr_general.end_of_time) date_to_nn ,jr.comments comments ,seg.segment_name segment_name ,DECODE(seg.application_column_name, 'SEGMENT1', ac.segment1) || DECODE(seg.application_column_name, 'SEGMENT2', ac.segment2) || DECODE(seg.application_column_name, 'SEGMENT3', ac.segment3) || DECODE(seg.application_column_name, 'SEGMENT4', ac.segment4) || DECODE(seg.application_column_name, 'SEGMENT5', ac.segment5) || DECODE(seg.application_column_name, 'SEGMENT6', ac.segment6) || DECODE(seg.application_column_name, 'SEGMENT7', ac.segment7) || DECODE(seg.application_column_name, 'SEGMENT8', ac.segment8) || DECODE(seg.application_column_name, 'SEGMENT9', ac.segment9) || DECODE(seg.application_column_name, 'SEGMENT10',ac.segment10) || DECODE(seg.application_column_name, 'SEGMENT11',ac.segment11) || DECODE(seg.application_column_name, 'SEGMENT12',ac.segment12) || DECODE(seg.application_column_name, 'SEGMENT13',ac.segment13) || DECODE(seg.application_column_name, 'SEGMENT14',ac.segment14) || DECODE(seg.application_column_name, 'SEGMENT15',ac.segment15) || DECODE(seg.application_column_name, 'SEGMENT16',ac.segment16) || DECODE(seg.application_column_name, 'SEGMENT17',ac.segment17) || DECODE(seg.application_column_name, 'SEGMENT18',ac.segment18) || DECODE(seg.application_column_name, 'SEGMENT19',ac.segment19) || DECODE(seg.application_column_name, 'SEGMENT20',ac.segment20) || DECODE(seg.application_column_name, 'SEGMENT21',ac.segment21) || DECODE(seg.application_column_name, 'SEGMENT22',ac.segment22) || DECODE(seg.application_column_name, 'SEGMENT23',ac.segment23) || DECODE(seg.application_column_name, 'SEGMENT24',ac.segment24) || DECODE(seg.application_column_name, 'SEGMENT25',ac.segment25) || DECODE(seg.application_column_name, 'SEGMENT26',ac.segment26) || DECODE(seg.application_column_name, 'SEGMENT27',ac.segment27) || DECODE(seg.application_column_name, 'SEGMENT28',ac.segment28) || DECODE(seg.application_column_name, 'SEGMENT29',ac.segment29) || DECODE(seg.application_column_name, 'SEGMENT30',ac.segment30) segment_details ,hr_bis.bis_decode_lookup('YES_NO', peo.current_employee_flag) current_employee_flag ,hr_bis.bis_decode_lookup('YES_NO', peo.current_applicant_flag) current_applicant_flag ,pptT.user_person_type person_type ,HRI_BPL_PERSON_TYPE.get_emp_user_person_type (peo.effective_start_date ,peo.person_id) employee_person_type ,HRI_BPL_PERSON_TYPE.get_apl_user_person_type (peo.effective_start_date ,peo.person_id) applicant_person_type ,HRI_BPL_PERSON_TYPE.get_concat_user_person_type (peo.effective_start_date ,peo.person_id) user_concat_person_type ,fs.id_flex_structure_name information_type ,peo.current_employee_flag current_employee_flag_code ,peo.current_applicant_flag current_applicant_flag_code ,jr.analysis_criteria_id analysis_criteria_id ,jr.business_group_id business_group_id ,seg.id_flex_num id_flex_num ,jr.person_id person_id ,jr.person_analysis_id person_analysis_id ,seg.segment_num segment_num ,pptT.person_type_id person_type_id FROM hr_all_organization_units_tl bgrT ,per_person_types_tl pptT ,per_people_x peo ,per_person_analyses jr ,fnd_id_flex_structures_vl fs ,per_analysis_criteria ac ,fnd_id_flex_segments_vl seg WHERE seg.id_flex_num = ac.id_flex_num AND seg.enabled_flag = 'Y' AND seg.id_flex_code = fs.id_flex_code AND seg.id_flex_num = fs.id_flex_num AND seg.application_id = fs.application_id AND ac.analysis_criteria_id = jr.analysis_criteria_id AND jr.person_id = peo.person_id AND peo.person_type_id = pptT.person_type_id AND pptT.language = userenv('LANG') AND fs.application_id = 800 AND fs.id_flex_code = 'PEA' AND jr.business_group_id = bgrT.organization_id AND bgrT.language = userenv('LANG') AND jr.business_group_id = NVL(hr_bis.get_sec_profile_bg_id,jr.business_group_id) WITH READ ONLY

View Text - HTML Formatted

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, PEO.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, PEO.APPLICANT_NUMBER APPLICANT_NUMBER
, JR.DATE_FROM DATE_FROM
, JR.DATE_TO DATE_TO
, NVL(JR.DATE_FROM
, HR_GENERAL.START_OF_TIME) DATE_FROM_NN
, NVL(JR.DATE_TO
, HR_GENERAL.END_OF_TIME) DATE_TO_NN
, JR.COMMENTS COMMENTS
, SEG.SEGMENT_NAME SEGMENT_NAME
, DECODE(SEG.APPLICATION_COLUMN_NAME
, 'SEGMENT1'
, AC.SEGMENT1) || DECODE(SEG.APPLICATION_COLUMN_NAME
, 'SEGMENT2'
, AC.SEGMENT2) || DECODE(SEG.APPLICATION_COLUMN_NAME
, 'SEGMENT3'
, AC.SEGMENT3) || DECODE(SEG.APPLICATION_COLUMN_NAME
, 'SEGMENT4'
, AC.SEGMENT4) || DECODE(SEG.APPLICATION_COLUMN_NAME
, 'SEGMENT5'
, AC.SEGMENT5) || DECODE(SEG.APPLICATION_COLUMN_NAME
, 'SEGMENT6'
, AC.SEGMENT6) || DECODE(SEG.APPLICATION_COLUMN_NAME
, 'SEGMENT7'
, AC.SEGMENT7) || DECODE(SEG.APPLICATION_COLUMN_NAME
, 'SEGMENT8'
, AC.SEGMENT8) || DECODE(SEG.APPLICATION_COLUMN_NAME
, 'SEGMENT9'
, AC.SEGMENT9) || DECODE(SEG.APPLICATION_COLUMN_NAME
, 'SEGMENT10'
, AC.SEGMENT10) || DECODE(SEG.APPLICATION_COLUMN_NAME
, 'SEGMENT11'
, AC.SEGMENT11) || DECODE(SEG.APPLICATION_COLUMN_NAME
, 'SEGMENT12'
, AC.SEGMENT12) || DECODE(SEG.APPLICATION_COLUMN_NAME
, 'SEGMENT13'
, AC.SEGMENT13) || DECODE(SEG.APPLICATION_COLUMN_NAME
, 'SEGMENT14'
, AC.SEGMENT14) || DECODE(SEG.APPLICATION_COLUMN_NAME
, 'SEGMENT15'
, AC.SEGMENT15) || DECODE(SEG.APPLICATION_COLUMN_NAME
, 'SEGMENT16'
, AC.SEGMENT16) || DECODE(SEG.APPLICATION_COLUMN_NAME
, 'SEGMENT17'
, AC.SEGMENT17) || DECODE(SEG.APPLICATION_COLUMN_NAME
, 'SEGMENT18'
, AC.SEGMENT18) || DECODE(SEG.APPLICATION_COLUMN_NAME
, 'SEGMENT19'
, AC.SEGMENT19) || DECODE(SEG.APPLICATION_COLUMN_NAME
, 'SEGMENT20'
, AC.SEGMENT20) || DECODE(SEG.APPLICATION_COLUMN_NAME
, 'SEGMENT21'
, AC.SEGMENT21) || DECODE(SEG.APPLICATION_COLUMN_NAME
, 'SEGMENT22'
, AC.SEGMENT22) || DECODE(SEG.APPLICATION_COLUMN_NAME
, 'SEGMENT23'
, AC.SEGMENT23) || DECODE(SEG.APPLICATION_COLUMN_NAME
, 'SEGMENT24'
, AC.SEGMENT24) || DECODE(SEG.APPLICATION_COLUMN_NAME
, 'SEGMENT25'
, AC.SEGMENT25) || DECODE(SEG.APPLICATION_COLUMN_NAME
, 'SEGMENT26'
, AC.SEGMENT26) || DECODE(SEG.APPLICATION_COLUMN_NAME
, 'SEGMENT27'
, AC.SEGMENT27) || DECODE(SEG.APPLICATION_COLUMN_NAME
, 'SEGMENT28'
, AC.SEGMENT28) || DECODE(SEG.APPLICATION_COLUMN_NAME
, 'SEGMENT29'
, AC.SEGMENT29) || DECODE(SEG.APPLICATION_COLUMN_NAME
, 'SEGMENT30'
, AC.SEGMENT30) SEGMENT_DETAILS
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEO.CURRENT_EMPLOYEE_FLAG) CURRENT_EMPLOYEE_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEO.CURRENT_APPLICANT_FLAG) CURRENT_APPLICANT_FLAG
, PPTT.USER_PERSON_TYPE PERSON_TYPE
, HRI_BPL_PERSON_TYPE.GET_EMP_USER_PERSON_TYPE (PEO.EFFECTIVE_START_DATE
, PEO.PERSON_ID) EMPLOYEE_PERSON_TYPE
, HRI_BPL_PERSON_TYPE.GET_APL_USER_PERSON_TYPE (PEO.EFFECTIVE_START_DATE
, PEO.PERSON_ID) APPLICANT_PERSON_TYPE
, HRI_BPL_PERSON_TYPE.GET_CONCAT_USER_PERSON_TYPE (PEO.EFFECTIVE_START_DATE
, PEO.PERSON_ID) USER_CONCAT_PERSON_TYPE
, FS.ID_FLEX_STRUCTURE_NAME INFORMATION_TYPE
, PEO.CURRENT_EMPLOYEE_FLAG CURRENT_EMPLOYEE_FLAG_CODE
, PEO.CURRENT_APPLICANT_FLAG CURRENT_APPLICANT_FLAG_CODE
, JR.ANALYSIS_CRITERIA_ID ANALYSIS_CRITERIA_ID
, JR.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, SEG.ID_FLEX_NUM ID_FLEX_NUM
, JR.PERSON_ID PERSON_ID
, JR.PERSON_ANALYSIS_ID PERSON_ANALYSIS_ID
, SEG.SEGMENT_NUM SEGMENT_NUM
, PPTT.PERSON_TYPE_ID PERSON_TYPE_ID
FROM HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_PERSON_TYPES_TL PPTT
, PER_PEOPLE_X PEO
, PER_PERSON_ANALYSES JR
, FND_ID_FLEX_STRUCTURES_VL FS
, PER_ANALYSIS_CRITERIA AC
, FND_ID_FLEX_SEGMENTS_VL SEG
WHERE SEG.ID_FLEX_NUM = AC.ID_FLEX_NUM
AND SEG.ENABLED_FLAG = 'Y'
AND SEG.ID_FLEX_CODE = FS.ID_FLEX_CODE
AND SEG.ID_FLEX_NUM = FS.ID_FLEX_NUM
AND SEG.APPLICATION_ID = FS.APPLICATION_ID
AND AC.ANALYSIS_CRITERIA_ID = JR.ANALYSIS_CRITERIA_ID
AND JR.PERSON_ID = PEO.PERSON_ID
AND PEO.PERSON_TYPE_ID = PPTT.PERSON_TYPE_ID
AND PPTT.LANGUAGE = USERENV('LANG')
AND FS.APPLICATION_ID = 800
AND FS.ID_FLEX_CODE = 'PEA'
AND JR.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND JR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, JR.BUSINESS_GROUP_ID) WITH READ ONLY