[Home] [Help]
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
Name |
BUSINESS_GROUP_NAME |
JOB_NAME |
"_KF:JOB_NAME" |
DATE_FROM |
DATE_TO |
COMMENTS |
JOB_GROUP_NAME |
"_DF:PER_JOBS" |
"_DF:JOB_DEV" |
BUSINESS_GROUP_ID |
JOB_ID |
JOB_DEFINITION_ID |
JOB_GROUP_ID |