Home / AppsDBA Scripts / Find the Org and Organization mappings

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

  ood.operating_unit = hou.organization_id 

AND hou.legal_entity_id = hle.organization_id

AND gsob.set_of_books_id = hle.set_of_books_id

About Syed Saad Ali

With 13 years of experience as a certified and skilled Oracle Database Administrator, I possess the expertise to handle various levels of database maintenance tasks and proficiently perform Oracle updates. Throughout my career, I have honed my analytical abilities, enabling me to swiftly diagnose and resolve issues as they arise. I excel in planning and executing special projects within time-sensitive environments, showcasing exceptional organizational and time management skills. My extensive knowledge encompasses directing, coordinating, and exercising authoritative control over all aspects of planning, organization, and successful project completions. Additionally, I have a strong aptitude for resolving customer relations matters by prioritizing understanding and effective communication. I am adept at interacting with customers, vendors, and management, ensuring seamless communication and fostering positive relationships.

Check Also

Application Report Queries

QUERY TO CHECK LIST OF RUNNING REQUEST

Leave a Reply