实现目标:根据配置文件调整职务LOV内容
个性化设置:
获取配置文件的值:FND_PROFILE.VALUE('CUX_PER_MO_ABBR')
配置个性化条件
设置活动:创建记录组 , 设置LOV对应的记录组
SELECT pjv.job_id,
pjv.NAME,
pjv.date_from job_start_date,
pjv.date_to job_end_date
FROM per_jobs_v pjv ,
per_job_definitions pjd
WHERE pjv.business_group_id = :ctl_globals.business_group_id
AND pjd.job_definition_id = pjv.job_definition_id
AND :positions.effective_start_date BETWEEN pjv.date_from AND nvl(pjv.date_to,:ctl_globals.end_of_time)
AND (CASE
WHEN FND_PROFILE.VALUE('CUX_PER_MO_ABBR') IN ('DFL',
'DFAC',
'DFCV',
'DFMHQ',
'DFSCV',
'DFYY') AND pjd.segment5 = '10' THEN 'Y'
WHEN FND_PROFILE.VALUE('CUX_PER_MO_ABBR') IN ('DFMSY',
'DFMXY',
'DFMED') AND pjd.segment5 = '20' THEN 'Y'
WHEN FND_PROFILE.VALUE('CUX_PER_MO_ABBR') IN ('DFTC') AND pjd.segment5 = '30' THEN 'Y'
WHEN FND_PROFILE.VALUE('CUX_PER_MO_ABBR') IN ('DFM') AND pjd.segment5 IN ('10','20','30')THEN 'Y'
ELSE 'N'
END) = 'Y'
ORDER BY NAME