Search Results amw_export_ap_v




Overview
Explore in AI Chat

Overview

AMW_EXPORT_AP_V is a database view belonging to the Oracle E-Business Suite product AMW — Internal Controls Manager, a module that is now marked obsolete in the ETRM (E-Business Suite Technical Reference Manual) documentation set. The view is designed to expose audit procedure data in a flat, export-oriented format, consolidating header-level procedure attributes, step-level detail, and associated control information into a single result set. The "AP" in the view name refers to Audit Procedures, while the "EXPORT" prefix indicates the view was built to support extraction, reporting, or downstream integration of audit procedure definitions rather than day-to-day transactional entry. In Oracle EBS 12.1.1 and 12.2.2, Internal Controls Manager was used primarily for compliance and audit management workflows, and views such as this one served as denormalized staging points for moving procedural audit content out of the EBS database into external reporting or archival environments. Because the module is obsolete, the view is documented as "Not implemented in this database," meaning it may not exist in all environments and should be treated as a legacy object.

Underlying Base Objects

The view text shows that AMW_EXPORT_AP_V is defined over several AMW base tables joined through audit procedure, step, and control associations:

The documented ETRM metadata lists no referenced base objects, so the relationships above are inferred directly from the view text, which is authoritative for this object.

Key Columns

  • APID, APRID, APRNM — audit procedure ID, revision ID, and revision number.
  • APEND, APAPDT, APCAF, APLRF — procedure end date, approval date, current approved flag, and latest revision flag.
  • APAPP — approval status meaning, resolved from AMW_LOOKUPS using the AMW_PRCDR_APPRV_STATUS lookup type.
  • APNM, APDS — localized procedure name and description.
  • APCLASS — classification work type name resolved from AMW_OBJ_CLASSIFICATION_V.
  • CNM, ADE, AOE — associated control name and the design and operational effectiveness indicators, defaulting to 'N' when null.
  • STPNM, STPNUM, STDSC, STSS — step name, sequence number, description, and sample size.
  • RAP and PARTY_ID — a placeholder empty string and a constant -100, indicating export-context usage.

Common Use Cases and Queries

Typical uses include extracting approved, latest-revision audit procedures for compliance reporting and exporting audit procedure steps alongside their associated controls for archival. A basic query follows:

  • SELECT APID, APRNM, APNM, APAPP, CNM, STPNM FROM AMW_EXPORT_AP_V WHERE APLRF = 'Y';
  • SELECT APCLASS, COUNT(*) FROM AMW_EXPORT_AP_V GROUP BY APCLASS;
  • SELECT APID, APNM, STPNM, STSS FROM AMW_EXPORT_AP_V WHERE APCAF = 'Y';

Because the module is obsolete and the view may not be present, existence should be verified via ALL_VIEWS before relying on it in any custom integration.