VIEW: APPS.HRFV_JOBS

Source

View Text - Preformatted

SELECT bgrT.name business_group_name ,jbt.name job_name ,'_KF:PER:JOB:jdef' ,jobs.date_from date_from ,jobs.date_to date_to ,jobs.comments comments ,jgrp.displayed_name job_group_name ,'_DF:PER:PER_JOBS:jobs' ,'_DF:PER:Job Developer DF:jobs' ,jobs.business_group_id business_group_id ,jobs.job_id job_id ,jdef.job_definition_id job_definition_id ,jgrp.job_group_id job_group_id FROM hr_all_organization_units_tl bgrT ,per_job_definitions jdef ,per_jobs_tl jbt ,per_jobs jobs ,per_job_groups jgrp WHERE jdef.job_definition_id = jobs.job_definition_id AND jobs.job_group_id = jgrp.job_group_id AND jobs.business_group_id = bgrT.organization_id AND bgrT.language = userenv('LANG') AND jobs.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, jobs.business_group_id) AND jobs.job_id = jbt.job_id AND jbt.language = userenv('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, JBT.NAME JOB_NAME
, '_KF:PER:JOB:JDEF'
, JOBS.DATE_FROM DATE_FROM
, JOBS.DATE_TO DATE_TO
, JOBS.COMMENTS COMMENTS
, JGRP.DISPLAYED_NAME JOB_GROUP_NAME
, '_DF:PER:PER_JOBS:JOBS'
, '_DF:PER:JOB DEVELOPER DF:JOBS'
, JOBS.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, JOBS.JOB_ID JOB_ID
, JDEF.JOB_DEFINITION_ID JOB_DEFINITION_ID
, JGRP.JOB_GROUP_ID JOB_GROUP_ID
FROM HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_JOB_DEFINITIONS JDEF
, PER_JOBS_TL JBT
, PER_JOBS JOBS
, PER_JOB_GROUPS JGRP
WHERE JDEF.JOB_DEFINITION_ID = JOBS.JOB_DEFINITION_ID
AND JOBS.JOB_GROUP_ID = JGRP.JOB_GROUP_ID
AND JOBS.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND JOBS.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, JOBS.BUSINESS_GROUP_ID)
AND JOBS.JOB_ID = JBT.JOB_ID
AND JBT.LANGUAGE = USERENV('LANG') WITH READ ONLY