VIEW: APPS.PER_JOB_GROUPS_V

Source

View Text - Preformatted

SELECT jgr.rowid row_id , jgr.job_group_id , jgr.business_group_id , org.name , jgr.legislation_code , jgr.internal_name , jgr.displayed_name , jgr.id_flex_num , fnd.id_flex_structure_name , jgr.master_flag , jgr.object_version_number , jgr.creation_date , jgr.created_by , jgr.last_update_date , jgr.last_updated_by , jgr.last_update_login from per_job_groups jgr, hr_all_organization_units org, fnd_id_flex_structures_vl fnd where jgr.business_group_id = org.organization_id (+) and jgr.id_flex_num = fnd.id_flex_num and fnd.id_flex_code = 'JOB'

View Text - HTML Formatted

SELECT JGR.ROWID ROW_ID
, JGR.JOB_GROUP_ID
, JGR.BUSINESS_GROUP_ID
, ORG.NAME
, JGR.LEGISLATION_CODE
, JGR.INTERNAL_NAME
, JGR.DISPLAYED_NAME
, JGR.ID_FLEX_NUM
, FND.ID_FLEX_STRUCTURE_NAME
, JGR.MASTER_FLAG
, JGR.OBJECT_VERSION_NUMBER
, JGR.CREATION_DATE
, JGR.CREATED_BY
, JGR.LAST_UPDATE_DATE
, JGR.LAST_UPDATED_BY
, JGR.LAST_UPDATE_LOGIN
FROM PER_JOB_GROUPS JGR
, HR_ALL_ORGANIZATION_UNITS ORG
, FND_ID_FLEX_STRUCTURES_VL FND
WHERE JGR.BUSINESS_GROUP_ID = ORG.ORGANIZATION_ID (+)
AND JGR.ID_FLEX_NUM = FND.ID_FLEX_NUM
AND FND.ID_FLEX_CODE = 'JOB'