Search Results amw_ctrl_owner_role




Overview
Explore in AI Chat

Overview

APPS.AMW_OWNER_ROLES_V is a security and access-control view in the Oracle E-Business Suite Applications (APPS) schema. It belongs to the AMW module, which corresponds to Oracle Application Object Library security components, and is registered as FND Design Data object AMW.AMW_OWNER_ROLES_V with a status of VALID. The view presents a consolidated, human-readable projection of role grants held by owners and parties, joining low-level grant records in FND_GRANTS to user, party, company, and menu metadata. Its VIEW Type is documented as Internal, meaning the object is delivered for use by standard Oracle Applications programs rather than as a supported public interface.

Because the view exposes derived descriptive columns such as PARTY_NAME, COMPANY_NAME, ROLE_NAME, and OBJECT_NAME alongside identifiers, it is typically consumed in reporting and integration contexts where a flattened grant-role listing is required without manually joining the underlying base tables.

Underlying Base Objects

The view is defined over the following documented objects:

The view presents one row per applicable grant-role combination, joining grant data to descriptive attributes. It is itself referenced by additional AMW objects, including AMW_EXPORT_AP_V, AMW_EXPORT_CTRL_V, AMW_EXPORT_PROCESS_V, and the AMW_LOAD_PROC_DATA procedure, indicating a role in export and load processing utilities.

Key Columns

The column that the user searched for, OBJECT_KEY_TYPE, is a VARCHAR2 column that classifies the type of the secured object identified by OBJECT_KEY. Together they identify the grantable target (for example, a menu or function) whose name is resolved into OBJECT_NAME. Other significant columns include:

  • GRANTEE_TYPE and GRANT_GUID — the type of grantee and the unique grant identifier.
  • GRANT_GUID — RAW(16), matching the primary grant record in FND_GRANTS.
  • START_DATE and END_DATE — the effective period of the role grant.
  • PARTY_NAME_ORIG, PARTY_NAME, COMPANY_NAME — hierarchical naming attributes derived from HZ_PARTIES and HZ_FORMAT_PUB.
  • COMPANY_ID and PARTY_ID — numeric identifiers for the company and party.
  • ROLE_NAME and ROLE_DESCRIPTION — the granted role and its short description.
  • MENU_ID, PK1_VALUE through PK5_VALUE — menu and primary key components used to identify the secured object.
  • INSTANCE_SET_ID — the associated instance set, if any.
  • USER_NAME — the application user name where the grantee is a user.
  • SWITCHERCOL and ROLENAMELINK — presentation helper columns.

Common Use Cases and Queries

Typical uses include auditing which roles are granted to which owners or parties, identifying active grants by date range, and reconciling exported security data. Because OBJECT_KEY_TYPE is commonly used to filter by grant category, a representative query is:

  • SELECT OBJECT_KEY_TYPE, OBJECT_KEY, OBJECT_NAME, ROLE_NAME, PARTY_NAME FROM APPS.AMW_OWNER_ROLES_V WHERE SYSDATE BETWEEN START_DATE AND NVL(END_DATE, SYSDATE) ORDER BY OBJECT_KEY_TYPE, OBJECT_NAME;
  • SELECT USER_NAME, ROLE_NAME, OBJECT_NAME FROM APPS.AMW_OWNER_ROLES_V WHERE OBJECT_KEY_TYPE = :p_key_type;
  • SELECT GRANTEE_TYPE, ROLE_NAME, COMPANY_NAME, START_DATE, END_DATE FROM APPS.AMW_OWNER_ROLES_V WHERE ACTIVE_FILTER;
  • SELECT OBJECT_KEY_TYPE, COUNT(*) FROM APPS.AMW_OWNER_ROLES_V GROUP BY OBJECT_KEY_TYPE;

Access should be limited in accordance with the Oracle Internal Use Only warning; the view is intended for standard Applications programs rather than general reporting access.