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