Search This Blog

Saturday, November 25, 2017

Organization Department Query

SELECT haou.name
      ,fnd.set_name
      ,haou.attribute1 classification
      ,haou.attribute2 business_function
      ,haou.attribute3 operating_unit
      ,TO_CHAR (haou.effective_start_date
               ,'dd-mm-yyyy')
          Effective_Start_Date
      ,hl.iNTERNAL_LOCATION_CODE LOCATION_CODE
FROM   hr_org_unit_classifications_f houc
      ,hr_all_organization_units haou
      ,fnd_setid_sets fnd
      ,hr_locations hl
WHERE  1 = 1
AND    hl.location_id(+) = haou.location_id
AND    haou.organization_id = houc.organization_id
AND    houc.classification_code = 'DEPARTMENT'
AND    fnd.set_id = houc.set_id

1 comment: