HR: Organization Classifications Query

 This query help you to find the different Organization Classification information of an Org.

1.  select distinct t.ORG_INFORMATION_CONTEXT from hr_organization_information t

2.     SELECT o.organization_id,

               o.organization_id,

               otl.name,

               o.date_from,

               o.date_to,

               o.internal_address_line,

               o.location_id,

               o.comments,

               o4.org_information1

          FROM hr_all_organization_units    o,

               hr_all_organization_units_tl otl,

               hr_organization_information  o2,

               hr_organization_information  o3,

               hr_organization_information  o4

         WHERE o.organization_id = otl.organization_id

           AND o.organization_id = o2.organization_id(+)

           AND o.organization_id = o3.organization_id

           AND o.organization_id = o4.organization_id

           AND o3.org_information_context = 'Business Group Information' 

           AND o2.org_information_context(+) = 'Work Day Information' -- Get a distinct of this from the above query 

           AND o4.org_information_context = 'CLASS' -- This means the Classification

           AND o4.org_information1 = 'HR_BG' -- BG Business group 

           AND o4.org_information2 = 'Y';