Search Results org_information4

Overview

AMW_AUDIT_UNITS_V is a reporting view within the Oracle E-Business Suite product AMW — Internal Controls Manager, a module now classified as obsolete in ETRM documentation. The view returns descriptive information about Audit Units: the organizational entities against which audits, controls testing, and remediation activities are scoped within Internal Controls Manager. An Audit Unit represents a discrete business area subject to internal audit, such as a subsidiary, line of business, or operational department. The view resolves the Audit Unit organization hierarchy into a denormalized, user-readable form, exposing the unit name, effective dates, company and line-of-business codes together with their translated descriptions, and the associated HR organization type meaning.

Because Audit Units are modeled as HR organizations classified with the AMW_AUDIT_UNIT organization classification, this view sits on top of the standard Oracle HR organization model and presents AMW-specific semantics to reporting tools, concurrent programs, and integrations. ETRM records no owner for the view and notes that it is not implemented in the database instance documented, meaning the view text is provided for reference only and the object may not exist in every environment.

Underlying Base Objects

The view is defined over five Oracle HR base objects. ETRM does not document referenced base objects separately, but the view text identifies them explicitly:

• HR_ALL_ORGANIZATION_UNITS (alias O) — the master organization definition, supplying organization ID, business group ID, date range, and location.
• HR_ALL_ORGANIZATION_UNITS_TL (alias OTL) — the translated organization name, joined on the session language via USERENV('LANG').
• HR_ORGANIZATION_INFORMATION (alias O2) — the classification row where ORG_INFORMATION_CONTEXT = 'CLASS', ORG_INFORMATION1 = 'AMW_AUDIT_UNIT', and ORG_INFORMATION2 = 'Y'. This predicate is the filter that restricts the view to Audit Units only.
• HR_ORGANIZATION_INFORMATION (alias O3) — the descriptive flexfield context row where ORG_INFORMATION_CONTEXT = 'AMW_AUDIT_UNIT', supplying company code, LOB code, and the associated value set IDs. This join is outer (+).
• HR_LOOKUPS (alias HRLKP) — an outer join on LOOKUP_TYPE = 'ORG_TYPE' resolving the organization type meaning.
• FND_FLEX_VALUES_VL — referenced twice in scalar subqueries to translate the company code and LOB code into their flexfield value descriptions.

Key Columns

• BUSINESS_GROUP_ID / ORGANIZATION_ID — primary identifying keys for the Audit Unit organization.
• NAME — the translated Audit Unit name from HR_ALL_ORGANIZATION_UNITS_TL.
• DATE_FROM / DATE_TO — the effective date range of the organization record.
• COMPANY_CODE / COMPANY — ORG_INFORMATION1 and its flexfield description.
• LOB_CODE / LOB_DESCRIPTION — ORG_INFORMATION2 and its flexfield description.
• SUBSIDIARY_VALUESET / LOB_VALUESET — ORG_INFORMATION3 and ORG_INFORMATION4, the value set IDs used to resolve company and LOB descriptions.
• LOCATION_ID — the location assigned to the organization.
• ORG_TYPE — the decoded organization type lookup meaning.

Common Use Cases and Queries

Typical uses include populating audit scope selection lists, driving audit plan reporting by company or line of business, validating Audit Unit setup during implementation, and feeding downstream data warehouses. A representative query listing active Audit Units with their company and LOB descriptions follows:

• SELECT organization_id, name, company_code, company, lob_code, lob_description, org_type FROM amw_audit_units_v WHERE SYSDATE BETWEEN date_from AND NVL(date_to, SYSDATE + 1) ORDER BY name;

A narrower variant groups Audit Units by line of business for audit coverage analysis:

• SELECT lob_code, lob_description, COUNT(*) audit_unit_count FROM amw_audit_units_v GROUP BY lob_code, lob_description;

Because the object is documented as obsolete and unimplemented in the referenced database, consumers should verify its existence and definition in their own instance before relying on it in custom code.