View: HRFV_JOBS

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

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, JOBS.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 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) WITH READ ONLY

Columns