View: HRFV_DETAILED_SPECIAL_INFO

Product:	PER - Human Resources
Description:	Business view template from which the flexfield view is generated.
Implementation/DBA Data:	APPS.HRFV_DETAILED_SPECIAL_INFO

View Text

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
, 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
, FS.ID_FLEX_STRUCTURE_NAME INFORMATION_TYPE
, 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

Columns