Thursday, 15 May 2014

Oracle HRMS Position Query

/* Formatted on 5/15/2014 9:12:46 AM (QP5 v5.115.810.9015) */
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

3 comments:

  1. You are awesome and appreciate your effort in writing this blog

    ReplyDelete
  2. Hi all, Oracle technical and fusion cloud SCM online classes, if you are interested whatsapp to this number 7382582893, thank you.

    ReplyDelete