Search Results scope_modified_date

Overview

AMW.AMW_EXECUTION_SCOPE is a transactional table within the Oracle E-Business Suite Audit Management and Workbench (AMW) schema. It holds the execution scope definitions that govern audit projects and process certification activity. Each row identifies a scoped entity—either a project or a process certification—together with the organizational, subsidiary, line-of-business, and process hierarchy context in which that entity is evaluated. The table is owned by AMW, carries the FND Design Data reference AMW.AMW_EXECUTION_SCOPE, and is stored in the APPS_TS_TX_DATA tablespace with a PCT Free of 10. Its documented columns number 38, and the object is marked VALID.

From a dimensional modeling perspective, the mined relationship heuristic classifies this table as satellite-leaning. It attaches descriptive scope attributes and change-tracking flags to a central certification or project entity rather than acting as a standalone hub or an association link. This classification is a modeling suggestion; the physical implementation remains a standard EBS transactional table with WHO audit columns and a DESCRIPTIVE flexfield.

Key Information Stored

The surrogate primary key is EXECUTION_SCOPE_ID, enforced by the unique index AMW_EXECUTION_SCOPE_U1 on the same column. The documented unique index set identifies EXECUTION_SCOPE_ID as the principal business-key candidate.

• ENTITY_TYPE / ENTITY_ID — The scoped entity's type and identifier. ENTITY_TYPE supports the values PROCESS_CERTIFICATION or PROJECT.
• SCOPE_CHANGED_STATUS — Change marker holding C for creation, R for removal, or null for no change.
• SCOPE_MODIFIED_DATE — The timestamp recording when the scope definition was last modified. This is the column referenced by the search term and is the primary date filter for delta and audit-change reporting.
• LEVEL_ID — Depth indicator for the scope hierarchy, resolving to MSD_LEVELS.
• TOP_PROCESS_ID / PARENT_PROCESS_ID / PROCESS_ID — Root, parent, and current process identifiers that describe the process tree a scope belongs to.
• ORGANIZATION_ID — Organization context for the scope row.
• SUBSIDIARY_VS / SUBSIDIARY_CODE — Subsidiary value set and resulting subsidiary code.
• LOB_VS / LOB_CODE — Line-of-business value set and resulting code.
• SCOPE_ ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — Descriptive flexfield defining column and segments for client-specific scope attributes.
• CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the EBS framework.
• SECURITY_GROUP_ID — Security grouping reference to FND_SECURITY_GROUPS.
• PROCESS_ORG_REV_ID — Process organization revision reference.

Common Use Cases and Queries

The dominant reporting pattern is retrieving the current scope for a certification or project and identifying recently changed scopes. Because AMW_EXECUTION_SCOPE_N1 covers ENTITY_ID, ENTITY_TYPE, ORGANIZATION_ID, and PROCESS_ID, entity-driven lookups benefit from that composite index, while AMW_EXECUTION_SCOPE_N2 (LEVEL_ID, ENTITY_TYPE, ENTITY_ID) supports hierarchy-depth filtering.

Typical query — scope rows created or removed within a period:

SELECT execution_scope_id,
       entity_type,
       entity_id,
       scope_changed_status,
       scope_modified_date
  FROM amw.amw_execution_scope
 WHERE scope_modified_date >= :p_from_date
   AND scope_changed_status IN ('C','R');

Typical query — all scope rows for a given project or certification, joined to certification metadata:

SELECT s.execution_scope_id,
       s.entity_type,
       s.level_id,
       s.process_id,
       s.organization_id
  FROM amw.amw_execution_scope s
 WHERE s.entity_id = :p_entity_id
   AND s.entity_type = 'PROJECT'
 ORDER BY s.level_id;

Because SCOPE_MODIFIED_DATE is not indexed by any documented index, high-volume delta extracts should be constrained by ENTITY_ID or ORGANIZATION_ID where possible, or executed during off-peak windows.

Related Objects

• AMW.AMW_CERTIFICATION_B — Referenced through the ENTITY_ID foreign key; the certification base table holding the entity targeted by the scope.
• MSD_LEVELS — Referenced through the LEVEL_ID foreign key; supplies hierarchy depth descriptions.
• FND_SECURITY_GROUPS — Referenced through the SECURITY_GROUP_ID foreign key; governs row-level security visibility.
• AMW.AMW_EXECUTION_SCOPE_U1 / _N1 / _N2 — The supporting unique and non-unique indexes supplying primary-key enforcement and query access paths.
• FND Flexfield views — The ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 segments are surfaced through the standard descriptive flexfield views associated with this table.