Search Results executed_by

Overview

AMW_EXPORT_AUDIT_PROCEDURE_V is a database view historically shipped with the Oracle E-Business Suite module AMW — Internal Controls Manager. In release 12.1.1 and 12.2.2 this module is classified as obsolete, and the ETRM metadata records this view as "Not implemented in this database." Consequently, the object will not be present in a standard, current 12.1.1 or 12.2.2 installation unless a legacy Internal Controls Manager schema was previously deployed and retained.

The view is an export-oriented, denormalized reporting object. It joins audit procedure associations to audit procedures, tasks, users, and execution records, flattening the Internal Controls Manager data model into a single wide row set intended for reporting, extraction, and downstream integration. Its primary purpose is to expose the complete status and ownership picture of an audit procedure revision — including which auditor, organization, and task it belongs to, and the state of its execution — without requiring the consumer to reconstruct the relationship chain manually.

Underlying Base Objects

The ETRM metadata does not document a formal list of referenced base objects at the object level, but the embedded view text reveals the underlying tables and views. These include:

• AMW_AP_ASSOCIATIONS (APA) — the driving table, supplying association identifiers and the PK1–PK4 key columns.
• AMW_AP_EXECUTIONS — correlated subqueries retrieve status, work description, executed-by, executed-on, and execution identifiers filtered by AUDIT_PROCEDURE_REV_ID.
• AMW_LOOKUPS — resolves the execution STATUS code into a descriptive MEANING via lookup type AMW_PROCEDURE_STATUS.
• Audit procedure, task, and user views — aliased AAPV, AATV, and AUV, supplying procedure name, task name/description, and user name respectively.

The view is defined in two layers: an inner query that assembles procedure-level attributes and execution state, and an outer SELECT that joins step-level data (SID, SS, SWD, SEB, SEO, SEID, SENM, SNM, SDES, SNUM, SAU, FAD) alongside summary columns (KEYC, PRNM, RNM, COBJ).

Key Columns

• APRID (AUDIT_PROCEDURE_REV_ID) — the audit procedure revision identifier, the central key referenced throughout the execution subqueries.
• APAID, APID, APJID — association, audit procedure, and AP job identifiers.
• OID, CID, TID — organization, compliance/control, and task identifiers derived from PK2, PK3, and PK4; PK4 of -1 signals procedures with no task assignments.
• APNM, TNM, TDES, ONM — procedure name, task name, task description, and organization name.
• APS — procedure status, decoded from AMW_LOOKUPS and defaulting to 'IN PROGRESS'.
• APWD, APEB, APEO, APEID, APENM — execution work description, executed-by, executed-on, execution ID, and executor name.
• DEF, OEF, CAR, COBJ, KEYC, DSUM, OSUM, CSUM — deficiency, observation, and conclusion attributes and summaries.
• Step columns (SID, SNM, SDES, SNUM, SAU) — step identity, sequence, and auditor.

Common Use Cases and Queries

Typical scenarios include auditing procedure execution history, exporting procedure-to-task associations, and building reconciliation extracts. A representative query follows:

• SELECT APRID, APNM, TNM, APS, APEB, APEO FROM AMW_EXPORT_AUDIT_PROCEDURE_V WHERE APS = 'IN PROGRESS';
• SELECT APRID, ONM, TNM, COUNT(*) FROM AMW_EXPORT_AUDIT_PROCEDURE_V GROUP BY APRID, ONM, TNM;
• SELECT * FROM AMW_EXPORT_AUDIT_PROCEDURE_V WHERE TID = -1; — isolates procedures lacking task assignments.

Because the view relies on correlated subqueries against AMW_AP_EXECUTIONS, performance on large data sets should be validated. Before use in any 12.1.1 or 12.2.2 environment, confirm the object exists, as ETRM documents it as not implemented in current databases.