Results for “orgs_ncost”

4 results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.GMF_RESOURCE_COSTS_V is a reporting view in the Process Manufacturing (OPM/GMF) costing schema of Oracle E-Business Suite. It exposes resource nominal costs by resource, usage unit of measure, cost type, and accounting period, resolving each row to a specific organization and calendar period. The view reconciles organization-specific costing records with global (organization-independent) costing records maintained in the same detail table, presenting a single unified nominal cost figure per resource/cost type/period/organization combination.

Its practical role is to serve as a simplified query surface for reporting and integration. Rather than requiring callers to understand the dual organization-specific and global cost storage model in CM_RSRC_DTL, the view drives the resolution logic internally and returns a single NOMINAL_COST value, which is precisely the attribute most frequently sought by costing reports, interfaces, and downstream PGM consolidation logic.

Although documented under ETRM metadata for 12.2.2, the definition is consistent with the 12.1.1 code line, since both releases share the Process Manufacturing costing data model. The view is owned by APPS and is typically granted to reporting roles rather than being exposed directly to end-user responsibility menus.

Underlying Base Objects

The view is defined over two referenced base objects, both exposed as synonyms in the APPS schema:

  • CM_RSRC_DTL — The Process Manufacturing resource cost detail table. It stores nominal cost per resource, usage UOM, cost type, period, and organization, with a NULL ORGANIZATION_ID indicating a global or organization-independent cost. The DELETE_MARK column filters logically deleted rows.
  • GMF_PROCESS_ORGANIZATIONS_GT — A global temporary table of process organizations. It supplies ORGANIZATION_ID and ORGANIZATION_CODE, and expands global cost rows across the set of applicable organizations.

The view joins CM_RSRC_DTL to the process organizations table on NVL(rsrc.organization_id, gpo.organization_id) = gpo.organization_id, so that organization-specific rows retain their own organization and global rows are distributed to each process organization. A single-row legal entity subquery (gmf_process_organizations_gt WHERE ROWNUM = 1) constrains the detail set to the current legal entity context.

Key Columns

  • RESOURCES — The resource identifier from the resource cost detail record.
  • USAGE_UOM — Unit of measure in which the resource is consumed and costed.
  • COST_TYPE_ID — The costing type (for example, standard or actual) under which the nominal cost was recorded.
  • PERIOD_ID / PERIOD_CODE / CALENDAR_CODE — The accounting period and calendar to which the cost applies.
  • ORGANIZATION_ID / ORGANIZATION_CODE — The resolved process organization, derived from either the detail row or the global temporary table expansion.
  • NOMINAL_COST — The cost figure returned. It is computed as NVL(orgs_ncost, global_ncost), meaning an organization-specific cost takes precedence over a global cost where both exist for a given resource, cost type, and period. The internal ORGS_NCOST and GLOBAL_NCOST columns are not exposed.

Common Use Cases and Queries

The view is used to retrieve resource costs for a given organization and period, or to compare costs across cost types and organizations. Because the internal ROW_NUMBER() window ranks rows partitioned by resource, cost type, period, and organization with organization-specific rows ordered ahead of global rows (NULLS LAST), only one row per combination is returned, ensuring a deterministic single nominal cost per key.

Typical query scenarios include:

  • Fetching nominal cost for a specific resource and period: SELECT resources, usage_uom, nominal_cost FROM apps.gmf_resource_costs_v WHERE period_code = :period AND organization_code = :org AND cost_type_id = :ct;
  • Reporting costs across all organizations for a resource: SELECT organization_code, period_code, nominal_cost FROM apps.gmf_resource_costs_v WHERE resources = :resource ORDER BY organization_code, period_code;
  • Auditing where global versus organization-specific cost is in effect: comparing results filtered by organization against runs filtered from the underlying CM_RSRC_DTL with ORGANIZATION_ID IS NULL.

The view is read-only and intended for reporting and integration use; it should not be used for direct data maintenance, since underlying costing records are managed through the OPM costing application and concurrent processes.