Search Results amw_control_location

Overview

APPS.AMW_EXPORT_CTRL_V is a reporting-oriented database view in the Oracle E-Business Suite Audit Management (formerly Oracle Audit Vault and the GRC "Audit" module delivered under the AMW schema prefix) product family. Its purpose is to present a flattened, exportable representation of audit control definition data so that controls maintained in the Audit Management module can be extracted for downstream reporting, reconciliation, or external integration. The view joins the base control table to descriptive lookup meanings, application and job context, and object classification, producing a single row per control revision with human-readable values that are typically only stored as lookup codes in the underlying tables. Because the view resolves codes to meanings at query time, it is well-suited for ad hoc reporting and for feeds that must be consumed by tools that cannot resolve EBS lookup semantics themselves.

Underlying Base Objects

The documented ETRM metadata for this view lists no explicitly referenced base objects. Inspection of the view text, however, reveals that it is defined primarily over AMW_CONTROLS_B (aliased ACB), the base table holding control header and revision attributes such as CONTROL_ID, CONTROL_REV_ID, REV_NUM, approval status, control type, frequency, and the verification source. The view also references AMW_CONTROLS_TL (aliased ACT) for translated name, description, physical evidence, and verification instruction and source name. Supporting lookups are supplied by AMW_LOOKUPS, which stores lookup codes for control approval status, control location, control type, automation type, verification source, and control frequency. Additional context is drawn from FND_APPLICATION (application short name), PER_JOBS and PER_BUSINESS_GROUPS (job and business group names), and AMW_OBJ_CLASSIFICATION_V for work type classification. In EBS 12.1.1 and 12.2.2, AMW_LOOKUPS is a seeded lookup table with a fixed, non-MLD structure; the SECURITY_GROUP_ID and multilanguage treatment typical of other AMW views does not alter this behavior.

Key Columns

Column aliases are terse, reflecting their export lineage. Key exposures include:

• CID / CRID / CRNM — control identifier, control revision identifier, and revision number.
• CNM / CDS — control name and description from the translated table.
• CAPP / CAPDT — approval status meaning and approval date.
• CLOC / CTYP / CAUT — control location, control type, and automation type meanings resolved from AMW_LOOKUPS.
• CVSO / CVNM / CVIN — verification source lookup meaning, verification source name, and verification instruction. This is the set of columns most relevant to searches on "amw_verification_source," as the lookup type AMW_VERIFICATION_SOURCE is decoded here.
• CCF / CUOMTL — control frequency code and its frequency meaning (derived from AMW_CONTROL_FREQUENCY using UOM_CODE).
• CAPL / CJOB / CBGR — owning application short name, job name, and business group name.
• CPRV / CDET / CDIS / CKEY — preventive, detective, and disclosure control flags plus the key mitigating indicator.
• CEND / CCAF / CLRF — end date, current approved flag, and latest revision flag.
• CPEV — physical evidence text.

Common Use Cases and Queries

Typical uses include extracting all latest-approved controls for an internal audit workpaper repository, producing control inventories filtered by verification source or approval status, and driving external GRC or BI dashboards. A representative query retrieving latest revisions whose verification source is a specific lookup code is shown below.

SELECT cid, cnm, ct p? . . .

In practice, an analyst would query the view filtering on CLRF = 'Y' for latest revision, CCAF = 'Y' for currently approved controls, and optionally on CVSO (verification source meaning) or CCAPD. Because the view embeds scalar subqueries against AMW_LOOKUPS, performance depends heavily on the ENABLED_FLAG and END_DATE_ACTIVE filters in those subqueries; set-based rewrites or materialized staging tables are often advisable for large-volume extracts.