Home / AppsDBA Scripts (page 2)

AppsDBA Scripts

Find the Org and Organization mappings

  SELECT   ood.organization_code Warehouse_code,   ood.organization_name Warehouse,   ood.operating_unit OU_ID,   hou.name OU_Name,   hle.name Legal_entity,   hle.set_of_books_id,   gsob.name SOB FROM   org_organization_definitions ood,   hr_operating_units hou,   hr_legal_entities hle,   gl_sets_of_books gsob WHERE …

Read More »