View: HRFV_JOB_AND_POS_REQUIREMENTS

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

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, JOB.NAME JOB_NAME
, POS.NAME POSITION_NAME
, PJR.COMMENTS COMMENTS
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PJR.ESSENTIAL) ESSENTIAL
, FLEX.ID_FLEX_STRUCTURE_NAME INFORMATION_TYPE
, '_DF:PER:PER_JOB_REQUIREMENTS:PJR'
, '_KF:PER:PEA:PAC'
, PJR.JOB_ID JOB_ID
, PJR.POSITION_ID POSITION_ID
FROM PER_JOB_REQUIREMENTS PJR
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_JOBS JOB
, PER_ALL_POSITIONS POS
, PER_ANALYSIS_CRITERIA PAC
, FND_ID_FLEX_STRUCTURES_VL FLEX
WHERE PJR.JOB_ID = JOB.JOB_ID (+)
AND PJR.POSITION_ID = POS.POSITION_ID (+)
AND PJR.ANALYSIS_CRITERIA_ID = PAC.ANALYSIS_CRITERIA_ID
AND PJR.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND PAC.ID_FLEX_NUM = FLEX.ID_FLEX_NUM
AND PJR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PJR.BUSINESS_GROUP_ID) WITH READ ONLY

Columns