查询系统已定义OU，ORG 以及相关基本信息

查询系统已定义OU，ORG 以及相关基本信息

下面的SQL可以查找到系统已定义OU，ORG 以及相关基本信息，可用来评估系统设置。

SELECT DISTINCT HOU.BUSINESS_GROUP_ID,
                HOU.BUSINESS_GROUP_NAME,
                HOU.OPERATING_UNITS_ID ORG_ID,
                OPERATING_UNIT_NAME,
                DATE_FROM,
                DATE_TO,
                LEGAL_ENTITY_ID,
                LEGAL_ENTITY_NAME,
                LOCATION_NAME,
                OOD.ORGANIZATION_CODE,
                OOD.ORGANIZATION_ID,
                OOD.ORGANIZATION_NAME,
                OOD.USER_DEFINITION_ENABLE_DATE,
                OOD.DISABLE_DATE,
                OOD.SET_OF_BOOKS_ID,
                OOD.INVENTORY_ENABLED_FLAG
  FROM APPS.HRFV_OPERATING_UNITS         HOU, --HR_OPERATING_UNITS;
       APPS.ORG_ORGANIZATION_DEFINITIONS OOD
 WHERE HOU.OPERATING_UNITS_ID = OOD.OPERATING_UNIT
 ORDER BY HOU.OPERATING_UNITS_ID, OOD.ORGANIZATI