Search Results gmd_org_access_vw




Overview
Explore in AI Chat

Overview

GMD_ORG_ACCESS_VW is a public view owned by the APPS schema in Oracle E-Business Suite (documented for 12.1.1 and 12.2.2). It belongs to the Process Manufacturing Product Development (GMD) product family and is documented in the E-Business Suite Technical Reference Manual (ETRM). Its stated purpose is to serve as a substitute for the standard ORG_ACCESS_VIEW, offering improved performance for queries that need to resolve the set of inventory organizations accessible to the current responsibility.

The view returns one row per process-enabled inventory organization that is either explicitly granted to the caller's responsibility through the ORG_ACCESS table or not restricted by any ORG_ACCESS entry. Because it derives the responsibility identifier directly from FND_GLOBAL, it is inherently session- and responsibility-aware: the result set changes automatically as the logged-in user switches responsibilities. This makes it suitable for reporting, concurrent programs, and integrations that must return only the organizations the current user is authorized to see.

Underlying Base Objects

The ETRM lists the following referenced base objects: FND_GLOBAL (package), HR_GENERAL (package), HR_ORGANIZATION_INFORMATION (synonym), HR_ORGANIZATION_UNITS (view), HR_SECURITY (package), MTL_PARAMETERS (synonym), and ORG_ACCESS (synonym).

The view text joins HR_ORGANIZATION_UNITS (aliased A) to MTL_PARAMETERS (aliased B) on ORGANIZATION_ID, restricting the result to organizations whose PROCESS_ENABLED_FLAG is 'Y' — that is, process manufacturing organizations. It further joins HR_ORGANIZATION_INFORMATION (HOI1) to enforce that the organization has a classification record (ORG_INFORMATION_CONTEXT = 'CLASS') with ORG_INFORMATION1 = 'INV' (an inventory organization) and ORG_INFORMATION2 = 'Y' (enabled).

Access control is applied through a correlated ORG_ACCESS subquery. A row qualifies when an ORG_ACCESS record exists for the organization, the responsibility (RESPONSIBILITY_ID from FND_GLOBAL.RESP_ID) and application (FND_GLOBAL.RESP_APPL_ID), with a NULL or future DISABLE_DATE; or when no active ORG_ACCESS record exists for that organization at all. Although HR_GENERAL and HR_SECURITY appear as referenced objects, they are invoked indirectly through the HR_ORGANIZATION_UNITS view and the security predicates it carries.

Key Columns

  • ORGANIZATION_CODE — The short inventory organization code from MTL_PARAMETERS. Commonly used as the user-facing identifier in reports and LOVs.
  • ORGANIZATION_NAME — The organization name, sourced from HR_ORGANIZATION_UNITS.NAME. Provides a descriptive label for display.
  • ORGANIZATION_ID — The unique organization identifier, used as the join key to inventory, costing, and process manufacturing tables.

The output is ordered by ORGANIZATION_CODE (ORDER BY 1), so results arrive in a deterministic, presentation-friendly sequence.

Common Use Cases and Queries

Typical scenarios include restricting a report or concurrent program to the organizations the current responsibility may access, populating an organization LOV in a custom form or OAF page, and driving integration extracts that must respect organizational security. Because the view already filters on process-enabled inventory organizations, it is especially convenient for GMD-related objects such as recipes, formulas, and batches.

List all accessible organizations for the current session:

  • SELECT organization_id, organization_code, organization_name FROM apps.gmd_org_access_vw ORDER BY organization_code;

Validate that a specific organization is accessible before processing:

  • SELECT COUNT(*) FROM apps.gmd_org_access_vw WHERE organization_id = :p_org_id;

Join the view to process data to produce a secured listing:

  • SELECT g.organization_code, g.organization_name, x.item_id FROM apps.gmd_org_access_vw g, apps.gmd_recipes_b x WHERE x.organization_id = g.organization_id;

Note that ORG_ACCESS_VIEW applies the same security model but with a heavier definition; GMD_ORG_ACCESS_VW is the recommended replacement where performance of organization-security resolution is a concern.