Select distinct
PD.segment1 POSITION_NUMBER ,
pd.segment2 POSITION_NAME ,
pd.segment3 POSITION_GRADE ,
(select name from hr_all_organization_units where ORGANIZATION_ID = pd.segment4) org ,
pd.segment4 org_id,
pd.segment5 POSITION_CODE,
po.name position,
j.name job ,
po.position_id
From
per_positions po ,
per_jobs j ,
hr_all_organization_units org ,
PER_POSITION_DEFINITIONS PD
where 1=1
AND po.BUSINESS_GROUP_ID = 81
and pd.POSITION_DEFINITION_ID = po.POSITION_DEFINITION_ID
and j.job_id = po.job_id
and org.ORGANIZATION_ID = po.ORGANIZATION_ID
and po.position_id= 17624
No comments:
Post a Comment