Saturday, April 5, 2014

Oracle HRMS Query - Position

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

Best Blogger TipsGet Flower Effect